- Home
- Skills
- Business & Operations
- Agency Project Profitability Auditor
Works with the AI Agents you already use
Agency Project Profitability Auditor
Analyzes project revenue, labor costs, and hours to identify margin leakage and actual agency profitability.
$10
Agency Project Profitability Auditor
Example session with this skill installed
Audit project 'Alpha-Web-Redesign'. Revenue: $50k. Budget: 400 hrs. Actuals: 520 hrs (PM 80, Dev 300, Design 140). Rates: PM $60, Dev $80, Design $70. Expenses: $2k assets. Target margin: 50%.
- Read your context and instructions
- Compiled the agency project profitability
I have completed the profitability audit for Project Alpha-Web-Redesign. The analysis shows significant margin leakage due to a 30% overrun in delivery hours, primarily in the Development and Design phases.
Agency Project Profitability Audit
1. Executive Summary
- Project Identifier: Alpha-Web-Redesign
- Revenue Basis: Recognized Revenue
- Net Project Revenue: $50,000.00
- Total Direct Delivery Cost: $40,600.00
- Gross Project Profit: $9,400.00
- Gross Project Margin: 18.8%
- Data Completeness: High (All roles and expenses provided)
- Main Finding: Project missed the 50% target margin by 31.2 points due to 120 unplanned delivery hours.
3. Hours and Labor Cost Breakdown
| Role | Actual Hours | Budget Hours | Variance | Loaded Rate | Total Cost |
|---|---|---|---|---|---|
| Project Management | 80 | 60 | +20 | $60 | $4,800 |
| Development | 300 | 240 | +60 | $80 | $24,000 |
| Design | 140 | 100 | +40 | $70 | $9,800 |
| Totals | 520 | 400 | +120 | - | $38,600 |
5. Profitability Calculations
- Gross Project Profit: $50,000 (Revenue) - ($38,600 Labor + $2,000 Expenses) = $9,400.
- Effective Revenue Per Delivery Hour: $50,000 / 520 hrs = $96.15/hr.
- Effective Profit Per Delivery Hour: $9,400 / 520 hrs = $18.08/hr.
7. Margin Leakage Investigation
Scope Creep (High Confidence): Dev and Design hours exceeded budget by 25% and 40% respectively, suggesting unmanaged revisions or technical debt.
- PM Overhead (Medium Confidence): 20-hour PM overrun indicates high communication overhead or project delays.
Next steps
- Review the Dev logs to determine if the 60-hour overrun was due to technical complexity or new requirements.
- Update the fixed-fee pricing model for 'Web Redesign' services to reflect a baseline of 500+ hours.
- Implement a 15% contingency buffer on all future Design estimates.
Connects securely to your tools. The creator never sees your data.
About this skill
Agencies often struggle to identify why profitable-looking projects result in low bank balances. This skill audits project-level financial performance to find exactly where margin leakage occurs. It analyzes the gap between estimated and actual delivery costs to help owners fix pricing and scoping.
What it does
- Revenue reconciliation calculates net project revenue by accounting for discounts, credits, refunds, and write-offs.
- Labor cost calculation totals role-specific costs using loaded internal rates and delivery hours.
- Margin analysis computes gross, contribution, and fully loaded profit margins based on agency-defined cost buckets.
- Variance reporting compares quoted vs. actual hours, revenue, and expenses to highlight unfavorable deviations.
- Leakage identification pinpoints scope creep, untracked meetings, excessive revisions, and idle capacity.
How it works
- Data ingestion processes your project ID, revenue, time entries, labor rates, and direct expenses.
- Reconciliation validates the dataset for missing hours, duplicate entries, and inconsistent date ranges.
- Calculation applies standard management accounting formulas to determine profit per delivery hour and gross margin.
- Investigation links margin drops to specific evidence like unbilled support or contractor overruns.
Frameworks & tools
This skill uses management reporting principles for professional services. It works with data exported from time-tracking tools, CRMs, and accounting software.
Why this beats prompting it yourself
Generic prompts often confuse invoiced revenue with recognized revenue or double-count contractor labor. This skill enforces strict accounting definitions and weighted portfolio math to ensure your margins are mathematically sound.
Use cases
- Post-mortem audits to find why a completed fixed-fee project went over budget.
- Portfolio review to compare profitability across different service lines or client accounts.
- Scoping adjustment to refine pricing for future projects based on historical labor costs.
Known limitations
Does not provide audited accounting, tax, or legal advice. Requires manual input of loaded labor rates as it cannot infer employee burden or overhead without user-defined data.
Does not provide tax/legal advice. Requires loaded labor rates to be provided manually. Cannot access live accounting systems directly.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 14 days ago