Question: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average

The quarterly sales data for a gift item over the past three years are as follows.

  1. Calculate the Quarterly Centered Moving Average and the average seasonal index for each quarter.

    Centered

    Unadjusted

    Moving

    Seasonal

    Period

    Sales

    Average

    Index

    Average

    Year 1

    Quarter 1

    7320

    Seasonal

    Quarter 2

    5230

    Period

    Index

    Quarter 3

    3380

    Quarter 1

    Quarter 4

    1280

    Quarter 2

    Year 2

    Quarter 1

    7640

    Quarter 3

    Quarter 2

    6230

    Quarter 4

    Quarter 3

    3230

    Quarter 4

    1340

    Year 3

    Quarter 1

    7380

    Quarter 2

    4720

    Quarter 3

    3700

    Quarter 4

    1650

    What is the Centered Moving Average for Quarter 4 of Year 1?

QUESTION 27

  1. What is the Centered Moving Average for Quarter 2 of Year 2?

QUESTION 28

  1. What is the Centered Moving Average for Quarter 3 of Year 2?

QUESTION 29

  1. What is the Centered Moving Average for Quarter 4 of Year 2?

QUESTION 30

  1. What is the Centered Moving Average for Quarter 1 of Year 3?

QUESTION 31

  1. What is the Centered Moving Average for Quarter 2 of Year 3?

QUESTION 32

  1. What is the average seasonal index for Quarter 1 is (round-off to 3 decimal places)?

QUESTION 33

  1. What is the average seasonal index for Quarter 2 is (round-off to 3 decimal places)?

QUESTION 34

  1. What is the average seasonal index for Quarter 3 is (round-off to 3 decimal places)?

QUESTION 35

  1. What is the average seasonal index for Quarter 4 is (round-off to 3 decimal places)?

QUESTION 36

  1. The number of items sold over a four-month period are:

    month

    1

    2

    3

    4

    sales

    5100

    5500

    5400

    5600

    Calculate the forecasts for the 4th and 5th months using 3-month weighted moving average method with weights of 0.6 for the most recent month and 0.3 for the next to the most recent month. Further, suppose that the exponential smoothing constant =0.5. Then calculate the forecasts for 3rd, 4th and 5th months, using exponential smoothing method.

    Under the 3-month weighted moving average method, what is the forecast for the fourth month?

QUESTION 37

  1. Under the 3-month weighted moving average method, what is the forecast for the fifth month?

QUESTION 38

  1. Under the exponential smoothing method, What is the forecast for the third month?

QUESTION 39

  1. Under the exponential smoothing method, what is the forecast for the fourth month?

QUESTION 40

  1. Under the exponential smoothing method, what is the forecast for the fifth month?

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!

Q:

Income statement and balance sheet data for The Athletic Attic are provided below. Required: 1. Calculate the following risk ratios for 2021 and 2022: a. Receivables turnover ratio. b. Inventory...

Q:

PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average seasonal index for each quarter....

Q:

The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average seasonal index for each quarter. Centered Unadjusted...

Q:

PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average seasonal index for each quarter....

Q:

help please PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average seasonal index for each...

Q:

PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average seasonal index for each quarter....

Q:

PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average seasonal index for each quarter....

Q:

please explain answers solve the equation, using rhe graph provided with the questions below the chart PROBLEM 1: In an assembly line, there are 7 workstations, as shown below. In row 1, you are...

Q:

PROBLEM III. The quarterly sales data for a gift item over the past three years are as follows. Calculate the four-quarter centered moving average and the seasonal indexes for the four quarters. 1...

Q:

please i need the solution for problem iii thus, 11 through 14. thank you PROBLEM III. The quarterly sales data for a gift item over the past three years are as follows. year 1 year 2 year 3 3...

Q:

The quarterly sales data for a gift item over the past three years are as follows. ___________________________________________________________ year 1 year 2 year 3...

Q:

If Andrew's batting average is exactly 0.600 going into the series, and that value is based on exactly 3000 career hits out of 5000 previous times at bat, what is the least his average could possibly...

Q:

One hundred kilogram-moles per hour of a three-component bubble-point mixture to be separated by distillation has the following composition: (a) For a distillate rate of 60kmol/h, five theoretical...

Q:

A levered office building has a Debt Coverage Ratio ( DCR ) of 1 . 2 x . What does this DCR value specifically indicate regarding the property's NOI relative to its debt obligations?

Q:

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...