Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To the person who solves this can you please attach the excel formulas thats what I need as well. Thank you! Home Insert Draw Page

image text in transcribedimage text in transcribedTo the person who solves this

can you please attach the excel formulas thats what I need as well. Thank you!

Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 ' ab Wrap Text General Paste BI UV ar Av Merge & Center $ v % A41 x fx A B C D E F G H DG 2 Company, a manufacturer, predicts sales of 11,200 units in January, 10,400 units in February, 14,400 units in March, and 15,800 units in April. The company wants each month's ending finished goods inventory to equal 40% of next month's predicted unit sales. Beginning finished goods inventory for January is 4,480 units. Each unit finished goods requires 0.40 pounds of direct materials at a cost of $12.00 per pound, and 5.0 hours of direct labor at a cost of $20 per hour. 3 Additionally, the company wants each month's ending raw materials inventory to equal 30% of next month's budgeted production. Prepare a sales budget, a production budget, a direct materials and a direct labor budget. 4 5 7 8 Company Budget Assumptions For the months of January, February, and March 2021 January February Selling price per unit $300 $300 Budgeted sales (units) 11,200 10,400 Budgeted sales (units) April Budgeted production (units) April Ratio of ending finished goods inventory to next month's sales Ratio of ending raw materials inventory to next month's requirements Number of units in finished goods inventory, January 1 Number of pounds in raw materials inventory, January 1 Number of pounds of raw materials required per unit Cost per pound of raw materials Number of direct labor hours required per unit Rate per direct labor hour March $300 14,400 15,800 16,600 40% 30% 4,480 1,306 0.40 $12.00 5.0 $20.00 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Company Sales Budget For the months of January, February, and March 2021 January February Budgeted sales (units) 11.200 10,400 Selling price per unit $300 $300 Total budgeted sales (dollars) $3,360,000 $3,120,000 March 14,400 $300 $4,320,000 Company Production Budget For the months of January, February, and March 2021 January February Next month's budgeted sales (units) 10,400 14,400 Ratio of inventory to future month's sales 40% 40% Budgeted ending inventory (units) Add: Budgeted sales (units) 1 Required units of available production March 15,800 40% Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) Insert v General Wrap Text ~ A A CA 27 O Paste BIU = = Marga Center $ % SX Delete ft Format Conditional Format Call Formatting as Table Styles Sort Filter Find Select Analyze Data Sensitivity A25 A G H DG DH DI DJ DK DL DM DN DU DP 00 DE B Company Sales Budget For the month of January February, and March 2021 January February Budgeted sales (units) 11,200 10,400 Soling price per unt $200 $300 Total budgeted sales (colars) S3,260,000 S3,120.000 March 14,400 $300 $4,320,000 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Company Production Budget For the months of January February, and March 2021 January February Next month's budgeted sales funits 10,400 14,400 Ratio of inventory to future menth's sales 40% 40% Budgeted ending inventary units) Add: Budgeted sales (units) Required units of available production Deduct: Beginning inventory (units) Budgeted units to produce March 15,800 40% March %ESS SEE BE S 8 9 82 83 2 ) 8 88 Company Direct Materials Dudgut For the months of January February, and March 2021 January February Budgeted units to produce Materials requirements per unit Materials needed for production (pounds) Aud: Budgeled ending inventory (pounds) Tolal materials requirements (pounds) Deduct: Beginning inventory (pounds) Materials to be purchased (pounds Material price per pound Total budgeled cost of direct materials purchases company Direct Labor Budget For the month of January February, and March 2021 January February Budgeted units to produce Direct labor requirements (hours) per uni. Total direct labor hours needed March Direct labor rate per hour) Total budgeted direct labor cost

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_2

Step: 3

blur-text-image_3

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

Managerial Accounting, 1, (6 Months)

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

14th Edition

1337270814, 9781337270816

More Books

Students also viewed these Accounting questions