Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10. Carl Lipke is the marketing VP for a propane gas distributor. He would like to have a forecast of sales on a quarterly basis,

image text in transcribed

10. Carl Lipke is the marketing VP for a propane gas distributor. He would like to have a forecast of sales on a quarterly basis, and he has asked you to prepare a time-series decomposition model. The data for 2005 through 2016 follow:(c6p10) Propane Gas Sales in Millions of Pounds (Total at End-Month of Each Quarter) (continued on next page) 2. To help Carl Lipke see how propane gas sales have varied over the 12-year period, prepare a time-series plot of the raw data and the deseasonalized data (i.e., the centered moving averages). Use Forecast XTM to find seasonal indices for quarters 1 through 4 . Write a short paragraph in which you explain to Carl Lipke exactly what these indices mean. Plot the values of actual sales, the centered moving averages, and the trend. All of these can be found in your Forecast XTM results. 1. From Forecast XTM, get a forecast for 2017Q1 through 2017Q4 based on the timeseries decomposition model. Enter your forecast values into an Excel sheet that you set up like in the table shown below. Given the actual values shown in the table, calculate the mean absolute percentage error (MAPE) for 2017

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

Principles Of Investments

Authors: Alan Marcus, Zvi Bodie, Michael Drew, Anup Basu, Alex Kane

1st Edition

0071012389, 978-0071012386

More Books

Students also viewed these Finance questions