Intermediate
Standard costing variance dashboard (PPV, labor, overhead)
Creates a variance dashboard structure and investigation playbook for standard costing variances. Useful for plant controllers and operations reviews.
Build a standard costing variance dashboard for {plant_name} for {period}.
Inputs:
- Standard cost file and actuals: {standard_vs_actual}
- PPV data (purchases): {ppv_data}
- Labor hours and rates: {labor_data}
- Overhead absorption rates: {overhead_rates}
- Production volumes: {production_volumes}
Output:
1) Dashboard table: PPV, labor rate/efficiency, OH spending/volume variances.
2) Investigation playbook by variance type (questions, data, owners).
3) Recommended KPI cadence and thresholds.
4) Common root causes and corrective actions.
Keep it ops-friendly and quantified.Related Prompts
Industry-Specific
AdvancedInventory reserve framework: obsolescence, shrink, and markdowns
Designs an inventory reserve approach for obsolescence and markdowns with calculation templates and controls. Useful for retail and manufacturing close and audit support.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
30
Industry-Specific
BeginnerNonprofit: Functional Expense Allocation (990)
Allocates expenses between Program, Management, and Fundraising buckets.
GPT-4oGemini 1.5 Pro
0
0
25
Industry-Specific
AdvancedConstruction WIP schedule: percent complete and billings
Builds a construction Work-in-Progress (WIP) schedule including percent complete, revenue recognized, billings, and under/over billings. Useful for contractors and auditors.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
19