Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S 1 2 L 7 and S 1 2 L 5 . The S 1

Production Budget
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows:
Line Item Description S12L7 S12L5
First quarter, 20Y11,1601,885
Second quarter, 20Y13,1902,030
Third quarter, 20Y18,1207,685
Fourth quarter, 20Y16,6705,655
First quarter, 20Y21,3051,740
The vice president of sales believes that the projected sales are realistic and can be achieved by the company.
Stillwater Designs needs a production budget for each product (representing the amount that must be outsourced to outside manufacturers). Beginning inventory of S12L7 for the first quarter of 20Y1 was 340 boxes. The company's policy is to have 20% of the next quarter's sales of S12L7 in ending inventory. Beginning inventory of S12L5 was 170 boxes. The company's policy is to have 30% of the next quarter's sales of S12L5 in ending inventory.
Required:
Question Content Area
Prepare a production budget for each quarter for 20Y1 and for the year in total.
Stillwater Designs
Production Budget for S12L7
For the Year Ended December 31,20Y1
Line Item Description 1st Qtr.2nd Qtr.3rd Qtr.4th Qtr. Year
Sales Sales
Sales
Sales
Sales
Sales
Desired ending inventory Desired ending inventory
Desired ending inventory
Desired ending inventory
Desired ending inventory
Desired ending inventory
Total needs Total needs
Total needs
Total needs
Total needs
Total needs
Less: Beginning inventory Less: Beginning inventory
Less: Beginning inventory
Less: Beginning inventory
Less: Beginning inventory
Less: Beginning inventory
Units produced Units produced
Units produced
Units produced
Units produced
Units produced
Question Content Area
Prepare a production budget for each quarter for 20Y1 and for the year in total. If required, round your answers to nearest whole value.
Stillwater Designs
Production Budget for S12L5
For the Year Ended December 31,20Y1
Line Item Description 1st Qtr.2nd Qtr.3rd Qtr.4th Qtr. Year
Sales Sales
Sales
Sales
Sales
Sales
Desired ending inventory Desired ending inventory
Desired ending inventory
Desired ending inventory
Desired ending inventory
Desired ending inventory
Total needs Total needs
Total needs
Total needs
Total needs
Total needs
Less: Beginning inventory Less: Beginning inventory
Less: Beginning inventory
Less: Beginning inventory
Less: Beginning inventory
Less: Beginning inventory
Units produced Units produced
Units produced
Units produced
Units produced
Units produced
Check My Work

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

Managerial Accounting For Managers

Authors: Eric Noreen, Peter Brewer, Ray Garrison

6th Edition

1264100590, 9781264100590

More Books

Students also viewed these Accounting questions

Question

=+a) Is this an experiment or an observational study? Explain.

Answered: 1 week ago