Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 incomeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started