Beginning Excel Exercise 2 solution by cuiliqing

VIEWS: 6 PAGES: 2

									             Adam's Travel - 2008
              Minneapolis
              1/18/08 -        Seattle            January
              1/20/08          1/22/08 - 1/26/08 Total
Mileage        $       71.25    $           95.00
Parking        $       37.00    $          200.00
Hotel          $     300.00     $          400.00
Meals          $     150.00     $          200.00
Airfare        $     300.00     $          500.00
Rental Car     $         -      $          250.00
Misc.          $       50.00    $          150.00
TOTALS         $     908.25     $        1,795.00 $ 2,703.25


Average cost
per trip     $     1,351.63
Mileage      $        0.475




C:\Docstoc\Working\pdf\3e18400c-436f-4f5a-97f2-f80d55a7af04.xlsx   8/20/2012 2:47 PM2:47 PM
 Martha's Travel - 2008
                   Phoenix     Total for
               1/1/08 - 1/4/08 January
Mileage        $         71.25
Parking        $         50.00
Hotel          $        600.00
Meals          $        150.00
Airfare        $        400.00
Misc.          $        250.00
TOTAL          $      1,521.25 $ 1,516.75




Mileage rate   $        0.475

								
To top