Answered step by step
Verified Expert Solution
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,
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started