In: Accounting
The sales budget often uses the prior year’s sales as a starting point, and then sales quantities are revised for various factors such as planned advertising and promotion, projected pricing changes, and expected industry and general economic conditions. LearnCo has completed reviewing its prior year’s sales and has prepared the following sales budget.
After reviewing LearnCo’s sales budget, you note that three numbers have been omitted. The company’s controller has told you that the units sold for the Basic and Deluxe models are expected to be the same. Fill in the missing amounts.
LearnCo Sales Budget For the Year Ending December 31, 20Y2 |
|||
Product |
Unit Sales Volume |
Unit Selling Price |
Total Sales |
Basic Abacus | $7 | $252,000 | |
Deluxe Abacus | 468,000 | ||
Totals | 72,000 | $720,000 |
LearnCo |
|||
Sales Budget |
|||
For the Year Ending December 31, 20Y2 |
|||
Product |
Unit Sales |
Unit Selling |
Total |
Volume |
Price |
Sales |
|
Basic Abacus |
36,000 |
$7 |
$252,000 |
Deluxe Abacus |
36,000 |
$13 |
$468,000 |
Totals |
72,000 |
$720,000 |
--Working
LearnCo |
|||
Sales Budget |
|||
For the Year Ending December 31, 20Y2 |
|||
Product |
Unit Sales |
Unit Selling |
Total |
Volume |
Price |
Sales |
|
Basic Abacus |
=252000/7 |
7 |
252000 |
Deluxe Abacus |
=72000-36000 |
=468000/36000 |
468000 |
Totals |
72000 |
=252000+468000 |