How the Beer Game Spreadsheet works
This video is how the spreadsheet is setup to work to play the game. The actual game play video is here: • Beer Game Spreadsheet ...
Based on the beergame.org's game structure, I've setup the following spreadsheet that can be used to play with a single supply chain group.
docs.google.com/spreadsheets/...
You can use this for teaching supply chain delays, the bullwhip effect, and sudden demand increases causing empty inventories.
If you find errors in the spreadsheet, please let me know.
If you enjoyed this or the spreadsheet, www.buymeacoffee.com/thinkniko
Пікірлер: 5
Great job!
Hi Niko, can you pls share the complete spreadsheet. Thanks :)
Good job. I just wanted to know the conditions at 2:22? can you share them, so it would be easy to relate. Thanks.
@thinkniko
2 жыл бұрын
It handles if the inventory would go negative and if the incoming inventory would satisfy (even partially) the order (and backorders) to ship if the inventory is zero or would be negative. The spreadsheet is viewable and you can look at the formula. After doing a few play throughs testing the sheet with various inputs to see if I can hit all the possible conditions to handle it in the formulas. Ordered more than inventory + incoming = ship inventory and incoming, but make negative inventory for what didn't ship. Backorder (neg inventory) but incoming would satisfy order and backorders = ship order+backorder amounts and inventory should be zero or positive. etc. etc.
@rafhanrifan8891
2 жыл бұрын
@@thinkniko Thanks Niko. ☺️