Question: Problem 12-2 (Algo) Given the series of demand data below Period: Demand: 1 41 2 31 3 51 4 45 5 23 6 48 7

Problem 12-2 (Algo) Given the series of demand

Problem 12-2 (Algo) Given the series of demand data below Period: Demand: 1 41 2 31 3 51 4 45 5 23 6 48 7 33 8 43 9 29 10 38 Click here for the Excel Data File a. Calculate the forecasts for periods 7 through 11 using moving average models with n=2, n = 4, and n=6. (Round your intermediate calculations and final answers to 1 decimal place.) Week n = 2 n = 4 n = 6 7 39.8 8 35.5 40.5 38.0 36.0 33.5 41.8 37.3 36.8 38.3 38.5 40.5 9 10 36.8 11 35.8 35.7 b-1. Calculate the bias and MAD for each set of forecasts. (Negative answers should be indicated by a minus sign. Round your intermediate calculations and final answers to 1 decimal place.) Moving Average Forecast n = 2 n = 4 n = 6 Bias MAD b-2. Which moving average model is best with respect to MAD? 2-week moving average 6-week moving average 4-week moving average

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!

ACCT2201 GROUP CASE STUDY SEMESTER 1 2023 On 1 July 2013 Ross Ltd acquired all of the share capital (cum div)of Zara Limited for a consideration of $650,000 cash and PPE with a fair value of $50,000....

Problem 12-2 (Algo) Given the series of demand data below Period: Demand: 1 45 2 35 3 4 5143 5 22 6 50 7 36 8 38 9 26 10 37 pictureClick here for the Excel Data File a. Calculate the forecasts for...

2 Problem 12-2 (Algo) Given the series of demand data below Period 2 31 41 6 3 51 4 45 5 23 7 33 8 43 9 29 30 38 -look Pateick here for the Excel Data File a. Calculate the forecasts for periods 7...

Given the series of demand data below Period: Demand: 1 41 2 31 3 51 4 45 5 23 6 48 7 33 8 43 9 29 10 38 picture Click here for the Excel Data File a. Calculate the forecasts for periods 7 through 11...

Problem 12-2 (Algo) Given the series of demand data below Periodi Demands 1 23 2 34 3 38 4 29 5 35 6 24 7 23 8 23 9 31 10 32 DolctureClick here for the Excel Data File a. Calculate the forecasts for...

Problem 12-2 (Algo) Given the series of demand data below Period: Demand: 1 45 6 3 54 4 41 5 19 9 10 2 40 DolctuteClick here for the Excel Data File 6. Calculate the forecasts for perlods 7 through...

Problem 12-2 (Algo) Given the series of demand data below Period: Demand: 1 23 34 38 5 35 6 24 7 23 8 23 9 31 10 32 DrictureClick here for the Excel Dato File a. Calculate the forecasts for perlods 7...

Problem 12-2 (Algo) Given the series of demand data below Period: 1 2. 3 Demand: 26 46 31 4 5 6 7 49 41 31 53 8 9 10 44 34 56 picture Click here for the Excel Data File a. Calculate the forecasts for...

Given the series of demand data below Period: Demand: 1 41 2 34 3 52 4 45 5 23 7 34 49 8 38 9 29 10 43 picture Click here for the Excel Data Fie a. Calculate the forecasts for periods through 11...

part a is all correct, i just need part b. Given the series of demand data below Period: Demand: 1 2 35 30 3 59 4 41 S 23 6 49 7 33 B 42 9 29 10 44 DaictureClick here for the Excel Data File a....

Need 2 A and 2 B Average Bias = -0.9 MAD - 3.5 MAPE 14% Bias 1.1 MAD 4.9 MAPE 163 PROBLEMS 2 3 4 5 9 8 40 Assume you are forecasting with an exponential smoothing model using a=0.6. How much weight...

Home Realty Inc. has been operating for three years and is owned by three investors. J. Doe owns 60 percent of the 9,000 shares that are outstanding and is the managing executive in charge. On...

BASF Inc. makes CDs for use in computers. A quality control engineer at the plant tests batches of 50 disks at a time and plots the proportions of defective disks on a control chart. The first 10...

If Jodi owns 2 0 0 shares of stock, a 2 - for - 1 stock split will double the value of her holdings. True False

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...