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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Please do not give solution in image format thanku

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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education