Answer the following where the X's Indicates.

Using the data provided in the following excel sheet, extrapolate the correct answers for each Cell indicated with an X that corresponds with the column and row it is contained within.

H N P Practice 5 2 3 One Way Pricing and Adjustments 4 5 Activity-based cost per unit of activity 6 Revenue per unit of activity (operating ratio 80%) 7 Activity Based Costs Suggested Price Per mile Per load Per hour Per load Per mile $1.75 $40.00 $15.00 Final rate Per mile 8 956 Loaded Miles Empty miles ( Utilization allowed is 10%) Actual utilization Applied revenue 1 X 9 Baseline cost-plus pricing 10 Based on length of Haul 11 12 13 14 15 Adjustments To Empty 16 Miles Expectations 17 18 19 20 Cylce time Adjustments 6% Actual empty miles % Actual empty miles Difference from allowed Adjustment to revenue X Hours per load Total Dock Time (Del & PU) Transit time @45 mph Total adjusted hours Applied revenue In contrac Actual Adjustment - 2.2 1.8 x 24 X 27 Special customer Service 28 Adjustments Adjustments Insurance requirements Trailer requirements Other special requirements Total Revenue adjustments Per mile Per load Total $0.08 $24.00 x $16.00 X 29 30 31 x x H N P Practice 5 2 3 One Way Pricing and Adjustments 4 5 Activity-based cost per unit of activity 6 Revenue per unit of activity (operating ratio 80%) 7 Activity Based Costs Suggested Price Per mile Per load Per hour Per load Per mile $1.75 $40.00 $15.00 Final rate Per mile 8 956 Loaded Miles Empty miles ( Utilization allowed is 10%) Actual utilization Applied revenue 1 X 9 Baseline cost-plus pricing 10 Based on length of Haul 11 12 13 14 15 Adjustments To Empty 16 Miles Expectations 17 18 19 20 Cylce time Adjustments 6% Actual empty miles % Actual empty miles Difference from allowed Adjustment to revenue X Hours per load Total Dock Time (Del & PU) Transit time @45 mph Total adjusted hours Applied revenue In contrac Actual Adjustment - 2.2 1.8 x 24 X 27 Special customer Service 28 Adjustments Adjustments Insurance requirements Trailer requirements Other special requirements Total Revenue adjustments Per mile Per load Total $0.08 $24.00 x $16.00 X 29 30 31 x x