Updated Invalid DateStep 5 of 7
3 findings
ProductionA supervisor layer runs the floor and appears on no chartConfirmed
What we found
The employee master routes eleven people to one manager. Five of them named him. Seven people across the company named a day-to-day manager other than the one the file lists — four of them in Production, and those four land on just two names, neither of which the file lists as anyone's manager.
What it means
Two shifts are run by people who hold no recorded responsibility for anyone. Every instruction that layer gives is unbacked, and every escalation that should stop there is addressed a level too high.
What it's worth
Six of the eleven are in practice managed by someone the chart does not know about. Not costed — nothing in the books prices a reporting line.
What to do
Put the two shift supervisors on the chart with the four people who already work to them, and confirm the rest of the eleven before this quarter's goals reach people.
Records
- StatedEmployee master spreadsheet supplied by the company· Mehta Auto - Employee Master (Jul 2026).xlsx, uploaded 19 Aug 2026· 19 Aug 2026
- StatedEach person's own selection when they confirmed their details· Details confirmed, to 26 Aug 2026· 26 Aug 2026
ConfirmedVinod Shirke2026-08-27
Correct, and it has been that way since the second line started. Put it on the chart.
Anil sees this with the finding.
ProductionCapacity cannot be computed from anything connectedAdded
What we found
The daily production log is registered for its update times only — its contents are never read, because merged cells and formula columns cannot be parsed. No other connected source carries line or machine output. The founder puts utilisation at about 80%.
What it means
The one number that decides whether to buy the next machine has nothing behind it. A new line stands idle while an old one runs overtime, and no connected record can say by how much.
What it's worth
Not costed. Nothing connected carries output, so any rupee here would be invented. The file's format, not the management, is the reason the number does not exist.
What to do
Rebuild the production log as flat rows, one line per row, so next quarter computes utilisation instead of estimating it.
Records
- RecordDaily Production Log (shared drive), registered cadence-only· Daily Production Log.xlsx - merged cells and formula columns; content parsing off· 26 Aug 2026 06:20
- StatedThe founder, in his interview· Interview sittings 19 Aug 2026 - 22 Aug 2026· 22 Aug 2026
AddedVinod Shirke2026-08-27
The merged cells are mine. I built the sheet that way so it prints on one page for the morning meeting. I can keep a flat copy alongside it.
Anil sees this with the finding.
CompanyAnil reads this tooNine reports run the company; four of them can be readNot answered
What we found
Nine reports were described in onboarding. Four sit in a system Corto can read. Three live on individual laptops, one in an unconnected Drive account, and one is no longer produced at all. Separately, two files nobody described are edited every working morning and opened by four people each.
What it means
Weekly decisions rest on files that exist in one person's possession — when that person is away the decision is made without the report, or not made. And the two most-used files in the company were invisible to the question "what reports do you make?", because people do not call their own habits reports.
What it's worth
Five of the nine reports the company runs on cannot be read by anything except the person who makes them.
What to do
Collect the four missing reports into the connected drive this week and register the two files nobody named, so the next quarter computes from them instead of around them.
Records
- StatedWhat each person described about the reports they make· Artifact register, described rows, to 26 Aug 2026· 26 Aug 2026
- RecordThe connected shared drive - file listing and revision history· Drive scan, 26 Aug 2026· 26 Aug 2026 16:05
Anil sees this with the finding.