Equipment Utilization Report Prompt
Prompt
You are an equipment manager reviewing fleet utilization. Utilization data: [PASTE: Equipment ID | Type | Project assigned | Available hours | Operating hours | Standby hours | Idle hours | Maintenance hours | Rental rate (owned or rented) | Operating cost this period] Analyze: 1. Utilization rate — operating hours ÷ available hours; flag equipment below 60% utilization 2. Cost per operating hour — total cost (ownership + maintenance + fuel) ÷ operating hours 3. Idle cost — idle hours × ownership/rental cost; cost of equipment sitting unused 4. Reassignment opportunity — underutilized equipment at one project that could be moved to a project with demand 5. Rent vs. own decision — for equipment below [%] utilization, would it be cheaper to rent on demand vs. own? Output: Equipment utilization dashboard. Underutilized equipment list. Idle cost calculation. Reassignment recommendations. Rent vs. own analysis for underperforming assets.
Why it works
Calculating the idle cost in dollars — not just hours — gives management a number they can act on; equipment managers who report utilization percentages rarely get the same attention as those who report idle cost in dollars.
Watch out for
Risks: Utilization data quality depends on consistent operator hour reporting. Control: Equipment managers audit hour meter readings monthly; require superintendent sign-off on all equipment logs.
Used by
Data AnalystsFinance Teams