Executive summary
Nile Valley Dairy Co. is a well-run mid-sized processor that has grown faster than its internal systems. The plant itself is clean, the product quality is consistent, and the customer base is loyal. The three problems constraining the business today are not production problems — they are information problems. Inventory is tracked on paper at shift change and in a spreadsheet at month end; the gap between those two is where the variance lives. Shift planning is done by one supervisor from memory; when she is on leave the plant runs hot and short at the same time. Pricing and margin review happens annually; in a market where input costs moved fifteen percent in six months, annual is too slow.
Three findings matter more than the rest. We estimate the recoverable cost, if all three are addressed, at roughly EGP 1.1 to 1.6 million per year — before any top-line effect from the improved customer service that follows. The implementation does not require new software purchases, does not require new hires, and does not require a capex cycle. It requires four people to change how they spend roughly an hour each day, and one owner to commit to receiving one operational report per week.
Three key findings
1. Inventory variance is structural, not operational. Monthly stock take shows consistent losses of three to five percent across chilled SKUs. Staff are not stealing. The count system is built to fail: paper slip at shift handover, manual entry at month end, no reconciliation in between. Fix the loop, the variance collapses.
2. Shift planning is a single-person dependency. One supervisor holds the plan in her head. When she is on leave, the plant over-staffs cheese lines and under-staffs bottling. The cost is visible in two places: overtime on bottling weekends and waste on cheese shift ends. A simple shared rota template would remove the dependency without removing her judgment.
3. Pricing review is too slow for current input volatility. Last price review was March 2025. Input costs rose roughly fifteen percent between August 2025 and February 2026. Gross margin on three product lines is now below the floor the owner would set if he were re-pricing today. Quarterly review cycle, not annual, with a one-page trigger list.
Current-state observations
Scale and shape
Forty staff across three shifts (morning 05:00–13:00, afternoon 13:00–21:00, night 21:00–05:00). Roughly twenty-two on the production floor, six in cold store and dispatch, five in administration and finance, four in QA and lab, three in management. Revenue mix (approx.): fresh milk 45%, white cheese 30%, yoghurt and labneh 20%, cream and butter 5%. Distribution through three wholesale routes covering greater Cairo, Giza and three Delta governorates.
What is working
The plant itself is run well. The morning hand-over meeting is disciplined, the cleaning schedule is followed, and the QA function has a clear owner who is trusted by the plant manager. Staff turnover is low by sector standard. The three wholesale customers interviewed as part of this engagement describe the product as reliable and consistent — this is not a cosmetic claim, it is an operational asset.
Inventory tracking
Fresh-in, cold-store, and dispatch are tracked on a paper slip at each shift handover. At month end, the slips are entered into a spreadsheet by the plant office and reconciled against the accounts spreadsheet. Variance of three to five percent is described by the team as "normal shrink". Our read: the reconciliation is happening too late to tell the difference between yield variance (which is cost-of-goods), process loss (which is fixable), and counting error (which is an artefact of the method).
Shift planning
One supervisor, twelve years in the business, writes the weekly rota on Sunday afternoon for the week ahead. She does it from memory — staff preferences, product mix, public-holiday rules, pregnancy and family constraints, skill overlap. When she is on leave the task defaults to the plant manager, who does a competent but conservative job, which is why over-staffing shows up on those weeks.
Pricing
Wholesale pricing list last refreshed March 2025. Input costs (raw milk collection, packaging film, transport diesel) increased an estimated fifteen percent between August 2025 and February 2026. Three product lines — 500g white cheese block, 200g labneh tub, 1L UHT — are now at or below a 20% gross margin. Two of those are featured promotions with one customer; the third is the volume SKU.
Decision-making
The owner is involved in most non-routine decisions. This is not a problem at current scale but will become one. The plant manager has the experience to decide more than he is currently allowed to decide. There is no written delegation of authority. Interviews suggest both men are ready for this change and have not had the conversation.
Prioritised recommendations
Recommendation 1 — Close the inventory loop at shift change
Effort: low. Time: two weeks to pilot, four weeks to standard. Cost: negligible; one shared spreadsheet and twenty minutes of supervisor time per shift. Estimated recovery: EGP 600,000 – 900,000 per year once variance is down to one to two percent.
Replace the paper slip with a shared spreadsheet (on the existing plant laptop, no new software). Supervisor enters closing counts at shift end; the incoming supervisor accepts. Any variance above one percent triggers a note field. The plant manager reviews variance at Monday morning stand-up. This is not a new process — it is the existing process, closed weekly instead of monthly. The reconciliation work the plant office does at month end becomes a check, not the primary count.
Recommendation 2 — Make the rota a shared document
Effort: low. Time: one week. Cost: negligible. Estimated recovery: EGP 300,000 – 450,000 per year in avoided over-staffing and waste.
Keep the supervisor as the owner of the rota. Change the medium. A shared document (spreadsheet, printed wall copy, both) means her judgment is still the input, but the plan does not leave the building with her. A second-line supervisor shadows the rota-building for three weeks and takes it over once a quarter; this is not about replacing the owner, it is about making the business not fragile to one person's leave calendar.
Recommendation 3 — Move pricing to quarterly, with a one-page trigger list
Effort: low. Time: one pricing cycle (90 days). Cost: three hours per quarter of owner and accountant time. Estimated recovery: EGP 200,000 – 280,000 per year on the three SKUs currently sitting below margin floor, assuming half the movement is passed through.
Build a one-page dashboard: raw milk cost per litre, packaging cost per unit, transport cost per route, gross margin per SKU. Owner and accountant review monthly; a formal pricing conversation with each of the three wholesale customers happens quarterly. Where the market will not bear a price move, that is also an answer — but it should be a decision made quarterly, not an absence of a decision.
Ninety-day implementation plan
Week 1
Plant manager and rota supervisor agree the new shift-change inventory spreadsheet format. Pilot on the morning shift only. Pricing dashboard template sketched by owner and accountant. Draft delegation-of-authority list from owner.
Weeks 2–4
Shift-change inventory loop runs on all three shifts. Weekly review at Monday stand-up. Rota shared document launched. Pricing dashboard populated with January and February actuals. First delegation review meeting between owner and plant manager.
Weeks 5–8
Variance numbers expected to tighten; if they do not, root-cause the exception (almost always one specific SKU or line, not the whole plant). Second-line supervisor begins shadowing rota-building. Pricing conversation scheduled with the largest of the three wholesale customers.
Weeks 9–12
Monthly inventory reconciliation becomes a check, not the primary count. Second-line supervisor builds the rota for one week with support. Pricing moves agreed with at least one of the three wholesale customers; formal quarterly pricing cadence scheduled.
Risk register
R1 — Rota supervisor reads the second-line shadow as a replacement move
Likelihood: medium. Impact: high. Mitigation: owner and plant manager frame the change as a leave-cover fix and document it that way; the rota supervisor's pay and title do not change; she is explicitly asked to remain the primary. Review this in week four.
R2 — Wholesale customer resists the price move
Likelihood: medium. Impact: medium. Mitigation: bring the dashboard to the conversation. The three customers are not adversaries; they are businesses that can read a cost-pass-through chart. Where no price move is possible, consider SKU simplification with that customer instead.
R3 — The inventory loop surfaces a loss the owner would rather not name
Likelihood: low. Impact: high if it surfaces. Mitigation: agree up front how variance exceptions are handled; do not start the loop until that agreement exists. In nine out of ten assessments of this shape, nothing dramatic surfaces — variance was structural, not ethical. The tenth matters a great deal when it happens.
R4 — Dashboard becomes a monthly report rather than a decision tool
Likelihood: medium. Impact: medium. Mitigation: attach a specific decision to each field. If the decision is not triggered in a quarter, the field is wrong.
What we did not recommend, and why
New ERP or inventory software. The plant does not have the habit or the data hygiene to benefit from one yet. Build the habit on a spreadsheet first; revisit in twelve months.
Route optimisation for the three wholesale routes. The routes are simple and the volumes are stable. There is less than one percent of distribution cost available here; it is not worth a project.
Expanding the product range. The owner asked the question. Our view: the current four product families are at different margin profiles, and two of them need attention first. Adding a fifth before the existing four are controlled is a distraction.
Next steps
A thirty-minute delivery call is scheduled for 16 March 2026. We will walk through the three recommendations, the ninety-day plan, and answer questions. One round of follow-up questions by email is included through 14 April 2026.
If, after the report lands, you would like help executing any of the recommendations, we offer a monthly follow-up retainer at $500/month. No commitment is asked for today.
End of sample report. This document runs to roughly fifteen printed pages in the PDF deliverable. Real assessments include two to four annotated charts and an appendix with source documents used. Neither is shown on this HTML sample.