both tables please

Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and 512L5. The 512L7 sells for $475) and the S12L5 sets for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L5 1,160 S12L7 First quarter, 2011 1,885 Second quarter, 20Y1 3,190 2,030 Third quarter, 2011 8,120 7,655 Fourth quarter, 2011 6,670 5,655 First quarter, 2012 1,305 1,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 manufacturers located in B). Beginning inventory of S12L7 for the first quarter of 201 was 340 boxes. The company's policy is to have 20w of the next quarter's sales of $12.7 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 20Y1 and for the year in total Stillwater Designs Production Budget for S12L7 For the Year Ended December 31, 2011 1st Qtr. 2nd Qtr. 3rd Qtr. 4th otr. Year Previous Next Check My Works more Check My Work uses pemaining Stillwater Designs Production Budget for S12L7 For the Year Ended December 31, 2011 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year Sales Desired ending inventory Total needs Less: Beginning inventory Units produced 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, 2011 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year Sales Desired ending inventory Total needs Less: Beginning inventory Units produced Check My Work 5 more Check My Work uses remaining