Concept explainers
A
Interpretation: Find out the
Concept Introduction: The method followed in predicting the future value depending on the previous forecast including the portion of errors in the previous forecast is called Simple Exponential Smoothing forecast.
B
Interpretation: Determine the forecast error for the last week.
Concept Introduction: Forecast error indicates the percent of error in the forecasted value based on the actual outcome.
C
Interpretation: Determine the forecast value for the next week based on the three week moving averages.
Concept Introduction: Using regression, we will be able to define relationship between any two variables, denoting the cause and effect. The method can also be used to forecast the future depending on the past performances.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Practical Operations Management
- At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.arrow_forwardThe Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?arrow_forwardSales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 410.00, the following sales forecast has been developed: Forecasted Year Sales Sales 2005 450 410.00 2006 495 422.00 2007 518 443.90 2008 570 466.13 2009 585 497.29 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 75.73 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a = 0.60 and a starting forecast of 410.00 are (round your responses to two decimal places): Year 2005 2006 2007 2008 2009 2010 Forecasted Sales 410.00arrow_forward
- Compare the exponential smoothing model when a=0 and when a=1arrow_forwardPrior to conducting double exponential smoothing a simple linear regression is conducted and the trend equation is Y=42+38.3t, so the smoothed constant process value should be C0=38.3 and the smoothed trend value should be T0=42.? TRUE OR FALSE? Please only taping answerarrow_forwardA restaurant wants to forecast its weekly sales. Historical data (in dollars) for 15 weeks are shown in this Excel file (also shown in Problem 6 on page 243 in the textbook). Answer the following questions related to this information: What is the MSE for the two- and three-period moving average models? Compare the results. Find the best number of periods for the moving average model based on MSE.arrow_forward
- Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 415.00, the following sales forecast has been developed: Forecasted Year Sales Sales 2005 455 415.00 2006 510 427.00 2007 516 451.90 2008 570 471.13 2009 585 500.79 The MAD for a forecast developed using exponential smoothing with a = 0.30 is sales (round your response to two decimal places).arrow_forwardSales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 415.00, the following sales forecast has been developed: Forecasted Year Sales Sales 2005 455 415.00 2006 510 427.00 2007 516 451.90 2008 570 471.13 2009 585 500.79 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 74.04 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a = 0.60 and a starting forecast of 415.00 are (round your responses to two decimal places): Year 2005 2006 2007 2008 2009 2010 Forecasted Sales 415.00 439 481.6 502.24 542.9 568.12 The MAD for a forecast developed using exponential smoothing with a = 0.60 is 51.05 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a =…arrow_forward3. Attendance at Los Angeles' newest Disney like attraction, Vacation World has been as follows: Quarter Guests Quarter Guests (in Thousands) (in Thousands) 2017 Q1 73 Q3 124 Q2 104 Q4 52 Q3 168 2019 Q1 89 Q4 74 Q2 146 2018 Q1 65 Q3 205 Q2 82 Q4 98 a. Graph the data. (Use Excel) b. Compute seasonal indices using all the data. (Solve manually)arrow_forward
- The following company sells two family of products. The company begins its roll-up forecast anticipating a need for 60 units of A1 and 75 units of A2 at a cost of $200 per unit and $350 per unit, respectively. In addition, they anticipate a need for 85 units of B1 and 90 units of B2 at a cost of $410 per unit and $525 per unit respectively. Complete the roll-up pyramid forecasting technique for MPC Inc. Fill all the blanks. Allow 1 decimal value.arrow_forwardAn operation analyst is forecasting this year's demand for one of his company's products based on the following historical data: (4 year ago Quantity sold was 10842), (3 year ago Quantity sold was 11881 ), (2 year ago Quantity sold was 16064 ) and the last year Quantity sold was 19273 . The previous trend line had predicted 12250 for three years ago, 13000 for two years ago and 13750 for last year. What was the mean absolute percent error (MAPE) for these forecasts? a. 16.95 b. 2739 c. 0.17 d. 2985arrow_forwardThe following two demand sets are to be used to test two different basic exponential smoothingmodels. The first model uses 0.1, and the second uses 0.5. In both cases, the modelshould be initialized with a beginning forecast value of 50; that is, the ESF forecast for period 1made at the end of period 0 is 50 units. In each of the four cases (two models on two demandsets), compute the average forecast error and MAD. What do the results mean?Demand Set I Demand Set IIPeriod Demand Period Demand1 51 1772 46 2833 49 3904 55 4225 52 5106 47 6807 51 7168 48 8199 56 92710 51 10 7911 45 11 7312 52 12 8813 49 13 1514 48 14 2115 43 15 8516 46 16 2217 55 17 8818 53 18 7519 54 19 1420 49 20 16arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,