Intermediate

Customer/product profitability model with contribution margins

Builds a profitability view by customer or product including allocations where appropriate and a transparency note. Useful for commercial strategy and pruning unprofitable segments.

Build a customer/product profitability model for {period}.

Inputs:
- Revenue by customer/product: {revenue_detail}
- Direct costs (COGS, delivery): {direct_costs}
- Variable Opex linked to revenue (commissions, payment fees): {variable_opex}
- Allocation pools (optional): {allocation_pools}
- Profitability questions to answer: {questions}

Output:
1) Profitability table: Revenue, Direct cost, Contribution margin, Allocated costs, Operating margin.
2) Top/bottom segments and drivers.
3) Allocation transparency: what was allocated and why (avoid false precision).
4) Actions: pricing, terms, service model, cost reduction.

Include caveats and data quality notes.

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