Activity 3.5 – Module Problems and Case Study

Complete the following case study and problems and submit the results in either a Microsoft Word document or a Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each problem on a separate sheet and label the tab with problem number. Save your document with a descriptive file name, including the assignment and your name.

Complete the Chapter 4 Case and answer the questions:

North-South Airline Case Study: In January 2012, Northern Airlines merged with Southeast Airlines . . .

3-1 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table.

Year Demand for fertilizer (1,000s of bags)

1 4

2 6

3 4

4 5

5 10

6 9

7 10

8 11

9 15

10 16

11 18

1. Develop a 3-year moving average to forecast sales.
2. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 3 and a weight of 2 for the second past year and sales in the other 2 years are each given a weight of 1.
3. Which method do you think is best?
4. Develop a trend line for the demand for fertilizer using any computer software.
5. You have now developed three different forecasts. These are a 3-year moving average, a weighted moving average, and a trend line. Which one would you use? Explain your answer.

3-2 Sales of Cool-Man air conditioners have grown steadily during the past 5 years:

Year Sales

1 440

2 465

3 520

4 573

5 586

6 ?

The sales manager had predicted, before the business started, that year 1’s sales would be 410 air conditioners.

1. Using exponential smoothing with a weights of a = 0.30, 0.60, and 0.90 develop forecasts for years 2 through 6.
2. What effect did the smoothing constant have on the forecasts for Cool-Man air conditioners?
3. Which smoothing constant gives the most accurate forecast?
4. Use a three-year moving average forecasting model to forecast the sales of Cool-Man air conditioners.
5. Use the trend projection method to develop a forecast for the sales of Cool-Man air conditioners.
6. Which of the five models you developed was the most accurate (best)?

3-3 A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are compiled and the state comptroller uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. Four years of quarterly data (in $millions) for one particular area of southeast Texas follow:

1. Compute seasonal indices for each quarter based on a CMA.
2. Deseasonalize the data and develop a trend line on the deseasonalized data.
3. Use the trend line to forecast the sales for each quarter of year 5.
4. Use the seasonal indices to adjust the forecasts found in part (c) to obtain the final forecasts.

Price: $20.68

Solution: The downloadable solution consists of 12 pages, 868 words and 1 charts.
Deliverable: Word Document