Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $603,...

 

Transcribed Image Text:

Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $603, and the S12L5 sells for $381. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20Y1 800 1,300 Second quarter, 20Y1 2,200 1,400 Third quarter, 20Y1 5,600 5,300 Fourth quarter, 20Y1 4,600 3,900 First quarter, 2012 900 1,200 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Required: 1. Prepare a sales budget for each quarter of 20Y1 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, 20Y1 Line Item Description S12L7: Units Price Sales S12L5: Units Price Sales Total sales 1st Qtr. x 2nd Qtr. 4th Qtr. Year Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $603, and the S12L5 sells for $381. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20Y1 800 1,300 Second quarter, 20Y1 2,200 1,400 Third quarter, 20Y1 5,600 5,300 Fourth quarter, 20Y1 4,600 3,900 First quarter, 2012 900 1,200 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Required: 1. Prepare a sales budget for each quarter of 20Y1 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, 20Y1 Line Item Description S12L7: Units Price Sales S12L5: Units Price Sales Total sales 1st Qtr. x 2nd Qtr. 4th Qtr. Year