Question: Suppose that you work for a U.S. senator who is contemplating writing a bill that would put a national sales tax in place. Because the
Suppose that you work for a U.S. senator who is contemplating writing a bill that would put a national sales tax in place. Because the tax would be levied on the sales revenue of retail stores, the senator has asked you to prepare a forecast of retail store sales for year 8, based on data from year I through year 7. The data are:
Year Retail Store Sales
1…………………….$1,225
2. …………………….1,285
3………………………1,359
4………………………1,392
5………………………1,443
6………………………1,474
7………………………1,467
a. Use the first naive forecasting model presented in this chapter to prepare a forecast of retail store sales for each year from 2 through 8.
b. Prepare a time-series graph of the actual and forecast values of retail store sales for the entire period. (You will not have a forecast for year 1 or an actual value for year 8.)
c. Calculate the root-mean-squared error for your forecast series using the values for year 2 through year 7.
Step by Step Solution
3.39 Rating (177 Votes )
There are 3 Steps involved in it
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
647-M-S-L-R (6184).xlsx
300 KBs Excel File
