Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. You are the manager of a beer distribution center and you want to determine a method for allocating beer delivery costs to the customers.

image text in transcribed
image text in transcribed
1. 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. e. Should you use the model to predict the delivery time for a customer who is receiving 500 cases of beer? Why or why not? f. Determine the coefficient of determination, R, and explain its meaning in this problem. 8. Perform a complete residual analysis. Does the analysis support all the assumptions required for a valid model? Explain. h. At the 0.05 level of significance, is there evidence of a linear relationship between unloading time and the number of cases of beer? 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. 95 103 1 Customer Number of Cases Delivery Time 52 32.1 64 34.8 36.2 85 37.8 37.8 39.7 116 38.5 121 41.9 10 143 44.2 11 157 47.1 161 43 184 49.4 14 202 57.2 15 218 56.8 16 243 60.6 17 254 61.2 267 58.2 275 63.1 65.6 298 67.3 22 23 BBBO00 OU AWNA ?> 20 287 24 25 26 27

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Finance For Your Small Business

Authors: Eric James Burton, Steven M Bragg

1st Edition

9780471323600

More Books

Students also viewed these Accounting questions

Question

Design an internal skills transfer system through tutoring.

Answered: 1 week ago