Cost per rack can help a business understand chemical expenditure in relation to activity. It is a management measure, not a dispensing target. Do not reduce a required product setting simply to improve the figure.
Define a reliable observation period
Choose a period that captures representative operation and allows stock use to be measured consistently. Record opening stock, receipts and closing stock for each product using the site’s authorised handling method. Do not open or disconnect a chemical system merely to estimate consumption.
Count racks using a consistent definition. Note whether the total includes rewash. If the business wants to compare first-pass workload, keep rewash as a separate field rather than silently including it in some weeks but not others.
Use a simple formula
Chemical cost per 100 racks = chemical cost used during the period ÷ racks processed × 100.
For an invented example, suppose detergent use costs $90 and rinse-additive use costs $30 over 2,000 recorded racks. The combined chemical cost is $120 ÷ 2,000 × 100 = $6 per 100 racks. These figures illustrate arithmetic only; they are not Aspin prices or expected consumption.
Keep the components visible
Record detergent and rinse additive separately before presenting a combined figure. Include any other required process chemical as its own line. This prevents a change in one component from being hidden in a single total.
Add notes for unusual events, such as a product transition, spill, service work or major change in rack mix. A weekly figure without context can suggest a problem where the workload simply changed.
Use the result for questions
If the measure changes unexpectedly, review stock recording, rack counts and operating events with the responsible people. Ask the service provider to investigate dispensing concerns; the spreadsheet cannot diagnose a machine.
Use rewash tracking alongside the cost record. D-10 and R-10 serve different stages, so a useful commercial comparison includes performance, equipment support and supply reliability as well as chemical expenditure.