Question

In: Accounting

Sales Budget Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team...

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:

  1. Model LB-1 is a newer version of the leaf blower with a gasoline engine. The LB-1 is mounted on wheels instead of being carried. This model is designed for the commercial market and did better than expected in its first year. As a result, the number of units of Model LB-1 to be sold was forecast at 275% of the previous year's units.
  2. Models WE-8 and WE-9 were introduced on July 1 of last year. They are lighter versions of the traditional weed eater and are designed for smaller households or condo units. Alger estimates that demand for both models will continue at the previous year's rate.
  3. A competitor has announced plans to introduce an improved version of model WE-6, Alger's traditional weed eater. Alger believes that the model WE-6 price must be cut 45% to maintain unit sales at the previous year's level.
  4. It was assumed that unit sales of all other models would increase by 5%, prices remaining constant.

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 $

Solutions

Expert Solution

Product Number Sold Price ($) Revenue
LB-1 40425 $               32.00 $      1,293,600
LB-2 18900 $               20.00 $          378,000
WE-6 25200 $                  8.25 $          207,900
WE-7 17010 $               10.00 $          170,100
WE-8 13800 $               18.00 $          248,400
WE-9 8000 $               22.00 $          176,000
Total $      2,474,000

Related Solutions

Sales Budget Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team...
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...
Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team is finalizing...
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:...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette,...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 14,880 for the Sleepeze, 11,860 for the Plushette, and 5,210 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: Salaries for his office (including himself at $66,750, a marketing research assistant at $38,850, and an administrative assistant at $27,700) are budgeted for $133,300 next year. Depreciation on the offices and...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette,...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,160 for the Sleepeze, 12,430 for the Plushette, and 5,410 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: Salaries for his office (including himself at $65,750, a marketing research assistant at $44,400, and an administrative assistant at $23,600) are budgeted for $133,750 next year. Depreciation on the offices and...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette,...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 14,960 for the Sleepeze, 12,080 for the Plushette, and 5,460 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: Salaries for his office (including himself at $62,550, a marketing research assistant at $44,900, and an administrative assistant at $27,450) are budgeted for $134,900 next year. Depreciation on the offices and...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette,...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,130 for the Sleepeze, 11,920 for the Plushette, and 5,500 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: Salaries for his office (including himself at $64,200, a marketing research assistant at $39,950, and an administrative assistant at $23,900) are budgeted for $128,050 next year. Depreciation on the offices and...
Sales and A budget of estimated unit production.Production Budgets Sonic Inc. manufactures two models of speakers,...
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 278 69 Desired inventory (units), June 30 320 60 Expected sales volume (units): East Region 3,900 3,450 West Region 5,250 4,550 Unit sales price $110 $225 a. Prepare a sales budget. Sonic Inc. Sales...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette,...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,560 for the Sleepeze, 11,960 for the Plushette, and 5,150 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: Salaries for his office (including himself at $66,950, a marketing research assistant at $44,850, and an administrative assistant at $26,000) are budgeted for $137,800 next year. Depreciation on the offices and...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette,...
Sales Forecast and Flexible Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,540 for the Sleepeze, 12,140 for the Plushette, and 4,570 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: Salaries for his office (including himself at $67,550, a marketing research assistant at $40,150, and an administrative assistant at $23,400) are budgeted for $131,100 next year. Depreciation on the offices and...
Leaf Industries is preparing its master budget for 2013. Relevant data pertaining to its sales budget...
Leaf Industries is preparing its master budget for 2013. Relevant data pertaining to its sales budget are as follows: Sales for the year are expected to total 8,000,000 units. Quarterly sales are 25%, 30%, 15%, and 30%, respectively. The sales price is expected to be $2.00 per unit for the first quarter and then be increased to $2.20 per unit in the second quarter. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total for Yr Unit Sales 8,000,000 Unit Selling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT