0

Can you please provide the calculations for all the answers

4a Data entry in colored cells only. If colour formatting error, scroll up and down to fix. Do not cut and paste cells. The following information is for budget preparation for the Cruised model of car for the Dhodge Motor Company, for August. Required: 1) Develop a production budget for the month of August. 2) Develop an operating budget for the month of August based on planned sales and production. Production Costs 1) PRODUCTION BUDGET Budgeted u sales target FG Invent ending target FG Invent beginning Units for production in August 2,200 400 0 2,600 Try = correct Try again Material Labour Overheads Total Fixed 240.000 450.000 10,100,000 10.790,000 Variable 3,300 800 1,800 5,900 Price Totall 2) OPERATING BUDGET Sales Units 2,200 Selling, General & Admin expenses Fixed 200,000 Variable 130 Total fixed costs Other information Units 0 Unit variable Fixed cost cost per unit 0 0 3,300 800 1,800 5,900 Totall 0 Cost of good sold (COGS) Beginning finished goods inventory Production: Materials Production: Labour Prodution: OH Total production costs Ending finished goods inventory Total COGS 17,000 Budgeted selling price: 240,000 450,000 10,100,000 10,790,000 2,200 Budgeted sales (units of cars in August) 2,600 Denominator level: cars per month (for ending fixed costs in finished goods) 0 Beginning finished goods (FG) inventory of cars (units) August (expected) 400 Ending finished goods (FG) inventory of cars (units) August (expected) Gross profit 2% expected bad debt (of total sales) 200,000 130 S&A expenses Bad debt write-off expense Operating income