# Set chargeability targets by staff level and test firm profitability

A model linking chargeable hours, billing rates, leverage, and salaries by level to show whether a professional services firm makes its target margin.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Advanced
- Tags: Finance, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/set-chargeability-targets-by-staff-level-and-test-firm-profitability

## Prompt

```text
Help me set chargeability targets by staff level and test whether my professional services firm can hit its profit goal.

**Firm type:** [accounting / consulting / architecture / engineering]
**Staff by level:** [e.g. "partners 3, managers 5, seniors 8, staff 10, admin 4" - with average salary and benefits load per level]
**Standard hours per year:** [e.g. "2,080"]
**Paid time off and holidays per person:** [HOURS]
**Current chargeability by level:** [PASTE, if known]
**Billing rates by level:** [AMOUNTS]
**Realization (collected / standard value):** [e.g. "88%", or by level]
**Overhead excluding salaries:** [rent, software, insurance, marketing - annual total]
**Target net margin or profit per partner:** [GOAL]

Build:
1. A table by level: available hours, target chargeable hours, chargeability %, standard value, expected collections after realization, and cost.
2. Firm-level results: net revenue, total cost, profit, margin, profit per partner, and revenue per full-time equivalent.
3. Leverage analysis: non-partner staff per partner, and how changing the pyramid shifts profit.
4. A sensitivity table: profit if chargeability moves +/-5 points by level, if realization moves +/-5 points, and if rates rise 3-5%.
5. Recommended targets by level that are achievable - lower for partners and managers who sell and supervise, higher for staff - with the reasoning, and a check that the targets add up to the profit goal.
6. Risks of pushing chargeability too high: burnout, turnover, no time for training or business development.

Use only my figures; mark gaps [NEED DATA] and show all formulas so I can rebuild this in a spreadsheet.
```

## What to fill in

- accounting / consulting / architecture / engineering
- e.g. "2,080"
- HOURS
- PASTE, if known
- AMOUNTS
- e.g. "88%", or by level
- rent, software, insurance, marketing - annual total
- GOAL
- NEED DATA

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.