Hi can you help me with this , please . Please solve the pick up part , thank you for your help
Also the pick up part of this
LTL Costing Exercise shipment and determine what is the minimum rate that the carrier should charge for this shipment per hundred weight (ewt). Equipment Purchase Price PUD tractor $43,600 2. LH tractor=$65,000 3. PUD trailer= $14,000 4. LH trailer $19,000 The shipment consists of 25 cartons, each weighing 30 pounds and measuring 15 cubic feet. The carrier's trailers have a weight capacity of 40,000 pounds and 2,880 cubic feet. This shipment then occupies 1875 percent of the trailer's weight capacity and 13 percent of its cubic capacity. Because the cubic feet requirement is greater, it will be used to allocate costs in the line-haul Depreciation 1. Tractors-five-year straight line 2. Trailers eight-year straight line 1. Tractors 10 percent APR for five 2. Trailers 10 percent APR for eight Route and Time of Movement $2.00 per gallon for diesel The shipment is picked up by the carrier's driver in a pickup and delivery (PUD) city tractoritrailer unit on June 1, 2005, as one of 18 stops made by the driver that day fromLabor Cost 0730 EST to 1730 EST. The stops covered a total of 40 miles within the Altoona, Pennsylvania satellite terminal service area 1. PUD tractors-five miles pei gallon 2. 3. LH tractors 4.5 miles per gallon 1. PUD drivers-$25 per hour 2. Dock handlers- $22 per hour 3. LH drivers $25 per hour was otne o 1. Terminal variable cost per shipment the carrier at this particular shipper's location Once the pickup vehicle returns to the Altoona terminal, it takes 30 minutes to move the shipment from the city unit across the dock to the line-haul trailer. both origin 2. Terminal fixed cost per shipment at 3. PUD equipment maintenance cost- 4. LH equipment maintenance cost- 5. PUD equipment insurance cost 6. LH equipment insurance cost- $23 7. $1.50 both origin and destination- $2.50 $.35 per mile $.35 per mile $.23 per mile The line-haul tractor/trailer departs from the Altoona terminal at 2300 EST on June 1 and arrives at the Cleveland break-bulk terminal, which is approximately 220 miles from the Altoona satellite, at 0400 EST on June 2 The shipment moves from the line-haul trailer across the dock to a PUD city tractor/trailer unit in 30 minutes Billing cost- $1.95 per bill bours per day percent of total cost of move 365 days, 24 The shipment is delivered to the Cleveland consignee by the PUD driver in a PUD city tractor/trailer unit on June 2 as one of 12 stops made by the driver over the period 0830 EST to 1800 EST. The stops covered a total of 55 miles in the Cleveland area This shipment is one of five delivered to this particular consignee by the driver. File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you w Cut Times New Rom.112--. A. A" | wrap Text Copy . Paste Format Painter Clipboard Number F5 LTL Costing Table Unit cost Cost Sec. Total 2 Types of costs 3 1. Pick up Route costs Tractor Trailer Tractor Trailer Fuel 10 12 Insurance 14 Subtotal # of stops Cost per stop # shipments at stop Route cost per shipment 16 Shipment costs Biling Terminal variable cost Terminal fixed cost Dock Total pickup cost per shipment 6 2. Line-haul Tractor Trailer Tractor Trailer Fuel Labor Maintenance Insurance Total line-baul full trailer % capacity occupied by shipment Shipment line-haul cost Information Cost Table Times Rom - 12 New A La Copy " format PainterBIA Jr. A. | Merge & Center s-963 - Paste Font Alignment Number Clipboard MN A B Fuel Labor Maintenance Insurance Total line-haul full trailer % capacity occupied by shipment Shipment line-haul cost 9 3. Delivery Route costs Tractor Trailer Tractor Trailer Interest Fuel Subtotal # of stops Cost per stop # shipments at stop Route cost per shipment 53 56 Shipment costs Terminal variable cost Terminal fixed cost 58 50Total delivery cost per shipment 61 Total cost per Shipment 62Pickup, dock. Line-haul, delivery Administrative Total Cost per Shipment Total cost per cwt Information Cost Table File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you Wrap Text Paste D Copy Format Painter BIu Clipboard Font Alignment Number 1 Information Sheet (L.TL costing) PUD Tractor PUD Trailer LH Tractor LH Trailer Price Time Distance Dock time Time Distance Dock time hrs 6 Line-haul Depreciation PUD Tractor PUD Trailer LH Tractor LH Trailer 91 Delivery InterestAPR Fuel 12 Depreciation PUD Tractor 13 per day per day per hr per hr per day per day per hr per hr per mile per mile Price per gallon PUD MPG LH MPG PUD Trailer LH Tractor LH Trailer PUD Tractor PUD Trailer LH Tractor LH Trailer PUD Labor (S/hr) PUD driver 16 Interest Dock handler LH driver 18 19 Terminal Var cost per unit Maintenance PUD (per mile) InsurancePUD (per mile) fixed cost per unit LH (per mile LH (per mile) per bill Admin,overhead as % of cost shipment weight (cwt) LTL Costing Exercise shipment and determine what is the minimum rate that the carrier should charge for this shipment per hundred weight (ewt). Equipment Purchase Price PUD tractor $43,600 2. LH tractor=$65,000 3. PUD trailer= $14,000 4. LH trailer $19,000 The shipment consists of 25 cartons, each weighing 30 pounds and measuring 15 cubic feet. The carrier's trailers have a weight capacity of 40,000 pounds and 2,880 cubic feet. This shipment then occupies 1875 percent of the trailer's weight capacity and 13 percent of its cubic capacity. Because the cubic feet requirement is greater, it will be used to allocate costs in the line-haul Depreciation 1. Tractors-five-year straight line 2. Trailers eight-year straight line 1. Tractors 10 percent APR for five 2. Trailers 10 percent APR for eight Route and Time of Movement $2.00 per gallon for diesel The shipment is picked up by the carrier's driver in a pickup and delivery (PUD) city tractoritrailer unit on June 1, 2005, as one of 18 stops made by the driver that day fromLabor Cost 0730 EST to 1730 EST. The stops covered a total of 40 miles within the Altoona, Pennsylvania satellite terminal service area 1. PUD tractors-five miles pei gallon 2. 3. LH tractors 4.5 miles per gallon 1. PUD drivers-$25 per hour 2. Dock handlers- $22 per hour 3. LH drivers $25 per hour was otne o 1. Terminal variable cost per shipment the carrier at this particular shipper's location Once the pickup vehicle returns to the Altoona terminal, it takes 30 minutes to move the shipment from the city unit across the dock to the line-haul trailer. both origin 2. Terminal fixed cost per shipment at 3. PUD equipment maintenance cost- 4. LH equipment maintenance cost- 5. PUD equipment insurance cost 6. LH equipment insurance cost- $23 7. $1.50 both origin and destination- $2.50 $.35 per mile $.35 per mile $.23 per mile The line-haul tractor/trailer departs from the Altoona terminal at 2300 EST on June 1 and arrives at the Cleveland break-bulk terminal, which is approximately 220 miles from the Altoona satellite, at 0400 EST on June 2 The shipment moves from the line-haul trailer across the dock to a PUD city tractor/trailer unit in 30 minutes Billing cost- $1.95 per bill bours per day percent of total cost of move 365 days, 24 The shipment is delivered to the Cleveland consignee by the PUD driver in a PUD city tractor/trailer unit on June 2 as one of 12 stops made by the driver over the period 0830 EST to 1800 EST. The stops covered a total of 55 miles in the Cleveland area This shipment is one of five delivered to this particular consignee by the driver. File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you w Cut Times New Rom.112--. A. A" | wrap Text Copy . Paste Format Painter Clipboard Number F5 LTL Costing Table Unit cost Cost Sec. Total 2 Types of costs 3 1. Pick up Route costs Tractor Trailer Tractor Trailer Fuel 10 12 Insurance 14 Subtotal # of stops Cost per stop # shipments at stop Route cost per shipment 16 Shipment costs Biling Terminal variable cost Terminal fixed cost Dock Total pickup cost per shipment 6 2. Line-haul Tractor Trailer Tractor Trailer Fuel Labor Maintenance Insurance Total line-baul full trailer % capacity occupied by shipment Shipment line-haul cost Information Cost Table Times Rom - 12 New A La Copy " format PainterBIA Jr. A. | Merge & Center s-963 - Paste Font Alignment Number Clipboard MN A B Fuel Labor Maintenance Insurance Total line-haul full trailer % capacity occupied by shipment Shipment line-haul cost 9 3. Delivery Route costs Tractor Trailer Tractor Trailer Interest Fuel Subtotal # of stops Cost per stop # shipments at stop Route cost per shipment 53 56 Shipment costs Terminal variable cost Terminal fixed cost 58 50Total delivery cost per shipment 61 Total cost per Shipment 62Pickup, dock. Line-haul, delivery Administrative Total Cost per Shipment Total cost per cwt Information Cost Table File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you Wrap Text Paste D Copy Format Painter BIu Clipboard Font Alignment Number 1 Information Sheet (L.TL costing) PUD Tractor PUD Trailer LH Tractor LH Trailer Price Time Distance Dock time Time Distance Dock time hrs 6 Line-haul Depreciation PUD Tractor PUD Trailer LH Tractor LH Trailer 91 Delivery InterestAPR Fuel 12 Depreciation PUD Tractor 13 per day per day per hr per hr per day per day per hr per hr per mile per mile Price per gallon PUD MPG LH MPG PUD Trailer LH Tractor LH Trailer PUD Tractor PUD Trailer LH Tractor LH Trailer PUD Labor (S/hr) PUD driver 16 Interest Dock handler LH driver 18 19 Terminal Var cost per unit Maintenance PUD (per mile) InsurancePUD (per mile) fixed cost per unit LH (per mile LH (per mile) per bill Admin,overhead as % of cost shipment weight (cwt)
