# Find out which jobs actually make me money A prompt file from MediaMentorAI's Daily AI Move series. Tutorial and live demo: https://mediamentorai.com/ai-tutorials/job-profit-dashboard-with-claude ## How to use this file 1. Export or copy your last 3 months of jobs from your scheduling or invoicing app, or a spreadsheet. For each job you need: the date, the type of job, what you charged, hours on site, hours driving, and materials. 2. Open a new chat in Claude. ChatGPT can follow this file too, but we made the tutorial in Claude. 3. Upload this file, or copy everything from "Instructions for the AI" down and paste it into the chat. Then paste your jobs when it asks. 4. Check the numbers on two or three jobs by hand before you act on them. You don't need to know how to code or write formulas. --- ## Instructions for the AI You are helping a small business owner find out which kinds of jobs actually make them money once materials and their time, including drive time, are counted. The owner is busy and is not technical. Use plain words and keep every message short. ### Step 1: Ask me what you need Ask me these, two or three at a time, and skip anything I've already told you: 1. What does my business do? 2. What is my time worth per hour? (What I pay myself, or what I'd pay someone to do the work.) 3. Do I want to count drive time? (Yes, unless I say otherwise.) 4. Are there costs per job that aren't in my log, like a disposal fee or a helper? Then ask me to paste my job log: one job per line with date, job type, charged, hours on site, drive hours and materials. A header row is fine, and so is a paste straight from a spreadsheet. ### Step 2: Check the data Tell me how many jobs and job types you found. Point out anything that looks off: missing numbers, job types spelled two ways, a job with zero hours. Ask me to confirm before you build. ### Step 3: Build the dashboard Build it as one self-contained web page: - One HTML file with the CSS and JavaScript inside it. No AI, accounts, internet connection or outside services. - My hourly rate in an input I can change, with everything updating as I type. - Take-home per hour for each job type: (charged minus materials) divided by (hours on site plus drive hours). Show it as bars with my hourly rate as a line, green past the line and red short of it. - A table by job type: jobs, average charge, average materials, average hours, take-home per hour, profit per hour above my rate, and total profit. - My five best and five worst individual jobs by take-home per hour. - Plain advice: what to do more of, what to reprice or drop (with the price that would break even at my rate), and where drive time is eating the profit. - A box to paste a new job log later, an "Analyze this log" button and a "Load sample log" button that brings back this log. - Make every button work with a click handler, not a form submit, so it also works inside a chat preview. - Works on a phone, and with a keyboard and a screen reader. Check your math on at least two job types before you show it to me. Show it to me here first. Don't publish it or share it. ### Step 4: Explain it Give me the headline numbers in a few sentences: overall take-home per hour, the best and worst job types, and the one change that would help most. If I ask for changes, update the dashboard and tell me what changed. --- ## Example (the handyman demo) This is the message used in the tutorial. The handyman and all 40 jobs are made up. > I'm a handyman. Below is my job log from the last 3 months. > > Show me which kinds of jobs actually make me money after materials and drive time, if my time is worth $45 an hour. > Build it as a dashboard: profit per hour for each job type, my best and worst jobs, and what I should do more of. > Let me paste a new job log later, with a button that loads this one as a sample. > It has to work without AI or the internet. > Show it to me here first. Don't publish it yet. > > Job log: > Date,Job,Charged,Hours on site,Drive hours,Materials > 2026-08-04,TV mounting,160,1.5,0.5,15 > 2026-08-13,Drywall patch,230,2.25,0.5,24 > 2026-08-20,Small repair,125,0.75,0.8,9 > 2026-08-21,Furniture assembly,120,2.25,0.8,0 > 2026-08-22,Gutter cleaning,205,1.75,0.6,0 > 2026-08-24,Small repair,110,1.0,0.9,11 > 2026-08-25,Small repair,120,1.0,0.6,22 > 2026-08-28,Small repair,140,1.0,0.6,27 > 2026-08-29,Drywall patch,255,2.5,0.6,29 > 2026-09-05,TV mounting,180,1.0,0.5,4 > 2026-09-07,Furniture assembly,100,2.25,0.7,0 > 2026-09-08,Furniture assembly,95,2.5,0.7,0 > 2026-09-09,Deck staining,850,6.75,0.7,150 > 2026-09-11,Small repair,105,1.0,0.6,31 > 2026-09-12,Small repair,100,1.25,0.5,11 > 2026-09-14,Deck staining,870,6.75,0.5,148 > 2026-09-16,Gutter cleaning,175,2.25,0.5,0 > 2026-09-17,Gutter cleaning,175,2.0,0.7,0 > 2026-09-18,Drywall patch,220,2.75,0.7,26 > 2026-09-21,TV mounting,175,1.25,0.5,12 > 2026-09-24,Small repair,135,0.75,0.7,35 > 2026-09-25,Furniture assembly,125,2.0,0.7,0 > 2026-09-29,TV mounting,150,1.25,0.5,14 > 2026-10-01,Small repair,110,1.25,0.9,8 > 2026-10-03,Deck staining,910,7.0,0.6,151 > 2026-10-04,Gutter cleaning,185,2.0,0.4,0 > 2026-10-06,Furniture assembly,95,2.75,0.6,0 > 2026-10-08,Gutter cleaning,180,2.0,0.6,0 > 2026-10-09,Furniture assembly,130,2.5,0.5,0 > 2026-10-10,Small repair,95,1.0,0.6,10 > 2026-10-12,Furniture assembly,130,2.5,0.6,0 > 2026-10-13,Small repair,125,1.0,0.9,29 > 2026-10-16,TV mounting,160,1.5,0.5,4 > 2026-10-17,Drywall patch,200,2.75,0.7,32 > 2026-10-22,Deck staining,890,8.0,0.5,157 > 2026-10-23,Small repair,125,1.0,0.6,10 > 2026-10-24,TV mounting,150,1.25,0.5,6 > 2026-10-26,Drywall patch,260,2.5,0.6,20 > 2026-10-28,Small repair,140,1.25,0.6,5 > 2026-10-29,Small repair,105,1.0,0.9,22 What Claude found: deck staining takes home $94.61 an hour and is the best; furniture assembly takes home $37.24 an hour, the only job type under $45, and lost $166 against that rate (it would need about $137 a job, roughly 21% more, to break even); 41% of small-repair hours are driving. --- Made by MediaMentorAI, which builds AI that takes the busywork off service businesses. https://mediamentorai.com