Project Profitability Tracker.

Build a project profitability tracker for Keel & Gray, a 20-person strategy consultancy in Seattle, for the managing partner who rebuilds this analysis in a spreadsheet every quarter. Layout. Two tabs. The Overview tab leads with four stat cards: fees billed over the last 12 months (about $1.9 million), blended margin (34 percent), average effective hourly rate ($164), and engagements below target margin (4). Under them, a horizontal bar chart ranks all 15 engagements by margin percent, best at top, with the 40 percent target marked as a reference line, and beside it a bar chart compares average effective hourly rate across the three billing types: fixed fee, retainer, hourly. The Register tab is a sortable table, one row per engagement: engagement name, client, billing type badge, fees billed, hours worked, direct costs, margin dollars, margin percent, effective hourly rate, and variance against target margin, sorted by margin percent ascending so the losers surface first. Clicking a row opens a side panel that breaks the engagement down, showing fees, delivery cost, contractor costs, and the resulting margin as simple labeled bars, plus an edit button. An Add Engagement button opens a dialog capturing client, engagement name, billing type, fees billed, hours, contractor costs, and target margin. Data. Seed 15 engagements across 11 named clients over the last 12 months: six fixed fee, five hourly, four retainer, with fees from $18,000 to $420,000, logged hours, contractor costs, and target margins around 40 percent. Delivery cost is hours times an internal loaded rate of $85. Plant the story: the flagship account, a $420,000 fixed fee transformation for Meridian Bank, earns only 12 percent margin at a $96 effective rate, while a modest $45,000 hourly engagement for Copperline Freight earns 58 percent at $210 per hour; on average, hourly work beats fixed fee across the whole book. Behavior. Margin dollars and percent, effective hourly rate, and variance are computed; users enter fees, hours, costs, and targets. Variance colors: green at or above target, amber within 10 points below, red more than 10 points below. The tool must present a complete year of analysis from the seeded engagements alone. Style. Use a copper brown accent for primary actions, ranking bars, and chart emphasis, on a warm paper-white base with the feel of a well-set financial report.