About us
We did not invent this. We took it apart.
BoxVyapar began as a Google Sheet that genuinely ran a corrugation plant — thirty tabs, three forms, and about fifteen hundred lines of script holding it together. It worked. It also carried a handful of arithmetic errors that quietly cost the factory money.
What we did before writing any code
We recomputed every formula in that spreadsheet against its own data, to the last decimal. Not to admire it — to find out which numbers the floor could keep trusting and which ones had been wrong for years.
Some details only make sense once you have done that. Sheet area is divided by 1550, because that is the constant the paper trade works to and the one the factory’s own records assume. GSM is stored as kilograms per square metre. Sheets-per-box is divided at stitching, which is the single place sheets become boxes. Get any of those backwards and every weight in the system is quietly wrong.
Four of the nine things we found
Paper requirement doubled
Whenever a box used less than a full sheet, the liner requirement was multiplied by the box count instead of the sheet count. One order asked for 1,335 kg against a true 668 kg.
Two answers to one question
“Has the paper arrived?” was answered from the inward challan on one tab and the allocation ledger on another. The same order read as fully received and short by 37 kg at the same time.
Liner never purchased against
Semi and craft were split from the flute weight alone, so the liner layer was planned for but never bought. We include it, with a switch to reproduce the old figures during migration.
Finished orders reported as late
The tracker and the TAT watch were separately maintained copies, so a dispatched order still showed as stuck in material planning. Both are now queries over one table.
What we believe about factory software
- A number should be derived, not stored. Stock is the sum of its movements. A balance is the sum of its payments. Nothing that can be recomputed is kept in a second place where it can disagree with the first.
- Measure, do not assume. Wastage was a percentage somebody typed once. We weigh the board after pasting and the box after stitching, and the difference is the answer.
- Nothing vanishes. Supervisors run the floor and the billing, but only the owner deletes. Everything else becomes a request, and every change carries a name and a time.
- Accounting stays where it is. We are not trying to replace your accountant. We track what the factory makes, what it consumes and what it wastes.