Question

Sales Budget

Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $532, and the S12L5 sells for $336. Projected sales (number of speakers) for the coming five quarters are as follows:

	S12L7	S12L5
First quarter, 20X1	800	1,300
Second quarter, 20X1	2,200	1,400
Third quarter, 20X1	5,600	5,300
Fourth quarter, 20X1	4,600	3,900
First quarter, 20X2	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 20X1 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, 20X1
	1st Qtr.	2nd Qtr.	3rd Qtr.	4th Qtr.	Year
S12L7:
Units
Price	$	$	$	$	$
Sales	$	$	$	$	$
S12L5:
Units
Price	$	$	$	$	$
Sales	$	$	$	$	$
Total sales	$	$	$	$	$

Answer 1

Sales budget for each quarter of 20X1:

Stillwater Designs
Sales Budget
For the Year Ended December 31, 20X1
	1st Qtr.	2nd Qtr.	3rd Qtr.	4th Qtr.	Year
S12L7:
Units	800	2200	5600	4600	13200
Price	$532	$532	$532	$532	$532
Sales	$425600	$1170400	$2979200	$2447200	$7022400
S12L5:
Units	1300	1400	5300	3900	11500
Price	$336	$336	$336	$336	$336
Sales	$436800	$470400	$1780800	$1310400	$3864000
Total sales	$862400	$1640800	$4760000	$3757600	$10886400