Score Franchise Unit Performance and Pick Who Needs a Field Visit
Tap any variable to replace it with your own value:
AI prompt
Act as a franchise performance analyst. I will give you unit-level data. Rank units by need for support and recommend who gets a field visit this month. Data per unit: [unit name, sales vs last year, sales vs system average, labour percent, customer review score, audit score, complaints, royalty payment lateness, months open] Capacity: I have [number] field visits available this month. Brand priorities: [e.g. protect reputation, grow sales, fix compliance] Please: 1. Build a simple scoring model, show the weights you chose, and explain why in a sentence each. 2. Output a ranked table with the main driver of each unit's score. 3. Separate units that are struggling from units that are new and still ramping, so I do not penalise young sites unfairly. 4. For the top [number] units, write a visit agenda with three questions to ask and the evidence to bring. 5. Name two units that look healthy but show an early warning sign. State any assumption you made about missing data.