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.

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

Minitab output:

Regression Analysis: Delivery Time versus Number of Cases

The regression equation is
Delivery Time = 24.8 + 0.140 Number of Cases

Predictor Coef SE Coef T P
Constant 24.835 1.054 23.56 0.000
Number of Cases 0.140026 0.005627 24.88 0.000

S = 1.98650 R-Sq = 97.2% R-Sq(adj) = 97.0%

Analysis of Variance

Source DF SS MS F P
Regression 1 2443.5 2443.5 619.20 0.000
Residual Error 18 71.0 3.9
Total 19 2514.5

Predicted Values for New Observations

New Obs Fit SE Fit 95% CI 95% PI
1 45.838 0.458 (44.876, 46.801) (41.555, 50.121)

Values of Predictors for New Observations

Number
New Obs of Cases
1 150

i. 95% confidence interval estimate of the mean time to unload 150 cases of beer: (44.876, 46.801)

i.e. we are 95% confident that the mean time 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.555, 50.121).

we are 95% confident that the unloading time for a single delivery of 150 cases of beer lies in (41.555, 50.121).

j. Since from ANOVA table we see that p-value of F test <0.05 so there is sufficient evidence to conclude that there is significant linear relationship between unloading time and the number of cases of beer delivered. Moreover since R-Sq = 97.2% so 97.2% of total variation in the sample of unloading time is explained by this regression line.

k. If your delivery cost is $100 per hour, variable cost for unloading 150 cases of beer=45.838*100=$4583.8

orchestra answered 1 year ago

Next > < Previous

Related Solutions

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

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

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.

Subjects