XYZ Corporation is preparing a master budget for 2016. Sales for the year are ex

Question

XYZ Corporation is preparing a master budget for 2016. Sales for the year are expected to total 1,200,000 units. Quarterly sales in units are 20%,25%,30%, and 25% respectively. The sales price is expected to be $50 per unit for the first 3 quarters and $55 per unit beginning in the fourth quarter. Sales in the first quarter of 2017 are expected to be 10% higher than the budgeted sales volume for the first quarter of 2016.

Cash collections from sales are 60% in the quarter of sale, 30% in the following quarter and 8% in the second quarter after sale.

For production purposes management desires to maintain ending finished goods inventories at 25% of the next quarters budgeted sales volume. Beginning finished goods on Jan 1 2016 are 60,000 units.

For production purposes two pounds of raw material are required for each finished product.

Management targets ending inventory of materials equal to 20% of next period’s production needs of finished goods

Beginning materials inventory on January 1, 2016 was 10,000 pounds.

Prepare

       

        A)cash inflows schedule for the third quarter 2016

        B)materials purchase budget in pounds for the first quarter 2016

Explanation / Answer

A)cash inflows schedule for the third quarter 2016

B)materials purchase budget in pounds for the first quarter 2016

Cash inflow 8% of first quarter sales (1200000*20%*50*8%) 960000 30% of second quarter sales (1200000*25%*50*30%) 4500000 60% of third quarter sales (1200000*30%*50*60%) 10800000 Total cash inflow in third quarter 16260000

Related Questions

Navigate

• Browse (All)
• Browse X
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.