Prepare the monthly Cash budget for the quarter: ABC Pty Ltd Sales Units Unit selling price Direct

Prepare the monthly Cash budget for the quarter:

   

Transcribed Image Text:

ABC Pty Ltd Sales Units Unit selling price Direct Material used per unit Quantity Cost per unit Budgeted Direct Labour time per unit April The desired finished goods inventory for each month is The full absorption cost of the opening finished goods inventory is The variable manufacturing cost of the opening finished goods inventory is Finished goods inventory on April 1 is Materials required to be on hand at the beginning of the month to produce Direct Labour cost per hour 67,500 $6,200 May Rotor 4 $81 54,000 Blades 5 $108 June 60,750 July $50 81,000 8 hours Actual Sales Volume 3-moths to June 162,200 60% of the next month's sales $4,730 per unit $1,930 per unit 43,200 units 20% of that month's estimated sales Actual Material Used - 3 months to June Rotor Blades 750,800 729,100 Actual cost of material Used - 3 months to June $48,651,840 $80,883,680 Actual Labour Used - 3 months to June 1,662,590 Actual cost of labour Used- 3 months to June $70,660,100 ABC Pty Ltd Sales Units Unit selling price Direct Material used per unit Quantity Cost per unit Budgeted Direct Labour time per unit April The desired finished goods inventory for each month is The full absorption cost of the opening finished goods inventory is The variable manufacturing cost of the opening finished goods inventory is Finished goods inventory on April 1 is Materials required to be on hand at the beginning of the month to produce Direct Labour cost per hour 67,500 $6,200 May Rotor 4 $81 54,000 Blades 5 $108 June 60,750 July $50 81,000 8 hours Actual Sales Volume 3-moths to June 162,200 60% of the next month's sales $4,730 per unit $1,930 per unit 43,200 units 20% of that month's estimated sales Actual Material Used - 3 months to June Rotor Blades 750,800 729,100 Actual cost of material Used - 3 months to June $48,651,840 $80,883,680 Actual Labour Used - 3 months to June 1,662,590 Actual cost of labour Used- 3 months to June $70,660,100

Answer rating: 100% (QA)

A cash budget sometimes known as a combined cash budget is a financial planning tool that forecasts when money will enter and leave your company on a monthly or quarterly basis The budget identifies a... View the full answer