DD-BVA-001
Mizan Manufacturing: The Customer Who Left — Budget, Reforecasts and Actual
Mizan Manufacturing makes household, personal-care, paper and industrial products for about sixty trade customers. You get every sales invoice line from January 2024 to September 2026 with units and prices, the monthly management P&L by account, and eight plan versions - the 2025 and 2026 budgets and March, June and September reforecasts for each year - by month and account. 2025 did not go to plan. Split the revenue gap into volume, price and mix, see what happened to the margin when the volume went and the fixed costs stayed, measure how good each reforecast was, and build the 2026 outlook. The same company appears in the general-ledger set DD-GLT-003.
- Budget vs Actual
- L1 · XLSX
- ~15,124 rows
- 5 tables
- 30 questions
Get the data
v1.0 · 4 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-BVA-001_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-BVA-001_Data_Dictionary.xlsx
- Business Introduction PDF DD-BVA-001_Business_Introduction.pdf
- Raw fact data DD-BVA-001_Budget_vs_Actual.xlsx
Questions
Open one to discuss it- Q001 Easy Revenue for 2025
- Q002 Easy Budgeted revenue for 2025
- Q003 Easy Revenue against budget, 2025
- Q004 Easy Units sold in 2025
- Q005 Easy Largest product line of 2025
- Q006 Easy Customers who bought in 2025
- Q007 Easy Invoices in 2025
- Q008 Easy Average price of household cleaners, 2025
- Q009 Easy Gross margin, 2025 actual
- Q010 Easy Gross margin, 2025 budget
- Q011 Easy EBITDA for 2025
- Q012 Easy Budgeted EBITDA for 2025
- Q013 Easy Plan versions
- Q014 Easy June 2025 reforecast of full-year revenue
- Q015 Easy Largest customer of 2024
- Q016 Easy What that customer bought in 2025
- Q017 Easy Administrative expenses, 2025
- Q018 Easy Revenue, January to September 2026
General discussion
Anything about this dataset that is not one question — loading the files, which tool, how you set it up.
A free account takes a minute. Your draft is kept while you sign in. Need help? Message us