Is there an app template for vehicle management that exists in the government space?
My office has more than 400 assets that require tracking - this includes maintenance, status of asset (operational / assigned / non-operational), location of asset, and costs related to the asset. Assets include vehicles, hard and soft sided tent systems, mobile ICUs, mobile pharmacies, and various types of trailers.
Some assets are primary movers while some are system components. The 400+ assets are located throughout the country.
We have built some home-grown solutions through Microsoft Forms --> Automate --> PowerBI to be able to see the vehicle location / assignment / cost but the solution is cumbersome and requires the driver to do a lot of clicking. Currently, drivers must submit zipcodes of their starting and ending locations in order to be mapped; we have no way to do this based on GPS location or automatic information.
Drivers must also submit different reports for each asset type assigned. Ideally, the driver could submit one report for all assets assigned to an operation - primary movers, component parts/systems, etc. - without having to submit multiple reports. Right now, that is not possible through MS Forms because of limitations with the branching.
Drivers are also responsible for submitting purchases for fuel or supplies so that cost per vehicle is tracked as well.
Leadership wants to see a map of assets, breakdowns of assigned/non-assigned assets, costs by asset and type of asset by quarter/year as well as type of cost, number of times an asset has been assigned to various incident types, etc.
Is there something out there that already exists that can be adopted to meet these needs?
