Fryer Oil Management & Change-Out Tracker: Fryer oil quality log, change-out record and oil cost per portion
Full description
For kitchen managers, chefs and food and beverage controllers who want to control fryer oil. The workbook holds a register of fryers and a daily log of TPM, temperature, oil condition, skimming, filtering, top-up litres and portions. Each reading gets a flag, from OK and Watch to Discard now. A change-out record shows oil life and disposal receipts. For any period you choose, each fryer shows oil used, oil cost, cost per portion and litres per 100 portions against your usage target, with a status such as Usage over target, Filter gap or Temp drift. The Word pack adds a daily check form, quality limits, filtering and change-out procedures and a weekly review.
What is inside
- Fryer_Oil_Tracker.xlsx: 7 tabs, 1,619 formulas, 2 native charts, 30 drop-down and input rules
- Fryers: a register of 5 sample fryers with 8 register fields, 19 result columns and a status, plus 7 spare rows
- Daily Log: 210 sample readings (21 days, 2 shifts, 5 fryers) with TPM, temperature, oil condition, skimming, filtering, top-up and portions, plus 60 spare rows
- Change-Outs: 15 sample oil changes with reason, litres, collector, receipt and days since the previous change, plus 25 spare rows
- Dashboard: 7 KPI tiles, a check tile, a fryer scorecard, 2 charts and flag and status counts; 11 integrity checks on the Checks tab
- Fryer_Oil_Procedure_and_Forms.docx and PDF: 8 pages with the daily check form, quality limits, filtering and change-out procedures, a change-out record, usage targets and a weekly review
- README.txt and LICENSE-and-Terms.txt
How it works
- Set the period, the TPM watch and limit and the oil prices on Settings.
- Replace the sample fryers with yours and enter a usage target for each.
- Log every shift on Daily Log and every oil change on Change-Outs. Follow the procedures in the Word pack.
- Read the flags and statuses weekly and hold the review.
Details
- Formats: 1 Excel workbook (.xlsx), 1 pack in Word (.docx) and PDF, English
- Software: Excel 2016 or later, or LibreOffice Calc 7 or later
- No macros, no external links, no data tables, no array formulas
- 3 files plus README and license; instant digital download
Good to know
- Sample data is illustrative. Replace it with your own figures.
- The files are management tools, not food safety, safety or legal advice. Set oil limits and disposal steps from your oil supplier, fryer maker and local requirements.
- TPM limits, tolerances and usage targets are editable inputs, not standards.
- Single-user license. Do not redistribute.
FAQ
How many fryers and readings are included?
5 sample fryers, 210 sample readings over 21 days and 15 sample change-outs, with spare rows for your own.
How is oil cost worked out?
Oil used is the new oil at change-outs plus top-up litres in the period. It is priced per litre from the oil types table on Settings. Cost per portion is oil cost divided by portions fried.
What does Discard now mean?
A reading with TPM at or above your limit, or an oil condition of Smoky, Off smell or Foaming. Each Discarded shift must match a change-out, and the Checks tab tests this.
What is TPM?
Total polar material, read with a handheld oil tester. You enter the percentage the tester shows and set your own watch level and limit.
Do I need macros?
No. Every result is a standard worksheet formula.
