# Question

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 trend, but you should justify the equation you choose.

b. Use your answer from part a to explain how your predictions of Procter & Gamble net sales increase from year to year.

c. Are there any outliers?

d. You can be approximately 95% sure that Procter & Gamble net sales in the year following next year will be between what two values?

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 trend, but you should justify the equation you choose.

b. Use your answer from part a to explain how your predictions of Procter & Gamble net sales increase from year to year.

c. Are there any outliers?

d. You can be approximately 95% sure that Procter & Gamble net sales in the year following next year will be between what two values?

## Answer to relevant Questions

The file S12_70.xlsx lists annual revenues (in millions of dollars) for Nike. Forecast the company’s revenue in each of the next two years with a linear or exponential trend. Are there any outliers in your predictions for ...The file S12_75.xlsx contains five years of monthly data for a particular company. The first variable is Time (1 to 60). The second variable, Sales1, contains data on sales of a product. Note that Sales1 increases linearly ...In PC Tech’s product mix problem, assume there is another PC model, the VXP that the company can produce in addition to Basics and XPs. Each VXP requires eight hours for assembling, three hours for testing, $275 for ...Modify PC Tech’s product mix model so that there is no maximum sales constraint. Does this make the problem unbounded? Does it change the optimal solution at all? Explain its effect. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Don’t forget to modify range names. Then modify the model again so that there ...Post your question

0