Unless this is watertight, it really doesn't matter what you do, the exercises will only be a face saver.
Personal experience speaking here.
My system was based on a Database rather than a Spreadsheet, but that's neither here nor there.
As only about three quarters of the Staff actually recorded their Requisitions and the Delivery Invoices were frequently a week behind. The figure meant little. Good Luck