Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $679, and the S12L5 sells for $429. Projected sales (number of speakers) for the coming five quarters are as follows: S12L5 First quarter, 20Y1 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: S12L7 800 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
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $679, and the S12L5 sells for $429. Projected sales (number of speakers) for the coming five quarters are as follows: S12L5 First quarter, 20Y1 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: S12L7 800 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
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please do not give solution in image format thanku

Transcribed Image Text:Sales Budget
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $679, and the S12L5 sells for $429. Projected sales (number of speakers) for the coming five quarters are as follows:
S12L5
First quarter, 20Y1
1,300
Second quarter, 20Y1
1,400
Third quarter, 20Y1
5,300
Fourth quarter, 20Y1
3,900
First quarter, 20Y2
1,200
The vice president of sales believes that the projected sales are realistic and can be achieved by the company.
Required:
S12L7:
Units
Price
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
2nd Qtr.
3rd Qtr.
Sales
S12L5:
Units
Price
Sales
Total sales
1st Qtr.
$
$
$
800
660 X $
380,000 X $
1,300 ✓
417 X
S12L7
542,100 X
1,070,100 X
800
2,200
5,600
4,600
900
2,200 ✔
660 X
1,045,000 X
1,400 ✔
417 X
583,800 X $
2,035,800 X
$
5,600 ✓
5,300
660 X $
2,660,000 X $ 2,185,000 X
4th Qtr.
417 X $
2,210,100 X
5,906,100 X
4,600
660 X $
3,900
Year
417 X $
1,626,300 X
X $
4,662,300 X
13,200
660 X
6,270,000 X
11,900 ✓
417 X
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps

Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education