A regional supplier of jet fuel is interested in forecasting its sales
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

A regional supplier of jet fuel is interested in forecasting its sales

12. A regional supplier of jet fuel is interested in forecasting its sales. These sales data are shown for the period from 2002Q1 to 2017Q4 (data in billions of gallons): 



a. Prepare a time series graph of these data. What, if any, seasonal pattern do you see in the plot? Explain.

b. Use ForecastXTM to make a time series decomposition forecast for 2018. Write a brief report explaining your forecast. Include a graph of the fitted values, the forecast values, and the actual sales.

c. Develop two other forecasts of jet fuel sales using the following methods: 

1. A Winters' exponential smoothing model; and

2. A regression model using just time and quarterly dummy variables.

Compare the MAPEs for the three models you have developed, and comment on what you like or dislike about each of the three models for this application.

Hint
Accounts & FinanceC(2) Regression analysis is a set of statistical processes used in statistical modeling to estimate the relationships between a dependent variable (often referred to as the 'outcome' or'response' variable) and one or more independent variables (often referred to as 'predictors,"covariates,'explanatory variables,'or' features'). Linear regression is the most frequent type of r...

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.