Please help me answer all 3 questions in this case. The numbers and questions asked, in this case, is different than the other cases similar to it, so please don't copy and past other answers from the same case. Also if you could please provide steps to how you're getting the answers, if possible show it in excel with formulas, please. And also please mark the TOTAL COST OF THE MOVE FOR QUESTION 1.
1. $2.10 per gallon for diesel 2. Line-haul tractors 6.5 miles per gallon Labor 1, Line-haul drivers $0.42 per mile 2. Pick-up and delivery (PUD) drivers $30 (fully loaded) per hour 3. Dock workers $25 (fully loaded) per hour Miscellaneous I. Insurance cost-$0.05 per mile . Maintenance cost- $0.15 per mile . Billing cost $5.00 per freight bill 4. Administrative/overhead cost- 8 percent of total cost of move 5. Dock facility cost- $15 per hour 6. Line-haul vehicle averages 45 mph between origin and destination. Route and Time of Move The shipment (40,000 pounds) originates at a customer location in Pittsburgh, located 20 miles from Hardee's dispatch center. A PUD driver is dispatched from the Hardee location at 8:30 a.m. on January 12, 2010, and arrives at destination at 9:00 a.m the same day. The shipment is loaded from 9:00 a.m. to 12:00 p.m. The PUD driver departs the customer location at 12:00 p.m. and arrives back at the Hardee dispatch center at 12:30 p.m The sort process starts at 12:30 p.m. and ends at 8:30 p.m. on January 12. It requires unloading the trailer, sorting, and repalletizing the load. This operation requires two dock workers, each working the same trailer for 8 hours in the dispatch center The line-haul portion begins with the vehicle being dispatched from the Pittsburgh location at 8:30 p.m. on January 12 and traveling to Charlotte, North Carolina, a dis- tance of 481 miles, and arriving at Charlotte at 7:12 a.m. on January 13. The driver rests from 7:12 a.m. until 3:12 p.m. The trip continues with the vehicle departing Charlotte at 3:12 p.m. on January 13 and traveling to Jacksonville, Florida, a distance of 399 miles, arriving at Jacksonville at 12:06 a.m. on January 14. The driver rests from 12:06 a.m. until 10:06 a.m. The line-haul portion concludes with the vehicle departing Jacksonville at 10:06 a.m. and traveling to the customer's location in Miami, a distance of 369 miles, and arriving at the distribution center at 6:18 p.m. on January 14 The line-haul driver stays with the vehicle while it is being unloaded (2 hours un load time). The driver then deadheads at 8:18 p.m. from the customer's distribution center and arrives at a Hardee dispatch center located in Miami at 8:48 p.m., a distance of 15 miles from the distribution center Hourly Principal and interest Calculator Loan Amount Interest Rate Days in a Year Tractor $80,000.00 1096 365 Trailer $24,000.00 1096 365 Length of Loan (years) Monthly Payment ($1,699.76) PMT(C9/12,C12*12,C8 ($364.18) PMT(E9/12,E12*12,E8) $4,370.16) E13 12 Annual Payment Hourly Payment $20,397.16) $2.33 C13 12 C16/(24 C10) $0.50 E16/(24 E10)
