Find a linear trend line for expected freight car loadings

Assignment Help Operation Management

Reference no: EM131018373

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

Week	Number	Week	Number	Week	Number
1	250	7	295	13	410
2	260	8	325	14	415
3	270	9	355	15	435
4	260	10	345	16	445
5	270	11	375	17	455
6	275	12	405	18	465

a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.)

b. Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.)

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

c. The manager intends to install new equipment when the volume exceeds 830 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 decimal places.)

Reference no: EM131018373

Questions Cloud

Determine the appropriate ka or kb value based on the ph : The PH of a 0.100M Na2CO3 solution is 12.0. write the net ionic equation for hydrolysis and determine the appropriate Ka or Kb value based on the PH

What statistic measures data variability in both groups : What statistic measures data variability in both groups in an independent t-test? How do statistical tests like the one sample t adjust for the absence of parameter values?

Examine the proposed business ethical problem : Examine the proposed business ethical problem that the Brazilian Federal Data Processing Service is presently experiencing. Determine whether you agree or disagree that Brazil's problem is an ethical one that should be corrected. Provide a rationa..

Calculate the profit maximizing quantity : Calculate the profit maximizing quantity and the profit maximizing price for this monopolist assuming that the monopolist only has one price for which it is willing to sell the good. In your answer be sure to identify your final answers clearly, b..

Find a linear trend line for expected freight car loadings : Determine a linear trend line for expected freight car loadings. Use the above trend equation to predict expected loadings for Weeks 20 & 21.

Is there an enforceable contract between tim and jen : Is there an enforceable contract between Tim and Jen - Is promissory estoppel relevant to Jen's dispute with Simon from Delish Cakes?

The code to implement the singleton pattern is complex : The object-oriented approach to user-centered design focuses on users and their work by identifying actors, use cases, and scenarios followed when using the system..

What is the estimated weight of an oval-shaped diamond : What is the estimated weight of an oval-shaped diamond with a length of 9.04 mm, width of 6.50 mm, depth of 3.33 mm, and a slightly thick girdle?

What are some of advantages of a safety management system : What are some of the advantages of a safety management system that emphasize processes rather than individual behavior?

User Account

All Pages