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 with AI-Powered 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