Question
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows:
Line Item Description | 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
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.
Line Item Description | 1st Qtr. | 2nd Qtr. | 3rd Qtr. | 4th Qtr. | Year |
---|---|---|---|---|---|
S12L7: | |||||
Units | Units | Units | Units | Units | Units |
Price | $Price | $Price | $Price | $Price | $Price |
Sales | $Sales | $Sales | $Sales | $Sales | $Sales |
S12L5: | |||||
Units | Units | Units | Units | Units | Units |
Price | $Price | $Price | $Price | $Price | $Price |
Sales | $Sales | $Sales | $Sales | $Sales | $Sales |
Total sales | $Total sales | $Total sales | $Total sales | $Total sales | $Total sales |
Question Content Area
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started