Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed0

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Sampling An Introduction

Authors: Dan M. Guy, D. R. Carmichael, O. Ray Whittington

5th Edition

047137590X, 978-0471375906

More Books

Students also viewed these Accounting questions