Question: Answer the following questions using the data from the Excel file Great Smoky Mountain. xlsx from Problem 16.47. a. Using a four period simple moving

Answer the following questions using the data from the Excel file Great Smoky Mountain. xlsx from Problem 16.47.
a. Using a four period simple moving average, forecast the number of visitors each year visiting the Great Smoky Mountain National Park in 2013.
b. Calculate the MAD for the forecast in part a.
c. Using exponential smoothing with α = 0.7, forecast the number of visitors each year visiting the Great Smoky Mountain National Park in 2013.
d. Calculate the MAD for the forecast in part c.
e. Which forecast do you have most confidence in?

Step by Step Solution

★★★★★

3.42 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Absolute Actual Forecast Forecasting Year Period Visitors Visitors Error t A t F t A t F t 1997 1 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

483-M-S-F (278).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Answer the following questions using the data from the Excel file Deloitte. xlsx from Problem 16.36. From Problem a. Using exponential smoothing with = 0.6, forecast the percentage of holiday...

Answer the following questions using the data from the Excel file daily customers. xlsx described in Problem 16.38: a. Forecast the number of customers who will visit Daves store on Day 9 using a two...

Answer the following questions using the data from the Excel file average bonus. xlsx from Problem 16.43. From Problem a. Using exponential smoothing with Î± = 0.5, forecast the average...

Answer the following questions using the data from the Excel file Great Smoky Mountain.xlsx from Problem 16.47. a. Using a four-period simple moving average, forecast the number of visitors each year...

Answer the following questions using the data from the Excel file Great Smoky Mountain.xlsx from Problem 16.47. The Great Smoky Mountain National Park on the border of Tennessee and North Carolina is...

Answer the following questions using the data from the Excel file daily customers.xlsx described in Problem 16.38: a. Forecast the number of customers who will visit Daves store on Day 9 using a...

Consider the demand for some product over the lact 12 periods. The weights of 0,4, 0.9,0,3, and 0.1 are assigned to the most recent second most recent, the most recent, and fourth most recent...

answer only question 3 AutoSave C - Glos Demand forecasting Fire Exercise NEF (1) Excel Scarch Rajesh Dip File Home Insert Page Layout Formulas Data Review View Help Share Comments Calibri AutoSum 12...

Consider the demand for some product over the last 12 periods. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the...

Chapter 09 Homework: Forecasting and Demand Planning 7. Forecasts and actual sales of digital music players at Just Say Music are as follows: 8 tudy Tools Forecast Actual Sales 190 160 s Month March...

During 2008, Kate Holmes Co.'s first year of operations, the company reports pretax financial income at $250,000. Holmes's enacted tax rate is 45% for 2008 and 40% for all later years. Holmes expects...

Fashion Master purchased mens sweaters for $72 less 40% and 15%. The normal rate of markup on selling price is 40%, and overhead is 25% of the regular selling price. The sweaters were reduced to...

Historically, corporate bond holders have had a greater return on their investment than corporate stockholders. Group of answer choices True. False.

Problem 7A-2 (LO 5) Balance sheet worksheet, mid-year purchase, intercompany bonds and inventory. Book, Inc., acquires all of the outstanding $25 par common stock of Cray, Inc., on June 30, 20X4, in...

Pitney Bowes surveyed 302 directors and vice presidents of marketing at large and midsized U.S. companies to determine what they believe is the best vehicle for educating decision makers on complex...

In a study of incentives used by companies to retain mature workers by The Conference Board, it was reported that 41% use flexible work arrangements. Suppose that of those companies that do not use...

A small independent physicians practice has three doctors. Dr. Sarabia sees 41% of the patients, Dr. Tran sees 32%, and Dr. Jackson sees the rest. Dr. Sarabia requests blood tests on 5% of her...

Hubbard Industries just paid a common dividend, D_0, of $1.00. It expects to grow at a constant rate of 4% per year. If investors require a 8% return on equity, what is the current price of Hubbard's...

A project under consideration has an internal rate of return of 18% and a beta of 0.3. The risk-free rate is 8%, and the expected rate of return on the market portfolio is 18%. a-1. Calculate the...

Suppose you have just bought a new house and are considering the of compact fluorescent bulb (CFB) fixtures instead of the 10 conventional incandescent lighting fixtures (which cost total of...