Student learning outcome the student will apply a time

Assignment Help Operation Management

Reference no: EM13382241

Student Learning Outcome: The student will apply a time series forecasting method to calculate forecasts, and use the Mean Absolute Deviation (MAD) and Tracking Signal to evaluate the accuracy of the forecasts.
Scenario: A manager must ensure that an adequate supply of copier paper is maintained in inventory. This item is bulky and takes up space, so the manager wants to avoid having excess inventory on hand. However, running out of paper will immediately cause problems in the daily functioning of the office, by preventing necessary activities from taking place. They operate seven days per week. Because demand for (usage of) the paper varies from day to day, the manager needs to forecast (estimate) how much will be used in the future. The following data is available on daily demand over the past two weeks. Past forecasts are also given in the table where available. Forecasts are rounded to the nearest tenth of a case for each day.

Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Demand (cases) 11 14 12 10 15 17 16 20 18 18 22 21 20 24 ?
Forecast 10.0 10.2 11.0 11.2 11.0 11.8 12.8 13.4 14.7 15.4

1. Using simple exponential smoothing with a smoothing constant of α = 0.2, and the demand and forecast data as given above, calculate forecasts for days 11 through 15. Put your answers in column 3 of the table below.

2. Starting with day 6, calculate the MAD and Tracking Signal (TS) for days 6 through 10. Put your answers in columns 6 and 7 of the table below. Based on the TS values, is the forecast in control during this period? If not, briefly describe the problem and suggest a change that could be made to improve future forecasts.

Day Demand Forecast Error RSFE MAD TS
6 17 11.8
7 16 12.8
8 20 13.4
9 18 14.7
10 18 15.4
11 22 XXXXX XXXXX XXXXX XXXXX
12 21 XXXXX XXXXX XXXXX XXXXX
13 20 XXXXX XXXXX XXXXX XXXXX
14 24 XXXXX XXXXX XXXXX XXXXX
15 ? XXXXX XXXXX XXXXX XXXXX

Reference no: EM13382241

Questions Cloud

Your options for shipping 100 000 of machine parts from : your options for shipping 100 000 of machine parts from hamilton to kuala lumpur malaysia are 1 use a ship that will

Why is high productivity important for a nation 2 why do : why is high productivity important for a nation? 2. why do you suppose that service jobs have lower productivity than

Car solutions ccs a manufacturer of car and two-wheeler : car solutions ccs a manufacturer of car and two-wheeler engines has purchased a1000 bearings per week from a local

Peters paper clips uses a three-stage production process : peters paper clips uses a three-stage production process cutting wire to prescribed lengths inner bending and outer

Student learning outcome the student will apply a time : student learning outcome the student will apply a time series forecasting method to calculate forecasts and use the

1 in a one sentence describe the main job of the finance : 1. in a one sentence describe the main job of the finance function in an organization? the marketing function? the

1 if company has 1 million to spend on a new strategy and : 1. if company has 1 million to spend on a new strategy and is considering to invest in either market development or

1 define price and discuss the two roles price plays in the : 1. define price and discuss the two roles price plays in the evaluation of product alternatives.2. list the three

1is a level strategy a pure or a mixed strategy and the : 1.is a level strategy a pure or a mixed strategy? and the chase strategy?2.what is a heuristic method?3.what is an

User Account

All Pages