Question: Need help with C please! Week Week Week 14 Hamin Number 220 245 280 275 300 310 Number 350 360 400 380 420 Number 460

Need help with C please!Need help with C please! Week Week Week 14 Hamin

Week Week Week 14 Hamin Number 220 245 280 275 300 310 Number 350 360 400 380 420 Number 460 475 500 510 525 541 450 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 3 decimal places.) = 208.484 91 18996 ot b. Use the trend equation to predict expected loadings for weeks 20 and 21. (Round your intermediate calculations and final answers to 3 decimal places.) The forecasted demand for week 20 and 21 is 588.404 and 607.400 respectively. c. The manager intends to install new equipment when the volume exceeds 800 loadings per week. Assuming the current trend continues, the loading volume will reach that level in approximately how many more weeks? (Round your intermediate calculations to 3 decimal places and final answer to the nearest whole number.) It would take approximately 31 more weeks

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!