Question

Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells...

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:

S12L7 S12L5
First quarter, 20X1 880 1,430
Second quarter, 20X1 2,420 1,540
Third quarter, 20X1 6,160 5,830
Fourth quarter, 20X1 5,060 4,290
First quarter, 20X2 990 1,320

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 manufacturers located in Asia). Beginning inventory of S12L7 for the first quarter of 20X1 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.

A production budget for each quarter for 20X1 and for the year in total.

Production Budget for S12L7

Sales 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Year Total
Desired Ending Inventory
Total Needs
Less: Beginning inventory
Units produced

Production Budget for S12L5

Sales 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Year Total
Desired Ending Inventory
Total Needs
Less: Beginning inventory
Units produced

Homework Answers

Answer #1

PRODUCTION BUDGET FOR S12L7

S12L7

Q1 q2 q3 q4 q5
Sales 880 2420 6160 5060 990
Desired ending inventory 484 1232 1012 198 340
Total needs 1364 3652 7172 5258 1330
Less begining inventory 340 484 1232 1012 198
Units produced 1024 3168 5940 4246 1132

PRODUCTION BUDGET FOR S12L5

Q1 q2 q3 q4 q5
Sales 1430 1540 5830 4290 1320
Desired ending inventory 462 1749 1287 396 170
Total needs 1892 3289 7117 4686 1490
Less begining inventory 170 462 1749 1287 396
Units produced 1722 2827 5368 3399 1094

Notes

1) The opening inventory for 1qtr is ending inventory for last quarter

The ending inventory for 1qtr is opening inventory for 2 qtr

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells...
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: S12L7 S12L5 First quarter, 20X1 1,120 1,820 Second quarter, 20X1 3,080 1,960 Third quarter, 20X1 7,840 7,420 Fourth quarter, 20X1 6,440 5,460 First quarter, 20X2 1,260 1,680 The vice president of sales believes that the projected sales are realistic and can be achieved...
Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells...
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: S12L7 S12L5 First quarter, 20Y1 920 1,495 Second quarter, 20Y1 2,530 1,610 Third quarter, 20Y1 6,440 6,095 Fourth quarter, 20Y1 5,290 4,485 First quarter, 20Y2 1,035 1,380 The vice president of sales believes that the projected sales are realistic and can be achieved...
Stillwater Designs produces two subwoofers: S12L7 and S12L5. The S12L7 sells for $660, and the S12L5...
Stillwater Designs produces two subwoofers: S12L7 and S12L5. The S12L7 sells for $660, and the S12L5 sells for $417. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20X1 800 1,300 Second quarter, 20X1 2,200 1,400 Third quarter, 20X1 5,600 5,300 Fourth quarter, 20X1 4,600 3,900 First quarter, 20X2 900 1,200 Sales Budget for Year Ended in December 31 20X1 S12L7 1st Qtr 2nd QTR 3rd QTR 4th Qtr Year Units Price...
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475,...
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: S12L7 S12L5 First quarter, 20Y1 1,040 1,690 Second quarter, 20Y1 2,860 1,820 Third quarter, 20Y1 7,280 6,890 Fourth quarter, 20Y1 5,980 5,070 First quarter, 20Y2 1,170 1,560 The vice president of sales believes that the projected sales are realistic and can be achieved by the...
Production Budget • Desired ending finished goods inventory is 15% of the budgeted unit sales of...
Production Budget • Desired ending finished goods inventory is 15% of the budgeted unit sales of the next quarter Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Budgeted unit sales 12500 15000 20000 16250 Add desired ending finished goods inventory 7 8 9 5000 Total needs ? ? ? 21250 Less beginning finished goods inventory 2000 10 11 12 Required production in units ? ? ? ?
KylerKyler Foods produces specialty soup sold in jars. The projected sales in dollars and jars for...
KylerKyler Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as? follows: Total sales revenue Number of jars sold 1st quarter. . . . $185,000 154,500 2nd quarter. . . $213,000 180,000 3rd quarter. . . . $257,000 210,500 4th quarter. . . . $199,000 161,000 KylerKyler anticipates selling 226 comma 000226,000 jars with total sales revenue of $ 265 comma 000$265,000 in the first quarter of...
XO Manufacturing's sales budget showed the following projections, by quarter, for the next six quarters: Quarter  ...
XO Manufacturing's sales budget showed the following projections, by quarter, for the next six quarters: Quarter   1st 2021   2nd 2021   3rd 2021 4th 2021   1st 2022   2nd 2022 Units       10,000       12,000       14,000     16,000       12,000       14,000 Inventory on December 31 of 2020 is expected to be 1,000 units. The quantity of finished goods inventory at the end of each quarter is to equal 10%of the next quarter's budgeted units to be sold. Required: Prepare a Production Budget for XO for 2021...
The marketing department of Colette Corporation has submitted the following sales forecast for the upcoming fiscal...
The marketing department of Colette Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account, and recorded in Accounts Receivable): 1st quarter 2nd quarter 3rd quarter 4th quarter Budgeted unit sales 10,000 13,000 12,000 15,000 The selling price of the company's product is $15 per unit. Management expects to collect 60% of sales in the quarter in which the sales are made, 35% in the following quarter, and 5% of sales are expected...
Problem D5-31 Coronado Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric...
Problem D5-31 Coronado Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Vanessa Aaron, the company’s sales manager, prepared the following sales forecast for 2018. The forecasted sales prices include a 5% increase in the acoustic guitar price and a 10% increase in the electric guitar price, to cover anticipated increases in raw materials prices. Sales Price 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Acoustic guitar sales $1,240...
he marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...
he marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,700 13,700 15,700 14,700 The selling price of the company’s product is $26 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT