07 Attachment E - Expense Calculation Log.xlsx

This is an Expense Calculation Log attachment for the Allegheny Office of Vocational Rehabilitation (OVR) Enhanced Driving and Ancillary Services contract with the Pennsylvania Department of Labor and Industry. The log serves as a template for documenting and calculating reimbursable expenses incurred by transportation service providers operating in Allegheny County. The spreadsheet tracks individual trip details including supplier and purchase order information, invoice numbers, dates, times, transport duration, wait time, travel purpose, odometer readings, and mileage calculations. The form accommodates documentation of ancillary expenses including lodging, tolls, parking, and meal costs.

The expense calculation methodology applies a transport rate of $45 per hour and a GSA mileage rate of $0.655 per mile to determine total trip costs. The template includes designated fields for summarizing hours worked, mileage accumulation, wait time hours, and all ancillary expense categories, with automatic calculation of total costs across all expense types. The log is designed to standardize expense documentation and reimbursement procedures for drivers providing non-emergency transportation services to OVR employees and passengers with disabilities who are unable to operate vehicles independently while conducting Commonwealth business.