ࡱ> Na  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMPQ_STUVWXYZ[\]^`bcdRoot Entry F1)`bYO@WorkbookMsoDataStore P#)a)HV2PMOEQ5==2P#))Item PropertiesSAFH0UMPUL==2 P#)`i)Item Properties OXKU1LK1Q==2 P#)a)Item  RPropertiesG g2\pWortham, Elieente Ba= = PK8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1$Arial1 Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1Arial1 Arial1 Arial1 Arial1!Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)A<_("$"* #,##0.000_);_("$"* \(#,##0.000\);_("$"* "-"??_);_(@_) "$"#,##0.00!"$"#,##0.00;[Red]"$"#,##0.00"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"B=_("$"* #,##0.000_);_("$"* \(#,##0.000\);_("$"* "-"???_);_(@_) "$"#,##0.0000.0],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)$[$-409]dddd\,\ mmmm\ dd\,\ yyyy[$-409]h:mm:ss\ AM/PM=8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)                                                                      ff + ) , *      P  P        ! ` "      #   $ % a> & ,   x    8@  8  8  8@  |  |  8 @  |  |  ,8  <  ,8  <   8  8     x""@ @   x"@   x" @   x @   x  "@ @  "@ @  @ @  ,"@ @  !@ @    "x x !"@ @  @ @  )!@ @  @ @  )!@ @  @ @  !@ @  !@ @  )!!@ @ "@ @  !!@ @   @ @  !@ @  @ @   !@ @  @ @  !@ @  @ @   *!@ @  @ @   @@ " "@ @   "@ @  "@ @ "@   @   " @  ,"@ @   ,"@ @  ,"@ @ ,"@ @  ,@ @   ,"@ @   ,"@ @  ,"@ @  "@ @  !@@  !@   ! @ "@  "  "    @@ ,  @ ,    @ ,  "@@  "@  @@  @    @   @         @@ ,  @ ,    @ , "@@ "  @  @@  @    @ x  x  "x "x  *x *x  "x "x  "x  "x  "x  "x  x  x  *x  *x  *x@@ *x@ *x  @ x@@ x@ ||\r}A} #0\);_("ef(@_) -}A} #0\);_("ef(@_) -}A} #0\);_("ef(@_) -}A} #0\);_("ef(@_) -}A} #0\);_("ef(@_) -}A} #0\);_("ef (@_) -}A} #0\);_("L(@_) -}A} #0\);_("L(@_) -}A} #0\);_("L(@_) -}A} #0\);_("L(@_) -}A} #0\);_("L(@_) -}A} #0\);_("L (@_) -}A} #0\);_("23(@_) -}A} #0\);_("23(@_) -}A} #0\);_("23(@_) -}A} #0\);_("23(@_) -}A}  #0\);_("23(@_) -}A}! #0\);_("23 (@_) -}A}" #0\);_("(@_) -}A}# #0\);_("(@_) -}A}$ #0\);_("(@_) -}A}% #0\);_("(@_) -}A}& #0\);_("(@_) -}A}' #0\);_(" (@_) -}A}( #0\);_("(@_) -}}) }#0\);_("(@_) -##0.  }}* #0\);_("(@_) -???##0.??? ??? ???}-}/ #0\);_("}A}1 a#0\);_("(@_) -}A}2 #0\);_("(@_) -}A}3 #0\);_("?(@_) -}A}4 #0\);_("23(@_) -}-}5 #0\);_("}}7 ??v#0\);_("̙(@_) -##0.  }A}8 }#0\);_("(@_) -}A}9 e#0\);_("(@_) -}x}:#0\);_("(@_##  }}; ???#0\);_("(@_???## ???  ??? ???}-}= #0\);_("}U}> #0\);_("(@_## }-}? #0\);_("}(}U23#0\);_("}(}V23#0\);_("}(}W23#0\);_("}(}X23#0\);_("}(}Y23#0\);_("}(}ZL#0\);_("}(}[L#0\);_("}(}\L#0\);_("}(}]L#0\);_("}(}^L#0\);_("}d}`#0\);_("(@_ ## ??? }d}a#0\);_("(@_ ## ??? }(}oef#0\);_("}(}sef#0\);_("}(}u23#0\);_("}(}~ef#0\);_("}(}ef#0\);_("}(}23#0\);_("}(}23#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}(}L#0\);_("}P}#0\);_("(@_ ##}<}#0\);_("(@_}P}#0\);_(" (@_ ##}<}#0\);_(" (@_}d}#0\);_("(@_ ## ??? }P}#0\);_("(@_ ##}d}#0\);_("(@_ ## ??? }P}#0\);_("(@_ ##}P}#0\);_("(@_ ##}<}#0\);_("(@_}<}#0\);_(" (@_}(}#0\);_("}P}#0\);_("(@_ ##}<}#0\);_("(@_}P}#0\);_("(@_ ##}<}#0\);_("(@_ 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`WTrip Optimizer SystemS~Vehicle Rental Rates Average MPG  ;!SffH@B:|x  L3 A@@  dR RefuelingInput VariablesCalculated ResultsTotal Reimbursement ExpenseTotal Rental Cost"Total Days in Trip (24-hr periods) IntermediateTypeCompact Full SizeLuxuryMedium-Size Sport UtilityMini-VanDailyWeekly Sub-Compact Current State Rate&Total Miles to be Traveled During Trip1 Use # of 24-hour periods (4 day trip = 4)\ State Of Mississippi Trip Optimizer System: Car Rental vs Mileage Reimbursement CalculatorCityHighwayMiscellaneous Fees*Taxes and Fees5Mileage Reimbursement Rate (if pool car is available)Special ConditionsCost of Gasoline per Gallon**Enterprise Rent - A - CarHertz CorporationVanguard/National Car Rental Average MPGAverage*X* The average mpg value is the only value that will be used in the Trip Optimizer System Chart Help: Calcuation Help:9Mileage Reimbursement Rate (if pool car is not available)(./ Rental Costg** Gas prices do fluctuate but an estimated price can be retrieved from sites such as www.gasbuddy.com. Input any other fees charged including but not limited to sales tax, motor vehicle tax, and etc. to be charged due to form of payment6 = Total Days in Trip X Car Daily Rental Price 4 = Total Amount of Additional Taxes and Fees$Average Rental Car Gas Mileage (MPG)%Dollars Saved - No Pool Car Available"Dollars Saved - Pool Car Availabled Input price for rental vehicle using the vehicle rental rates (See Vehicle Rental Rates Tab)F _ Input average MPG for rental car type using the Average MPG chart (See Average MPG Tab)J , = Total Miles to be Traveled X .535& ' + = Total Miles to be Traveled X .17& ' a = Rental Cost + Taxes and Fees + Refueling + Distance from Home to Rental Car Location  ) + 6 8 G = (Total Miles in Trip / Average MPG) X Cost of Gas per Gallon ! / 1 d Rental Car CostU Vehicle Rental Daily Price Contract # 8200015385Contract # 8200015383Contract # 8200015368=Landrum Enterprises: U - Save Car and Truck Rental (Meridian)Contract # 8200015382 Contract# 8200015361Contract # 8200015367:David Dearman Auto Rentals: U - Save Car and Truck Rental Corporate ID: 1757/1785Corporate ID: XZ55012Corporate ID: 68344 or 0068344VOne Source Enterprises: U - Save Car and Truck Rental (Starkville, Tupelo, Louisville)Corporate ID: 1413Corporate ID: MSU1Corporate ID: XZ55012 z Input only the distance to the rental car location (this mileage will be doubled in the total calculation formula)"Total Miles to Rental Car location Travel Dates:oTraveler Name: Agency #: 2 Input miles that exceed 100 miles per day | Input current pump price (Utilize the higher cost between city from which the travel will begin and the destination)"* If the rental is not directly billed to the agency or charged on a Travel Card, sales and motor vehicle tax can be reimbursed. ȦԴվ the rental car company to obtain the added miscellaneous fees that will be added to the total, including tax from the city of which you will be renting.E = Total Rental Cost - Total Reimbursement Expense @ .535/mi D = Total Rental Cost - Total Reimbursement Expense @ .17/mi 4Personal Owned Vehicle Car Cost (Pool Car Available)3Personal Owned Vehicle Cost (No Pool Car Available)Vehicle Rental Weekly Price  Input price for rental vehicle only if renting a car on a weekly basis using the vehicle rental rates (See Vehicle Rental Rates Tab)'O n Weekly Rental Cost = Weekly Rental CostZF GGI"ILM OQ' R !V3ccB g2 #fKop  dMbP?_*+%&?'?(?)?M\\DFA-PRINT\PTFM 5 Canon 5255 A ߁ odXLetterCanonX` 1Canon iR-ADV C7260/7270 UFR II ddd      d d d d dd    dd@@d  d  d dd d""eddd      !"#$%&'()*+,-./0123456789:;<=>?@ABCd"    @  !"#$%&'()*+,-d.d/d0123456789:;<=>?@ABCDEFGHIJKLMNO"PQd     d !"#$%&d!dddd!      d  dddH8 o 22= o 22= Xdd Arial\CNZSRGBC.ICC\CNZSRGBC.ICC\CNZSRGBC.ICC CONFIDENTIALCONFIDENTIALHArialDefault SettingsX d     #$%&"BX 333333?333333?&430U} =} mw} X} I} I } I#  @ @  w@  w  h h          h hhhhhhhhhhhhw ; TTTTTTTTT  F }E  b! cZ dG e[ f gD\ fC e3] f, eN] fO g ] f& e ] fH g~ 1@ h @ g#~ J@ h @ i) ^ j- kx l" BBmynB M  o!~ DD  p. mzp L  o!~ DD  p/mzpA 2 A q$! DD p' qPD pQ mD  p( m)DD D  r1 s5%DD  t0 u*! DD pJ u+! DD pK v{|  Dl.&&&&&&&&&44&4AAA;;IUAA 8@!w " I  !% !"C ~( Kx (   B 9x L@?Line 20k<k]9`B :x L@?Line 20k=k]:`B ;x L@?Line 20;:;];`B x L@?Line 20 ;< ;]>`B ?x L@?Line 20 ;< ;]?`B @x L@?Line 20 {; {]@`B Ax L@?Line 20: 8 ]A`B Bx L@?Line 20=]B`B Cx L@?Line 20=]C`B Dx L@?Line 20=]D`B Ex L@?Line 20=]E`B Fx L@?Line 20{={]F`B Gx L@?Line 20E=E]G`B Hx L@?Line 20=]H`B Ix L@?Line 20=]I`B Jx L@?Line 208<8]J`B Kx L@?Line 20=]K`>@FUdJ !! 7gg@ g2 :m  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U} Q}  Q} Q:@hhhhhhhw  h h h h hhhhhhh@hhhhhhhh9@h_h ;  `6 < D E F GMA@Ni@ GMC@N@m@ G MF@Np@ G MQ@N@z@ G M@Q@Ny@ J OM@Pu@   `4 =  D E F G H@@Ig@ G H@@Ig@ GH@@Ig@ G HE@Im@ G HQ@Ix@ G HM@IHt@ G HO@Iu@   a5 > D E F GHA@Ii@ GHA@Ii@ GHA@Ii@ G HE@I p@ G HR@I |@ G HO@Iw@ G HO@Iw@ 7  `8 @ D E FDl&*$$$$$$&*$$$$$$$&*$$$$$$$& h!h"h#h$h%h& @'h(h)h*h+h,h-h.h/h0h1h2h3h4h5h6h7h8h9w G MA@Ni@ !G!MC@N@m@ "G "MF@Np@ #G #MQ@N@z@ $G $M@Q@Ny@ %G %MM@Nu@ &? & '`9 'A' (D (E (F )G)HA@Ii@ *G*HA@Ii@ +G+HC@I@m@ ,G ,HF@I p@ -G -H@Q@Iy@ .G .HM@Iu@ /G /HN@Iv@ 0 0 1`: 1B1 2D 2E 2F 3G3HC@I(k@ 4G4HC@I(k@ 5G5HB@I(k@ 6G 6HF@In@ 7G 7HQ@Ix@ 8G 8HN@It@ 9J 9K@P@LXv@8$$$$$$&*$$$$$$$&*$$$$$$PH h0(  h>@333b  ''11 &&00ggD g2    dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U} }  }  w w hhhhhhw  :@   X Y Y U GR<@RC@VA@ GR;@RC@V?@ GR9@RB@V>@ G R3@R?@V9@ G R2@R=@V6@ G R5@R<@V8@ J S1@S9@W4@ b8*******PH0l0(  l>@   ggD   !"#%&'(*+,-./0123456789:< DocumentLibraryFormDocumentLibraryFormDocumentLibraryForm This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision. metaAttributes"/>Oh+'0 PX| Enterprise Trip OptimizerRobert MullanKeeler, GeorgetteMicrosoft Excel@?QSummaryInformation( $$DocumentSummaryInformation8)XCompObj;k@N{h@H)՜.+,D՜.+,D PXh px COCC Trip Optimizer SystemVehicle Rental Rates Average MPG#'Trip Optimizer System'!Print_Area  Worksheets Named Ranges2BZfr      TravelSection ContentTypeTravelCategory7display_urn:schemas-microsoft-com:office:office#Editor xd_Signature TemplateUrl7display_urn:schemas-microsoft-com:office:office#Author xd_ProgID PublishingStartDate PublishingExpirationDate _SourceUrl _SharedFileIndexWeightGround Transportation DocumentFormsAnna Francis Robin Beard FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q