DD-ARC-001
Mizan Manufacturing: Sales Up, Cash Slow — Accounts Receivable & Collections
Mizan Manufacturing sells packaging and industrial supplies to 60 business customers in the UAE and the Gulf on 30 to 90 days' credit. You get every invoice from January 2024 to September 2026 - 16,000 of them - with the open invoices brought forward, every receipt, the customer master with credit limits, the monthly collection targets (including next year's) and a calendar. Age the book, work out DSO, find who is over their limit, measure collections against target and find out why the 90+ bucket keeps growing.
- Accounts Receivable & Collections
- L1 · XLSX
- ~16,150 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-ARC-001_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-ARC-001_Data_Dictionary.xlsx
- Business Introduction PDF DD-ARC-001_Business_Introduction.pdf
- Raw fact data DD-ARC-001_Receivables.xlsx
Questions
Open one to discuss it- Q001 Easy Sales invoiced in 2025
- Q002 Easy Invoices raised in 2025
- Q003 Easy Cash collected in 2025
- Q004 Easy Owed at the end of 2025
- Q005 Easy Owed today
- Q006 Easy Biggest customer of 2025
- Q007 Easy Average invoice value
- Q008 Easy Customers who bought in 2025
- Q009 Easy Sales growth
- Q010 Easy The best sales month of 2025
- Q011 Easy Customers on 90 days
- Q012 Easy Export sales in 2025
- Q013 Easy Receipts that arrived without a reference
- Q014 Easy Collection target for 2025
- Q015 Easy Next year's collection target
- Q016 Easy Invoices brought forward
- Q017 Easy The largest invoice of 2025
- Q018 Easy How much rides on the key accounts
- Q019 Medium Overdue at the end of 2025
- Q020 Medium How much of the book is overdue
- Q021 Medium The 90+ bucket
- Q022 Medium DSO at the end of 2025
- Q023 Medium Collections against target
- Q024 Medium Customer concentration
- Q025 Medium Days to get paid
- Q026 Medium Paid a month late
- Q027 Medium The customer who left
- Q028 Hard Over the credit limit
- Q029 Hard The best DSO month of 2025
- Q030 Very Hard The worst month-end for overdue debt
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