Question

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 7%, 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			$

Answer 1

	Sales Budget Alger Inc
	Last Year Actual	Coming Year Budget	Remarks
Model	Sales Units	Price/unit	Revenue	Sales Units	Price/unit	Revenue
LB-1	14,700	$              32.00	$    470,400.00	40,425.00	$        32.00	$         1,293,600	Units increase by 275%
LB-2	18,000	$              20.00	$    360,000.00	19,260.00	$        20.00	$             385,200	=+7% in units, price same
WE-6	25,200	$              15.00	$    378,000.00	25,200.00	$           8.25	$             207,900	Price cut by 45% over last yr, units same
WE-7	16,200	$              10.00	$    162,000.00	17,334.00	$        10.00	$             173,340	=+7% in units, price same
WE-8	6,900	$              18.00	$    124,200.00	13,800	$        18.00	$             248,400	Last year units were for half the year , coming year itbis doubled for full year, Rate same
WE-9	4,000	$              22.00	$       88,000.00	8,000	$        22.00	$             176,000	Last year units were for half the year , coming year itbis doubled for full year, Rate same
Total sales	85,000		$       1,582,600	$     124,019		$         2,484,440