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:

In looking over the previous year’s sales figures, Alger’s sales budgeting team recalled the following:

a. 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 250% of the previous year’s units.

b. 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.

c. 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 30% to maintain unit sales at the previous year’s level.

d. It was assumed that unit sales of all other models would increase by 5%, prices remaining constant.

Required:
1. Prepare a sales budget by product and in total for Alger Inc. for the coming year.
2. Alger’s team reviewed the previous year’s sales figures to construct the sales budget for the coming year. Which of the four data analytic types (descriptive, diagnostic, predictive, or prescriptive) were they using? Explain.

Transcribed Image Text:

Product LB-1 LB-2 WE-6 WE-7 WE-8 WE-9 Total Number Sold 14,700 18,000 25,200 16,200 6,900 4,000 Price ($) 32.00 20.00 15.00 10.00 18.00 22.00 Revenue $ 470,400 360,000 378,000 162,000 124,200 88,000 $1,582,600