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

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro

163

Management Accounting & FP&A

Intermediate

SaaS Rule of 40 Performance Review

Calculates the balance between growth and profitability for technology companies.

GPT-4oClaude 3.5 Sonnet

178

Management Accounting & FP&A

Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet

164