Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $632, and the S12L5 sells for $399. 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:

Question Content Area

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.

	1st Qtr.	2nd Qtr.	3rd Qtr.	4th Qtr.	Year
S12L7:
Units	fill in the blank 066afbfff006fbc_1	fill in the blank 066afbfff006fbc_2	fill in the blank 066afbfff006fbc_3	fill in the blank 066afbfff006fbc_4	fill in the blank 066afbfff006fbc_5
Price	$fill in the blank 066afbfff006fbc_6	$fill in the blank 066afbfff006fbc_7	$fill in the blank 066afbfff006fbc_8	$fill in the blank 066afbfff006fbc_9	$fill in the blank 066afbfff006fbc_10
Sales	$fill in the blank 066afbfff006fbc_11	$fill in the blank 066afbfff006fbc_12	$fill in the blank 066afbfff006fbc_13	$fill in the blank 066afbfff006fbc_14	$fill in the blank 066afbfff006fbc_15
S12L5:
Units	fill in the blank 066afbfff006fbc_16	fill in the blank 066afbfff006fbc_17	fill in the blank 066afbfff006fbc_18	fill in the blank 066afbfff006fbc_19	fill in the blank 066afbfff006fbc_20
Price	$fill in the blank 066afbfff006fbc_21	$fill in the blank 066afbfff006fbc_22	$fill in the blank 066afbfff006fbc_23	$fill in the blank 066afbfff006fbc_24	$fill in the blank 066afbfff006fbc_25
Sales	$fill in the blank 066afbfff006fbc_26	$fill in the blank 066afbfff006fbc_27	$fill in the blank 066afbfff006fbc_28	$fill in the blank 066afbfff006fbc_29	$fill in the blank 066afbfff006fbc_30
Total sales	$fill in the blank 066afbfff006fbc_31	$fill in the blank 066afbfff006fbc_32	$fill in the blank 066afbfff006fbc_33	$fill in the blank 066afbfff006fbc_34	$fill in the blank 066afbfff006fbc_35