Solutions
Problem 1: Observations of the demand for a certain part stocked at a parts supply depot during the calendar year 1999 were Month January February March April May June Demand 89 57 144 221 177 280 Month July August September October November December Demand 223 286 212 275 188 312
a. Determine the one-step-ahead forecasts for the demand for January 2000 using 3-, 6-, and 12-month moving averages. b. Using a four-month moving average, determine the one-step-ahead forecasts for July through December 1999. c. Compute MAD, MSE, MAPE for the forecasts obtained in b. Solution: a. MA (3) forecast: 258.33 MA (6) forecast: 249.33 MA (12) forecast: 205.33 b. Month July August September October November December Forecast 205.50 225.25 241.50 250.25 249.00 240.25 Demand 223 286 212 275 188 312 Error -17.50 -60.75 29.50 -24.75 61.00 -71.75
c. MAD = 44.21 MSE = 2391.45 MAPE = 17.91%
EMIS 8348 Homework 1 – Part 1
Solutions
Problem 2: Observed weekly sales of ball peen hammers at the town hardware store over an eightweek period have been 14, 9, 30, 22, 34, 12, 19, 23. a. Suppose that three-week moving averages are used to forecast sales. Determine the one-step-ahead forecasts for weeks 4 through 8. b. Suppose that exponential smoothing is used with a smoothing constant of α = 0.15. Find the exponential smoothing forecasts for weeks 4 through 8. c. Based on the MAD, which method did better? Solution: a. Week 4 5 6 7 8 b. and c. You may start ES forecast from week 1 or start ES forecast from week 4 using MA(3) forecast for the first period. The following are the results for each of the cases. Starting ES forecast from week 1:
Week 1 2 3 4 5 6 7 8 Demand 14 9 30 22 34 12 19 23 ES(.15) 14 14 13.25 15.76 16.70 19.29 18.20 18.32 MA(3) |Error|ES |Error|MA
MA(3) Forecast 17.67 20.33 28.67 22.67 21.67
17.67 20.33 28.67 22.67 21.67
6.24 17.30 7.29 0.80 4.68 7.263 MADES
4.33 13.67 16.67 3.67 1.33 7.934 MADMA
Based on above results, ES(.15) had a lower MAD over the five weeks Starting ES forecast from week 4 using MA(3):
Week 4 5 6 7 8 Demand 22 34 12 19 23 ES(.15) 17.67 18.32 20.67 19.37 19.32 MA(3) 17.67 20.33 28.67 22.67 21.67 |Error|ES 4.33 15.68 8.67 0.37 3.68 6.547540 MADES |Error|MA 4.33 13.67 16.67 3.67 1.33 7.934 MADMA
Based on above results, ES(.15) had a lower MAD over the five weeks
EMIS 8348 Homework 1 – Part 1
Solutions
Problem 3: The sales of a laptop computer in a popular electronic store during the calendar year 2006 were Month January February March April May June Demand 96 110 127 143 161 177 Month July August September October November December Demand 192 210 224 240 259 277
a. Using simple moving average, double moving average and exponential smoothing (with α = 0.15 and 0.25), determine the one-step-ahead forecasts for July 2006 through January 2007. b. Compute MAD, MSE, and MAPE for the above forecasts. c. Based on the MSE, which method did best? Solution: a. We assume to use the 3-month moving average for both simple and double moving average. Please see the attached Excel file for detail. Please check the sheet “DMA with Level and Trend” in the Excel file for an alternative method to compute double moving average forecasts. b. See the attached Excel file. c. The 3-month simple moving average is the best method for this problem. If an alternative method is used for double moving average forecast (using Level and Trend), the 3-month double moving average is the best method for this problem (see the second sheet in the Excel file).
You May Also Find These Documents Helpful
-
2. The use of quarterly data to develop the forecasting model Yt = a +bYt−1 is an example of which forecasting technique?…
- 454 Words
- 3 Pages
Satisfactory Essays -
In the text, exercise 9.1 provides data for Palmdale Human Services. In this exercise it asks for the 20X5 figures using several forecasting models. The process of find 20X5 will include the use of moving averages, weighted moving averages, and exponential smoothing. The Palmdale Human Services personal expenses for the past four years are represented in the following data:…
- 505 Words
- 3 Pages
Satisfactory Essays -
a. Suppose your friend orders 2,500 gallons of malt each time an order is made. What is the total annual holding and ordering costs using this order quantity?…
- 517 Words
- 1 Page
Satisfactory Essays -
Forecast personnel expenses for fiscal year 20X5 using moving averages weighted moving averages, exponential smoothing, and time series regression. For moving averages and weighted moving averages, use only the data for the past three fiscal years. For weighted moving averages, assign a value of 1 to the data for 20 X 2, a value of 2 to the data for 20 X 3, and a value of 3 to the data for 20 X 4. For exponential smoothing, assume that the last forecast for fiscal year 20 X 4 was $6,300,000. You decide on the alpha to be used for exponential smoothing. For time series regression, use the data for all four fiscal years. Which forecast will you use? Why?…
- 492 Words
- 2 Pages
Satisfactory Essays -
•Lokesh Chandana FT152087 Case – Problems & Issues Problems : •To identify a forecasting technique so as to forecast the demand for existing products as well as new products. Issues : •Best fit model ?? •Problems associated with each forecasting model ?? •Performance of the used model ??…
- 369 Words
- 3 Pages
Satisfactory Essays -
d. Compute year end totals for each job in Table 1.1 and do a gap analysis to determine where shortages will occur in the next year.…
- 1369 Words
- 6 Pages
Powerful Essays -
1. Read Problem 6 in Chapter 6 of your textbook. Calculate and answer parts a through d. Include all calculations and spreadsheets in your post. Explain why the moving average method was used instead of another forecasting method. What might be another forecasting method that could prove to be just as useful?…
- 215 Words
- 4 Pages
Satisfactory Essays -
Read the M & L Manufacturing case on page 126 in your text. Prepare a weekly forecast clearly labeling your calculations. Explain the benefits of a more formalized approach to forecasting using course related principles in 200 words. You…
- 4733 Words
- 19 Pages
Powerful Essays -
Question 1: From the given last two years sales figure, it is showing an average of 4% price is increased in every boat. Based on last 2 years pricing pattern and the condition attached with B16 & B35.Before considering the price of B33, Billing Boats AS has to think about the challenge of B29 and market popularity both of these two boats .After considering all these factors the manufacturer’s selling price for the next year can be followed by:…
- 522 Words
- 6 Pages
Good Essays -
d. Calculate the double exponential smoothing forecast for periods 2-6 using an initial trend forecast (T1) of 2.0, and initial exponential smoothing forecast (S1) of 60 an of…
- 405 Words
- 2 Pages
Good Essays -
If a part fails and a spare is not available, it will take two days to obtain a replacement and install it. The cost for idle equipment is $500 per day. What quantity of spares should be ordered? 3. The daily demand for muffins, at a campus cafeteria in McGill University, recorded to the nearest 10 muffins, has been recorded for 50 consecutive days with the following results: Number of Muffins 50 60 70 80 90 100 110 120 130 140 Number of Days 1 2 3 5 8 10 10 6 3 2…
- 1104 Words
- 5 Pages
Powerful Essays -
We first predict the annual demand for the year 1972 based on trend for 4 months of 1972 based on corresponding months of 1971.…
- 1410 Words
- 13 Pages
Powerful Essays -
[1] Toys R'Fun is planning a new line of cuddly toys called “furby.” The plush furby toy will be priced at $27. Toys R'Fun purchases the fur by for $18. The annual demand is estimated to be 36,400 furbys (or 700 per week). The opportunity cost of capital for Toy R'Fun is 25% per annum. Other relevant holding costs (taxes, insurance, theft, obsolescence, etc.) are estimated to be 8% per annum. The cost of capital is 10% per annum. The ordering cost is $40 per order. It is also estimated that the weekly demand will have a normal distribution with a mean of 700 and standard deviation of 100. The lead-time to procure the toys from Hyderabad, India is guaranteed to be exactly 9 weeks if the shipment is by sea with a unit transportation cost of 5 cents. a) Find the economic order quantity (EOQ) and compute the total cost per year including the purchase cost @$18/furby but not inclusive of the transportation cost. b) Determine the safety stock for obtaining 99% service level (i.e., an in-stock probability of 99%). When should Toys R'Fun reorder? c) It has been suggested that Toys R'Fun use air shipment to ship the toys. Shipping by air reduces the transportation lead -time to 1 week but increases the unit transportation cost by 5 cents. Is it worthwhile to use air-shipments? [2] A mail order firm has four regional warehouses. Demand at each warehouse is normally distributed with a mean of 10,000 per week and a standard deviation of 2,000. Annual holding cost for the company is 25% and each unit costs $10. Each order incurs a fixed order cost of $1,000 (primarily from fixed transportation costs) and the lead time of supply is one week. The company wants the probability of stocking out to be no more than 5%. Each warehouse has an information system that allows it monitor inventory continuously. Assume that 50 weeks in a year. (a) Assuming that each warehouse operates independently what should be the order policy at…
- 1350 Words
- 6 Pages
Good Essays -
* This budget proposal is for the starting and running of a single location, sit-down Italian restaurant named Papa Geo’s. The restaurant would be located in Orlando, Florida and would majorly target middle to lower-middle class families with children, as well as adults and seniors, thus making it a friendly and family place. The major product and service provided by the restaurant would be Italian food served buffet style with an all-you-can-eat format with a lot of variety including a salad bar, pizza, several different types of pasta with three or four types of sauces, soup, desserts, and a self-serve soda bar. There would also be a gaming area within the restaurant with gaming machines installed which would be of interest to children. The business would provide wholesome and fresh food, in a simple format, with very good prices and is located in a densely populated area, all of which would help the restaurant to do well and establish…
- 3102 Words
- 13 Pages
Powerful Essays -
Question 1: Wheeler Feed Mills Wheeler Feed Mills Ltd. has a production capacity of 10 MT per hour. The cattlefeed is packed in 50 kg jute gunny bags. During the last three years, the company had seen a growth as follows: Year 1997‐8 1998‐9 1999‐0 Sales in MT 26208 32236 39972 % over Prev.Yr 18% 23% 24%…
- 3601 Words
- 15 Pages
Good Essays