Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

I upload both files of the assignment it has the instructions attach. @font-face {font-family:"Cambria Math"; panose-1: XXXXXXXXXX; mso-font-charset:0; mso-generic-font-family:roman;...

1 answer below »
I upload both files of the assignment it has the instructions attach.





@font-face {font-family:"Cambria Math"; panose-1: XXXXXXXXXX; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature: XXXXXXXXXX;}@font-face {font-family:Calibri; panose-1: XXXXXXXXXX; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature: XXXXXXXXXX XXXXXXXXXX;}@font-face {font-family:"Malgun Gothic"; panose-1: XXXXXXXXXX; mso-font-alt:"맑은 고딕"; mso-font-charset:129; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature: XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX;}@font-face {font-family:"\@Malgun Gothic"; mso-font-charset:129; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature: XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX;}p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0in; margin-right:0in; margin-bottom:8.0pt; margin-left:0in; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Malgun Gothic"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:KO;}p.MsoHeader, li.MsoHeader, div.MsoHeader {mso-style-priority:99; mso-style-link:"Header Char"; margin:0in; mso-pagination:widow-orphan; tab-stops:center 3.25in right 6.5in; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Malgun Gothic"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:KO;}p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; margin-top:0in; margin-right:0in; margin-bottom:8.0pt; margin-left:.5in; mso-add-space:auto; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Malgun Gothic"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:KO;}p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; mso-add-space:auto; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Malgun Gothic"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:KO;}p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; mso-add-space:auto; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Malgun Gothic"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:KO;}p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:8.0pt; margin-left:.5in; mso-add-space:auto; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Malgun Gothic"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:KO;}span.HeaderChar {mso-style-name:"Header Char"; mso-style-priority:99; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:Header;}.MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:11.0pt; mso-ansi-font-size:11.0pt; mso-bidi-font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Malgun Gothic"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:KO;}.MsoPapDefault {mso-style-type:export-only; margin-bottom:8.0pt; line-height:107%;}div.WordSection1 {page:WordSection1;}ol {margin-bottom:0in;}ul {margin-bottom:0in;}
Answered 1 days After Apr 26, 2023

Solution

Subhanbasha answered on Apr 28 2023
26 Votes
Final Project_DSCI2305_SP23
Page 2 of 2
Page 1: General Instruction
Page 2: Project Context
Page 3 ~ 5: Project problems
If you have not, please do the following before you jump in the final project.
1. Go to Canvas week 13 module and watch lecture videos and Excel Demo videos.
2. Set your Excel equipped with Data Analysis Add-Ins. How to get it? Check the last two links of week 13 module.
3. Download Excel practice data file from week 13 module and practice watching Excel Demo videos on the practice data file. Learn how to interpret the output as well.
You are supposed to apply analysis skills you learned in week 13 to this project.
Ready for this project? Download and save both files as yours.
· Download and save the word file named “Problems_FinalProject”. Put your name in front of the file name. For example, “YourName_Problems_FinalProject”. Type in your answers in this problem file.
· Download and save the Excel file named “Data_FinalProject_...”. Put your name in front of the file name. For example, “YourName_Data_FinalProject”. Make your Excel outputs in the file. Your output should be in this file. Please do not bother to import tables and graphs to the problem file. Each file will be graded.
How to submit your project:
 To submit** your project, go to your project submission link in Week 15 module,
1. Click "Start Assignment".  This means you are starting "uploading/posting your files"
2. Post your Excel Data (including your output) file. 
3. Click "add another file".  Post your Problem (including your answers) file. 
4. Click "Submit". 
Your files should be posted at "ONE" submission since the last submission replaces previous submission at multiple submissions. If you submit file 1 and submit file 2, what I receive is only file 2 because the last submission of file 2 replaced file1.
**Please do NOT email your project to instructor. Email submission will not be accepted. All course material should stay within our class Canvas platform, following DLIT internet course regulations.
Following project context is from page 840 of your textbook. But the data and problems have been adjusted by the instructor for your project.
Context:
Managing expenses is often a critical job duty for Chief Financial Officers (CFOs). Sometimes costs are fairly easy to forecast. Items such as office supplies and staffing costs are generally more manageable costs to estimate for budgeting purposes. Other expenses such as raw materials and utility costs can be harder to forecast because the prices can fluctuate widely during a given time period.
Gasoline is another such expense. Gasoline prices are determined in part by the price per ba
el of crude oil. There are two predominant types of crude oil used in the industry to determine the price of gas we see at the pump: West Texas Intermediate (WTI) and Brent Blend. WTI is the benchmark used in the United States and Brent Blend is mostly used in Europe and Africa. An interesting side note is that about 20 gallons of gasoline are made from one ba
el of crude oil (source: Frequently Asked Questions (FAQs) – U.S. Energy Information Administration (EIA)).
Industries that rely heavily on gasoline to provide their product or service can find it difficult to estimate the gasoline expense from month to month and sometimes even from day to day. Some examples of industries that have fluctuating gas price impacts are transportation, landscaping, and logistics. Being able to reliably forecast the gasoline expenses is a critical component of estimating company profits.
Imagine you are tasked with determining reliable estimates of the price per gallon of gasoline to be used in forecasting company profits. Using the data file answer the following questions to...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here