Predict the sales for May using a. weighted three-month moving average with weights 5, 3, and 2, where 5 is the weight for last month’s sale, 3 is the weight for the sales two months ago, and 2 is the weight for sales three months ago. b. exponential smoothing with α = 0.4. Assume the forecast for January was 25 laptops.

Predict the sales for May using a. weighted three-month moving average with weights 5, 3, and 2, where 5 is the weight for last month’s sale, 3 is the weight for the sales two months ago, and 2 is the weight for sales three months ago. b. exponential smoothing with α = 0.4. Assume the forecast for January was 25 laptops.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Below are given the annual production figures (in thousand tonnes) of a fertiliser factory : Year 2011 2012 2013 2014 2015 2016 2017 Production : 70 75 90 91 95 98 100 (1) Fit a straight line trend by the method of least squares and tabulate the trend values. (i) Convert your annual trend equation into a monthly trend equation.
Consider the following data: Month Jan-14 Feb-14 Profit ($) 16,113 16,263 Monthly Profit of an Auto Repair Shop Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 15,055 17,117 18,763 17,210 19,141 18,468 20,254 Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.35. If necessary, round your answer to one decimal place.
The following table present quarterly sales for a company over the three years (a) Fit the trend as a linear function of time t and predict the sales for the 4th year? Year 2 Year 3 309 405 326 429 369 446 416 465 quarter 1 2 3 4 Year 1 241 263 273 292
Given the number of calls per week received by a dental clinic, what is the forecasted number of calls for week 12 considering that the forecast for week 1 was 47 and a smoothing constant a -0.2? CALLS 52 35 25 36 45 35 44 WEEK 1 2 3 4 5 6 7 869 10 34 calls 35 calls 33 calls 38 calls 30 35 25
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 31 2 34 3 33 4 35 5 37 6 36 7 38 8 40 9 40 10 41 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast ( F1�1 ) of 31. Note: Round your intermediate calculations and answers to 2 decimal places. b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.30, a δ of 0.30, an initial trend forecast ( T1�1 ) of 1, and an initial exponentially smoothed forecast ( F1�1 ) of 30. Note: Round your intermediate calculations and answers to 2 decimal places. c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. Note: Round your intermediate calculations and answers to 2 decimal places. c-2. Which is best? multiple choice Exponential smoothing with trend forecast Single exponential smoothing forecast
Month Actual demand Forecasted Demand 1 950 1000 2 1070 1000 3 1100 1000 4 960 1000 5 1090 1000 6 1050 1000 For the dataset above, compute the overall MAPE.
Period 1 2 3 4 5 6 7 Actual 42 41 39 43 45 F ? ? 2 2. Using the same table above, compute the weighted moving average forecast for demand for four latest period. With data using a weight of .40 for the most recent, .30 for the next recent, .20 the next, and .10 for the oldest. Assume actual demand for period 6 is 44, what is the forecast for period 7?
Weekly sales of copy paper at Cubicle Suppliers are in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute each forecast. Which model is more accurate? Forecast week 8 with the more accurate method. Week Sales (cases) 1 17 2 21 3 27 4 31 5 19 6 17 7 21
Use regression analysis on deseasonalized demand to forecast demand in summer 2013. Forecast for summer 2023 ______