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

Intermediate

Retail gross margin bridge: markdowns, mix, shrink, freight

Builds a gross margin bridge explaining changes driven by markdowns, mix, shrink, and freight. Useful for merchandising and finance alignment.

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

173

Industry-Specific

Intermediate

Loan accounting: nonaccrual, troubled debt, and interest income checks

Builds a checklist and analytics for loan nonaccrual status, modifications, and interest income recognition. Useful for bank controllers and auditors.

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

127

Industry-Specific

Advanced

Inventory 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

229