A thorough Analyses of the beer game data Interpretation of the beer game Analyse the provided beer game data using Excel.

In doing so, you might follow these steps:

a. Plot the orders for every supply chain role in one graph (x-axis: weeks, y-axis: orders, all four roles in one graph).

b. Plot the inventory (backorder is negative inventory - x-axis: weeks, y-axis: inventory/backorder, all four roles in one graph)

c. Plot the cumulative costs (x-axis: weeks, y-axis: cost, all four roles in one graph)

Discuss the data:

1. Using your analysis, what do you observe about the degree of fluctuation in the order quantity (and inventory levels) for each role? Explain the effect you observe (refer to your data plots).

2. What do you think contributes to this effect?

3. What are the implications for the retailer and the factory

Excel file link: https://ufile.io/kiyxo Alternative link: https://files.fm/u/cc2yxn7u Alternative Link: http://www.filedropper.com/beergamedata_2

Let me know what the issue is? Can you not download the file or can you not open the file?

| 5055505550550500000000555055550000000000 50000550055050500 0 0000005555005005 0 0 0 0 0 0 str er 0 0 0 0 0 0 0 0 5 0 5 5 5 5 5 5 60 5 5 5 5 5 5 5 5 5 4 8 8 8 8 8 8 8 8 8 9 883 55500 10 5 5 5 5 0 0 5 5 0 5 0 5 0 0 0 0 0 0 0 0 0 5 5 5 5 0 0 5 0 0 1 0 0 0 er 0 0 0 0 0 0 0 3 1 9 1 6 5 4 3 2 1 5 4 5 6 7 7 4 3 2 2 3 9 8 7 6 5 9 3 2 3 39 555599962 10 7 4 0 0 5 5 0 0 5 5 0 5 0 5 0 0 0 0 0 0 0 0 0 555513 er d 5 5 5 5 5 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 | 5055505550550500000000555055550000000000 50000550055050500 0 0000005555005005 0 0 0 0 0 0 str er 0 0 0 0 0 0 0 0 5 0 5 5 5 5 5 5 60 5 5 5 5 5 5 5 5 5 4 8 8 8 8 8 8 8 8 8 9 883 55500 10 5 5 5 5 0 0 5 5 0 5 0 5 0 0 0 0 0 0 0 0 0 5 5 5 5 0 0 5 0 0 1 0 0 0 er 0 0 0 0 0 0 0 3 1 9 1 6 5 4 3 2 1 5 4 5 6 7 7 4 3 2 2 3 9 8 7 6 5 9 3 2 3 39 555599962 10 7 4 0 0 5 5 0 0 5 5 0 5 0 5 0 0 0 0 0 0 0 0 0 555513 er d 5 5 5 5 5 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9