Question

In: Statistics and Probability

You are the manager of a beer distribution center and you want to determine a method...

You are the manager of a beer distribution center and you want to determine a method for allocating beer delivery costs to the customers. Although one cost clearly relates to travel time within a particular route, another variable cost reflects the time required to unload the cases of beer at the delivery point. You want to develop a model to predict this cost, so you collect a random sample of 20 deliveries within your territory. The unloading time and the number of cases are shown in the Excel data file for this assignment, under the tab Delivery.

DO NOT USE MINITAB, but you can use EXCEL.

i. Construct a 95% confidence interval estimate of the mean time to unload 150 cases of beer and a 95% prediction interval of the unloading time for a single delivery of 150 cases of beer. Explain your results.

j. What conclusions can you reach from the analysis above regarding the relationship between unloading time and the number of cases of beer delivered?

k. If your delivery cost is $100 per hour, what variable cost for unloading 150 cases of beer should you add to that customers invoice?   Explain your thought process.

Customer Number of Cases Delivery Time
1 52 32.1
2 64 34.8
3 73 36.2
4 85 37.8
5 95 37.8
6 103 39.7
7 116 38.5
8 121 41.9
9 143 44.2
10 157 47.1
11 161 43
12 184 49.4
13 202 57.2
14 218 56.8
15 243 60.6
16 254 61.2
17 267 58.2
18 275 63.1
19 287 65.6
20 298 67.3

Solutions

Expert Solution

Using <Excel<Data<Megastst<Correlation/regression<regression

Regression Analysis
0.972
r   0.986
Std. Error   1.987
n   20
k   1
Dep. Var. Delivery Time
ANOVA table
Source SS   df   MS F p-value
Regression 2,443.4660 1   2,443.4660 619.20 2.15E-15
Residual 71.0315 18   3.9462
Total 2,514.4975 19  
Regression output confidence interval
variables coefficients std. error    t (df=18) p-value 95% lower 95% upper
Intercept 24.8345
Number of Cases 0.1400 0.0056 24.884 2.15E-15 0.1282 0.1518
Predicted values for: Delivery Time
95% Confidence Interval 95% Prediction Interval
Number of Cases Predicted lower upper lower upper Leverage
150 45.8385 44.8761 46.8009 41.5555 50.1215 0.053

i. 95% confidence interval estimate of the meantime to unload 150 cases of beer: (44.8761,46.8009)

We are 95% confident that the meantime to unload 150 cases of beer lies in  (44.876, 46.801)

95% prediction interval of the unloading time for a single delivery of 150 cases of beer: (41.5555, 50.1215).

We are 95% confident that the unloading time for a single delivery of 150 cases of beer lies in (41.556, 50.122).

j. Since from ANOVA table,

We get the p-value of F test is less than the level of significance 0.05 so there is sufficient evidence to conclude that there is a significant linear relationship between unloading time and the number of cases of beer delivered.

Since R-Sq = 97.2% so 97.2% of the total variation in the sample of unloading time is explained by this regression line.

k.  If your delivery cost is $100 per hour, then the variable cost for unloading 150 cases of beer=45.8385*100=$4583.85


Related Solutions

You are the manager of a beer distribution center and you want to determine a method...
You are the manager of a beer distribution center and you want to determine a method for allocating beer delivery costs to the customers. Although one cost clearly relates to travel time within a particular route, another variable cost reflects the time required to unload the cases of beer at the delivery point. You want to develop a model to predict this cost, so you collect a random sample of 20 deliveries within your territory. The unloading time and the...
Suppose you are a financial manager of a company and you want to determine the price...
Suppose you are a financial manager of a company and you want to determine the price of the stock. The most recent annual (2019) dividend payment of the company, was $8 per share. You expect that these dividends will grow at a 5% annual rate over the next five years. At the end of the fifth year (i.e. the end of 2024) the dividend growth rate is expected to increase to 6.5% for the foreseeable future. If the firm’s required...
You want to determine the speed limit for a local highway. Distribution data for the driving...
You want to determine the speed limit for a local highway. Distribution data for the driving speed on a given street is given below; all speeds have been rounded to the nearest integer. Part a: What is the average(mean) and standard deviation of this sample of data? (Hint, you will need to manipulate the data – you cannot use the average or stdev functions in excel on the data as is.) Part b: What is the value that 85% of...
You want to determine the speed limit for a local highway.    Distribution data for the driving...
You want to determine the speed limit for a local highway.    Distribution data for the driving speed on a given street is given below; all speeds have been rounded to the nearest integer.   Speed(x) Car Count 39 8 40 8 41 24 42 24 43 48 44 96 45 208 46 200 47 200 48 136 49 16 50 16 51 8 52 0 53 8 Part a: What is the average(mean) and standard deviation of this sample of data?...
the manager of a candy supply store, and you want to determine whether the mean amount...
the manager of a candy supply store, and you want to determine whether the mean amount of candy contained in 5-ounce bag purchased from a nationally known refiner is actually 5 ounces. You know from the refiner's specifications that the amount of candy per bag is normally distributed with the standard deviation of 0.25 ounces. You select a random sample of 30 bags, and the mean amount of candy per 5-ounce bag is 5.10 ounces. What are the hypotheses that...
Determine the factorization method and MLE of gamma distribution
Determine the factorization method and MLE of gamma distribution
As the newly hired manager of a company that provides cell-phone service, you want to determine...
As the newly hired manager of a company that provides cell-phone service, you want to determine the proportion of adults in your state that live in a home with a cell phone but no land line service. 1.Assuming you have no prior information, how many people must you survey to ensure that your estimate has no more than a 4% margin of error, with 95% confidence? (Hint: use p=50% when you haven't done a pilot study) 2.Suppose you do a...
You have been hired as the manager of a community health center. This health center provides...
You have been hired as the manager of a community health center. This health center provides medical care to children. One of your first tasks is to develop a static annual budget for the health center. In fact, the Board of Directors wants to see your budget by Saturday at midnight. In order to develop an accurate static budget you know you need to get some facts. You ask around to see what kind of information you can gather. *This...
When a can of beer is both full and empty, the center of mass is in...
When a can of beer is both full and empty, the center of mass is in the center of the can. As you drink your beer, however, the center of mass lowers to some minimum point, before returning back to the center. What is that minimum point?   
For every beer drinker it is extremely important to determine whether the glass of tapped beer...
For every beer drinker it is extremely important to determine whether the glass of tapped beer in a certain pub contains 0.5l of beer as claimed. Based on the random sample of 200 beers the following sample characteristics were obtained: sample mean 0.49l and sample standard deviation 0.1l. Based on the assumption that the amount of beer in a glass is normally distributed, construct a 95% condence interval for the mean.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT