A company is making a spending plan to estimate future demand You want to accurately budget for diesel fuel by using a suitable forecasting technique Below is the raw data N A is not available Either choose to remove or predict the N A values when forecasting and specify your decision Perform a forecasting analysis to predict the 12 week future forecast for diesel fuel Use a 5 p moving average b Exponential smoothing Choose the best alpha value and explain your approach c Is the linear regression between WTI and Diesel cost a good model for this exercise What are your recommendations d Research another factor (besides WTI and Diesel cost), try to find the data for this variable, and then perform a multiple linear regression to see if you can get a good model 18 12 201725 12 201701 01 201808 01 201815 01 201822 01 201829 01 201805 02 201812 02 201819 02 201826 02 201805 03 201812 03 201819 03 201826 03 201802 04 201809 04 201816 04 201823 04 201830 04 201807 05 201814 05 201821 05 201828 05 201804 06 201811 06 201818 06 201825 06 201802 07 201809 07 201816 07 201823 07 201830 07 201806 08 201813 08 201820 08 201827 08 20180 20181091857 17N AN A61 73N A63 6665 7164 1859 41N A63 8162 4961 3562 0165 4963 0563 466 2367 6168 5670 7471 0172 26N A64 7666 165 9169 9173 8973 9368 2267 971 1969 0167 2566 569 97N A67 552 9012 9032 9732 9963 0283 0253 073 0863 0633 0273 0072 9922 9762 9723 013 0423 0433 1043 1333 1573 1713 2393 2773 2883 2853 2663 2443 2163 2363 2433 2393 223 2263 2233 2173 2073 2263 2523 258

The Answer is in the image, click to view ...

Question: A company is making a spending plan to estimate future demand. You want to accurately budget for diesel fuel by using a suitable forecasting technique.

A company is making a spending plan to estimate future demand. You want to accurately budget for diesel fuel by using a suitable forecasting technique. Below is the raw data. N/A is not available. Either choose to remove or predict the N/A values when forecasting and specify your decision. Perform a forecasting analysis to predict the 12-week future forecast for diesel fuel.

Use:

a. 5-p moving average.

b. Exponential smoothing. Choose the best alpha value and explain your approach.

c. Is the linear regression between WTI and Diesel cost a good model for this exercise? What are your recommendations?

d. Research another factor (besides WTI and Diesel cost), try to find the data for this variable, and then perform a multiple linear regression to see if you can get a good model.

A company is making a spending plan to estimate future demand. You want to accurately budget for diesel fuel by using a suitable forecasting

18.12.201725.12.201701.01.201808.01.201815.01.201822.01.201829.01.201805.02.201812.02.201819.02.201826.02.201805.03.201812.03.201819.03.201826.03.201802.04.201809.04.201816.04.201823.04.201830.04.201807.05.201814.05.201821.05.201828.05.201804.06.201811.06.201818.06.201825.06.201802.07.201809.07.201816.07.201823.07.201830.07.201806.08.201813.08.201820.08.201827.08.20180.20181091857.17N/AN/A61.73N/A63.6665.7164.1859.41N/A63.8162.4961.3562.0165.4963.0563.466.2367.6168.5670.7471.0172.26N/A64.7666.165.9169.9173.8973.9368.2267.971.1969.0167.2566.569.97N/A67.552.9012.9032.9732.9963.0283.0253.073.0863.0633.0273.0072.9922.9762.9723.013.0423.0433.1043.1333.1573.1713.2393.2773.2883.2853.2663.2443.2163.2363.2433.2393.223.2263.2233.2173.2073.2263.2523.258

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The chief accountant for Grandview Corporation provides you with the company's 2021 statement of cash flows and income statement. The accountant has asked for your help with some missing figures in...

A company is making a spending plan to estimate future demand. You want to accurately budget for diesel fuel by using a suitable forecasting technique. Below is the raw data. N/A is not available....

A company is making a spending plan to estimate future demand. You want to accurately budget for diesel fuel by using a suitable forecasting technique. Below is the data. N/A is not available. Remove...

Acme Inc. is looking to predict their spending plan as best as they can and to make significant improvements to estimate future demand in the presence of uncertainty. You are the Private Fleet...

Acme Inc. is looking to predict their spending plan as best as they can and to make significant improvements to estimate future demand in the presence of uncertainty . You are the Private Fleet...

Please provide summary of the above text (More than 3000 words) **There should be no plagiarism. If you provide wrong solution then i will dislike and report you abusive and spam. Don't waste my...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Evangel Temple Assembly of God leased a facility from Wood Care Centers, Inc., to house evacuees who had lost their homes in Hurricane Katrina. One clause in the lease contract said that Evangel...

Doctors Smith and Jones, two rival ophthalmologists, plan to enter the market for laser corrective eye surgery in a medium-size community in Illinois. Smith and Jones both utilize the same laser...

Mansfield Information Systems ( MIS ) is an IT support firm. Managers and statf are billed to clents on an hourly basis. The senior administrative staff does not directly provide clent support....

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...