Jupiter Planet Brewing (JPB) is a premium brewery based in Houston, Texas. JPB ships beer to regional distribution centers in several of the lower 48 states. JPB prides itself on its logistical operations, which it claims provides the best service to its customers. The firm has a fleet of 30 semi-trailer trucks, which are in nearly constant service. Jupiter Planet Brewing Fleet JPB currently has three different long-haul semi-trailer truck models in its fleet. Kenworth T2000, Peterbilt 587 and Freightliner CST120.

A recent audit indicated that shipping costs were out of control. J. Peter Trooper, who is the CEO of JPB, has asked your team to analyze a shipping cost dataset (in the accompanying spreadsheet) to see if the significant cost factors can be identified and to determine if the cost of a shipment can be reasonably forecast. Data JPBs operations staff maintains a database of operating data for all long-haul trips. Operating data for a recent year is included in the accompanying spreadsheet. The table below contains a description of the various columns in the spreadsheet.

Summarize your findings. What does this analysis tell you about shipping costs at JPB? Do you believe that shipping costs are out of control? Based on your analysis, what should JPB focus on as they try to reduce their costs?

Column Departure Date Unit Number Truck Total Operating Cost Miles Driver Experience Daylight Percent Mountains Significant Weather Significant Wind Avg Temp Avg Speed Description Calendar date that shipment leaves the plant Truck unit number Truck model Total cost of diesel fuel and DEF does Miles traveled (round trip) Years of service (less than a year is 0). If trip was in at least 50% daylight hours, 1. Otherwise 0. Percentage of trip that is through mountainous terrain Significant precipitation/thunderstorms/snow High winds Average temperature Average speed maintained by the driver