Advanced
COGS variance: purchase price vs usage vs mix
Breaks COGS variance into purchase price, usage/efficiency, and mix components. Useful for manufacturing/retail and product businesses.
Decompose COGS variance for {period}.
Inputs:
- Actual vs standard costs: {actual_vs_standard_costs}
- Production/volume data: {production_volume}
- Material usage and scrap: {usage_scrap}
- Product mix and sales volumes: {product_mix}
- Inventory changes: {inventory_changes}
Output:
1) Variance decomposition table (PPV, UV, Mix, Yield/Scrap, Other).
2) Key drivers and operational interpretation.
3) Recommended actions and questions for ops/procurement.
4) Suggested KPI tracking to prevent recurrence.
Be explicit about formulas and data requirements.Related Prompts
Management Accounting & FP&A
AdvancedUnit economics for subscription/business model (CAC, LTV, payback)
Creates a unit economics model with CAC, LTV, gross margin, and payback, including sensitivity analysis. Useful for growth planning and investor discussions.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
16
Management Accounting & FP&A
BeginnerMetric definition library (single source of truth) template
Creates a standardized metric dictionary to prevent KPI drift across teams. Useful for scaling reporting and ensuring consistent definitions.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
17
Management Accounting & FP&A
BeginnerBudget 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
34