QUESTION # 7A small restaurant offers tacos to their patrons. One of their specialties is the Mega Taco Supreme.A weekly forecast of the demand of this special taco is to be made in order for the manager toorder taco shells in time. Recently the demand has been as follows:WeekTacos WeekТаcosApril 6April 13Аpril 20April 27May 4Мay 11566065565550a. Forecast the demand for the taco for April 27 to May 18 by using the simple movingaverage method with n-3. Then repeat the forecast by using the weighted moving averagemethod with n=3 and weights of 0.5, 0.3, and 0.2 with 0.5 applied to the most recentdemand.b. Calculate the MAD for each method and compare.

Given Information: a) The forecasted demand for using a moving average with n = 3 is :

QUESTION # 7 A small restaurant offers tacos to their patrons. One of their specialties is the Mega Taco Supreme. A weekly forecast of the demand of this special taco is to be made in order for the manager fo order taco shells in time. Recently the demand has been as follows: Week Таcos Week Таcos April 6 April 13 April 20 April 27 May 4 May 11 56 60 65 56 55 50 a. Forecast the demand for the taco for April 27 to May 18 by using the simple moving average method with n-3. Then repeat the forecast by using the weighted moving average method with n=3 and weights of 0.5, 0.3, and 0.2 with 0.5 applied to the most recent demand. b. Calculate the MAD for each method and compare.

QUESTION # 7 A small restaurant offers tacos to their patrons. One of their specialties is the Mega Taco Supreme. A weekly forecast of the demand of this special taco is to be made in order for the manager fo order taco shells in time. Recently the demand has been as follows: Week Таcos Week Таcos April 6 April 13 April 20 April 27 May 4 May 11 56 60 65 56 55 50 a. Forecast the demand for the taco for April 27 to May 18 by using the simple moving average method with n-3. Then repeat the forecast by using the weighted moving average method with n=3 and weights of 0.5, 0.3, and 0.2 with 0.5 applied to the most recent demand. b. Calculate the MAD for each method and compare.

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

Plz 100% correct solution needed.
State which forecast is best on the result for a., b., and c. forecasts. Explain your answer.
8.6 Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. The smoothing constant is 0.2, and the old forecast for month 1 is 245. Month 1 2 3 4 5 6 LO Actual Demand 260 230 225 245 250 Forecast Demand
2. Fastway is a parcel delivery company based in Pretoria. It measures demand on a weekly basis in terms of the number of parcels which it is given to deliver (irrespective of the size of each parcel). The forecast for week 20 is 63. The table below shows actual demands for Fastway. Week Actual demand 20 63 21 62 22 67 23 66 24 67 25 69 26 65 27 71 28 68 29 68 30 70 31 72 32 66 33 68 34 67 Predict the forecast for week 35 using an exponential smoothing with a smoothing constant of 0.20.
Please solve this
53 Can you help me find MSE in this chart?
Pls solve this question correctly instantly in 5 min i will give u 3 like for sure
Given below are the demands of a certain product over the past 10 weeks. Week | 1 2 3 4 | 5 67|89 | 10 Demand 50 64 66 68 67 63 69 67 65 66 (a) Forecast the demand for the 13th week using the following techniques: i. 3- week weighted moving average with weights 0.2, 0.3, and 0.5 ii. Exponential smoothing with a smoothing constant equal to 0.85 ii. Adjusted exponential smoothing with a smoothing constant equal to 0.85 and smoothing constant for trend equal to 0.65 (b) Compute for the accuracy of each model using the mean squared error. Based on the computed MSE, what is the best forecasting technique for this time series?
b3 need urgent in 15 minutes
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.
Calculate MSE for the 4 periods for which the actual and forecasted number of customers given in the table below: Forecasted Actual Number Period Number of Error of Customers Customers 1 1,975 2,000 2 2,050 2,025 3 1,925 1,975 4 2,075 2,025 390.63 37.5 6,250 True1,562.5
Please solve this question...