AutoSave On Assignment 2 - Last Modified: 9m ago File Home Insert Design Layout References Calibri...

Transcribed Image Text:

AutoSave On Assignment 2 - Last Modified: 9m ago File Home Insert Design Layout References Calibri (Body) 11 A A Aa Po Paste D Clipboard BI Uab x2 x A Font Page 1 of 3 340 words LV English (Canada) Mailings Paragraph Search Review View Help Table Design Layout T AaBbCcDc AaBbCcDc AaBbCc AaBbCcL 1 Normal v No Spac... Heading 1 Heading 2 Styles The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Orders: 1400 1550 1630 1590 1610 1550 1470 1500 1720 1350 Use the Following Tables to support your answer: a. Compute the monthly demand forecast for April through November using a 3-month weighted moving average. Use weights of 0.65, 0.25, and 0.10, with the heavier weights on the more recent months. b. Compute the monthly demand forecast for April through November using a 3-month moving average. c. Compute the monthly demand forecast for February through November using the naive method. d. Compute the monthly demand forecast for June through November using a 5-month moving average. e. Compute the mean absolute deviation for June through October for each of the methods used. Which method would you use to forecast demand for November? W O Anil Sandhu AS Share Find Replace Select Dictate Sensitivity Reuse Files Editing Voice Sensitivity Reuse Files 0 Comments + 80% Focus ENG US 12:06 AM 2022-02-26 AutoSave On Assignment 2 - Last Modified: 9m ago File Home Insert Design Layout References Calibri (Body) 11 A A Aa Po Paste D Clipboard BI Uab x2 x A Font Page 1 of 3 340 words LV English (Canada) Mailings Paragraph Search Review View Help Table Design Layout T AaBbCcDc AaBbCcDc AaBbCc AaBbCcL 1 Normal v No Spac... Heading 1 Heading 2 Styles The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Orders: 1400 1550 1630 1590 1610 1550 1470 1500 1720 1350 Use the Following Tables to support your answer: a. Compute the monthly demand forecast for April through November using a 3-month weighted moving average. Use weights of 0.65, 0.25, and 0.10, with the heavier weights on the more recent months. b. Compute the monthly demand forecast for April through November using a 3-month moving average. c. Compute the monthly demand forecast for February through November using the naive method. d. Compute the monthly demand forecast for June through November using a 5-month moving average. e. Compute the mean absolute deviation for June through October for each of the methods used. Which method would you use to forecast demand for November? W O Anil Sandhu AS Share Find Replace Select Dictate Sensitivity Reuse Files Editing Voice Sensitivity Reuse Files 0 Comments + 80% Focus ENG US 12:06 AM 2022-02-26