Prepare Operating Budgets as follows:
- 1) Ending Inventory Budget for the month of June
- 2) Cost of goods Sold Budget for the quarter
?
\fBudgeted Manufacturing Overheads Recent statistical data for Maintenance Costs Labour Hours 1,302,000 1,485,000 1,353,500 1,242,000 Total Maintenance Costs 579,920,000 585,80 5,000 $32,215,000 $77,625,000 Fixed Cost Variable Cost component per component per month DL hour Indirect labour $0 $56.70 Power 50 $5.40 Maintenance ?? ?? Supervision $37,800,000 50 Depreciation $3,375,000 50 Rates & Utilities 52,339,100 SCI Other 513,500,000 540.50 April May June Variable Selling Expenses $82,175,000 $50,220,000 $58,497,500 Fixed Selling 8: Admin Expenses $24,300,000 $19,440,000 521,570,000 Total Selling a Admin Expenses $87,075,000 $69,660,000 $78,867,500 Cash on hand at opening 53,315,000 Annual interest rate on borrowing 5% Cash Sales 50 Received in month of sale 80% Received in month after sale 1895 Balance of accounts receivables at the start of the month $82,853,000 Dividends paid in June 51,194,150 Land purchased in l'iiliavr $185,100,000 ABC Pty Ltd Sales April May June July Actual Sales Volume 3-moths to June Units 67,500 54,000 60,750 81,000 162,200 Unit selling price $6,200 The desired finished goods inventory for each month is 60% of the next month's sales The full absorption cost of the opening finished goods inventory is $4,730 per unit The variable manufacturing cost of the opening finished goods inventory is $1,930 per unit Finished goods inventory on April 1 is 43,200 units Materials required to be on hand at the beginning of the month to produce 20% of that month's estimated sales Direct Material used per unit Actual Material Used - 3 months to June Rotor Blades Rotor Blades Quantity 5 750,800 729,100 Cost per unit $81 $108 Actual cost of material Used - 3 months to June $48,651,840 $80,883,680 Budgeted Direct Labour time per unit 8 hours Actual Labour Used - 3 months to June 1,662,590 Direct Labour cost per hour $50 Actual cost of labour Used - 3 months to June $70,660,100