CASE 4-2 Hardee Transportation

profilek1662
HardeeTransportationFall2020data1.xlsx

Sheet1

Hardee Transportation
Equipment Cost Data
Equipment Purchase Price
1. Line-haul tractors $ 150,000.00
2. Line-haul Trailers $ 50,000.00
Depreciation
1. Tractors - straight line Years 7
2. Trailers- straight line Years 15
Interest
Tractors = 6 percent APR for 5 years
Trailors = 6 percent APR for 8 years
Fuel
1. per gallon for diesel $ 3.50
2. Line-haul tractors = 6 miles per gallon 6
Labour
Line- haul drivers .45 per mile $ 0.45
Pick up and deliver PUD drivers =(fully loaded) per hour $ 30.00
Dock Workers = (fully Loaded) per hour $ 35.00
Miscellaneous
Insurace cost per mile $ 0.075
Maintenance cost per mile $ 0.200
Billing Cost per freight bill $ 2.10
tractors and trailers are available for use 24 hours per day, 365 days per year
Admin overhead cost percentage of total move 8%
Dock Facility Cost per hour $ 15.00
Line-hual vehicle averages between origin and destination (MPH) 45

Sheet2