Question: Problem 3 (40 points) For the below demand, a) Forecast demand using exponential smoothing with an alpha of 0.4, and an initial forecast of 28.0

Problem 3 (40 points) For the below demand, a) Forecast demand using exponential smoothing with an alpha of 0.4, and an initial forecast of 28.0 for period 1. Period Demand 1 24 2 23 3 26 4 36 5 26 6 30 7 32 8 26 9 25 10 28 10 al b) Calculate the MAD. What is your recommendation? c) Calculate MSE and MAPE Problem 4 (30 points) For the below sales: 2 5 6 7 $ . 9 12 - 1 Jan 51 Month Sales 3 Mar 54 May 4 Apr 57 Feb 55 Jun Jul 66 Aug 59 Sep 67 10 Oct 69 11 No 75 Dec 73 SO 68 a) Use trend projection to estimate the relationship between time and sales. (Show your calculations for the intercept and the slope. b) Calculate forecasts for the first four months of the next year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Problem 3 (40 points) For the below demand, a) Forecast demand using exponential smoothing with an alpha of 0.4, and an initial forecast of 28.0 for period 1. - Period Demand 1 24 2 23 3 26 4 36 5 26...

zoom it 3 day Forecasting Student Appointments It is time for advising and the undergraduate office needs to plan for demand for services. The staff meets with students on a walk-in basis from...

Tutoring Center needs to allocate tutors this week for office appointments, so it needs to forecast the number of students who will seek appointments. The director has gathered the following time...

The business analyst for Heavy Equipment Inc. wants to forecast this year's (2019) demand for one of the company's products based on the following historical data: Demand Year 2015 100 2016 120 2017...

The business analyst for Ace Business Machine, Inc. wants to forecast the monthly demand for manual typewriters based on the following historical data (Demand for the last five months was): Month...

Following is the Demand for Oil in Barrels by the Acme Manufacturing Company: Year 1 2 3 4 5 6 7 8 9 10 11 12 (Forecast) Barrels 7 9 5 9 13 8 12 13 9 11 7 a) Calculate the Nave Forecast for Years 2...

Year Demand 2015 2016 2017 2018 100 120 180 200 The business analyst for Heavy Equipment Inc. wants to forecast 2019 demand using the demand for one of the company's products based on the above...

1) Monthly demand for a product has been as follows in the last 2 months. (Please provide detailed work for this question) July 60 units August 56 units What is the forecast for September using...

Who performs the MAC algorithm for SDMA? What could be possible roles of mobile stations, base stations, and planning from the network provider?

One mole of N 2 (C v = R 2/5R) gas is originally at room temperature (20C) and a pressure of 5 atm. It is allowed to expand adiabatically and quasi-statically until its pressure equals the room...

Call reports are usually required to be filed annually quarterly semiannually monthly

Winslow Company expects sales of its financial calculators to be $213,000 in the first quarter and $254,000 in the second quarter. Its variable overhead is approximately 19 percent of sales, and...