Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Beer Game Group 2

    Uploaded by

    Rahul Kumar
    The document contains data on inventory levels, orders, and backorders for a 4-level supply chain over 30 weeks. It shows the bullwhip effect where order variability increases as you move up the supply chain from factory to retailer. The factory has the smoothest demand pattern while the retailer has the most variable orders.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Beer Game Group 2

    Uploaded by

    Rahul Kumar
    33 views27 pages
    The document contains data on inventory levels, orders, and backorders for a 4-level supply chain over 30 weeks. It shows the bullwhip effect where order variability increases as you move up the supply chain from factory to retailer. The factory has the smoothest demand pattern while the retailer has the most variable orders.

    Original Description:

    beer game

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains data on inventory levels, orders, and backorders for a 4-level supply chain over 30 weeks. It shows the bullwhip effect where order variability increases as you move up the supply chain from factory to retailer. The factory has the smoothest demand pattern while the retailer has the most variable orders.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    33 views27 pages

    Beer Game Group 2

    Uploaded by

    Rahul Kumar
    The document contains data on inventory levels, orders, and backorders for a 4-level supply chain over 30 weeks. It shows the bullwhip effect where order variability increases as you move up the supply chain from factory to retailer. The factory has the smoothest demand pattern while the retailer has the most variable orders.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 27

    Retailer

    Week

    Incoming Order

    Current
    Inventory

    Accumulated
    Backorders

    Order Placed

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    Individual
    Costs
    Total Costs

    0
    0

    Wholesaler
    Week

    Incoming Order

    Current
    Inventory

    Accumulated
    Backorders

    Order Placed

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28

    Week

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    0

    0
    0

    Distributor
    Incoming Order

    Current
    Inventory

    Factory & R
    Accumulated
    Backorders

    Order Placed

    0
    0

    Week

    Incoming Order

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28

    6
    6
    6
    6
    6
    7
    8
    6
    0
    0
    0
    0
    0
    0
    10
    10
    25
    10
    30
    20
    10
    5
    4
    4
    0
    0
    0
    0

    Factory & RM
    Current
    Inventory

    Accumulated
    Backorders

    Order Placed

    12
    12
    12
    12
    8
    6
    0
    0
    0
    10
    12
    12
    12
    12
    2
    2
    0
    0
    0
    7
    17
    22
    28
    28
    28
    28
    28
    28

    0
    0
    0
    0
    0
    0
    2
    4
    0
    0
    0
    0
    0
    0
    0
    0
    13
    3
    13
    0
    0
    0
    0
    0
    0
    0
    0
    0

    6
    2
    5
    0
    4
    4
    10
    2
    0
    0
    0
    0
    10
    10
    20
    20
    40
    20
    10
    10
    4
    0
    0
    0
    0
    0
    0
    0

    338

    Total Cost
    408

    70
    408

    Retailer
    Week

    Incoming Order

    Current
    Inventory

    Accumulated
    Backorders

    Order Placed

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30

    1
    0.9
    0.8
    0.7
    0.6
    0.5
    0.4
    0.3
    0.2
    0.1
    0

    0
    0

    Chart Title
    1
    0.9
    0.8
    0.7
    0.6
    0.5
    0.4
    0.3
    0.2
    0.1
    0

    9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
    Incoming Order

    Current Inventory

    Accumulated Backorders

    Order Placed

    Wholesaler
    Week

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30

    Incoming
    Order

    Current
    Inventory

    Accumulated
    Backorders

    Order
    Placed

    12

    10

    Incoming Order

    Chart Title

    Incoming Order

    10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
    Current Inventory

    Accumulated Backorders

    Order Placed

    6 27 28 29 30

    Distributor
    Week

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30

    Incoming
    Order

    Current
    Inventory

    Accumulated
    Backorders

    Order
    Placed

    12

    10

    Chart Title

    10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
    Incoming Order

    Current Inventory

    Accumulated Backorders

    Order Placed

    28 29 30

    Factory & RM
    Week

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30

    Incoming
    Order

    Current
    Inventory

    Accumulated
    Backorders

    Order
    Placed

    12

    10

    Incoming Order

    Chart Title

    Incoming Order

    10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
    Current Inventory

    Accumulated Backorders

    Order Placed

    27 28 29 30

    Incoming Orders
    Week

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30

    Retailer

    Wholesaler

    Distributor

    Factory

    Incoming Orders
    12

    10

    10

    Retailer

    11

    12

    13

    14

    Wholesaler

    15

    16

    17

    18

    Distributor

    19

    20

    21

    Factory

    22

    23

    24

    25

    20

    21

    Factory

    22

    23

    24

    25

    26

    27

    28

    Current Inventory
    Week

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30

    Retailer

    Wholesaler

    Distributor

    Factory

    12

    10

    Current Inventory

    10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
    Retailer

    Wholesaler

    Distributor

    Factory

    25 26 27 28 29 30

    Accumulated Backorders
    Week

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30

    Retailer

    Wholesaler

    Distributor

    Factory

    12

    10

    Acumulated Backorders
    12

    10

    10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
    Retailer

    Wholesaler

    Distributor

    Factory

    1 22 23 24 25 26 27 28 29 30

    actory

    Order Placed
    Week

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30

    Retailer

    Wholesaler

    Distributor

    Factory

    12

    10

    Orders placed per week


    (Bull Whip Effect)
    12

    10

    10

    11

    12

    Retailer

    13

    14

    15

    Wholesaler

    16

    17

    18

    Distributor

    19

    20

    21

    Factory

    22

    week
    ct)

    18

    butor

    19

    20

    21

    Factory

    22

    23

    24

    25

    26

    27

    28

    29

    30

    You might also like