StartupSupply Chain Simulations

&APage &PSupply Chain SimulationsStart GameInstructorQuit GameThis simulation game was written by Rungson Samroengraja under the supervision of Professor Fangruo Chen, Columbia Business School. It is inspired by the Beer Distribution Game developed by the Systems Dynamics Group, Sloan School of Management, Massachusetts Institute of Technology. If you have any comments or suggestions, please email to fc26@columbia.edu.

Copyright 1997 by Fangruo Chen. All Rights Reserved.To access the game parameters, press the button below and enter the password:Push the button below to quit the game and restore Excel to it's former settings:

Main SheetFactoryPeriod:11Incoming Order fromDist. CenterProduction Scheduled50InventoryOn-Hand05050Backordered05050Beer in Transit toBeer in ProductionDist. Center

Factory BrewsProduction orders advance one position. An order that is entered in this period will be available three periods from now.

Click on the Proceed button to continue.Customer DemandThis period, your customers have ordered this many kegs of beer.

Click on the Proceed button to continue.Outgoing OrderInform your upstream partner that they are receiving an order for this many kegs this period.

Click on the Proceed button to continue.Incoming ShipmentWait for your upstream partner to inform you of the size of the incoming shipment. Type in the number of kegs here, and then press Enter.

Click on the Proceed button.Outgoing ShipmentInform your downstream partner that they are receiving this many kegs this period.

When you are finished, click on the Proceed button.Order FulfillmentIncoming beer is added to your inventory.

A shipment is made based on your On-Hand and Backordered Inventory and the Incoming Order.

Click on the Proceed Button to continue.Place Your OrderYou may now place an order with your upstream supplier. Type the number of kegs and then press Enter.

When you are satisfied, click on the Proceed button to end the period.In This Period:

Order from Dist. Center: 50 kegsProduced by Factory: 50 kegsShipment to Dist. Center: 50 kegsOrder placed: 50 kegs

When your entire team is ready to go on to the next period, click the Proceed button.Show SummaryPlease enter an integer greater than zeroProceedShipment AdvancementLast week's shipment advances one position. It will arrive to your downstream partner next period.

Click on the Proceed button to continue.Title ScreenReplay PeriodAdvancing OrdersOutstanding orders advance one position.

Note that what you receive may differ from what you ordered.

Click on the Proceed button to continue.Incoming OrderWait for your downstream partner to inform you of the size of the incoming order. Type in the number of kegs here and press Enter.

Click on the Proceed button to continue.Show History

HistoryBeer History SheetUse the PgUp andPgDn keys to scrollPosition:FactoryStartingEndingAccountingHolding &PeriodStartingQuantityDist. CenterQuantityEndingOutstandingScheduledOutstandingInventoryBackorderCumulativeNet Inven.ProducedOrderShippedNet Inven.OrdersProductionOrdersLevelCostCost452045453535501502050502010050130205522045505015130501351549315355050013550150009405050500150501500095050505001505015000960505050015050150009705050500150501500098050505001505015000990505050015050150009100505050015050150009110150121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980

&APage &PReturn To Main ScreenShow GraphsShow Graphs

MainModule

&APage &P&APage &P&APage &P

MainModule50

Warehouse OrderTime# of Kegs

SequenceModule

Order to FactoryTime# of Kegs

SetupModule45

Quantity ReceivedTime# of Kegs

Graphs

Ending Net Inven.# of Kegs

Graphs_CC

Return To History Screen

Graphs_CC50

Warehouse OrderTime# of Kegs

Game Parameters

Ending Net Inven.Time# of Kegs

Defaults

Order to FactoryTime# of Kegs

LocationDlg

Accounting Inventory Level

OptionsDlgGame ParametersProgram Use Only - Don't Modify!!Game Starting ValuesChosen1DemandTRAININGLength(Training)5SaveParamsPopulation StatsFactDistWareRetaLength(For Real)30Mod 2Mean49.0051.11Holding Cost(T)0.250.50.751Mod 3Std Dev17.7020.39Backorder Cost(T)00010BlinkTime(Training)0.25Game StatsHolding Cost(CC)0.250.250.250.25BlinkTime(For Real)0.1Game Options:Mean50.4049.37Backorder Cost(CC)0.50.50.510Cost Centers02Std Dev19.0220.02Starting Inventory100100100100Location Names:Demand Visible02PeriodTrainingFor RealOrders 140352530FactoryTraining02-8045245453535Dist. CenterExcel Status:-73453355WarehouseFormula-63832Shipping 14035250Retail StoreStatus-5386724545350CustomerWindow-4137-43454Data Entry-4146-36148FOR REALPassword(For Real)omgameMove After Ret.-25242FactDistWareReta(leave blank if none req'd)85-16175Holding Cost(T)0.250.50.75106968Backorder Cost(T)0001014363Holding Cost(CC)0.250.250.250.2523098Backorder Cost(CC)0.50.50.51037171Starting Inventory5050505048361Orders 135603540551502455045306583932072045Shipping 135603508622324550450949431037291155301259951344471413261546401675741717431869511953532033132170552242302383582439472578422628182751552876652957673066503170393268733364623428843559783659513730283857483967354026714154334272654362704435104453111846425547484448163749473950436951751052654353452354445955241856602573677584138592637604654615359625769634362643049655433663963674648683347693182704863713425726555738544744962754455766053776842783829797634802346

Return To History Screen&APage &PReturn to StartReset DefaultsSave ChangesAny values in BLUE text may be changed. All other values are fixed. For Length, please enter a value less than 80.

StartGameDlgGame ParametersGame Starting ValuesProgram Use Only - Don't Modify!!DemandTRAININGLength(Training)10Chosen3Mean48.2651.88FactDistWareRetaLength(For Real)30SaveParamsStd Dev9.269.98Holding Cost(T)0.250.50.751Mod 2PeriodTrainingFor RealBackorder Cost(T)00010BlinkTime(Training)0.25Mod 3-86053Holding Cost(CC)0.250.250.250.25BlinkTime(For Real)0.1-74924Backorder Cost(CC)0.50.50.510Game Options:-66455Starting Inventory100100100100Location Names:Cost Centers01-54816Orders 164413638FactoryDemand Visible01-44142249484341Dist. CenterTraining02-34348360WarehouseExcel Status:-23655Shipping 16441360Retail StoreStandard-1413624948430CustomerFormatting03845Drawing12875FOR REALPassword(For Real)beerFormula25649FactDistWareReta(leave blank if none req'd)Status33864Holding Cost(T)0.250.50.751Window-413745348Backorder Cost(T)00010Data Entry-414654942Holding Cost(CC)0.250.250.250.25Move After Ret.66145Backorder Cost(CC)0.50.50.51074742Starting Inventory5050505085247Orders 15542554594161224164836106658353114160Shipping 1554255012633922416480135553144152155645165061173448184147195152204949214646225046233539245562253163265457274659285058296050305464314164325757334268343161355042365266374959385846393469404948414958424753435447445553454950464955475357483955497159504862516447523864534365545845554760564563575132585447593558605659615555625448634643644753655032665658674949683834695149704463716250725048733751742261755734763461773645785456796549804754

Summary of Outbound Information this Period:

Your upstream partner receives an order for 25 kegs from you.

Your downstream partner receives a shipment of 32 kegs from you.

StartGameDlg2

&APage &PSupply Chain LocationOKCancelFactoryDist. CenterWarehouseRetail StoreLocationClick on the position you will be playing:

Sheet2

&APage &PSimulator OptionsOKCancelCost CentersTeamMgmt StructureThe first two sets of options determine which version of the game you will be playing. The Play Style options determine the pace of the game and whether the results will be recorded. Please see the manual for more information.TransmittedNot TransmittedDemand InformationTrainingFor RealPlay Style

SupportModule

&APage &PGet Ready...OKOkay, we're about to play a training version of the game. For the first few turns, you will be guided through the steps of the game. Your instructor will let you know when you can start making your own decisions.

Good Luck!

&APage &PGet Ready...OKYou are about to play the game for real. After a certain number of periods the game will end and your results will be saved to disk. Make sure your team has the game disk ready.

Good Luck!

Label List

&APage &POutgoing OrderInform your upstream partner that they are receiving an order for this many kegs this period.

Click on the Proceed button to continue.Shipment AdvancementLast week's shipment advances one position. It will arrive to your downstream partner next period.

Click on the Proceed button to continue.End of TurnPut end of turn statistics here.

Click on the Proceed button to start the next period.