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.

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
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
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON