Ending Closing Stock formula:
Opening Inventory + Purchases = the Cost of goods available for sale (COGAS)
COGAS x Cost percentage = Cost of goods sold (COGS)
COGAS – COGS = Ending Inventory
Example:
Your Opening Inv. Is 50.000€ + Purchases of 10.000€ (MTD or Month-end) = 60.000€ (COGAS)
60.000€ x 30% food cost = 18.000€ (COGS)
60.000€ – 18.000€ = 42.000€ (Closing Stock)
