Question: Need help with part C please 2. Freight car loadings over an 18-week period at a busy port are as follows: Week Week 1 2

Need help with part C please

Need help with part C please 2. Freight car

2. Freight car loadings over an 18-week period at a busy port are as follows: Week Week 1 2 3 4 Number 380 385 390 385 390 400 7 8 9 10 Number 450 500 550 545 Week 13 14 15 16 Number 655 665 715 720 5 points 5 11 17 725 595 645 6 12 18 730 eBook Click here for the Excel Data File a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) Print = 305.78 + 25.27 t References 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 811.18 and for Week 21 is 836.45 c. The manager intends to install new equipment when the volume exceeds 960 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.) It should reach 960 loadings in Week

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

See below please 2 Freight car loadings over an 18-week period at a busy port are as follows: Week Number 380 Number 450 Week 1 2 3 4 385 8 5 points 500 7899 Week 13 14 15 16 390 9 550 Number 655 665...

Freight car loadings during an 18-week period at a port are: (Ch.3, Prob.5) Week Number Week Number Week Number 1 220 7 350 13 460 2 245 8 360 14 475 3 280 9 400 15 500 4 275 10 380 16 510 5 300 11...

5. Freight car loadings during an 18-week period at a port are: L04 Week 1 2 3 41 5 Number 460 475 500 510 525 541 Week 13 15 17 18 14 16 450 Number 360 400 420 350 380 11 Week 7 8 9 10 12 Number 220...

Timely Transport provides local delivery service for a number of downtown and suburban businesses. Delivery charges are based on distance and weight involved for each delivery: 30 cents per pound and...

Check my work 2 Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 400 7 465 13 575 415 B 495 14 580 5 130 525 15 610 415 10 510 16 625...

4 00:14:12 Freight car loadings during an 18-week period at a port are: Week 1 2 3 4 5 6 7 8 9 Y = 10 11 12 13. 14 15 16 17 18 Number 223 239 280 263 291 316 346 369 398 381 428 441 462 478 505 511...

2 Freight car loadings over an 1 8 - week period at a busy port are as follows: \ table [ [ , Week,Number ] , [ 5 , 1 , 3 2 0 ] , [ points , 2 , 3 3 5 ] , [ , 3 , 3 5 0 ] , [ , 4 , 3 3 5 ] , [ eBook...

2 Freight car loadings over an 1 8 - week period at a busy port are as follows: \ table [ [ , Week,Number ] , [ 5 , 1 , 3 2 0 ] , [ points , 2 , 3 3 5 ] , [ , 3 , 3 5 0 ] , [ , 4 , 3 3 5 ] , [ , 5 ,...

Freight car loadings during an 18-week period at a port are: Week Number 1 223 2 252 3 276 4 272 5 304 6 316 7 342 8 369 9 396 10 380 11 429 12 451 13 466 14 470 15 499 16 515 17 532 18 544 a....

OPMT 620 17 1. Freight car loadings during an 18-week period at a port are: Week Number 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...

What is meant by materiality in the context of the audit plan? Discuss the difference between managements and auditors responsibilities regarding auditee organizations internal controls. As an...

What alkyne would you start with to prepare each of the following compounds by a hydroboration/oxidationreaction? (b) (a) CH CH-CCHCH3 -CH2CH CH

Explain the difference between the accrual basis and cash basis of accounting. What are the advantages and disadvantages of each method?

Tina and Raphael were interns at Ixita Technologies. Both of them are hardworking and dedicated. However, Tina was hired as a full-time employee after the completion of the internship but Raphael was...