AI Matrx Logo

Asset tracking

Moorfield Junction Operations · Asset tracking · Louisville, KY

Mireille Quintero is the operations manager at Moorfield Junction Operations, the team that keeps a Louisville parts warehouse's forklifts, vans, scanners and laptops running, and she reads each week's visits, minutes and spend by asset type from one dashboard instead of rebuilding a spreadsheet.

Any businessReportingDashboards3 tables · 4 views · 1 form · 1 dimension set · 1 dashboard · 1 digest · 1 notification · 1 agent
Use this template

Visit board

Service visits
Scheduled6
MJ-3131Yale 5,000 lb forkliftForklift
MJ-3132Zebra scanner, shippingHandheld scanner
MJ-3133Dell yard laptopLaptop
MJ-3134Hyster reach truckForklift
MJ-3135Raymond electric pallet jackPallet jack
1 more
Done30
MJ-3101Yale 5,000 lb forkliftForklift
MJ-3102Toyota 8,000 lb forkliftForklift
MJ-3103Hyster reach truckForklift
MJ-3104Ford Transit cargo vanDelivery van
MJ-3105Zebra scanner, receivingHandheld scanner
25 more
Deferred1
MJ-3137Honeywell scanner, returnsHandheld scanner

Tables

Service visits

37 sample rows · 10 columns

Every inspection, repair, calibration and part swap done on an asset, with the time it took and what it cost.

VisitAssetAsset typeVisit typeStatusVisit dateTechnician
MJ-3136Manual pallet jack, returnsPallet jackRepairScheduledOct 16, 1:00 PMLucan Vandersloot
MJ-3135Raymond electric pallet jackPallet jackInspectionScheduledOct 14, 2:00 PMYsolde Aberthwaite
MJ-3134Hyster reach truckForkliftRepairScheduledOct 12, 1:00 PMOsvaldo Brennerman
MJ-3133Dell yard laptopLaptopCalibrationScheduledOct 9, 6:00 PMPiedad Hollowell
MJ-3132Zebra scanner, shippingHandheld scannerPart replacedScheduledOct 8, 5:00 PMPiedad Hollowell
MJ-3131Yale 5,000 lb forkliftForkliftInspectionScheduledOct 7, 12:00 PMOsvaldo Brennerman
MJ-3130Lenovo planner laptopLaptopInspectionDoneOct 2, 6:00 PMPiedad Hollowell
MJ-3129Manual pallet jack, returnsPallet jackRepairDoneOct 1, 1:00 PMLucan Vandersloot
MJ-3128Crown order pickerForkliftInspectionDoneSep 30, 12:00 PMYsolde Aberthwaite
MJ-3127Mercedes Sprinter vanDelivery vanPart replacedDoneSep 29, 2:00 PMOsvaldo Brennerman
MJ-3126Dell dock laptopLaptopCalibrationDoneSep 28, 5:00 PMPiedad Hollowell
MJ-3125Raymond electric pallet jackPallet jackRepairDoneSep 25, 1:00 PMYsolde Aberthwaite

25 more rows

Assets

18 sample rows · 10 columns

The equipment the warehouse runs on, with where it sits, who looks after it and how much service time it has taken.

AssetTagAsset typeLocationStatusBought onPurchase cost
Yale 5,000 lb forkliftFL-101ForkliftDock AIn serviceOct 5, 2021$31,800
Toyota 8,000 lb forkliftFL-102ForkliftDock BIn serviceOct 5, 2022$42,500
Hyster reach truckFL-103ForkliftMain floorIn repairOct 5, 2020$38,900
Crown order pickerFL-104ForkliftMain floorIn serviceOct 5, 2024$29,700
Dell dock laptopLT-401LaptopDock AIn serviceOct 5, 2024$1,320
Lenovo planner laptopLT-402LaptopFront officeIn serviceOct 5, 2025$1,560
Dell yard laptopLT-403LaptopYardIn serviceOct 5, 2023$1,290
Crown electric pallet jackPJ-501Pallet jackDock AIn serviceOct 5, 2022$5,200
Raymond electric pallet jackPJ-502Pallet jackDock BIn serviceOct 5, 2023$5,600
Manual pallet jack, cold roomPJ-503Pallet jackMain floorIn serviceOct 5, 2021$640
Manual pallet jack, returnsPJ-504Pallet jackMain floorIn repairOct 5, 2021$640
Zebra scanner, receivingSC-301Handheld scannerDock AIn serviceOct 5, 2023$1,450

6 more rows

Forms and booking

Log a visit

Form
Log a visitWhat a technician fills in when a piece of equipment has been looked at or fixed.
Visit number *It starts MJ- and four digits.
Which asset was it? *
What kind of equipment is it? *ForkliftDelivery vanHandheld scannerLaptopPallet jack
What was done? *InspectionRepairCalibrationPart replaced
When did you do it? *
Who did the work?
How many minutes did it take?
What did parts and outside labor cost?
Add it to the week

Dashboards

Weekly numbers

Service visits
Visits each week
  • Aug 23, 20265
  • Aug 30, 20265
  • Sep 6, 20265
  • Sep 13, 20266
  • Sep 20, 20265
  • Sep 27, 20265
  • Oct 4, 20263
  • Oct 11, 20263
Visits by type
  • Inspection14
  • Repair11
  • Calibration5
  • Part replaced7
Minutes by asset type
  • Forklift895
  • Delivery van505
  • Handheld scanner125
  • Laptop165
  • Pallet jack350
Spend by asset type
  • Forklift$4,875
  • Delivery van$2,235
  • Handheld scanner$310
  • Laptop$565
  • Pallet jack$1,110
Assets by type
  • Forklift11
  • Delivery van6
  • Handheld scanner6
  • Laptop6
  • Pallet jack8

Also included

  • Visits coming upDigest
  • Visit loggedNotificationTells the operations manager when a visit is logged.

Related templates