Question: Using this data, answer the following questions. Calculate a Moving Average forecast for January 30 th using a period of 3, 7, 10, and 20

Using this data, answer the following questions.

Calculate a Moving Average forecast for January 30^th using a period of 3, 7, 10, and 20 days. Which period length seems to be the most accurate and why?
If you were to use an Exponential Smoothing model to forecast cases, what value would you choose for alpha and why?
Looking at the data of the cases since March 2020, what would your prediction be for the number of cases in Indiana on March 1, 2021 and June 1, 2021? Justify your answers.
Looking at the data of the cases since March 2020, what can you say about the effectiveness of the 7 day Moving Average forecasting method? Be specific.

AN Newly Reported Statewide Positive Cases by Day 10000 5000 2500 2020-6-23 2020-06-28 2020-08-27 2020-10-29 Date of Positive Case Positive Cases by Day - 7-Day Moving Avg Positive Cases) Newly Reported Positive Cases The table below shows the actual number of reported cases in the State of Indiana since the beginning of 2021. Cases Cases Date Cases Date 1/19/2021 2630 2727 119/2021 5966 Date 1/29/2021 1/28/2021 1/27/2021 2819 1/18/2021 2498 1/8/2021 6095 2230 1/17/2021 3162 1/7/2021 7270 1/26/2021 1718 1/16/2021 3889 1/6/2021 6146 1/25/2021 2189 1/15/2021 4666 1/5/2021 3395 2520 1/14/2021 4375 1/4/2021 3617 1/24/2021 1/23/2021 1/22/2021 3093 1/13/2021 3642 1/3/2021 2981 3489 1/12/2021 3139 1/2/2021 5317 1/21/2021 3624 1/11/2021 3685 1/20/2021 2877 1/10/2021 5093 1/1/2021 6288 AN Newly Reported Statewide Positive Cases by Day 10000 5000 2500 2020-6-23 2020-06-28 2020-08-27 2020-10-29 Date of Positive Case Positive Cases by Day - 7-Day Moving Avg Positive Cases) Newly Reported Positive Cases The table below shows the actual number of reported cases in the State of Indiana since the beginning of 2021. Cases Cases Date Cases Date 1/19/2021 2630 2727 119/2021 5966 Date 1/29/2021 1/28/2021 1/27/2021 2819 1/18/2021 2498 1/8/2021 6095 2230 1/17/2021 3162 1/7/2021 7270 1/26/2021 1718 1/16/2021 3889 1/6/2021 6146 1/25/2021 2189 1/15/2021 4666 1/5/2021 3395 2520 1/14/2021 4375 1/4/2021 3617 1/24/2021 1/23/2021 1/22/2021 3093 1/13/2021 3642 1/3/2021 2981 3489 1/12/2021 3139 1/2/2021 5317 1/21/2021 3624 1/11/2021 3685 1/20/2021 2877 1/10/2021 5093 1/1/2021 6288

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!

E2.6 (LO 3) (Adjusting Entries) Stephen Woo, a dental surgeon, opened a dental practice on January 1, 2025. During the first month of operations, the following transactions occurred. 1. Performed...

Chapter 09 Homework: Forecasting and Demand Planning 7. Forecasts and actual sales of digital music players at Just Say Music are as follows: 8 tudy Tools Forecast Actual Sales 190 160 s Month March...

In the worksheet named Data' you will see realtime demand data for four parts. The time frame for the the demand is from January 2017 to October 2018. Using the data answer the following questions: 1...

Spreadsheet Forecasts and actual sales of digital music players at Just Say Music are as follows: Month Forecast Actual Sales March 210 180 April 193 207 May 208 189 June 262 252 July 259 243 August...

In the worksheet named 'Data' you will see realtime demand data for four parts. The time frame for the the demand is from January 2 0 1 7 to October 2 0 1 8 . Using the data answer the following...

Download ICE Europe Brent Crude Electronic Energy Futures prices for the period over the last two years into Excel format. Using these data, answer the following questions Suppose that an exchange...

Download ICE Europe Brent Crude Electronic Energy Futures prices for the period over the last two years into Excel format. Using these data, answer the following questions: Suppose that an exchange...

ITIS 1P97 FALL 2016 GROUP ASSIGNMENT #2 Due Date: November 27, 2016 @11:55 PM THROUGH SAKAI INSTRUCTIONS: This is a team assignment. The assignment is due by 11:55 PM on November 27, 2016. There are...

Operations Management Take Home Exam Name: ID: A1. Mark the correct answer 1. Which of the following is an assumption of the basic EOQ model? a) Orders arrive not at once (in one lot). b) Demand is...

Below is a trend adjusted model fitted to quarterly revenues of a startup company selling PowerDrink , a new energy drink geared toward college millennials. Based on the data and model below, answer...

Use the above tables to answer the following questions; QUESTIONS: 1. Review the forecast line in the original S&OP grid and the new S&OP grid: How do the plans differ? Was there an expected trend in...

1n - Let Fn 44" + 1. Prove that : 4"n = 4 (mod Fn). Show details of your steps, and you may use the fact that n +1

Which accounting system is followed while recording transactions in a journal? a.Double entry b.Single entry c.Adjusting entry d.Journal entry

You have been requested by the university s administrative vice president ( AVP ) to construct budgets for other areas of operation ( e . g . , the library, grounds, dormitories, and maintenance ) ....

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...