Millers POS profit — user wise

Weight/pack is the product's real pack size — read from the product name, or from its Odoo variant ("100ml", "500ml"...) when the name has none; "set Pack (L) →" means neither was found and the Pack (L) figure is an unverified guess, so check it. Cost/unit = raw material ₹/kg (avg of last 5 Techultra bills) ÷ output % × oil density (kg/L) × pack size (L) + packing ₹. Enter the output % you get from the raw material (e.g. 55 for 55% oil from coconut chips) — everything blue is editable, and untick "Mfg?" to use the Techultra billed cost instead. Remember to save.

Cost/unit defaults to the average of the last 5 Techultra billed prices on/before the end date (size-adjusted where Techultra bills per kg). Type in the box to correct a cost or fill a red "manual" product, then save. Amber "review" = per-kg rate assumed on a product with no pack size in its name. "Download Excel (filtered)" exports exactly the dates, POS user, and search text set above — Summary, Detail, and an Oil manufacturing sheet when oils are in view — not the whole database.