Question
The Inventory Management spreadsheet template accounts for the loss of inventory in the production process through the 'Stock calculated' column. This column subtracts the 'Quantity used' from the 'Quantity ordered'. For instance, in the production of burgers, the amount of beef used is subtracted from the total beef ordered. This calculation is done on the 'Production' tab.
This question was asked on:
All of these ingredients are now summed on the tab under the "Quantity ordered" column. In this case, we have a thousand pounds of beef that we've ordered to date. But we also lose beef as we sell our burgers, which the "Stock calculated" column accounts for. It subtracts the "Quantity used" from the "Quantity ordered." This calculation is on the "Production" tab which we'll get to in a minute.
Receive new free presentations every Monday to your inbox.
Full content, complete versions — No credit card required.
