ZuoTi.Pro
Question

Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 13 230 250 2

a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predic

b. Use trend-adjusted smoothing with a 2 and B 1 to smooth the new account data in part a. What is the forecast for period 16

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

(a) The euation from the excel is

Y = 25.077x+172.88

2 M AB AC AD AE AF AG AH AI AJ AK AL AM Week Number 1 Number 2 250 y 25.077 17288... SEEDS 98 Q ENG UK 22/09 op

Y20 = 674.42

Y21 = 699.49

When Yt = 810, t will be

810-172.88 / 25.077 = 25.4

2

(a)

The euation is Y =7.3107x+194.25 from excel

Number y=7.3107x + 194.25... 2 4 6 8 10 12 14 16

Y16 = 311.22

Y17 =318.53

Y18 =325.84

Y19 = 333.15

0 0
Add a comment
Know the answer?
Add Answer to:
Freight car loadings over an 18-week period at a busy port are as follows: Week Number...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 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 270 7 360 13 390 2 290 8 370 14 400 3 310 9 380 15 440 4 290 10 360 16 460 5 310 11 370 17 480 6 320 12 380 18 500 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) =___+___ 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 300 7 365 13 485 2 305 8 395 14 490 3 310 9 425 15 540 4 305 10 420 16 545 5 310 11 450 17 550 6 315 12 480 18 555 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) Yˆ =...

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

    Freight car loadings over an 18-week period at a busy port are as follows: Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) Y cap = + t Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.) The forecasted demand of Week 20 is and for Week 21 is. The manager intends to install new...

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

    Freight car loadings over an 18-week period at a busy port are as follows: Week Week Number 480 520 560 540 Week 13 14 Number 390 410 430 410 430 440 Number 630 640 680 700 15 10 16 au AWN 11 580 17 720 12 620 18 740 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) Y = OD b. Use the above trend equation...

  • Problem 3-7 Freight car loadings over an 18-week period at a busy port are as follows:...

    Problem 3-7 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.)...

  • Freight car loadings over an 18-week period at a busy port are as follows. Week 13 14 15 16 17 18...

    Freight car loadings over an 18-week period at a busy port are as follows. Week 13 14 15 16 17 18 Week 1 Number 280 295 310 295 310 320 Week Number 350 400 450 435 485 535 Number 545 585 600 615 630 10 12 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...

  • 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 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 420 17 525 6 310 12 450 18 541     a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 3 decimal places.) I...

  • Freight car loadings over a 12-year period at a busy port are as follows: Number 13...

    Freight car loadings over a 12-year period at a busy port are as follows: Number 13 245 360 14 475 15 500 10 16 275 380 510 300 17 310 12 541 a. Determine a linear trend line for expected freight car loadings. b. Use the trend equation to predict expected loadings for weeks 20 and 21 c·The manager intends to install new equipment when the volume exceeds 800 loadings per week. Assuming the current trend continues, the loading volume...

  • a. Obtain the linear trend equation for the following data on new checking accounts at Fair...

    a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.) Period New Accounts Period New Accounts Period New Accounts 1 200 6 239 11 281 2 212 7 243 12 275 3 211 8 250 13 287 4 222 9 251 14 288 5 235 10 267...

  • a. Obtain the linear trend equation for the following data on new checking accounts at Fair...

    a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.) Period New Accounts Period New Accounts Period New Accounts 1 200 6 237 11 281 2 212 7 249 12 275 3 211 8 250 13 287 4 222 9 255 14 288 5 235 10 267...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT