The visiting head of the technical function only needed to look at the most recently plotted point on the chart (relative to preceding ones) for a Key Performance Indicator like. Cost per Hectolitres brewed(One Hectolitre = 100 Litres), to know if the brewery had stayed within the approved upper limit of spend(plotted as a straight line target across the same period) or not. Discussions would then take place based on identified "Exceptions"(which could be "good" e.g. savings made or "bad" e.g. monetary loss due to materials over_used), and "Actions To Be Taken" to correct or maintain observed performances agreed upon.
Spreadsheet Tracking As A Crucial Element For Business Development. There are ways you can use spreadsheets to record and track materials usages/stocks, product sales, and other business data such that discrepancies will be easily detected when they do occur. The use of spreadsheets when properly done, can help to uncover the cause(s) of "losses" in virtually any aspect of a business operation.
For the purpose of creating custom financial and business management solutions that solve your identified problems, and give you control/ownership, without burning a hole in your pocket, Excel VB offers an amazing variety of possibilities, in the hands of an adequately skilled user.
The savings _ from using your "in house" expertise _ in terms of money and man_hours alone, will quickly justify the investment you make in "developing the needed skills" _ especially, when you compare what you spend with the cost of purchasing a commercial software application _ or even engaging the services of an Excel VB developer.
examples of spreadsheet packages
excel inventory templates