A mail-order catalog business that sells personal computer supplies, software, and hardware maintains a centralized warehouse for the distribution of products ordered. Management is currently examining the process of distribution from the warehouse and has the business objective of determining the factors that affect warehouse distribution costs. Currently, a handling fee is added to the order, regardless of the amount of the order. Data that indicate the warehouse distribution costs and the number of orders received have been collected over the past 24 months and are stored in Warecost. The results are:
Months | Distribution Cost ($thousands) | Number of Orders |
1 | 52.95 | 4,015 |
2 | 71.66 | 3,806 |
3 | 85.58 | 5,309 |
4 | 63.69 | 4,262 |
5 | 72.81 | 4,296 |
6 | 68.44 | 4,097 |
7 | 52.46 | 3,213 |
8 | 70.77 | 4,809 |
9 | 82.03 | 5,237 |
10 | 74.39 | 4,732 |
11 | 70.84 | 4,413 |
12 | 54.08 | 2,921 |
13 | 62.98 | 3,977 |
14 | 72.30 | 4,428 |
15 | 58.99 | 3,964 |
16 | 79.38 | 4,582 |
17 | 94.44 | 5,582 |
18 | 59.74 | 3,450 |
19 | 90.50 | 5,079 |
20 | 93.24 | 5,735 |
21 | 69.33 | 4,269 |
22 | 53.71 | 3,708 |
23 | 89.18 | 5,387 |
24 | 66.80 | 4,161 |
a. Assuming a linear relationship, use the least-squares method to find the regression coefficients b0 and b1.
b. predict the monthly warehouse distribution costs when the number of orders is 4,500.
c. plot the residuals versus the time period.
d. Compute the Durbin-Watson statistic. At the 0.05 level of significance, is there evidence of positive autocorrelation among the residuals?
e. Based on the results of (c) and (d), is there reason to question the validity of the model?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.