Guided product tour · Stop 7 of 27 ← Procurement mobile appProcurement screens →
Reports · Procurement BI

Milk Procurement BI Report

Procurement BI shows routes, societies, chilling centres and zones by volume, quality, rate variation and efficiency, on web and mobile, with trend-change reports and daily mails.

Volume and quality trendsCompare any two datesDaily procurement mails
Milk Procurement BI Report
Two-date comparisonPlant, route, shift, vendor type, centre
Every morningDaily Procurement and Activity Report
Daily mailsTrend changes; CC purchase vs dispatch vs acknowledgement
Web and mobileSame figures everywhere

Milk Procurement BI turns the day’s procurement data into the decisions of the next morning. The dashboard covers routes, societies, chilling centres and zones by volume, quality, rate variation, efficiency and farmer insights. Two reports carry most of the weight: the Procurement Trend Change Report and the Daily Procurement and Activity Report. Both are explained below with their real screens (company and route names blurred).

On this page
How it works

How it worksFrom the day’s data to the morning’s decisions

Procurement intelligence, delivered
Procurement intelligence, delivered

When the day closes, the centre, chilling centre and plant data are in the ERP. The BI layer compares them against another day or range, mails the result to the people who act on it, and puts the same figures on the phone for drill-down.

The mails go to the people who act on them, so the procurement head, the plant managers and the route supervisors start the morning from the same figures, and drill down on the app when they need detail.

Functions on this topic
  • Daily procurement mails: Procurement trend changes; CC purchase vs CC dispatch vs dairy acknowledgement

How it worksThe Milk Procurement BI dashboard

The BI dashboard analyses routes, societies, chilling centres and zones on volume, quality, rate variation, efficiency and farmer insights. A BI chart compares two date ranges, and the purchase volume trend and the quality-based live report show the shape of the season.

Dashboards on the web match the ones on the app: plant versus centre difference, the last 7 days’ trend, and the comparisons described below.

Who uses it
Procurement headMDPlant managers
Functions on this topic
  • Milk Procurement BI dashboard: Routes, societies, CCs, zones; volume, quality, rate variation, efficiency, farmer insights; BI chart comparing two date ranges
  • Purchase volume trend; quality-based live report: Presentation image
  • Procurement Dashboards 1, 2 and 3: Overview; volume and quality trends; day vs range
  • Last 7 Days Trend
Plant vs centre difference dashboard
Plant vs centre difference dashboard
Last 7 days trend
Last 7 days trend
Reports

ReportsProcurement Trend Change Report

The Procurement Trend Change Report compares any two days of milk procurement and shows exactly where volume rose or fell: by plant, route, shift, vendor type and centre, with a 30-day trend behind every line. It is sent daily by email and is available on the web.

Inside: total procurement for the day against the comparison day; a plant-wise comparison with a 30-day sparkline per plant; the last-30-days chart with running average and day-over-day change; the last 10 days; started and stopped vendors and centres; route-wise comparison for the full day and each shift; a GPS trend map of centres; centre and vendor coverage; and per-plant detail by date, vendor type and route.

It answers which routes and centres to visit today, whether a fall is one shift, one route or the whole plant, which vendors stopped pouring, and which vendor types are growing.

Who uses it
Procurement headPlant managersRoute supervisorsMD
The benefit

Falls in volume are traced to a plant, route, shift or vendor the next morning.

Functions on this topic
  • Procurement Trend Change Report: plant-wise, date-wise, route-wise and vendor-type-wise comparison of any two dates
  • Trend reports (season / milk movement)
  • Procurement and market trend analysis on mobile
Plant-wise comparison and the 30-day volume chart
Plant-wise comparison and the 30-day volume chart
Route-wise comparison with 30-day trends
Route-wise comparison with 30-day trends
Vendor-type-wise change
Vendor-type-wise change
Centre and vendor coverage by plant
Centre and vendor coverage by plant

ReportsDaily Procurement and Activity Report

Every morning, for the previous day, one report covers the whole procurement day: litres, farmers and centres against the day before; re-pour checks on every milk test; centre-versus-plant differences; route kilometres; and what the field staff actually did.

Re-pour impact catches a farmer’s milk tested and saved again within 10 minutes at the same centre, comparing the first reading with the paid reading. Possible issues flag centre litres against plant litres by shift and route, and milk received at the plant with no centre record. Maps show each plant, route overlaps and field staff GPS paths; routes are compared with their approved kilometres; and field activity is listed by person, with the staff who did not report. The whole report downloads to Excel in one click.

Who uses it
Procurement headQuality and audit teamTransport in-chargeField supervisors
The benefit

Audits, route changes and field follow-ups start from facts the morning after.

Functions on this topic
  • Pilferage control, automatic daily MIS and advanced analytics on procurement
Daily tiles and the re-pour impact table
Daily tiles and the re-pour impact table
Possible issues: centre litres against plant litres
Possible issues: centre litres against plant litres
Routes against approved kilometres
Routes against approved kilometres

ReportsDifference, receipt, cost and comparison reports

On the web, the BI set includes AMCC versus chilling centre difference (date-wise and with amount) and the AMCC versus CC dashboard; CC receipts with landing TSR and day-wise CC receipt with amount; the day and shift-wise consolidated report; AMCC cost analysis; centre and plant invoice analysis; last-two-bill and three-date-wise comparisons; plant-in vendor comparison; and the route-wise average statement. Each is shown on Procurement Screens.

These reports are the detail behind the BI headlines: when the trend report shows a fall or a difference, these screens show which centre, which date and what amount.

Who uses it
Procurement headAccountsCFO
Functions on this topic
  • AMCC vs CC dashboard; AMCU vs CC TS matching
  • Plant vs Center Difference dashboard
  • AMCC vs Chilling Center Difference (date-wise; with amount)
  • CC Receipts Landing TSR; Day-wise CC Receipt with Amount
  • Day & Shift-wise Consolidated Report
  • AMCC Cost Analysis
  • Center and Plant Invoice Analysis
  • Last Two Bill Comparison; Three Date-wise Comparison
  • Plant-In Vendor Comparison
  • Route-wise Average Statement
AMCC vs chilling centre difference with amount
AMCC vs chilling centre difference with amount
Route-wise average statement
Route-wise average statement
Mobile

MobileThe same intelligence on the phone

Milk procurement monitoring and profiling is on the EasyDairyERP app: live chilling-centre trends compared day versus range or range versus range, centre data arrival, centre GPS with volume trend, farmer supply history, vendor segmentation, TS matching, pouring time, plant comparison, the quality-volume matrix, the HQM and LQM finders and volume analysis. See Procurement Mobile Application for each screen.

The phone screens and the BI reports draw on the same data, so a figure quoted from the app in a review meeting matches the figure in the morning mail.

Who uses it
Procurement headField team
Functions on this topic
  • Milk procurement monitoring and profiling in mobile app: Procurement Head deliverable
  • Live CC-wise trends; day vs range; range vs range
  • Centre data arrival monitoring / Center Data Availability
  • Centre GPS location with volume trend
  • Farmer milk supply history with trends
  • Vendor segmentation (CC / plant, route, vendor type); Vendor Type Wise Dashboard
  • TS matching on phone; centre-to-CC TS matching view
  • Milk Pouring Time
  • Plant-wise comparison
  • Quality Volume Dashboard / Quality Volume Report: By fat and SNF range
  • High / low quality milk (HQM / LQM): Plant-wise High Quality Milk Finder; LQM / HQM differentiation; quality-wise segmentation
  • Procurement Volume Analysis: By plant and route
  • Center Volume Report / Analysis
Quality-volume matrix
Quality-volume matrix
High-quality milk finder
High-quality milk finder
In depth

Every functionEvery function, with a picture

All 46 functions of Milk Procurement BI, one card each. Orange cards are key features.

Milk procurement monitoring and profiling in mobile app

Milk procurement monitoring and profiling in mobile app

Procurement Head deliverable.

Live CC-wise trends; day vs range; range vs range

Live CC-wise trends; day vs range; range vs range

Chilling centre trends on the phone, comparing a day or a period with another.

Centre data arrival monitoring / Center Data Availability

Centre data arrival monitoring / Center Data Availability

See which centres have sent their shift data and which have not.

Centre GPS location with volume trend
Key feature

Centre GPS location with volume trend

Every centre on a map with its volume trend.

Farmer milk supply history with trends

Farmer milk supply history with trends

Each farmer's supply history, with the trend over time.

Vendor segmentation (CC / plant, route, vendor type); Vendor Type Wise Dashboard

Vendor segmentation (CC / plant, route, vendor type); Vendor Type Wise Dashboard

Vendors grouped by chilling centre, plant, route and vendor type.

TS matching on phone; centre-to-CC TS matching view

TS matching on phone; centre-to-CC TS matching view

Total solids from the centre matched against the chilling centre, on the phone.

Procurement Dashboards 1, 2 and 3

Procurement Dashboards 1, 2 and 3

Overview; volume and quality trends; day vs range.

Milk Pouring Time

Milk Pouring Time

When milk was poured at each centre, shift by shift.

Plant-wise comparison

Plant-wise comparison

Plants side by side on volume and quality.

Quality Volume Dashboard / Quality Volume Report

Quality Volume Dashboard / Quality Volume Report

By fat and SNF range.

High / low quality milk (HQM / LQM)

High / low quality milk (HQM / LQM)

Plant-wise High Quality Milk Finder; LQM / HQM differentiation; quality-wise segmentation.

Procurement Volume Analysis

Procurement Volume Analysis

By plant and route.

Center Volume Report / Analysis

Center Volume Report / Analysis

Volume per centre over time, with rising and falling centres.

Milk Procurement BI dashboard
Key feature

Milk Procurement BI dashboard

Routes, societies, CCs, zones; volume, quality, rate variation, efficiency, farmer insights; BI chart comparing two date ranges.

Procurement Trend Change Report (PDF)

Procurement Trend Change Report (PDF)

Plant-wise, date-wise, route-wise, vendor-type-wise comparison of two dates.

AMCC vs CC dashboard; AMCU vs CC TS matching

AMCC vs CC dashboard; AMCU vs CC TS matching

Village readings matched against chilling centre readings for each shift.

Plant vs Center Difference dashboard

Plant vs Center Difference dashboard

Differences between what centres sent and what the plant received.

Last 7 Days Trend

Last 7 Days Trend

The last seven days of volume and quality at a glance.

AMCC vs Chilling Center Difference (date-wise; with amount)

AMCC vs Chilling Center Difference (date-wise; with amount)

Date-wise differences between village and chilling centre data.

CC Receipts Landing TSR; Day-wise CC Receipt with Amount

CC Receipts Landing TSR; Day-wise CC Receipt with Amount

Chilling centre receipts with landing TSR, day by day.

Day & Shift-wise Consolidated Report

Day & Shift-wise Consolidated Report

All collection for a day and shift in one consolidated report.

AMCC Cost Analysis

AMCC Cost Analysis

Cost of milk collected through each village centre.

Center and Plant Invoice Analysis

Center and Plant Invoice Analysis

Invoices analysed by centre and by plant.

Last Two Bill Comparison; Three Date-wise Comparison

Last Two Bill Comparison; Three Date-wise Comparison

Compare the last two bills, or any three dates, side by side.

Plant-In Vendor Comparison

Plant-In Vendor Comparison

Vendors compared on what they delivered at the plant.

Route-wise Average Statement

Route-wise Average Statement

Average volume and quality for each route.

Trend reports (season / milk movement)

Trend reports (season / milk movement)

Seasonal trends and milk movement over time.

Daily procurement mails
Key feature

Daily procurement mails

Procurement trend changes; CC purchase vs CC dispatch vs dairy acknowledgement.

Automatic pilferage control and mitigation; automatic daily MIS; advanced analytics

Automatic pilferage control and mitigation; automatic daily MIS; advanced analytics

Headline claims.

Purchase volume trend; quality-based live report

Purchase volume trend; quality-based live report

Presentation image.

Bulk arrivals; QC test and production acceptance

Bulk arrivals; QC test and production acceptance

Bulk milk arrivals are tested by QC and accepted into production.

Plant In & Out integration with weighbridge

Plant In & Out integration with weighbridge

Vehicle in and out weights come straight from the weighbridge.

Weighbridge integration and Weigh Bridge Desk (Windows)

Weighbridge integration and Weigh Bridge Desk (Windows)

Automated intake at the factory via weighbridge software for Windows; Weigh Bridge module in plans.

Weighbridge Reports 01 and 02

Weighbridge Reports 01 and 02

Weighbridge reports for every vehicle and material.

Material balance cross-check with weighbridge

Material balance cross-check with weighbridge

Material balance is checked against weighbridge weights.

Weighbridge image storage proofs for all materials

Weighbridge image storage proofs for all materials

Images from the weighbridge are stored as proof for each weighment.

TS matching: purchase vs despatch vs acknowledgement

TS matching: purchase vs despatch vs acknowledgement

Identifies TS loss.

Production day-close TS report by email; TS mail automation

Production day-close TS report by email; TS mail automation

A total solids report goes out by email when the production day closes.

Village-to-plant daily milk solids matching

Village-to-plant daily milk solids matching

Milk solids are matched every day from the village to the plant.

Across-plant daily solids matching; plant-level TS MIS with multiple plant control

Across-plant daily solids matching; plant-level TS MIS with multiple plant control

Solids matched across plants, with a TS MIS for each plant.

Procurement-to-sales TS matching

Procurement-to-sales TS matching

Solids followed from procurement through to sales.

MIS & PAN Operations TS matching

MIS & PAN Operations TS matching

MIS operations report; MIS kg TS across procurement, production and dispatch.

Day-wise TS Matching Report

Day-wise TS Matching Report

Total solids matching, day by day.

TS Matching Reports 1 and 2; TS MIS Report

TS Matching Reports 1 and 2; TS MIS Report

Fat, SNF and TS across stages.

Milk total solids management; configurable TS calculations

Milk total solids management; configurable TS calculations

Total solids worked out with calculations you can configure.

New in October 2026What's new

Part of the monthly updates, at no extra cost. See New Features for the full list.

Plausible Malpractice Report

Plausible Malpractice Report

Flags a test that was not kept when, within 10 minutes, the same farmer was saved with a better FAT or SNF before any other farmer was tested. It shows each centre's share, repeat farmers and the estimated excess paid per centre and farmer. A real re-test can look the same. The report shows which centres to check and does not accuse anyone.

Daily Procurement & Activity Report

Daily Procurement & Activity Report

One mail before 6 am with yesterday's collection compared with the day before. KPI tiles cover litres, farmers, centres, re-pour events, net re-pour impact, routes run, routes over approved km and field staff reported. An attached page has detail, an Excel download and live maps.

Procurement Activity Report (map)

Procurement Activity Report (map)

Procurement officers, AMCU service engineers and field staff on one map, with routes, GPS beats, numbered activity pins, tasks and punch-in/out. Layers can be toggled. Per-person cards show claimed km vs road km, GPS beats, longest silence, activities and open tasks. Activities are linked to the centre, plant, route and GPS location. There is a plant-wise view.

Procurement Weekly Update and Monthly Review

Procurement Weekly Update and Monthly Review

Landed cost of milk per plant = (milk value + centre service charges + cost additions/deductions + inward transport) ÷ litres purchased. They also show FAT, SNF and TS trends, plus TSR and "TSR by TS". One all-plant mail goes out, plus a mail to each plant head.

Shift-wise trend mails

Shift-wise trend mails

After every shift, each plant gets a mail with charts embedded, centre- and plant-wise coverage, and started/stopped centres flagged. No mail is sent when there is no volume.

Route-level view in the morning mail

Route-level view in the morning mail

Largest routes by litres, GPS-linked pourings, road km today and yesterday, approved km and the difference.

Daily Sales & Activity Report

Daily Sales & Activity Report

Sent after the daily sales mail. For each route it shows litres, value and day-on-day change, the vehicle salesperson from the delivery challan and the hierarchy above (SO, ASO, ASM, RSM, ZSM, MM, SH). It also shows new accounts with first-day litres and value, customers not mapped to the hierarchy, and route trips (gate-out/gate-in km).

Claimed km vs GPS km (field-force GPS)

Claimed km vs GPS km (field-force GPS)

Continuous tracking from punch-in to punch-out for procurement officers, AMCU service engineers and sales officers. It compares claimed km (bike allowance or odometer), road km (routed on the map server) and GPS km (the phone's own beats), and highlights claims above road km in red. Mocked GPS is marked.

Pouch Management System / pouch TS control

Pouch Management System / pouch TS control

Pouch count from each packing machine per variant and shift (needs an extra hardware counter). Sample pouches are weighed at the filler on a connected scale, showing the average excess over target. Leakage and flush milk are recorded per run. Daily TS matching runs across procurement → plant → packing → dispatch → customer acknowledgement, showing the stage where solids are lost.

Guided demoSee it in the demo tour

The demo tour walks through these functions in the order the milk moves, with a picture and a link to the Docs for each.

SpecificationsAt a glance

Dashboard dimensionsRoutes, societies, chilling centres, zones
MeasuresVolume, quality, rate variation, efficiency, farmer insights
Trend Change ReportDaily, by email and on the web; two-date comparison by plant, route, shift, vendor type and centre
Daily Procurement and Activity ReportEvery morning; re-pour impact, possible issues, maps, routes vs approved km, field activity; Excel download
MailsDaily procurement trend changes; CC purchase vs CC dispatch vs dairy acknowledgement
WhereWeb and the EasyDairyERP app

FAQFrequently asked questions

When does the Daily Procurement and Activity Report arrive?

Every morning, for the previous day.

What is a re-pour?

A farmer’s milk tested and saved again within 10 minutes at the same centre. The report compares the first reading with the paid reading, centre by centre.

Can I compare any two days?

Yes. The Procurement Trend Change Report compares any two days by plant, route, shift, vendor type and centre.

Who receives the mails?

The people your dairy chooses: typically the procurement head, plant managers, route supervisors and the MD.

Are the screenshots real?

Yes, from a working dairy, with company and route names blurred.

Report highlight · Procurement

Procurement Trend Change Report

Compares any two days of milk procurement and shows exactly where volume rose or fell: by plant, route, shift, vendor type and centre, with a 30-day trend behind every line.

  • Which routes and centres to visit today, because their volume dropped
  • Whether a fall is one shift, one route or the whole plant
  • Which vendors and centres stopped pouring and need a call

See the full report →

Procurement Trend Change Report

Keep exploring at your own pace

Every module page walks through the screens, reports and mobile apps in the same way, so you can see exactly how EasyDairyERP fits your dairy.

When you have seen enough, we are happy to show it to you live on our sample data: book a demo or call +91 94880 59495.

Next stop on the tour (8 of 27)Procurement ScreensContinue the tour →