The challenge
The farm and the plant kept their stock in Excel, and head office was 100 km away. Head office could not see clearly what was happening at the sites, or the real cost of a litre of milk.
What I built
- Multi-tenancy on one shared SQL Server database: the user picks Farm or Plant at login, and each site sees only its own data, while head office sees both.
- Complete inventory flow: Inward Gate Pass → GRN → Store Issuance Requisition → Store Issuance → Outward Gate Pass.
- Farm reports: daily milk production, milking and non-milking cow counts, cost per litre.
- Plant reports, including packing material loss.
Technical highlights
- Cost per litre and packing material loss were the hardest reports: both combine inventory consumption with production data to reach an accurate per-unit cost.
- Crystal Reports for printable, management-ready output.
Results
2sites on one application
100 kmbetween head office and the sites
Real timeinstead of Excel sheets