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.51504 8.11805 8.91203 6.83864 10.19143 .059

(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 5 decimal places and dollar amount to 1 decimal place 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 = .792. Optional technical note needed. The distance value equals Leverage. (Round your answers to 5 decimal places.)


99% PI; [, ]

Solutions

Expert Solution

a)

  • Since we are using the mean demand, then from the table we see that the 95 percent confidence interval is given as

→[8.11805,8.91203]

  • In order to have an ample supply, we must round up any decimal, so we would have

→8.91203≈9 bottles in supply.

  • The minimum value we would have in revenue is given as

→8.11805*3.70=$30.036785

b)

We know that n=30 and s=0.792

From the output, we also know that μ=8.51504

Now, for a 99 percent interval, the z value is given as

Zα/2=Z.01/2=Z.005=2.575

So the confidence interval is given as

[ 8.142370 , 8.88738 ]


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