Muhammad Fahad.
ERP · Multi-tenant

Multi-Tenant Dairy Inventory

One web application that runs inventory for a dairy farm and a production plant, giving head office 100 km away real-time visibility that Excel never gave them.

Company
Prema
Role
Sole developer
Period
Jul 2020 – Dec 2022
Team
Built single-handedly

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