We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Assignment 2. Using traditional methods of forecasting) The ABC Company has provided us with the following...
Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
QUESTION 5 A carnival runs for 10 days a year. Attendance for each day in each of the past three years has been captured and is provided in the table below. sing the multiplicative seasonal method, determine the average seasonal index for Day 2. Year 1 Year 2 Year 3 Dayl 13,578 14,471 15,421 Day2 21,659 21,630 21,124 Day3 20,051 20,558 20,367 Day4 12,035 12,820 13,315 Day5 12,264 12,924 12,077 Day6 13,139 13,875 13,818 Day7 18,754 18,801 19,491 Day8 21,670...
6.Use Exponential smoothing forecasts with alpha of 0.1, 0.2, ..., 0.9 to predict March 2019 demand. Identify the value of alpha that results in the lowest MAD. 7.Find the monthly seasonal indices for the demand values using Simple Average (SA) method. Find the de-seasonalized demand values by dividing monthly demand by corresponding seasonal indices. 8.Use regression to perform trend analysis on the de-seasonalized demand values. Is trend analysis suitable for this data? Find MAD and explain the Excel Regression output...