Question

In: Operations Management

Freight car loadings over an 18-week period at a busy port are as follows: Week Number...

Freight car loadings over an 18-week period at a busy port are as follows:

Week Number Week Number Week Number
1 360 7 430 13 505
2 375 8 450 14 515
3 390 9 470 15 545
4 375 10 455 16 560
5 390 11 475 17 575
6 400 12 495 18 590


a. Determine a linear trend line for expected freight car loadings.

YˆY^ =  +  t

b. Use the above trend equation to predict expected loadings for Weeks 20 & 21.

The forecasted demand for Week 20 is? and for Week 21 is ?

The manager intends to install new equipment when the volume exceeds 940 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level?

It should reach 940 loadings in Week?

Solutions

Expert Solution

The given data is as below. Here the independent variable (x) is the week and the dependent variable (y) is the number of loadings.

The regression equation to forecast the sales is of the form y = a+bx, where the value of a and b is calculate as per below formulas

where y is the dependent variable, x is the independent variable and n is the number of observations

Using these values in the above equations, we get

Hence the regression equation is Y = 334.4118+13.6584t

b. The loadings for week 20 and 21 can be determined by substituting t= 20 and t=21 in the above equation. Hence we have the below

Loadings for week 20 = 334.4118+13.6584*20 = 607.5798

Loadings for week 21 = 334.4118+13.6584*21 = 621.2382

c. To find the week in which the loadings reach 940, we need to consider Y as 940 in the regression equation and solve for t. Hence we have the below

940 = 334.4418+13.6548t

13.6548t = 940-334.4418 = 605.5582

t = 605.5582/13.6548 = 44.3476 which is the 45th week.

Hence it should reach 940 loadings in week 45th.


Related Solutions

Freight car loadings over an 18-week period at a busy port are as follows: Week Number...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 370 7 415 13 450 2 380 8 425 14 455 3 390 9 435 15 475 4 380 10 425 16 485 5 390 11 435 17 495 6 395 12 445 18 505 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) YˆY^ =  +  t...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 290 7 335 13 490 2 300 8 375 14 495 3 310 9 415 15 515 4 300 10 405 16 525 5 310 11 445 17 535 6 315 12 485 18 545 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) YˆY^ =  +  t...
Freight car loadings over an 18-week period at a busy port are as follows:
  Freight car loadings over an 18-week period at a busy port are as follows: Week Tons loaded 1 220 2 245 3 280 4 275 5 300 6 310 7 350 8 360 9 400 10 380 11 420 12 450 13 460 14 475 15 500 16 510 17 525 18 541 The port manager wants build a model to forecast the loads for the remainder of the year. a. Which variable is the dependent/response variable? b. Which...
The number of times a machine broke down each week was observed over a period of...
The number of times a machine broke down each week was observed over a period of 100 weeks and recorded as shown in the table below. Complete parts a and b below. Number of Breakdowns 0 1 2 3 4 5 or More Number of weeks 9 22 32 26 6 5 a. Using alphaequals?0.10, perform a? chi-square test to determine if the population distribution of breakdowns follows the Poisson probability distribution. What is the null? hypothesis, Upper H 0??...
A farmer records the number of bees spotted on his farm over a two week period...
A farmer records the number of bees spotted on his farm over a two week period in the middle of the summer. Below is a stem and leaf plot of his data: 1 67 2 269 3 29 4 399 5 4 6 14 7 8 7 key: 1 6=16 1) Find the mean, median, mode, and sample standard deviation for this data 2) List the values for your Five Number Summary for the data in order. 3) Identify any...
Which one of the following statements is not correct? A. Over a week-long period, if a...
Which one of the following statements is not correct? A. Over a week-long period, if a healthy person were to ingest 35 g of NaCl, the total amount of NaCl excreted in the urine would be less than 35 g. B. In the proximal tubule, large amounts of Na+ and water are reabsorbed but the concentration of Na+ in the proximal tubular fluid does not change. C. A drug that inhibits active NaCl reabsorption in the ascending limb of the...
The number of earthquakes that occur per week in California follows a Poisson distribution with a...
The number of earthquakes that occur per week in California follows a Poisson distribution with a mean of 1.5. (a) What is the probability that an earthquake occurs within the first week? Show by hand and provide the appropriate R code. (b) What is the expected amount of time until an earthquake occurs? (c) What is the standard deviation of the amount of time until two earthquakes occur? (d) What is the probability that it takes more than a month...
The number of faults over a period of time was collected for a sample of 100...
The number of faults over a period of time was collected for a sample of 100 data transmission lines. We want to test if the data come from a Poisson distribution. number of faults 0 1 2 3 4 5 >5 number of lines 38 30 16 9 5 2 0 (a) Assuming the number of faults for a data-transmission line, Yi , i = 1, . . . , 100, follows a Poisson distribution with parameter λ, find the...
An MRP exercise is being implemented over an 8-week period and the following relevant information is...
An MRP exercise is being implemented over an 8-week period and the following relevant information is provided: One (1) unit of A is made of two (2) units of B and three (3) units of C. One (1) unit of B is made up of three (3) units of D and two (2) units of E. One(1) unit of C is made up of two (2) units of B and two (2) units of D. Items A, C and E...
A campus deli serves 300 customers over its busy lunch period from 11:30 a.m. to 1:30...
A campus deli serves 300 customers over its busy lunch period from 11:30 a.m. to 1:30 p.m. A quick count of the number of customers waiting in line and being served by the sandwich makers shows that an average of 10 customers are in process at any point in time. What is the average amount of time that a customer spends in process?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT