Sales Volume 10000 12400 14250 15750 20500 18500 15750 20500 21500 22550 6. Using Data Set E1‚ what would be the forecast for period 7 using a four period moving average: (Choose the closest answer.) a. 17625 b. 15225 c. 15300 d. 17250 7. Using Data Set E1‚ what would be the forecast for period 6 using a five period weighted moving average? The weights for each period are 0.05‚ 0.10‚ 0.20‚ 0.30‚ and 0.35 from the oldest period to the most recent period‚ respectively. (Choose the
Free Exponential smoothing Moving average Average
FORECASTING FUNDAMENTALS Forecast: A prediction‚ projection‚ or estimate of some future activity‚ event‚ or occurrence. Types of Forecasts * Economic forecasts * Predict a variety of economic indicators‚ like money supply‚ inflation rates‚ interest rates‚ etc. * Technological forecasts * Predict rates of technological progress and innovation. * Demand forecasts *
Free Exponential smoothing Moving average Forecasting
OPERATIONS MANAGEMENT 1. Supplier Us Customer Raw materials Transforming Work in progress inventory Transformation Finished goods inventory Customer Codex 25000D1‚ 18 dollars (Notes and Problems). Assignment 1‚ 2 make for 15%. Midterm make for 35% and the Assignment 3 for 10%. Finals make up for 40%. Assignments handed in at the beginning of sessions 5‚ 7 and 12. Value added: Inputs Transformation process Outputs. How do we increase value to the product. A lot of things
Premium Value added Output Forecasting
ActualForecastErrorError1011-11810-22108 2266 0098 11 FCT 3 What is the forecast for May based on a weighted moving average applied to the following past demand data and using the weights .5‚ .3‚ .2 (largest weight is for most recent data) Nov.Dec.Jan.Feb.Mar.April373640424743 FCT 4 Weekly sales of ten-grain bread at the local Whole Foods Market are in the table below. Based on this data‚ forecast week 9 using a three-week moving average. Week Sales 1 415 2 389 3 420 4 382 5 410 6 432 7 380 8 410 FCT 4 Most forecasting
Premium Inventory Forecasting Moving average
Introduction to Management Science: Quantitative Methods: 50 Multiple Choice Questions Question 1 In a balanced transportation model where supply equals demand‚ a. all constraints are equalities b. none of the constraints are equalities c. all constraints are inequalities d. none of the constraints are inequalities Question 2 In a transportation problem‚ items are allocated from sources to destinations a. at a maximum cost b. at a minimum cost c. at a minimum profit d. at
Premium Decision theory Moving average Average
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
Free Exponential smoothing Moving average Time series analysis
Excel Chapter 8 Test 1) Match each term with the correct definition (15 points) A sequence of averages computed from parts of a data series that smoothes fluctuations in data to show a trend more clearly. Moving average In a moving average‚ the number of cells to include in the average. Interval Expenses that remain the same each month. Fixed expenses A point at which an entity covers its costs and starts to make a profit. Break-even A what-if
Premium Spreadsheet Mathematics Average
Pharos University Faculty of Financial & Administrative Sciences O PERATIONS M ANAGEMENT B y: Dr. Ola E lgeuoshy S pring 2013 C hapter (3) F orecasting F ORECASTING “ a Statement about the future value of a variable of i nterest .” U ses of Forecasting: Accounting Cost/profit estimates Finance Cash flow and funding Human Resources Hiring/recruiting/training Marketing Pricing‚ promotion‚ strategy MIS IT/IS systems‚ services Operations Schedules‚ MRP
Premium Time series Time series analysis Forecasting
t = -.412 and p = .689. A stationary model seems appropriate since the linear term‚ Period‚ is not significant. 7.1 c. Forecast for January -- 19‚ for upcoming year – 12*19 = 228 7.1 d. Forecast for January -- 20.4 e. 4 month moving average. MAD is 1.72 7.2 See files Ch7.2a.xls and Ch7.2b.xls a. Forecast for January -- 18.86 7.2 b. See file Ch7.2b.xls Forecast for January -- 20.28 c. = .6 gives the lower MSE 7.3 See file Ch7.3.xls a. b. Coefficients
Premium Regression analysis Linear regression Moving average
ISQS 3344 Test 1 review Chapter 1 What employers want The ability to think cross functionally Working in teams and collaborative learning Increase productivity and knowledge by 50% Operations management- the science and art of ensuring that goods and services are created and delivered successfully to customers. Planning Directing Controlling Organizing Government regulations- California 2006 Increase mpg standard for all vehicles or pay fine Lots of hybrids sold but companies
Premium Moving average Productivity Average