{
  "prompt_id": "PLUMBING_RED_FLAGS_001",
  "name": "PLUMBNG Red Flags Analysis",
  "version": "1.0",
  "category": "Home Services",
  "industry": "PLUMBING",
  "description": "Evaluates PLUMBING business health against industry red flags.",
  "output_format_instruction": "If the user specifies 'output: json', respond in clean JSON format. Otherwise, use natural, readable text with clear headings and bullet points.",
  "questions": [
    "What percent of your total revenue is recurring?",
    "What's your average revenue per ticket/sale?",
    "What percent of your revenue is from replacements vs repairs?",
    "What's your overall gross margin as a percent of total revenue?",
    "What's your average markup on supplies and materials?"
  ],
  "inputs": [
    {
      "index": 0,
      "value": "19%"
    },
    {
      "index": 1,
      "value": "300"
    },
    {
      "index": 2,
      "value": "36%"
    },
    {
      "index": 3,
      "value": "52%"
    },
    {
      "index": 4,
      "value": "12%"
    }
  ],
  "dataset": [
    {
      "A": "Industry",
      "B": "Business Type",
      "C": "Category",
      "D": "Metric",
      "E": "Healthy Range",
      "F": "RED FLAG Trigger",
      "G": "If Red Flag Conditions Are Met",
      "H": "If Red Flag Conditions Are Not Met"
    },
    {
      "A": "Home Services",
      "B": "PLUMBING",
      "C": "Revenue Mix",
      "D": "Recurring Revenue",
      "E": "Recurring revenue should be between 18 to 35% of total revenue.",
      "F": "If recurring revenue is less than 12% of total revenue, it's a red flag.",
      "G": "Possible reasons and impacts: Cash flow highly seasonal and winter crunch potential; inability to fund growth initiatives; vulnerability to economic downturns; reduced customer retention and loyalty; limited borrowing power from banks.",
      "H": "Congrats! You're doing great here."
    },
    {
      "A": "Home Services",
      "B": "PLUMBING",
      "C": "Revenue Mix",
      "D": "Average Revenue Per Ticket",
      "E": "Average revenue ticket should be between $325 and $650.",
      "F": "If average ticket revenue is under $325 it's a red flag.",
      "G": "Possible reasons and impacts: Underpricing or over-scoping leading to margin erosion; poor upselling by technicians; ineffective sales training; customer perception of low value; inability to cover fixed costs per job.",
      "H": "Congrats! You're doing great here."
    },
    {
      "A": "Home Services",
      "B": "PLUMBING",
      "C": "Revenue Mix",
      "D": "Replacement vs Repair Revenue",
      "E": "40 to 65% replacement vs repair revenue is the normal range.",
      "F": "If replacement revenue versus repair revenue is 75% or more of total revenue, it's a red flag.",
      "G": "Possible reasons and impacts: Lumpy cash flow and high working-capital needs; over-reliance on large infrequent jobs; technician skill gaps in repairs; missed maintenance revenue opportunities; exposure to supply chain disruptions.",
      "H": "Congrats! You're doing great here."
    },
    {
      "A": "Home Services",
      "B": "PLUMBING",
      "C": "Gross Margin",
      "D": "Overall Gross Margin",
      "E": "38 to 52% of overall gross margin of total revenue is normal.",
      "F": "If gross margin is less than 35% of total revenue, it's a red flag.",
      "G": "Possible reasons and impacts: Labor or material leak, which is an immediate OCF killer; inaccurate job costing; supplier price increases; untracked overtime; competitive underbidding pressure.",
      "H": "Congrats! You're doing great here."
    }
  ],
  "prompt_template": "You are an expert PLUMBING business consultant. Evaluate the following user inputs against the PLUMBING Red Flags dataset.\n\nUser Answers:\n{inputs_list}\n\nFor each metric:\n- Compare the user answer to the RED FLAG Trigger (column F).\n- If the trigger condition is met → use text from column G (\"If Red Flag Conditions Are Met\").\n- If the trigger is NOT met → use text from column H (\"If No Red Flag\").\n\nAlways reference:\n• Metric name (column D)\n• Healthy Range (column E)\n• Exact Trigger condition (column F)\n\n{output_format_instruction}"
}