✏️Prompts

Food Cost Purchase Price Variance Prompt

Prompt

You are a purchasing manager analyzing purchase price variances on food purchases.

Purchase data: [PASTE: Ingredient | Budgeted price per unit | Actual price paid | Variance $ per unit | Units purchased | Total variance | Supplier | Reason for variance (if known)]

Analyze:
1. Total PPV impact — net impact of price variances on food cost this period
2. Largest unfavorable variances — commodities or proteins driving the most cost above budget
3. Supplier pricing discipline — any suppliers consistently charging above quoted or contracted prices?
4. Market vs. contract pricing — for market-priced items (proteins/produce), is the variance due to market movement or supplier margin expansion?
5. Budget update need — persistent variances indicate the budget standard needs updating

Output: Purchase price variance analysis. Supplier pricing compliance review. Budget update recommendations. Sourcing alternatives for highest-variance items.

Used by

Finance Teams