SUPPLY CHAIN MANAGEMENT - THE BOOK'S INPUTS FOR THE BLANK SET
Type these back into the blue cells and the book's figures come back.

1. Supply_Chain_Management_Workbook_1_Demand_Lead_Time_and_Variance_Blank.xlsx

   Assumptions              C5   Mean weekly demand                                              1840
   Assumptions              C6   Standard deviation of weekly demand                             462
   Assumptions              C7   Weeks per year                                                  52
   Assumptions              C8   Mean replenishment lead time                                    6
   Assumptions              C9   Standard deviation of lead time                                 1.9
   Assumptions              C10  Selling price                                                   47.5
   Assumptions              C11  Purchase cost delivered                                         28.6
   Assumptions              C12  Cost of capital                                                 0.074
   Assumptions              C13  Storage                                                         0.031
   Assumptions              C14  Obsolescence                                                    0.0225
   Assumptions              C15  Insurance                                                       0.0065
   Assumptions              C16  Cost of placing one order                                       385
   Assumptions              C17  Cycle service level voted by the board                          0.98
   How well sigma is known  C5   Half width wanted on the standard deviation of lead time        0.3
   How well sigma is known  C6   Confidence                                                      0.95

Result: 9.4845 per cent of the variance from the market, 90.5155 from the lead time; 79 receipts.

2. Supply_Chain_Management_Workbook_2_Service_Levels_and_the_Money_Blank.xlsx

   Assumptions              C5   Mean weekly demand                                              1840
   Assumptions              C6   Standard deviation of weekly demand                             462
   Assumptions              C7   Weeks per year                                                  52
   Assumptions              C8   Mean replenishment lead time                                    6
   Assumptions              C9   Standard deviation of lead time                                 1.9
   Assumptions              C10  Selling price                                                   47.5
   Assumptions              C11  Purchase cost delivered                                         28.6
   Assumptions              C12  Cost of capital                                                 0.074
   Assumptions              C13  Storage                                                         0.031
   Assumptions              C14  Obsolescence                                                    0.0225
   Assumptions              C15  Insurance                                                       0.0065
   Assumptions              C16  Cost of placing one order                                       385
   Assumptions              C17  Cycle service level voted by the board                          0.98
   Fill rate solver         C5   Target fill rate                                                0.98

Result: fill rate 99.3846 per cent at the vote; 94.3945 per cent for a 98 per cent fill rate; +18,490.12 a year.

3. Supply_Chain_Management_Workbook_3_The_Reliability_Lever_Blank.xlsx

   Assumptions              C5   Mean weekly demand                                              1840
   Assumptions              C6   Standard deviation of weekly demand                             462
   Assumptions              C7   Weeks per year                                                  52
   Assumptions              C8   Mean replenishment lead time                                    6
   Assumptions              C9   Standard deviation of lead time                                 1.9
   Assumptions              C10  Selling price                                                   47.5
   Assumptions              C11  Purchase cost delivered                                         28.6
   Assumptions              C12  Cost of capital                                                 0.074
   Assumptions              C13  Storage                                                         0.031
   Assumptions              C14  Obsolescence                                                    0.0225
   Assumptions              C15  Insurance                                                       0.0065
   Assumptions              C16  Cost of placing one order                                       385
   Assumptions              C17  Cycle service level voted by the board                          0.98
   What you can pay         C5   Target standard deviation of lead time                          0.5
   What you can pay         C6   Horizon for the reliability case                                3

Result: 24,154.77 a year and 130,170.70 once for 1.9 to 0.5 weeks; 0.2525 per unit; 3.90 times the dispute.

4. Supply_Chain_Management_Workbook_4_Pooling_Bias_and_the_Holding_Rate_Blank.xlsx

   Assumptions              C5   Mean weekly demand                                              1840
   Assumptions              C6   Standard deviation of weekly demand                             462
   Assumptions              C7   Weeks per year                                                  52
   Assumptions              C8   Mean replenishment lead time                                    6
   Assumptions              C9   Standard deviation of lead time                                 1.9
   Assumptions              C10  Selling price                                                   47.5
   Assumptions              C11  Purchase cost delivered                                         28.6
   Assumptions              C12  Cost of capital                                                 0.074
   Assumptions              C13  Storage                                                         0.031
   Assumptions              C14  Obsolescence                                                    0.0225
   Assumptions              C15  Insurance                                                       0.0065
   Assumptions              C16  Cost of placing one order                                       385
   Assumptions              C17  Cycle service level voted by the board                          0.98
   Pooling                  C5   Number of regional depots                                       4

Result: four depots tie up 91,485.19 more stock and 8,401.59 a year of orders; a 10 per cent under-forecast costs 8,952.25.

The sensitivity axes (service levels, lead-time spreads, biases, holding rates, the search bounds and the
levels of the dispute) are kept: they are steps, not data.
