Question

In: Statistics and Probability

Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for...

Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for Fresh will be x1 = 3.70, the average price of competitors’ similar detergents will be x2 = 3.90, and Enterprise Industries' advertising expenditure for Fresh will be x3 = 6.50, y = the demand in hundreds of thousands of bottles. A 95 percent prediction interval for this demand is given on the following Excel add-in (MegaStat) output:

95% Confidence Interval 95% Prediction Interval
  Predicted lower upper lower upper Leverage
  8.4107     8.3143      8.5070    7.9188      8.9025    0.040    
95% Confidence Interval 95% Prediction Interval
Predicted lower upper lower upper Leverage
8.4107 8.3143 8.5070 7.9188 8.9025 0.040

(a) Find and report the 95 percent prediction interval on the output. If Enterprise Industries plans to have in inventory the number of bottles implied by the upper limit of this interval, it can be very confident that it will have enough bottles to meet demand for Fresh in the future sales period. How many bottles is this? If we multiply the number of bottles implied by the lower limit of the prediction interval by the price of Fresh ($3.70), we can be very confident that the resulting dollar amount will be the minimal revenue from Fresh in the future sales period. What is this dollar amount? (Round 95% PI to 4 decimal places, Lower dollar amount to 2 decimal places and Level of inventory needed to the nearest whole number.)

95% PI [  ,  ]
Level of inventory needed = bottles
Lower dollar amount = $


(b) Calculate a 99 percent prediction interval for the demand for Fresh in the future sales period. Hint: n = 30 and s = .235. Optional technical note needed. The distance value equals Leverage. (Round your answers to 4 decimal places.)

99% PI [ , ]

Solutions

Expert Solution

Answer:-

Given That:-

Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for Fresh will be x1 = 3.70, the average price of competitors’ similar detergents will be x2 = 3.90, and Enterprise Industries' advertising expenditure for Fresh will be x3 = 6.50, y = the demand in hundreds of thousands of bottles.

Given,

(a) Find and report the 95 percent prediction interval on the output. If Enterprise Industries plans to have in inventory the number of bottles implied by the upper limit of this interval, it can be very confident that it will have enough bottles to meet demand for Fresh in the future sales period. How many bottles is this? If we multiply the number of bottles implied by the lower limit of the prediction interval by the price of Fresh ($3.70), we can be very confident that the resulting dollar amount will be the minimal revenue from Fresh in the future sales period. What is this dollar amount?

95% PI[7.9188, 8.9025]

Level of inventory needed = 8.902 * 100000

= 890250

Lower dollar amount = 7.9188 * 3.70 * 100000

= 2898280.80


(b) Calculate a 99 percent prediction interval for the demand for Fresh in the future sales period. Hint: n = 30 and s = .235. Optional technical note needed. The distance value equals Leverage. (Round your answers to 4 decimal places.)

99% PI [ , ]

Distance value = 0.04

CI = 99%

= 1%

DF = n - p - 1

= 30 - 3 - 1

= 26

t critical value = 2.779

s = 0.235

99% prediction interval = point estimate

  

= (7.7448, 9.0766)

Please revert for dounts and please upvote my answer...


Related Solutions

Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for...
Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for Fresh will be x1 = 3.70, the average price of competitors’ similar detergents will be x2 = 3.90, and Enterprise Industries' advertising expenditure for Fresh will be x3 = 6.50, y = the demand in hundreds of thousands of bottles. A 95 percent prediction interval for this demand is given on the following Excel add-in (MegaStat) output: 95% Confidence Interval 95% Prediction Interval Predicted...
The Fresh Detergent Case Enterprise Industries produces Fresh, a brand of liquid detergent. In order to...
The Fresh Detergent Case Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 33 sales periods. Each sales period is defined as one month. The variables are as follows: Demand = Y = demand for a large size bottle of Fresh (in 100,000) Price =...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). The demand data are presented in table concerning y (demand for Fresh liquid laundry detergent), x1x1 (the price...
Enterprise Industries produces Fresh, a liquid laundry detergent product. In order to study the relationship between...
Enterprise Industries produces Fresh, a liquid laundry detergent product. In order to study the relationship between price and sales of Fresh, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is four weeks). The data can be found Fresh.xlsx. Here is the explanation of each variable: Period: the index of 30 sales period (Period = 1, 2, …, 30) Sales: the sales volume (in hundreds of thousands of bottles) of Fresh...
Q7. Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its...
Q7. Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). Summary of Fit RSquare 0.940514 RSquare Adj 0.928121 Root Mean Square Error 0.18111 Mean of Response 8.382667...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). The demand data are presented in table concerning y (demand for Fresh liquid laundry detergent), x1x1 (the price...
The following partial MINITAB regression output for the Fresh detergent data relates to predicting demand for...
The following partial MINITAB regression output for the Fresh detergent data relates to predicting demand for future sales periods in which the price difference will be .10 Predicted Values for New Observations New Obs Fit SE Fit 95% CI 95% PI 1 8.3323 .1570 (8.0107, 8.6539) (6.7456, 9.9189) 2 8.3601 .142 (8.0689, 8.6512) (6.7793, 9.9408) (a) Report a point estimate of and a 95 percent confidence interval for the mean demand for Fresh in all sales periods when the price...
The following partial MINITAB regression output for the Fresh detergent data relates to predicting demand for...
The following partial MINITAB regression output for the Fresh detergent data relates to predicting demand for future sales periods in which the price difference will be .10 Predicted Values for New Observations New Obs Fit SE Fit 95% CI 95% PI 1 8.4972 .1734 (8.1421, 8.8523) (6.9576, 6.9576) 2 8.4425 .134 (8.1690, 8.7160) (6.9197, 6.9197) (a) Report a point estimate of and a 95 percent confidence interval for the mean demand for Fresh in all sales periods when the price...
The following partial MINITAB regression output for the Fresh detergent data relates to predicting demand for...
The following partial MINITAB regression output for the Fresh detergent data relates to predicting demand for future sales periods in which the price difference will be .10 Predicted Values for New Observations New Obs Fit SE Fit 95% CI 95% PI 1 8.6116 .1505 (8.3032, 8.9200) (7.1346, 10.0887) 2 8.4946 .129 (8.2308, 8.7583) (7.0262, 9.9629) (a) Report a point estimate of and a 95 percent confidence interval for the mean demand for Fresh in all sales periods when the price...
Consider a binomial tree with one future period (T=0,1) in which the price can go up...
Consider a binomial tree with one future period (T=0,1) in which the price can go up to $30 or decrease to $15. The price of the asset at T=0 is $20, and there is a 20% probability that it goes up at T=1. The investor starts with an initial wealth of $1,000. The risk-free asset yields a return of zero percent. What is the expected terminal wealth of the investor if she invests 70% of her wealth in the risky...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT