The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City's many competitors. The manager has collected the following demand data for the past 8 months: Demand for Soft Shag Month Carpet (1,000 yd.) 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 Compute a 3-month moving average forecast for months 4 through 9. Compute a weighted 3-month moving average forecast for months 4 through 9. Assign weights of 0.55, 0.33 and 0.12 to the months in sequence, starting with the most recent month.

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)

6th Edition

ISBN:9781337111348

Author:Bruce Crauder, Benny Evans, Alan Noell

Publisher:Bruce Crauder, Benny Evans, Alan Noell

Chapter3: Straight Lines And Linear Functions

Section3.4: Linear Regression

Problem 12SBE: Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4

See similar textbooks

Related questions

Question

The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City's many competitors. The manager has collected the following demand data for the past 8 months:

Demand for Soft Shag

Month Carpet (1,000 yd.)

1 8

2 12

3 7

4 9

5 15

6 11

7 10

8 12

Compute a 3-month moving average forecast for months 4 through 9.
Compute a weighted 3-month moving average forecast for months 4 through 9. Assign weights of 0.55, 0.33 and 0.12 to the months in sequence, starting with the most recent month.

NB:

Time periods are in weeks
You may work in the network but please show the results in a table.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Time Series Analyses, Forecasting Methods, and Indices$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.