Question
EMJB Company sells three products with the following seasonal sales pattern: Products: Quarter A B C 1 40% 30% 10% 2 30% 20% 40% 3
EMJB Company sells three products with the following seasonal sales pattern:
Products:
Quarter | A | B | C |
1 | 40% | 30% | 10% |
2 | 30% | 20% | 40% |
3 | 20% | 20% | 40% |
4 | 10% | 30% | 10% |
Total | 100% | 100% | 100% |
The annual sales budget shows forecasts for the different products and their expected selling price per unit as follows:
Product | Units | Selling Price |
A | 200,000 | $10 |
B | 160,000 | 40 |
C | 400,000 | 16 |
Required: Prepare a sales budget in units and dollars by quarters for the company for the coming year.
Please use the following format:
| First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Year Total |
Product A: |
|
|
|
|
|
Sales (units) |
| ||||
Price x $10 |
| ||||
Sales ($) |
| ||||
|
|
|
| ||
Product B: |
|
|
| ||
Sales (units) |
| ||||
Price x $40 |
| ||||
Sales ($) |
|
| |||
|
|
|
| ||
Product C: |
|
|
| ||
Sales (units) |
| ||||
Price x $16 |
| ||||
Sales ($) |
| ||||
|
|
|
| ||
Total dollars |
|
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