# Question: The file S12 68 xlsx contains monthly data on consumer revolving credit

The file S12_68.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions.

a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holt’s method with optimized smoothing constants.

b. Which of these two methods appears to provide the best forecasts? Answer by comparing their

MAPE values.

a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holt’s method with optimized smoothing constants.

b. Which of these two methods appears to provide the best forecasts? Answer by comparing their

MAPE values.

**View Solution:**## Answer to relevant Questions

The file S12_69.xlsx contains net sales (in millions of dollars) for Procter & Gamble.a. Use these data to predict Procter & Gamble net sales for each of the next two years. You need consider only a linear and exponential ...Let Yt be the sales during month t (in thousands of dollars) for a photography studio, and let Pt be the price charged for portraits during month t. The data are in the file S11_45.xlsx. Use regression to fit the following ...Other sensitivity analyses besides those discussed could be performed on the product mix model. Use Solver Table to perform each of the following. In each case keep track of the values in the changing cells and the objective ...Consider the graphical solution to the product mix problem. Now imagine that another constraint—any constraint—is added. Which of the following three things are possible: (1) The feasible region shrinks; (2) The feasible ...Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using Solver Table and allowing the initial inventory to vary from 0 to 10,000 in increments ...Post your question