Sales Budget Assume that stillwater Designs produces two automotive subwoofers: 512L7 and 51215. The S12L7 sells for $641, and the 5125 sells for $405. Projected sales (mummber of speakers) for the coming five quarters are as follows: 512L7 512LS 800 1,300 First quarter, 2011 Second quarter, 20Y1 2,200 1,400 Third quarter, 2011 5,600 5,300 Fourth quarter 2011 4,600 3,900 First quarter, 2012 900 1,200 The vice president of sales belleves that the projected sales are realistic and can be achieved by the company, Required: Prepare a sales budget for each quarter of 2011 and for the year in total. Show sales by product and in total for each time period. Do not include a multiplication symbol as part of your answer. Stillwater Designs Sales Budget For the Year Ended December 31, 2011 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year S12L7 Stillwater Designs Sales Budget For the Year Ended December 31, 20Y1 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year S12L7: Units Price Sales S12L5: Units Price Sales Total sales Accounting numeric field How will stillwater Designs use this sales budget? 1. Stillwater Designs will use the sales budget in planning as the basis for the production budget. 2. The company can also compare actual sales against the budget to see if expectations were achieved. 3. Both 1 and 2 4. None of the above S12L5 960 Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and 51215. The S12L7 sells for $475, and the S125 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 First quarter, 2011 1,560 Second quarter, 2011 2,640 1,680 Third quarter, 2011 6,720 6,360 Fourth quarter, 2011 5,520 4,680 First quarter, 2072 1,080 1,440 The vice president of sales belleves trkot 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 mentory 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 S1215 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 TOP Athen 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 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 2011 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, 20Y1 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year Sales Desired ending inventory Total needs Less: Beginning inventory 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, 20Y1 1st Qtr. 2nd Qtr. 3rd r. 4th Qtr. Year Sales Desired ending inventory Total needs Less: Beginning inventory Units produced