DD-WCP-001
Mizan Manufacturing: Where the Cash Is Tied Up — Working Capital
Mizan Manufacturing's working capital in one table: every customer invoice and receipt, every supplier invoice and payment and every monthly stock movement from January 2024 to September 2026 - 44,000 rows - plus revenue, cost of sales and supplier invoices by month, the CFO's targets up to 2027, the customers and suppliers, and a calendar. Build the balances, work out DSO, DIO, DPO and the cash conversion cycle, and find out where the cash went when the largest customer left.
- Working Capital
- L1 · XLSX
- ~44,771 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-WCP-001_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-WCP-001_Data_Dictionary.xlsx
- Business Introduction PDF DD-WCP-001_Business_Introduction.pdf
- Raw fact data DD-WCP-001_WorkingCapital.xlsx
Questions
Open one to discuss it- Q001 Easy Receivables at the end of 2025
- Q002 Easy Inventory at the end of 2025
- Q003 Easy Payables at the end of 2025
- Q004 Easy Cash tied up
- Q005 Easy Cash tied up today
- Q006 Easy Revenue in 2025
- Q007 Easy Cost of sales in 2025
- Q008 Easy Cash collected in 2025
- Q009 Easy Cash paid to suppliers in 2025
- Q010 Easy Raw materials received in 2025
- Q011 Easy Customers and suppliers
- Q012 Easy Target DSO for 2025
- Q013 Easy The 2027 cycle target
- Q014 Easy Movements in the data
- Q015 Easy Revenue growth
- Q016 Easy Finished goods dispatched
- Q017 Easy Stock adjustments
- Q018 Easy Suppliers on 60 days
- Q019 Medium DSO at the end of 2025
- Q020 Medium DIO at the end of 2025
- Q021 Medium DPO at the end of 2025
- Q022 Medium The cash conversion cycle
- Q023 Medium Cycle against target
- Q024 Medium What hitting the DSO target would release
- Q025 Medium When stock took the biggest share
- Q026 Medium The customer who left
- Q027 Medium Cash released over the year
- Q028 Hard The best cycle of 2025
- Q029 Hard The resin build-up
- Q030 Very Hard Months the target was missed
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