Intermediate

Service line costing: utilization, billable rates, margins

Builds a service line costing model using utilization and blended rates to compute margins. Useful for professional services and agency businesses.

Build a service line costing model for {service_business_name}.

Inputs:
- Roles and billable rates: {roles_rates}
- Utilization assumptions: {utilization}
- Delivery vs SG&A costs: {cost_structure}
- Project mix and hours: {project_mix_hours}
- Period: {period}

Output:
1) Costing model formulas: revenue, labor cost, gross margin by service line.
2) Utilization sensitivity (±{util_sensitivity}%).
3) Recommended KPIs (billable %, realization, contribution margin).
4) Commentary template for leadership.

Keep it implementable in a spreadsheet.

Related Prompts

Management Accounting & FP&A
Intermediate

Driver-based budget model template (revenue, headcount, opex)

Creates a driver-based budgeting framework and templates that link revenue drivers, headcount, and operating expenses. Useful for FP&A teams building a scalable budget process.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Management Accounting & FP&A
Intermediate

Rolling forecast update: variance bridge to new forecast

Updates a rolling forecast by bridging from prior forecast to actuals and new assumptions. Produces a clear bridge and narrative for leadership.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Management Accounting & FP&A
Beginner

Budget kickoff pack: timeline, owners, templates, instructions

Generates a budget kickoff pack with roles, deadlines, template instructions, and FAQs. Useful for FP&A leaders coordinating cross-functional budgeting.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2