Question: i need help with 4) on first one 2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as

i need help with 4) on first one i need help with 4) on first one 2. National
i need help with 4) on first one 2. National
i need help with 4) on first one 2. National
2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales Month (000 units) Feb. 19 Mar. 18 15 Apr. May 20 Jun. 18 Jul. 22 Aug. 20 a. Plot the monthly data on a sheet of graph paper. b. Forecast September sales volume using each of the following: (1) The naive approach (2) A five month moving average (3) A weighted average using .60 for August, 30 for July, and 10 for June (4) Exponential smoothing with a smoothing constant equal to 20, assuming a a March forecast of 19000) (5) A linear trend equation c. Which method seems least appropriate? Why? (Hint: Refer to your plot from part a.) d. What does use of the term sales rather than demand presume? to faraneet ainment usage at its main plant. August usage was forecasted to be 88 7. Freight car loadings over a 12-year 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 280 9 400 15 500 4 275 10 380 16 510 5 300 11 420 17 525 6 310 450 18 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 will reach that level in approximately what week? 8. Air travel on Mountain Airlines for the past 18 weeks was: Week Passengers 1 405 2 410 3 420 4 415 5 412 6 420 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 464 15 466 16 474 17 476 18 482 a. Explain why an averaging technique would not be appropriate for forecasting b. Use an appropriate technique to develop a forecast for the expected number of passengers for the next three 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!