Fleet Management Agency - PowerPoint PPT Presentation

1 / 13
About This Presentation
Title:

Fleet Management Agency

Description:

Winnipeg Fleet Management Agency is a Special Operating Agency, ... Manufacturing and Fabrication. Fuel Management Services. Insurance and Licensing Services ... – PowerPoint PPT presentation

Number of Views:98
Avg rating:3.0/5.0
Slides: 14
Provided by: montyg
Category:

less

Transcript and Presenter's Notes

Title: Fleet Management Agency


1
Fleet Management Agency
RTA Conference 2008
Presented By Monty G. Perham CMA CAFM
2
Who We Are
  • Winnipeg Fleet Management Agency is a Special
    Operating Agency, acting at arms length from the
    City of Winnipeg, delivering high quality fleet
    management services to city departments.
  • Manage Approx. 1600 vehicles and equipment for
    city departments.

3
Who We Are
  • Our services include
  • Fleet Acquisition and Disposal Services
  • Rental Vehicles
  • Fleet Maintenance Services
  • Manufacturing and Fabrication
  • Fuel Management Services
  • Insurance and Licensing Services
  • Power Tools Services
  • Vehicle Safety Training
  • Financial and Leasing

4
Life Cycle Cost Management (LCCM)
  • Life Cycle Cost Management (LCCM) is a
    procurement methodology that assists fleet
    managers in making financial decisions by
    considering all unit or activity costs over the
    life of the vehicle or equipment.

5
WFMA RTA
  • WFMA has been using RTA for 5 years
  • Converted to SQL approximately 2 years ago.
  • Opportunities with using SQL
  • Electronic Billing
  • Data Auditing
  • Report Writing

6
WFMA RTA
  • Other Initiatives
  • Vehicle Component Numbers
  • Standardized Part Numbers
  • Lease Calculator

7
Electronic Billing
  • Work Order Billing
  • Export all closed Work Orders at the line level
    to Access
  • Using predefined macros to link to a Department
    Table
  • Creates a Detailed Monthly Billing Report
  • From this report create Customer Billing Report
    Journal Entry
  • Journal Entry is Uploaded to PeopleSoft

8
Electronic Billing
  • Lease Billing
  • Export listing of all active vehicles to RTA
  • Use predetermined macros to import rates
    associated to the vehicles
  • Create Master billing report
  • Create Customer Billing Report and Journal Entry
  • Journal Entry is Uploaded to PeopleSoft

9
Data Auditing
  • Omni Audit
  • Tracks changes on specified fields within RTA and
    the user who made the change
  • Inexpensive (Approx. 1000.00)

10
Report Writing
  • Currently using Microsoft Access Excel
  • In the process of implementing Crystal Report
    Writer
  • Ability to link RTA with other SQL Access
    databases

11
Vehicle Component Numbers
  • All Components of a unit are assigned an
    individual unit number
  • Chassis
  • Body
  • Additional Equipment
  • Chassis is considered Parent
  • Misc1 Field is used to identify the Parent unit
    for reporting

12
Standardized Part Numbers
  • Part Numbers are 11 digits
  • First 3 Alpha Major Code
  • Next 3 Alpha Minor Code
  • Next 5 Number Sequential
  • Example An Air Filter would be
  • FILAIR00001

13
Lease Calculator
  • WFMA leases units to the Citys Departments
  • Current version is in Excel
  • Process of converting into SQL providing
    automatic updating of tables
Write a Comment
User Comments (0)
About PowerShow.com