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

Question 16 Daily demand for sandwiches at a local deli is shown in the table. Using a 3 period weighted moving average (most recent demands receive the highest weights) with weights W1 = 0.50, W2 = 0.30 and W3 = 0.20, what is the forecast for day 8? Group of answer choices a. 39.3 sandwiches b. 41.3 sandwiches c. 43 sandwiches d. 43.3 sandwiches e. Impossible to determine
QUESTION 1 Sales of Fat Lips Burgers for 2012 are shown in the table below. 1. Do the 2 month SMA forecast 2. Do 2 month WMA forecast using the information below WMA – 2: last month, 1 – last 2 months 3. For the month of January 2012, the forecast was 438. Do the EMA forecast with the smoothing constant = 0.3. What is the forecast for Jan 2013? 4. Compare the forecasts above using MAD, MSE and MAPE. Which forecast method gives the least errors? Month Actual Sales Forecast Jan 2012 438 Feb 420 March 414 Apr 318 May 306 June 240 July 240 Aug 216 Sep 198 Oct 225 Nov 270 Dec 315 Jan 2013 - QUESTION 2Dayang sells 5 kg bags of fertilizer to local farmers in Tg Karang. The sales data for the past 11 months is shown below. Month Demand (10s of bags) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 1. Find the forecast for the month 12 using the methods below: a. Simple 4 month moving average (SMA) b.…
QUESTION ONE (b) The forecast of a product for the first week of January was 200 units, whereas the actual demand turned out to be 220 units. i. Find the forecast for the week of January assuming the smoothing constant 0.2 α = ii. Find the forecast for the third week of third week of January if the actual demand of the second week is 210 units
Question 21 A CFE of -140 suggests which of the following? Group of answer choices a. There is a bias towards over forecasting, though we cannot determine from the data provided whether that is severe bias or not b. There is a severe bias towards overforecasting c. There is a bias towards under forecasting, though we cannot determine from the data provided whether that is severe bias or not d. There is a severe bias towards under forecasting e. Bias is negligible in this case
Question 3 [Soalan 3] Use the data set below to answer the following questions: [Gunakan set data di bawah untuk menjawab soalan-soalan berikut:] Table 1: Monthly sales unit [Jadual 1: Unit jualan bulanan] Month [Bulan] Sales Units [Unit Jualan] 1 1100 2 1200 3 1450 4 1800 5 2100 6 2700 ii) Calculate the four-period weighted moving average forecasts for months 5 and 6 using weights of 0.05, 0.15, 0.30, and 0.50 from the earliest period to the latest period, respectively. [Hitungkan ramalan wajaran purata bergerak menggunakan empat-tempoh untuk bulan 5 dan 6 menggunakan pemberat 0.05, 0.15, 0.30 dan 0.50 dari tempoh yang terawal ke tempoh yang terakhir mengikut turutan.]
Question 4An investor is to purchase one of three types of real estate, as illustrated in Figure below. Theinvestor must decide among an apartment building, an office building, and a warehouse. Thefuture states of nature that will determine how much profit the investor will make are goodeconomic conditions and poor economic conditions. The profits that will result from eachdecision in the event of each state of nature are shown in Table below: a) Find the optimal act using Maxi-Max criteriab) Find the optimal act using Mini-Max criteria c) Find the optimal act using Maxi-Min criteria d) Find the optimal act using Min-Max regret table
Question 1 Double Exponential Smoothing should be applied to time series with ____________________. Group of answer choices a. no trend and no seasonality. b. trend but no seasonality. c. seasonality but no trend. d. both trend and seasonality. Question 2 An analyst fits a Holt’s Double exponential smoothing model in StatTools to a time series data on sales with the smoothing parameters to be optimized by the software. In the output she notes that the optimized smoothing parameter for trend to be 0.0000. What does this imply? Group of answer choices a. There is no trend in the data. b. There is both trend and seasonality in the data. c. There could be trend in the data, but it is not smoothed over time by the model. d. This output does not make any sense!
Question: Develop a problem statement for the scenario given below by considering the variables involved? Suppose you are a manager of a beverage company. You have recently witnessed a sudden decrease in sales. It has been widely accepted that due to Covid-19, the purchasing power of consumers has been declined. On the other hand in such situations, sales personnel avoid roaming for selling to avoid contact. The sudden decrease in the number of hours work and alternate shifts due to Covid-19 SOPs also resulted in a low-profit margin. You have to figure out the actual reason for the decline in sales as a manager.
Question 4 (a) With reference to your department or one in a company or organization that you are familiar with that is involved in generating forecasts of air cargo traffic, propose the purposes for which the forecasts can be employed. In the process of generating air cargo traffic forecasts, appraise the forces that will promote air freight growth and the constraints the air cargo market are likely to face.
Question 2 Mike is a first year university student who is trying to understand his financial situation. Mike currently lives 1.5 miles away from campus. He works part time in a retail centre that pays him £800 per month. Mike saves £200 out of the part time job pay for his further education plan. a). As to the below Travel Expenses table published by the Students’ Union, 185 students were randomly selected to help understand the travel expenses and distance to campus. What’s the probability for Mike to spend over £10 on journeys to campus? Distance to Campus (miles) Amount spent, £ 0.1 to 0.25 0.26 to 1.0 Over 1.0 0 – 4.99 35 26 10 5.00 – 9.99 18 39 20 10.00+ 4 14 19 b). How much is the frequency for students living over 1 mile away from the campus? c). As to the category of Amount Spent, £, what is the modal group? d). Assuming Mike is saving the same amount per month in the next 3 years. How much does Mike get for his saving…
Question 35 Suppose the actual sales and the forecasted, or smoothed sales, for the past 5 months have been Actual Smoothed 54.4 76.8 54.4 75.5 72.3 53.2 74.8 39.2 57.6 What is the Mean Square Error of the smoothed series? (please round your answer to 1 decimal place)
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average