Question

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 ? ? ? ?

Homework Answers

Answer #1

Desired finished inventory is 15% of next quater forecasted sales.

Budgeted sales 12500 15000 20000 16250
Add desired inventory 2250 3000 2438 5000
Total needs 14750 18000 22438 21250
Less beginning inventory 2000 2250 3000 2438
Reqd production 12750 15750 19438 18812

Add desired inventory row is calculated as 15% of next quarter sales.

Total needs is calculated by adding the budgeted sales and desired final inventory.

After subtracting the beginning inventory, we will get the required production in units.

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
Which of the following equations is used to prepare a production budget? Multiple Choice 1.Budgeted unit...
Which of the following equations is used to prepare a production budget? Multiple Choice 1.Budgeted unit sales − Desired units of ending finished goods inventory + Units of beginning finished goods inventory = Required production in units 2.Budgeted unit sales + Desired units of ending finished goods inventory − Units of beginning finished goods inventory = Required production in units 3.Budgeted unit sales + Desired units of beginning finished goods inventory − Units of ending finished goods inventory = Required...
Budgeted production is calculated by: A. adding budgeted unit sales to budgeted beginning finished goods inventory,...
Budgeted production is calculated by: A. adding budgeted unit sales to budgeted beginning finished goods inventory, and subtracting budgeted ending finished goods inventory. B. adding budgeted unit sales to budgeted ending finished goods inventory, and subtracting budgeted beginning finished goods inventory. C. adding budgeted unit sales to budgeted ending work in process inventory, and subtracting budgeted beginning work in process inventory. D. adding budgeted unit sales to budgeted beginning work in process inventory, and subtracting budgeted ending work in process...
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...
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...
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...
Data                                    Year 2 Quarter     &
Data                                    Year 2 Quarter                              Year 3 Quarter                                            1              2             3    4           1             2 Budgeted unit sales        40,000 60,000 100,000             50,000 70,000 80,000 Selling price per unit $12 Accounts receivable, beginning balance $65,000 Sales collected in the quarter sales are made 75% Sales collected in the quarter after sales are made 25% Desired ending finished goods inventory is 30% of budgeted unit sales of next QTR Finished goods inventory, beginning 12,000 Raw materials required...
Nearing Company has provided the following information: Budgeted unit sales: January 420,000 February 400,000 March 430,000...
Nearing Company has provided the following information: Budgeted unit sales: January 420,000 February 400,000 March 430,000 April 450,000 Nearing Company plans on maintaining ending inventory levels equal to 40% of the following month's unit sales. Fill in the amounts for the quarter ending March 31, 2018: You must enter your answers in the following format: x,xxx 1) Budgeted unit sales 2) Desired units of ending finished goods inventory 3) Total needs 4) Units of beginning finished goods inventory 5) Required...
Production Budget Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for...
Production Budget Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April 216,000 May 264,000 June 240,000 July 288,000 Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pumps is only 21,000. Required: Prepare a production budget for the second...
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to...
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to total 1,000,000 units. Quarterly sales in units are 20%,25%,30%, and 25% respectively. The sales price is expected to be $50 per unit for the first 3 quarters and $55 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than the budgeted sales volume for the first quarter of 2017. Cash collections from sales...
I have to create a production budget: 1. I don't know if what I already answered...
I have to create a production budget: 1. I don't know if what I already answered is correct (verification on that would be great) 2. I'm not sure how to solve the rest of it If anyone does answer this, can you please write our the formulas as well so I can understand how you answered it. Thanks a million! INPUT AREA: UNIT SALES VALUES: FROM "FORECAST" WORKSHEET      DESIRED FIN. GOODS ENDING INVENTORY IS 5% OF THE NEXT MONTH'S...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT