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 | $ |
Alger Inc.
Sales Budget
For the coming Year
Model | Units | Price |
Total Sales =Units×Price |
LB-1 (Unit increase to 250%) [WN:1] |
36,750 | $32 | $1,176,000 |
LB-2 (unit increase by 6%)[WN:2] |
9,080 |
$20 | $381,600 |
WE-6 (Price cut down by 40%)[WN:3] |
25,200 |
$9 |
$226,800 |
WE-7 (Unit increased by 6%}[WN:4] |
17,172 |
$10 | $171,720 |
WE-8 | 6,900 | $18 | $124,200 |
WE-9 | 4,000 | $22 | $88,000 |
Total | $2,168,320 |
WORKING NOTE[WN]:
1)No.of unit sold of LB-1= 14,700× 250%=36,750
2)No.of unit sales of LB-2= 18,000×(100+6)%=18,000×106%=19,080
3)Price of WE-6 is cut down by 40%= $15×(100-40)%=$15×60%=$9
4)Unit sales of WE-7= 16,200×(100+6)%=16,200(106)%=17,172
Sales Budget Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team...
Sales and A budget of estimated unit production.Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 238 64 Desired inventory (units), June 30 273 56 Expected sales volume (units): Midwest Region 2,600 2,900 South Region 5,200 4,500 Unit sales price $115 $210 a. Prepare a sales budget. Sonic Inc. Sales...
Sales and Production Budgets Sonic Inc, manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget. Rumble Thunder Estimated inventory (units), June 259 83 Desired Inventory (units), June 30 298 72 Expected sales volume (units): East Region 3,000 West Region 2,700 5,800 $110 6,550 Unit sales price $185 a. Prepare a sales budget. Sonic Inc. Sales Budget For the Month Ending June...
Sales and Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated Inventory (units), June 1 306 Desired Inventory (units), June 30 352 Expected sales volume (units): Midwest Region 4,250 3,750 South Region 5,800 5,050 Unit sales price $215 a. Prepare a sales budget. Sonic Inc. Sales Budget For the Month Ending June 30 Product...
Show Me How Calculator 258 Sales and Production Budgets Son Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June prepare(a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 Desire inventory (units), June 30 296 Expected sales volume (units): Midwest Region 2,700 3.000 South Region 5.750 6,500 Unit sales price $195 a. Prepare a sales budget Sonic Inc. Sales Budget For the Month Ending...
Sales and Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 256 63 Desired inventory (units), June 30 294 55 Expected sales volume (units): Midwest Region 2,900 2,550 South Region 5,500 4,800 Unit sales price $140 $190 a. Prepare a sales budget. Sonic Inc. Sales Budget For the Month Ending...
Sales and Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 750 300 Desired inventory (units), June 30 500 250 Expected sales volume (units): Midwest Region 12,000 3,500 South Region 14,000 4,000 Unit sales price $60 $90 a. Prepare a sales budget. Sonic Inc. Sales Budget For the Month Ending...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 400,000 units of the standard model and 140,000 units of the deluxe model during the coming year. The standard model requires 0.10 direct labor hour per unit, and the deluxe model requires 0.16. The controller has developed the following cost formulas...
Sales and Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget. Rumble Thunder 85 74 Estimated inventory (units), June 1290 Desired inventory (units), June 30 Expected sales volume (units) East Region West Region Unit sales price 3,850 5,650 $100 3,400 6,400 $205 a. Prepare a sales budget. Sonic Inc Sales Budget For the Month Ending June 30...
Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget. Rumble Thunder Estimated inventory (units), June 1 244 78 Desired inventory (units), June 30 280 68 Expected sales volume (units): East Region 2,600 2,900 West Region 5,400 6,100 Unit sales price $140 $200 a. Prepare a sales budget. Sonic Inc. Sales Budget For the Month Ending June 30...
In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 300,000 units of the standard model and 140,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas for each...