Would be nice for the spreadsheet to be more detailed. Where it breaks every Venue location into it's own tab. Ending with a Total Inventory tab. That way you can see how much inventory (quantity, cost, and sales) is in each Venue.
The inventory report has a total quantity and value on hand column in the All tab. It now also has a Value on Hand tab for all your major beverage categories!