A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The table below provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let α = 0.4 with an initial forecast for week 1 of 617) methods to forecast demand for week 13. Compare these methods by using the mean absolute deviation and mean absolute percent error performance criteria. Does your analysis suggest that sales are trending and if so, by how much? Week 1 2 3 4 5 6 7 8 9 10 11 12 Sales 617 617 648 739 659 623 742 704 724 715 668 740

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter6: Exponential And Logarithmic Functions
Section6.8: Fitting Exponential Models To Data
Problem 3TI: Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to...
icon
Related questions
Question

A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The table below provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let α = 0.4 with an initial forecast for week 1 of 617) methods to forecast demand for week 13. Compare these methods by using the mean absolute deviation and mean absolute percent error performance criteria. Does your analysis suggest that sales are trending and if so, by how much?

Week 1 2 3 4 5 6 7 8 9 10 11 12
Sales 617 617 648 739 659 623 742 704 724 715 668 740

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 10 steps

Blurred answer
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, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage