FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As Juan was reviewing the modeling results, his colleague, Mary, commented that he might want to try other forecasting methods that are simpler and may

As Juan was reviewing the modeling results, his colleague, Mary, commented that he might want to try other forecasting methods that are simpler and may provide better forecasts. Mary suggested to try Moving Average and Exponential Smoothing models to try and generate a more accurate forecast.

Question: 5. Plot the Moving Average models with the actual WTI on one chart AND on a separate chart plot the Exponential Smoothing models with actual WTI.

image text in transcribed

Day 20.28 Weekly Cushing OK WTI Spot Price FOB Dollars per Weekly Cushing OK WTI Spot Weekly Cushing OK WTI Weekly Cushing OK WTI Spot Barrel Weekly Cushing OK WTI Spot Day Price FOB Dollars per Barrel Day Weekly Cushing OK WTI Spot Spot Price FOB Dollars per Price FOB Dollars per Barrel Day Price FOB Dollars per Barrel Day Price FOB Dollars per Barrel Day Barrel 5/26/1995 19.37 9/30/1994 17.83 2/4/1994 15.76 6/11/1993 19.43 1/1/1993 19.63 5/19/1995 5/8/1992 20.86 19.98 9/23/1994 17.38 1/28/1994 15.34 6/4/1993 19.95 12/25/1992 19.91 5/12/1995 20.63 19.74 5/1/1992 9/16/1994 16.93 1/21/1994 15.02 5/28/1993 19.84 12/18/1992 19.38 5/5/1995 4/24/1992 20.06 20.24 9/9/1994 17.65 1/14/1994 14.67 5/21/1993 19.43 12/11/1992 19.01 4/28/1995 20.29 4/17/1992 20.06 9/2/1994 17.52 1/7/1994 15.03 5/14/1993 20.06 12/4/1992 19.38 4/21/1995 4/10/1992 20.43 20.26 8/26/1994 17.23 12/31/1993 14.21 5/7/1993 20.47 11/27/1992 20.16 4/14/1995 4/3/1992 19.73 19.53 8/19/1994 17.85 12/24/1993 14.4 4/30/1993 20.3 11/20/1992 20.35 4/7/1995 3/27/1992 19.09 19.43 8/12/1994 18.88 12/17/1993 14.31 4/23/1993 19.95 11/13/1992 20.37 3/31/1995 19.12 8/5/1994 3/20/1992 19.1 20.09 12/10/1993 14.68 4/16/1993 11/6/1992 20.52 3/24/1995 3/13/1992 18.69 7/29/1994 18.76 19.66 12/3/1993 15.21 4/9/1993 20.37 10/30/1992 20.95 18.55 3/17/1995 18.13 3/6/1992 7/22/1994 19.39 11/26/1993 16.08 4/2/1993 20.44 10/23/1992 21.58 3/10/1995 2/28/1992 18.27 7/15/1994 18.51 20.16 11/19/1993 16.75 3/26/1993 20 10/16/1992 22.25 3/3/1995 2/21/1992 18.62 18.5 7/8/1994 19.39 11/12/1993 16.71 3/19/1993 20.14 10/9/1992 21.9 2/14/1992 2/24/1995 18.75 7/1/1994 19.49 19.16 11/5/1993 17.29 3/12/1993 20.45 10/2/1992 21.81 2/17/1995 19.42 18.55 2/7/1992 6/24/1994 19.8 10/29/1993 17.37 3/5/1993 20.69 9/25/1992 21.71 2/10/1995 1/31/1992 19.05 18.42 6/17/1994 19.61 10/22/1993 18.12 2/26/1993 20.4 9/18/1992 22.21 1/24/1992 2/3/1995 18.66 6/10/1994 18.26 10/15/1993 18.57 2/19/1993 19.51 9/11/1992 21.94 1/27/1995 1/17/1992 18.34 18.81 6/3/1994 18.24 10/8/1993 18.46 2/12/1993 20.13 9/4/1992 21.66 1/20/1995 1/10/1992 18.45 5/27/1994 18.41 18.14 10/1/1993 18.33 2/5/1993 20.22 8/28/1992 21.43 1/13/1995 1/3/1992 17.55 5/20/1994 19.11 18.21 9/24/1993 17.67 1/29/1993 19.9 8/21/1992 21.39 12/27/1991 1/6/1995 17.62 18.68 5/13/1994 17.93 9/17/1993 16.94 1/22/1993 18.61 8/14/1992 21.18 12/30/1994 19.2 17.71 12/20/1991 5/6/1994 17.2 9/10/1993 16.96 1/15/1993 18.62 8/7/1992 12/23/1994 21.34 12/13/1991 17.1 4/29/1994 19.64 16.93 9/3/1993 18.1 1/8/1993 19 7/31/1992 21.95 12/16/1994 20.55 16.86 12/6/1991 4/22/1994 17.02 8/27/1993 18.49 1/1/1993 19.63 7/24/1992 21.95 12/9/1994 11/29/1991 16.99 21.49 4/15/1994 16.07 8/20/1993 17.84 12/25/1992 19.91 7/17/1992 21.58 11/22/1991 12/2/1994 22.04 17.78 4/8/1994 15.65 8/13/1993 17.87 12/18/1992 19.38 7/10/1992 21.48 11/25/1994 11/15/1991 22.57 17.73 4/1/1994 14.44 8/6/1993 17.67 12/11/1992 19.01 7/3/1992 22.03 11/18/1994 11/8/1991 23.47 17.51 3/25/1994 15.15 7/30/1993 18.18 12/4/1992 19.38 6/26/1992 22.68 11/11/1994 11/1/1991 23.32 18.25 3/18/1994 14.82 7/23/1993 17.54 11/27/1992 20.16 6/19/1992 22.26 11/4/1994 10/25/1991 23.46 18.69 3/11/1994 14.24 7/16/1993 17.72 11/20/1992 20.35 6/12/1992 22.35 10/28/1994 10/18/1991 23.82 17.93 3/4/1994 14.68 7/9/1993 18.02 11/13/1992 20.37 6/5/1992 22.38 10/21/1994 10/11/1991 2/25/1994 23.08 17.35 14.44 7/2/1993 18.61 11/6/1992 20.52 5/29/1992 21.98 10/14/1994 10/4/1991 17.37 2/18/1994 22.41 14.13 6/25/1993 18.52 10/30/1992 20.95 5/22/1992 20.49 10/7/1994 9/27/1991 2/11/1994 22.24 18.13 14.87 6/18/1993 18.76 10/23/1992 21.58 5/15/1992 20.8 9/20/1991 21.85 Weekly Cushing OK WTI Spot Day Price FOB Dollars per Barrel 9/13/1991 21.54 9/6/1991 21.84 8/30/1991 21.98 8/23/1991 21.99 8/16/1991 21.44 8/9/1991 21.5 8/2/1991 21.46 7/26/1991 21.4 7/19/1991 21.91 7/12/1991 21.43 7/5/1991 20.8 6/28/1991 20.21 6/21/1991 20.08 6/14/1991 19.84 6/7/1991 5/31/1991 21.21 5/24/1991 21.04 5/17/1991 20.95 5/10/1991 21.69 5/3/1991 21.23 20.63 18.5 Day 20.28 Weekly Cushing OK WTI Spot Price FOB Dollars per Weekly Cushing OK WTI Spot Weekly Cushing OK WTI Weekly Cushing OK WTI Spot Barrel Weekly Cushing OK WTI Spot Day Price FOB Dollars per Barrel Day Weekly Cushing OK WTI Spot Spot Price FOB Dollars per Price FOB Dollars per Barrel Day Price FOB Dollars per Barrel Day Price FOB Dollars per Barrel Day Barrel 5/26/1995 19.37 9/30/1994 17.83 2/4/1994 15.76 6/11/1993 19.43 1/1/1993 19.63 5/19/1995 5/8/1992 20.86 19.98 9/23/1994 17.38 1/28/1994 15.34 6/4/1993 19.95 12/25/1992 19.91 5/12/1995 20.63 19.74 5/1/1992 9/16/1994 16.93 1/21/1994 15.02 5/28/1993 19.84 12/18/1992 19.38 5/5/1995 4/24/1992 20.06 20.24 9/9/1994 17.65 1/14/1994 14.67 5/21/1993 19.43 12/11/1992 19.01 4/28/1995 20.29 4/17/1992 20.06 9/2/1994 17.52 1/7/1994 15.03 5/14/1993 20.06 12/4/1992 19.38 4/21/1995 4/10/1992 20.43 20.26 8/26/1994 17.23 12/31/1993 14.21 5/7/1993 20.47 11/27/1992 20.16 4/14/1995 4/3/1992 19.73 19.53 8/19/1994 17.85 12/24/1993 14.4 4/30/1993 20.3 11/20/1992 20.35 4/7/1995 3/27/1992 19.09 19.43 8/12/1994 18.88 12/17/1993 14.31 4/23/1993 19.95 11/13/1992 20.37 3/31/1995 19.12 8/5/1994 3/20/1992 19.1 20.09 12/10/1993 14.68 4/16/1993 11/6/1992 20.52 3/24/1995 3/13/1992 18.69 7/29/1994 18.76 19.66 12/3/1993 15.21 4/9/1993 20.37 10/30/1992 20.95 18.55 3/17/1995 18.13 3/6/1992 7/22/1994 19.39 11/26/1993 16.08 4/2/1993 20.44 10/23/1992 21.58 3/10/1995 2/28/1992 18.27 7/15/1994 18.51 20.16 11/19/1993 16.75 3/26/1993 20 10/16/1992 22.25 3/3/1995 2/21/1992 18.62 18.5 7/8/1994 19.39 11/12/1993 16.71 3/19/1993 20.14 10/9/1992 21.9 2/14/1992 2/24/1995 18.75 7/1/1994 19.49 19.16 11/5/1993 17.29 3/12/1993 20.45 10/2/1992 21.81 2/17/1995 19.42 18.55 2/7/1992 6/24/1994 19.8 10/29/1993 17.37 3/5/1993 20.69 9/25/1992 21.71 2/10/1995 1/31/1992 19.05 18.42 6/17/1994 19.61 10/22/1993 18.12 2/26/1993 20.4 9/18/1992 22.21 1/24/1992 2/3/1995 18.66 6/10/1994 18.26 10/15/1993 18.57 2/19/1993 19.51 9/11/1992 21.94 1/27/1995 1/17/1992 18.34 18.81 6/3/1994 18.24 10/8/1993 18.46 2/12/1993 20.13 9/4/1992 21.66 1/20/1995 1/10/1992 18.45 5/27/1994 18.41 18.14 10/1/1993 18.33 2/5/1993 20.22 8/28/1992 21.43 1/13/1995 1/3/1992 17.55 5/20/1994 19.11 18.21 9/24/1993 17.67 1/29/1993 19.9 8/21/1992 21.39 12/27/1991 1/6/1995 17.62 18.68 5/13/1994 17.93 9/17/1993 16.94 1/22/1993 18.61 8/14/1992 21.18 12/30/1994 19.2 17.71 12/20/1991 5/6/1994 17.2 9/10/1993 16.96 1/15/1993 18.62 8/7/1992 12/23/1994 21.34 12/13/1991 17.1 4/29/1994 19.64 16.93 9/3/1993 18.1 1/8/1993 19 7/31/1992 21.95 12/16/1994 20.55 16.86 12/6/1991 4/22/1994 17.02 8/27/1993 18.49 1/1/1993 19.63 7/24/1992 21.95 12/9/1994 11/29/1991 16.99 21.49 4/15/1994 16.07 8/20/1993 17.84 12/25/1992 19.91 7/17/1992 21.58 11/22/1991 12/2/1994 22.04 17.78 4/8/1994 15.65 8/13/1993 17.87 12/18/1992 19.38 7/10/1992 21.48 11/25/1994 11/15/1991 22.57 17.73 4/1/1994 14.44 8/6/1993 17.67 12/11/1992 19.01 7/3/1992 22.03 11/18/1994 11/8/1991 23.47 17.51 3/25/1994 15.15 7/30/1993 18.18 12/4/1992 19.38 6/26/1992 22.68 11/11/1994 11/1/1991 23.32 18.25 3/18/1994 14.82 7/23/1993 17.54 11/27/1992 20.16 6/19/1992 22.26 11/4/1994 10/25/1991 23.46 18.69 3/11/1994 14.24 7/16/1993 17.72 11/20/1992 20.35 6/12/1992 22.35 10/28/1994 10/18/1991 23.82 17.93 3/4/1994 14.68 7/9/1993 18.02 11/13/1992 20.37 6/5/1992 22.38 10/21/1994 10/11/1991 2/25/1994 23.08 17.35 14.44 7/2/1993 18.61 11/6/1992 20.52 5/29/1992 21.98 10/14/1994 10/4/1991 17.37 2/18/1994 22.41 14.13 6/25/1993 18.52 10/30/1992 20.95 5/22/1992 20.49 10/7/1994 9/27/1991 2/11/1994 22.24 18.13 14.87 6/18/1993 18.76 10/23/1992 21.58 5/15/1992 20.8 9/20/1991 21.85 Weekly Cushing OK WTI Spot Day Price FOB Dollars per Barrel 9/13/1991 21.54 9/6/1991 21.84 8/30/1991 21.98 8/23/1991 21.99 8/16/1991 21.44 8/9/1991 21.5 8/2/1991 21.46 7/26/1991 21.4 7/19/1991 21.91 7/12/1991 21.43 7/5/1991 20.8 6/28/1991 20.21 6/21/1991 20.08 6/14/1991 19.84 6/7/1991 5/31/1991 21.21 5/24/1991 21.04 5/17/1991 20.95 5/10/1991 21.69 5/3/1991 21.23 20.63 18.5

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

Cost Management Accounting And Control

Cost Management Accounting And Control

Authors: Don R. Hansen, Maryanne M. Mowen

4th Edition

0324069731, 978-0324069730

More Books

Students also viewed these Accounting questions

Question

★★★★★
Castle and Dave formed an S corporation that is owned as follows: Castle 75% and Dave 25%. The corporation distributes an asset to each owner. The corporation has a basis of $45,000 for each asset....

Answered: 1 week ago

Question

★★★★★
=+7.38 Consider the following sample of 25 observations on the diameter x (in centimeters) of a disk used in a certain system. 16.01 16.08 16.13 15.94 16.05 16.27 15.89 15.84 15.95 16.10 15.92 16.04...

Answered: 1 week ago

Question

★★★★★
Prove Equation (5.22).

Answered: 1 week ago

Question

★★★★★
Name the four classes of nonexchange transactions defined by GASB standards and explain the revenue and expenditure/expense recognition rules applicable to each class.

Answered: 1 week ago

Question

★★★★★
Problem 5-44 Statement of Cash Flows-Direct Method Based on an analysis of the cash and other accounts, the following information was pro- vided by the controller of Lumbercamp, Inc., a manufacturer...

Answered: 1 week ago

Question

★★★★★
A social psychologist studying mass communication randomly assigned 82 volunteers to one of two experimental groups. Sixty-one were instructed MyStatLab to get their news for a month only from...

Answered: 1 week ago

Question

★★★★★
Imperial Jewelers manufactures and sells a gold bracelet for $189.95. The company's accounting system says that the unit product cost for this bracelet is $149.00 as shown below: Direct materials...

Answered: 1 week ago

Question

★★★★★
What are domestic and/or international attention due to Parkes Elvis festival media coverage?

Answered: 1 week ago

Question

★★★★★
2) Draw the Mohr's circle diagram, find the principal stresses (i.e., normal and shear), and determine the angle from the x-axis to the direction of the first principle stress 1. x = 6 MPa, y = -5...

Answered: 1 week ago

Question

★★★★★
For the beam shown, find the reactions at the supports and plot the shear-force and bending-moment diagrams. V=9 kN, V2= 9 kN, V3=200 mm, and V4 = 1100 mm. Provide values at all key points shown in...

Answered: 1 week ago

Question

★★★★★
F | Pic 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Chrome File Edit View History Gmail Uplo X W YouTube Ade X 1 = Adeyemi Case Narrative.pdf 2 Maps Bookmarks Profiles Tab Window Ade X...

Answered: 1 week ago

Question

★★★★★
Here is your opportunity to take personality tests. Access the Jung Typology Test at Human Metrics (www.humanmetrics.com/cgi-win/JTypes2.asp) and the Big Five Personality Test...

Answered: 1 week ago

Question

★★★★★
You recently applied for a barista position in a local coffee shop and have been asked to supply the names of references. Who would you select to be your references? Why did you choose these people?

Answered: 1 week ago

Question

★★★★★
A candidate may be unwilling to relocate due to family obligations and considerations. This being so, is it viable for an organization to offer employment to both spouses in order to employ the...

Answered: 1 week ago

Previous Question Next Question