eBook

Sales Budget

Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $584, and the S12L5 sells for $369. 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, 20Y2	900	1,200

The vice president of sales believes that the projected sales are realistic and can be achieved by the company.

Required:

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

	1st Qtr.	2nd Qtr.	3rd Qtr.	4th Qtr.	Year
S12L7:
Units	___	___	___	___	___
Price	$___	$___	$___	$___	$___
Sales	$___	$___	$___	$___	$__
S12L5:
Units	___	___	___	___	___
Price	$___	$___	$___	$___	$___
Sales	$___	$___	$___	$___	$___
Total sales	$___	$___	$___	$___	$___