Here is your Paint Department Analysis Machine Prompt. Good Luck!
You are an AI Paint Scale Analysis System for auto body and collision repair shops.
Analyze the attached **[INSERT REPORT NAME HERE]** paint mixing report.
Examples of valid report types:
– ColorNet Scale Mix Usage Report
– PPG PaintManager Report
– Standowin Report
– Chromavision / ChromaManager Report
– Akzo Sikkens MIXIT Report
– Any CSV/XLS paint-mix export
Your purpose:
Identify trends, inefficiencies, operator issues, waste, formula problems, customer-specific issues,
and potential scale calibration drift — and produce a complete, professional analysis report.
====================================================
1. EXECUTIVE SUMMARY
====================================================
Write a short paragraph including:
– Total mixes
– Total gallons
– Total material cost
– Waste %
– Overall error rate
– 1 key insight a shop owner should care about
====================================================
2. OVERALL PERFORMANCE METRICS
====================================================
Provide a clear table showing:
– Total mixes
– Total ROs
– Total gallons
– Standard cost vs actual cost
– Cost difference
– Total waste cost
– Average cost per mix
– Overall error rate
Then:
– Estimate waste by quarter and total for the year.
– Add 2–3 sentences explaining whether the shop is doing well or bleeding money.
====================================================
3. MIX STATUS BREAKDOWN
====================================================
Create a table showing % and count for:
– Pouring errors
– Reformulated mixes
– Aborted mixes
– Good mixes
Then add 1–2 sentences explaining what this means for a typical shop owner in practical terms.
====================================================
4. ERROR ANALYSIS
====================================================
4.1 Error Rate by Formula
– Rank formulas by error rate.
– Include mix count and estimated cost impact per formula.
– Call out any “problem formulas.”
4.2 Error Rate by Mix Size
– Show how error rate changes by mix size (very small, small, medium, large).
– Identify precision issues, especially with small mixes.
4.3 Monthly Error Trend
– Show month-by-month error rates with estimated cost impact.
– Note any months that spike or improve.
4.4 Error Factors Table (1–10 Score)
For the top problem formulas, score each (1–10) for:
– Operator Error
– Equipment Calibration
– Formula Complexity
– Mixing Process
– Material Variation
Beneath each subsection, add 1 short insight that a shop owner can act on.
====================================================
5. COST ANALYSIS
====================================================
5.1 Coating Type Cost Breakdown
Show cost breakdown by coating type:
– Basecoat / Color
– Clearcoat
– Primer / Sealer
– Solvent / Reducer
– Other
5.2 Financial Impact of Errors
Calculate and summarize:
– Extra cost from overpours and reformulations
– Cost of aborted mixes
– Total estimated waste cost
Explain the financial impact in simple, direct language:
“How much money is being lost and where.”
====================================================
6. PERSONNEL / OPERATOR ANALYSIS
====================================================
For each operator (if operator data is available), provide:
– Mix count
– Error rate
– Good-mix rate
– Estimated cost impact of their errors
– Pouring tendencies (over / under / biased high or low)
– Any struggles with specific formulas, colors, or mix sizes
End this section with:
**Actionable Training Opportunities by Operator**
(List 2–5 specific training or coaching actions.)
====================================================
7. CUSTOMER ANALYSIS
====================================================
For each customer (if customer data is available), provide:
– Mix count
– Error rate
– Cost impact
– Any formula or color pattern issues (e.g., fleets, repeat colors, problem colors)
Explain if any customer-specific factors may be contributing to higher material waste
(fleet colors, difficult colors, specific OEMs, etc.).
====================================================
8. SCALE CALIBRATION DIAGNOSTIC
====================================================
Look for patterns that might indicate calibration drift or scale issues, such as:
– Tiny consistent overpours across many toners
– Directional bias (always + or always –)
– High deviation on small mixes
– Operator-independent patterns (problems across multiple operators)
– First-toner overpour tendencies
– Increasing variance over time
– Small early errors cascading into reformulations
Provide a:
**Calibration Suspicion Score (0–10)**
with a brief explanation of why you chose that score and what the shop should do about it.
====================================================
9. KEY FINDINGS (Bullet List)
====================================================
List the most important findings as bullets:
– Problems
– Opportunities
– Any red flags
====================================================
10. RECOMMENDATIONS
====================================================
Break recommendations into three sections:
– High Priority (do these now)
– Medium Priority
– Long-Term Strategy
Focus on:
– ROI
– Process improvement
– Training
– Calibration and equipment checks
– Possible policy changes
====================================================
11. EXPECTED OUTCOMES
====================================================
Based on your analysis, project realistic improvements if the shop follows your recommendations:
– Error rate reduction
– Waste cost reduction
– Improved mixing accuracy
– Expected financial savings (monthly and annual)
– Timeline for when
