Over the years the U.S. grocery distribution and sales industry has grown. Today, the total industry sales are in the billions of dollars. Major retailers, such as Walmart and Target, added food to complement their merchandise sales and Amazon recently purchased Whole Foods. For many companies, forecasts of industry sales are necessary information to plan for short- and long-term decisions. Using the total U.S. grocery store annual sales in millions of dollars (https://www.census.gov/retail/index.html#mrts) in the following table, respond to the following items.

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter4: Linear Functions
Section: Chapter Questions
Problem 8PT: Does Table 1 represent a linear function? If so, finda linear equation that models the data.
icon
Related questions
Question

Over the years the U.S. grocery distribution and sales industry has grown. Today, the total industry sales are in the billions of dollars. Major retailers, such as Walmart and Target, added food to complement their merchandise sales and Amazon recently purchased Whole Foods. For many companies, forecasts of industry sales are necessary information to plan for short- and long-term decisions. Using the total U.S. grocery store annual sales in millions of dollars (https://www.census.gov/retail/index.html#mrts) in the following table, respond to the following items.

 

Year
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Sales
$511, 222
510,033
520,750
547,476
563,645
574,547
599,603
Click here for the Excel Data File
Period
613,159
625,295
639,161
d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression?
(Round your answers to 2 decimal places.)
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Sales
511,222
510,033
520,750
547,476
563,645
574,547
599,603
613,159
625,295
639,161
Predicted Sales
Absolute Error
Transcribed Image Text:Year 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Sales $511, 222 510,033 520,750 547,476 563,645 574,547 599,603 Click here for the Excel Data File Period 613,159 625,295 639,161 d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal places.) 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Sales 511,222 510,033 520,750 547,476 563,645 574,547 599,603 613,159 625,295 639,161 Predicted Sales Absolute Error
d-3. What is the trend equation based on the regression analysis?(Negative amounts should be
indicated by a minus sign. Round your answer to 2 decimal places and other answer to 3 decimal
places.)
Annual US Grocery Sales
Predicted annual change of industry sales
e. What is the predicted annual change of industry sales? (Round your answer to 3 decimal places.)
+
Year
2018
2019
2020
Year.
Annual US Grocery Sales
millions
millions
millions
f. Using the trend model, forecast the next 3 years of grocery sales. (Round your answers to 2
decimal places.)
million per year.
Transcribed Image Text:d-3. What is the trend equation based on the regression analysis?(Negative amounts should be indicated by a minus sign. Round your answer to 2 decimal places and other answer to 3 decimal places.) Annual US Grocery Sales Predicted annual change of industry sales e. What is the predicted annual change of industry sales? (Round your answer to 3 decimal places.) + Year 2018 2019 2020 Year. Annual US Grocery Sales millions millions millions f. Using the trend model, forecast the next 3 years of grocery sales. (Round your answers to 2 decimal places.) million per year.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL