fill in yellow boxes
from Hamilton to Dayton
10 17 92 20 0 1 00 CB CS 38 0 0 OS CE int Mileage Distance Table Time From To Cincinnati Middletown Florence, KY Lexington, KY Hamilton Beavercreek Greenville Springfield Frankfort, KY Dayton Pa Hillsboro Columbus Danvile, KY Brookvillou wille, KY Cincinnat 51 22 88 110 95 64 90 .22 son 120 Middletown 51 127 381 TS 51 135 38 83 900 104 10 Florence, KY 22 00 0 76 741 120 GO 12 90 115 56 Lexington, KY 127 20 124 10 12 100 44 144 170 148 50 Hamilton 14 26 59 124 43 72 129 49 74 156 391 10 Beavercreek 74 tes 49 32 45 70 190 11 Greenville 110 75 120 76 0 20 122 10 203 12 Springfield 87 168 12 32 12 35 47 50 204 100 180 11 Frankfort, KY 44 129 16.01 150 173 100170 153 18 130 Dayton 64 73 144 401 13 55 147 32 4 15 Piqua 63 170 70 45 47 173 0 300 204 101 Hillsboro 72 70 144 123 153 89 100 85 154 100 . Columbus 100 100 115 18 108 30 100 7 0 23 200 Danville KY 120 564 103 50 114 180 221 204 66 179 204 130 223 15B 100 19 Brookvile IN 128 38 103 841 501 109 133 188 20 Luville KY es 2001 180 81 16 181 200 138 09 ! CHI 9 SEBAB 158 CH 261 BG 28 o SC 0 | 12 13:39:55 195 00 DIS BE 0 & 18 U 05 66 CB 00 07 105 98 O 98 0 0 ! OCT 58 9 CE 100 20 Select an ongnin city (From Cay) and destination cty (To City) from the drop down menues in the blue and green cells below From City To City Hamilton Dayton 1 Place a formula in cell D 30 to find the distance from one city to another city. Select the "From city in cell D 24 (blue cel) and the "To" city in cell 0.25 (green cell) 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Distance Sub Totals Cost per mile Depreciation per mile Labor cost per mille Extra cost per mile for mileage greater than 100 miles $0.15 S0.08 $250 $150 2. Calculate the cost for the trip mileage and labor Trip Mileage and labor cost ===== 40 41 Tax 0% 8 % # % ? 3 Calculate final customer cost by adding the tax cost to the trip mileage and labor cost calculated in step 2 above 45 46 Total Customer Cost 4. In the yellow cell below, indicate if the trip distance is valid or invalid. An invalid trip is when the From and To cities are the same city. When the From and To cities are the same the distance between cities is zero 48 49 50 Status of trip 10 17 92 20 0 1 00 CB CS 38 0 0 OS CE int Mileage Distance Table Time From To Cincinnati Middletown Florence, KY Lexington, KY Hamilton Beavercreek Greenville Springfield Frankfort, KY Dayton Pa Hillsboro Columbus Danvile, KY Brookvillou wille, KY Cincinnat 51 22 88 110 95 64 90 .22 son 120 Middletown 51 127 381 TS 51 135 38 83 900 104 10 Florence, KY 22 00 0 76 741 120 GO 12 90 115 56 Lexington, KY 127 20 124 10 12 100 44 144 170 148 50 Hamilton 14 26 59 124 43 72 129 49 74 156 391 10 Beavercreek 74 tes 49 32 45 70 190 11 Greenville 110 75 120 76 0 20 122 10 203 12 Springfield 87 168 12 32 12 35 47 50 204 100 180 11 Frankfort, KY 44 129 16.01 150 173 100170 153 18 130 Dayton 64 73 144 401 13 55 147 32 4 15 Piqua 63 170 70 45 47 173 0 300 204 101 Hillsboro 72 70 144 123 153 89 100 85 154 100 . Columbus 100 100 115 18 108 30 100 7 0 23 200 Danville KY 120 564 103 50 114 180 221 204 66 179 204 130 223 15B 100 19 Brookvile IN 128 38 103 841 501 109 133 188 20 Luville KY es 2001 180 81 16 181 200 138 09 ! CHI 9 SEBAB 158 CH 261 BG 28 o SC 0 | 12 13:39:55 195 00 DIS BE 0 & 18 U 05 66 CB 00 07 105 98 O 98 0 0 ! OCT 58 9 CE 100 20 Select an ongnin city (From Cay) and destination cty (To City) from the drop down menues in the blue and green cells below From City To City Hamilton Dayton 1 Place a formula in cell D 30 to find the distance from one city to another city. Select the "From city in cell D 24 (blue cel) and the "To" city in cell 0.25 (green cell) 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Distance Sub Totals Cost per mile Depreciation per mile Labor cost per mille Extra cost per mile for mileage greater than 100 miles $0.15 S0.08 $250 $150 2. Calculate the cost for the trip mileage and labor Trip Mileage and labor cost ===== 40 41 Tax 0% 8 % # % ? 3 Calculate final customer cost by adding the tax cost to the trip mileage and labor cost calculated in step 2 above 45 46 Total Customer Cost 4. In the yellow cell below, indicate if the trip distance is valid or invalid. An invalid trip is when the From and To cities are the same city. When the From and To cities are the same the distance between cities is zero 48 49 50 Status of trip
