Set chargeability targets by staff level and test firm profitability

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.