Question: Moving Average Question Either by hand or using excel, calculate the moving average forecast for time period 8, using the most recent 3 observations. Remember

Moving Average Question

Either by hand or using excel, calculate the moving average forecast for time period 8, using the most recent3observations. Remember toround your answer up.

1. 12

2. 10

3. 15

4. 19

5. 24

6. 27

7. 25

8. ?

a.25

b.19

c.26

d.13

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!

A Canadian tourist travelling to Miami learned that the local temperatures in Fahrenheit for the last week were as follows: 9 3 , 9 4 , 9 3 , 9 5 , 9 6 , 8 8 , 9 0 ( yesterday ) . a ) Forecast the...

The monthly sales for Yazid Batteries, Inc., were as follows. Month Jan Feb Mar Apr May Jun Aug Sep Oct Nov Dec Sales 20 21 17 14 11 18 17 11 20 21 23 23 This is contains only parts and h The...

Using simple moving averages and the following time series data, respond to each of the items. B click here for the Excel Data Fle b. Compute all possible forecasts using a six-perlod simple moving...

Really need help with these questions please and thank you! Using the data below and the SES forecast a=0.3. what is the error for the 3rd week? Week Time Series Value 1 10.00 2 8.00 3 17.00 10.00...

Updated question: A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to...

Market Demand Forecast Method Selection and Application: A Case Study in Hero MotoCorp Ltd. D K Choudhury Abstract: In this dynamic era, the market is very competitive and the demand for a product...

Microsoft Excel Activity #1: Moving Average Forecast X Question 1 0/10 Excel Online Structured Activity: Moving Average Forecast Submit Consider the demand for same product over the last 12 periods....

Consider the demand for some product over the last 12 periods. The weights of 0.4, 0.2, 0.3, and 0.1 are assigned to the most recent, second most recent, third most recent, and fourth most recent...

QUESTION 1 Kristen Pacheco owns a small restaurant that's open seven days a week. Until recently, she forecasted the daily number of customers she would have using her intuition. However, she wanted...

The more compounding periods, the ______ the effective rate of interest. Select one: a. lower b. higher c. no effect on d. better

Order the steps for the procedure for using the volumetric pipet to deliver a fixed volume of water. 1-First Step, 8-Last Step. ( ) Before starting make sure that the pipet is clean and is not...

A reverse mortgage ( reverse annuity mortgage ) allows early loan repayment repayment of a loan at a lower interest rate retired people to use the equity in their home FHA or VA financing

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...