The demand for a product of a company in each of the last twelve months isshown in the table below;MonthJanFebMarAprMayJunJulAugSepOctNovDecJanDemand 374041374550434756525554Use the table to compute the following forecast demand for the company;a. Four months simple moving averageb. Four months weighted moving average using the weight of 40%, 30%and 20% and 10%respectively.

The demand for a product of a company in each of the last twelve months is shown in the table below; Jan Feb Oct Nov Apr May Jun 50 Month Mar Jul Aug Sep Dec Jan Demand 37 40 41 37 45 43 47 56 52 55 54 Use the table to compute the following forecast demand for the company; a. Four months simple moving average b. Four months weighted moving average using the weight of 40%, 30% and 20% and 10%respectively.

The demand for a product of a company in each of the last twelve months is shown in the table below; Jan Feb Oct Nov Apr May Jun 50 Month Mar Jul Aug Sep Dec Jan Demand 37 40 41 37 45 43 47 56 52 55 54 Use the table to compute the following forecast demand for the company; a. Four months simple moving average b. Four months weighted moving average using the weight of 40%, 30% and 20% and 10%respectively.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Apply the moving average with base m=4 forecasting technique of the data to estimate the demand in week 13.
Dic 2 - Time Series Analysis and F eBook Problem 6-01 (Algorithmic) Consider the following time series data. Thm Week 1 2 3 4 5 6 Value 20 13 15 11 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error. If required, round your answer to one decimal place. b. Mean squared error. If required, round your answer to one decimal place. c. Mean absolute percentage error. If required, round your intermediate calculations and final answer to two decimal places. % d. What is the forecast for week 7? If required, round your answer to two decimal place.
Please answer all questions!
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 120 February 145 March 146 April 171 May 154 June 182 July 138 August 135 September 146 a. Forecast April through September using a three-month moving average. b. Use simple exponential smoothing with an alpha of 0.20 to estimate April through September, using the average of January through March as the initial forecast for April. c-1. Calculate MAD for Three-month moving average and Exponential smoothing. c-2. Use MAD to decide which method produced the better forecast over the six-month period.
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two moving average forecasting methods to see which one was better over this period. Month Actual Demand Jan 120 Feb 140 March 160 April 180 May 170 June 190 July 150 August 160 September 170 a. Forecast April through September using a three-month moving average and calculate MAD for the forecasts. b. Forecast May through September using a four-month moving average and calculate MAD for the forecasts.
Income at the law firm of Smith and Jones for the period February to July was as follows: Month February March April May June July Income (in $ thousand) 90.0 91.5 96.0 85.4 92.2 96.0 Assume that the initial forecast for February is $85,000 and the initial trend adjustment is 0. The smoothing constants selected are a = 0.1 and ß = 0.2. Using trend-adjusted exponential smoothing, the forecast for the law firm's August income =O thousand dollars (round your response to two decimal places).
b. Compute 2s control limits for each forecast. (Do not round your intermediate calculations. Round your answers to 2 decimal places.) Forecast Method 1 Method 2 Control Limits
The actual monthly demand of special pizza in the past 6 months were: 411, 272, 302, 396, 400, 308 If a four-month moving average forecasting model is used to generate forecasts, what is the value of the Mean Absolute Percent Error (in percent)? Use at least 4 decimals.
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?…
Practice examples. Please show solution. Thank you.
A company that produces protein bars used differentforecasting techniques to predict demand for its proteinbars. The actual demand and the forecasted demand forcases of protein bats using the two different forecasting methods are presented in the following table:Month F1 F2 Actual Demand At1 97 95 992 80 77 863 82 89 904 54 62 685 81 84 796 88 93 827 89 89 968 86 84 889 80 74 76a Compute MAD for the results of each forecastingmethod. Which one is more accurate?b Compute MSE for the results of each forecastingmethod. Which one is more accurate?c Compute MAPE for the results of each forecastingmethod. Which one is more accurate?