Tabellab
Read first

Do not average ratios

The company turnover is total COGS / total average stock, not the AVERAGE of the five category turnovers. Small categories would otherwise count as much as big ones. The same applies to fill rates: add the units first, then divide.

Loading the spreadsheet…