PROIN BUL Assume that Stillwater Designs produces two automotive subwoofers: 51217 and 51215. The S1217 sells for $475, and the 51215 sets for $300. Projected sales (number of speakers) for the coming fe quarters are as follows: 51217 51215 First quartet 20: 1,160 1,005 Second quarter, 2011 3,190 2,030 Third quarter, 2011 8,120 7,685 Fourth quarter, 201 6,670 5,655 First quarter, 2012 1,305 1,740 The vice president of seles 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 S127 for the first quarter oxes. The company's policy is to have 20% of the next quarter's sales of $1217 in ending inventory. Beginning inventory of $1215 was 170 boses. The company's policy is to have 30% of the next quarter's sales of 1215 in ending inventory. Required Prepare a production budget for each quarter for 2011 and for the year in total. Sales Stillwater Designs Production Budget for $1217 For the Year Ended December 31, 201 Desired ending inventory 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year