Sheet-09 Moving Average Method Example-1: ABC Company has the following manpower data for their health care division for the past six years: |Year |Manpower level/Data | | |(in nos.) | |2003 |500 | |2004 |600 | |2005 |800 | |2006 |1,000
Words: 608 - Pages: 3
Date Open High Low Close Volume Adj Close 10 Days SMA 14 Days SMA 20 Days SMA 30 Days SMA 2/1/2007 28.68 28.71 28.15 28.35 17905200 28.35 2/2/2007 28.57 28.92 28.45 28.77 16483100 28.77 2/5/2007 28.67 28.8 28.36 28.56 11163300 28.56 2/6/2007 28.61 29.56 28.6 29.35 24506800 29.35 2/7/2007 29.35 30.15 29.12 29.89 29162600 29.89 2/8/2007 29.75 30.24 29.73 30.08 15561700 30.08 2/9/2007 30.07 30.16 29.51 29.74 18172200 29.74 2/12/2007 29.29 29.77 29.05 29.17 18316200
Words: 8578 - Pages: 35
Forecasting Tammy Powell HSM/260 December 19, 2014 Adrianne Franklin Exercise 9.3 Moving Averages 20X2-20X4 $18,250,000 / 3 = $6,083,333 Weighted Moving Averages 20X2 $5,500,000 1 $5,500,000 20X3 $6,000,000 2 $12,000,000 20X4 $6,750,000 3 $20,250,000 __ ___________ 6 $37,750,000 20X5 $37,750,000 /6 = $6,291,667 Exponential Smoothing NF = LF + a (LD – LF) NF = $6,300,000 + 0.95($6,750,000 - $6,300,000) = $6,300
Words: 291 - Pages: 2
million. During week two the marketing team was challenged to predict the market sales for the next year. Denim sales have increased five percent over the past four years and is expected to increase again next year. The team used the weighted moving average with a weight of .9 for the most recent observation to give the lowest mean square error (MSE). The lowest MSE is the best model to predict what sales would be over the next year. The forecasted Denim sales over the next year are 777 million units
Words: 455 - Pages: 2
The correlation coefficient, bias, mean absolute deviation (MAD), mean squared error (MSE), and mean absolute percent error (MAPE) are shown. | Correlation | Bias | MAD | MSE | MAPE | Naïve | -- | 541.38 | 6865.52 | 69,856,200 | .19 | Moving Average (3 periods) |
Words: 837 - Pages: 4
of operation the automobile company had actual sales of: year one 800 units, year two 1200 units, year three 2000 units and by using a simple three year moving average calculation of the predicted demand for year four with an explanation of reasoning, in addition the sales department expects the growth in year four to closely resemble the average growth experienced in the last two years, with a prediction of the number of units expected in year four along with a discussion on whether or not to recommend
Words: 1726 - Pages: 7
#7 #8 #9 #10 1. (22 points) The H&S Motor Company produces small motors at a production cost of $30 per unit. Defective motors can be reworked at a cost of $12 each. The company produces 100 motors per day and averages 80 percent good
Words: 4635 - Pages: 19
a 3-year moving average to forecast sales. b. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 3 and a weight of 2 for the second past year and sales in the other 2 years are each given a weight of 1. c. Which method do you think is best? In this case, the 3 year moving average is the better method as the Mean Absolute Deviation (MAD) is only 3.042 as compared to 3.347 for the weighted moving average method. What
Words: 837 - Pages: 4
GROUP PROJECT Pasquet Ferdinand Ravera Quentin I- Presentation of the company The company was founded by Walter Chrysler (1875–1940) on June 6, 1925. The headquarters are in Auburn Hills in the Michigan. The brand was at the beginning a premium luxury position competing with the brands Cadillac. Chrysler was the top brand in the portfolio of what was then known as Chrysler Corporation. Chrysler's positioning changed several times over the years. Indeed, The Chrysler brand was originally
Words: 2962 - Pages: 12
Dr. Burns Operations Management PRACTICE EXAM 3 (with answers at the end) This exam consists of 40 multiple choice and 3 discussion questions/problems. The multiple choice questions are worth 40% of the exam grade. The problems are worth 60% of the exam grade. The exam is to be taken closed-book, closed-notes. Formulas are provided on the last page. 1. Aggregate Production Planning (APP) involves all of the following except _________. a. hiring and laying
Words: 1357 - Pages: 6
