DD-PRJ-001
Mizan Retail: Stores on Time, on Budget? — Project Management & Project Accounting
Mizan Retail opened six stores and refurbished 11 more between 2023 and 2026, and rolled out a new ERP. You get every project and task with its baseline dates and budget, every invoice the projects paid (the same lines as in the ledger set DD-GLT-003), and every timesheet line of the project team - 52,000 of them. Work out which projects overran and why, how late the stores opened, what the ERP really cost, who is booking hours they should not, and what the portfolio is telling the CFO.
- Project Management & Project Accounting
- L1 · XLSX
- ~52,283 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-PRJ-001_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-PRJ-001_Data_Dictionary.xlsx
- Business Introduction PDF DD-PRJ-001_Business_Introduction.pdf
- Raw fact data DD-PRJ-001_Project_Management.xlsx
Questions
Open one to discuss it- Q001 Easy Projects in the portfolio
- Q002 Easy Baseline budget of the portfolio
- Q003 Easy External cost of the portfolio
- Q004 Easy Fit-out cost of the new stores
- Q005 Easy The dearest fit-out
- Q006 Easy Hours booked in 2025
- Q007 Easy Project hours in 2025
- Q008 Easy People on the project team
- Q009 Easy Labour cost of the ERP rollout
- Q010 Easy External cost of the ERP rollout
- Q011 Easy The ERP budget
- Q012 Easy Closed projects
- Q013 Easy Tasks finished late
- Q014 Easy How late did store S040 open
- Q015 Easy Pre-opening costs of the new stores
- Q016 Easy Invoices in FactCost
- Q017 Easy The largest shopfitter
- Q018 Easy Timesheet lines still unapproved
- Q019 Medium Cost of the hypermarket fit-out
- Q020 Medium Overrun of the hypermarket fit-out
- Q021 Medium The worst overrun in the portfolio
- Q022 Medium Projects under budget
- Q023 Medium Project utilisation, 2025
- Q024 Medium The busiest project month
- Q025 Medium Average slip of late tasks
- Q026 Medium Days of more than 12 hours
- Q027 Medium Who books those days
- Q028 Hard Hours booked after the project closed
- Q029 Hard Cost performance of the ERP rollout
- Q030 Very Hard Schedule performance at the planned go-live
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