Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. 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

image text in transcribed
image text in transcribed
8. 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 1 through year 7 . The data are: Assignment a: Exercise 8 (page 45). Use the Retail Stores Sales data for years 1 through 7. Use the Nave Forecasting Model presented in the chapter to prepare a forecast of retail stores sales for each of the years 2 through 8 . (10 points) Assignment b: Use the above data for Assignment 1b and prepare a time-series graph of the actual and forecast values of retail store sales for the entire period and plot two graphs on the same chart, using Excel (note: you will not have a forecast for period 1 nor an actual for period 8 ). (10 points) Assignment c: Calculate the MAPE for your forecast series using the values for year 2 through year 7. (10 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics Of Finance

Authors: Petr Zima, Robert L. Brown

5th Edition

0070871353, 978-0070871359

More Books

Students also viewed these Finance questions

Question

why we face Listening Challenges?

Answered: 1 week ago

Question

what is Listening in Context?

Answered: 1 week ago