DD-BVA-003

Mizan Group: Budgets, Reforecasts and the Drivers Behind Them

Mizan Retail, Mizan Manufacturing and Mizan Logistics, January 2023 to September 2026. The actuals come by day, cost centre and account (Parquet); the plans come from the planning tool as nested JSON - each version and company with its lines by month, cost centre and reporting line; the drivers come as plan (Excel) and actual (CSV): stores open, units by product line, headcount, trips, fuel litres and fuel price. A submission log records every budget owner's submission and revision with a timestamp; the version calendar has the deadlines, lock and approval times. There is no date table, and Logistics plans April to March. Explain why each company missed or beat its plan - late store openings, a lost customer, a new contract at a lower price per trip, a fuel spike - with volume, price, mix and efficiency variances; measure how good each reforecast was; and test the planning process itself.

• Budget vs Actual
• L3 · PARQUET
• ~806,404 rows
• 12 tables
• 50 questions