In the atlanta area the number of daily calls for the


In the Atlanta area, the number of daily calls for the repair of Xerox copy machines has been recorded as follows: Day of month Calls (count) 1 92 2 127 3 106 4 165 5 125 6 111 7 178 8 97 Using Excel, perform the following calculations: Prepare a three-period moving-average forecast for the data. What is the error on each day? Prepare a three-period weighted-moving-average forecast using weights of w1=0.5, w2=0.3, w3=0.2 Which of the two forecasts is better? Then, Using the data prepare exponentially smoothed forecasts for the following cases: alpha = 0.1 and F1 = 90 alpha = 0.3 and F1 = 90

Request for Solution File

Ask an Expert for Answer!!
Operation Management: In the atlanta area the number of daily calls for the
Reference No:- TGS01197925

Expected delivery within 24 Hours