Brewing Long-Haul Trucking Analysis - Management Assignment Help

Assignment Task

Departure Date Calendar date that shipment leaves the plant
Unit Number Truck unit number
Truck Truck model
FCST120 Indicator variable for FCST120 truck type (1 if yes, 0 if no)
KWT2000 Indicator variable for KWT2000 truck type (1 if yes, 0 if no)
Total Operating Cost Total cost of diesel fuel and DEF does
Diesel Gallons Diesel fuel consumed
DEF Gallons Diesel Exhaust Fluid consumed
Diesel Fuel Cost (AVG/gal) Average cost of diesel on the trip
DEF Cost (AVG/gal) Average cost of DEF on the trip
Miles Miles traveled (round trip)
Percent Mountains Percentage of trip that is through mountainous terrain
Significant Weather Significant precipitation/thunderstorms/snow
Significant Wind High winds
Avg Temp Average temperature
Avg Speed Average speed maintained by the driver
Problem
J. Peter Trooper, JPB’s CEO is concerned about shipping costs. In a recent meeting, he asked you to provide information on the following. Use Microsoft Excel for this assignment.
Date 2/1/2017
Truck KW T2000
Unit 7
Diesel Fuel Cost (AVG/gal) 3.20
DEF Cost (AVG/gal) 2.50
Miles 2500
Percent Mountains 12%
Significant Weather 1
Significant Wind 1
Avg Temp 55
Avg Speed 64
Compute descriptive statistics and a correlation matrix for all relevant variables. Which correlations are interesting? Why?
Find the best one variable regression model to predict total operating cost (total cost of diesel and DEF) for individual trips before they are taken using the 2016 data. Note: do not use Diesel Gallons and DEF Gallons in the model because this data will not be available before the trip.
Develop a high-quality linear regression model to predict total operating cost.
Using your models from part 2 and 3, predict the total operating cost using the data at right. Is either prediction reasonably reliable? Could you base a decision on this prediction? Justify your answer.
Deliverable
In a Word Document, write a draft of an email to the JPB CEO that answers the questions in a concise and thoughtful manner. Please include your team number and names of the teammates who worked on this assignment on the message. Upload your email and your completed spreadsheet in the assignment dropbox. Remember that your email should answer the questions completely. Provide the necessary numerical results as needed. The CEO should not be required to refer to the spreadsheet to see the more important results. Similarly, he should not be required to wade through a lot of computer output in the email. So, carefully choose the data that you wish to include in your report. Finally, your spreadsheet analysis will be graded. So, make sure that your spreadsheet contains all of the analysis that you discuss in your report, make sure that everything on the spreadsheet is well organized and clearly labeled.

This Management Assignment has been solved by our Management Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.