Sales Budget
Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team is finalizing the sales budget for the coming year. Sales in units and dollars for last year follow:
Product | Number Sold | Price ($) | Revenue | |
LB-1 | 14,700 | 32 | $ 470,400 | |
LB-2 | 18,000 | 20 | 360,000 | |
WE-6 | 25,200 | 15 | 378,000 | |
WE-7 | 16,200 | 10 | 162,000 | |
WE-8 | 6,900 | 18 | 124,200 | |
WE-9 | 4,000 | 22 | 88,000 | |
Total | $1,582,600 |
In looking over the previous year's sales figures, Alger's sales budgeting team recalled the following:
Required:
Prepare a sales budget by product and in total for Alger Inc. for the coming year. Do not include a multiplication symbol as part of your answer.
Alger Inc. | |||
Sales Budget | |||
For the Coming Year | |||
Model | Units | Price | Total Sales |
LB-1 | $ | $ | |
LB-2 | |||
WE-6 | |||
WE-7 | |||
WE-8 | |||
WE-9 | |||
Total | $ |
Check My Work0 more Check My Work uses remaining.
Alger Inc. | |||
Sales Budget | |||
For the coming Year | |||
Model | Units | Price | Total Sales |
Units×Price | |||
LB-1 | 44,100 | $32 | $1,411,200 |
(Unit increase to 300%) [WN:1] | |||
LB-2 | 19,800 | $20 | $396,000 |
(unit increase by 10%)[WN:2] | |||
WE-6 | 25,200 | $9.75 | $245,700 |
(Price cut down by 35%)[WN:3] | |||
WE-7 | 17,820 | $10 | $178,200 |
(Unit increased by 10%}[WN:4] | |||
WE-8 | 6,900 | $18 | $124,200 |
WE-9 | 4,000 | $22 | $88,000 |
Total | $2,443,300 | ||
Working Notes : | |||
1. No. of units sold of LB 1 = | 14700 * 300% | 44100 | |
2. No. of units sold of LB 2 = | 18000 * (100+10)% | 19800 | |
3. Price of WE-6 is cut down by 35% = | 15 * ( 100 - 35)% | 9.75 | |
4. No. of units sold of WE 7 = | 16200 * (100+10)% | 17820 |
Get Answers For Free
Most questions answered within 1 hours.