Production Budget Assume that Stillwater Designa produces two automotive subwoofers: S12L7 arid S12L5 The 51217 sels for $475, and the S125 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 1,080 1.755 First quarter, 2011 Second quarter, 2011 2,970 1,890 Third quarter, 2011 7,560 7,155 Fourth quarter 2011 6,210 5,265 1.215 1,620 First quarter, 2012 The vice president of sales belleves 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 Aswoeginning inverton OP $12L7 for the first quarter of 201 was 340 boxes. The company's policy is to have 20% of the next quarter's sales of 512.7 in ending inventory Beginning inventor of S12L5 was 170 boxes. The company's policy is to have 10% of the next quarter's sales of $1245 in ending inventory Required: Prepare a production budget for each quarter for 2011 and for the year in total Stillwater Designs Production Budget for S12L7 For the Year Ended December 31, 20Y1 1st Qtr. 2nd Qtr. 3rd Qur. 4th Qtr. Sales 1.NO 2.970 7.500 6210 Desired ending inventory 334 X 891 X 2,26 X 1.861X Year 19,035X 5,346 X The vice president of sales belleves 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 2071 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: Prepare a production budget for each quarter for 2011 and for the year in total. Stillwater Designs Production Budget for S12L7 For the Year Ended December 31, 2011 1st Qur. 2nd Qur. 3rd Qtr. 4th otr. 1.00 2.970 7.500 6210 Desired ending inventory 334 X 191 X 2.765 X 1 X Total needs 9.820 X 5,07 X Less: Beginning inventory 1 x 2.300 X Units produced Year Sales 19,035 X X 3.361X 1.44 x 30 20151 X 340 334 X 1.064 X 3. X 97 X SOX 23,041 X Check My Wor Partially correct Prepare a production budget for each quarter for 2011 and for the year in total. If required, round your answers to nearest whole value Prepare a production budget for each quarter for 2071 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, 2011 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year Sales 1.755 1.890 7.155 5,265 Desired ending Inventory Total needs 11111 Less: Beginning inventory Units produced