Please answer the questions for "hot smart"

A B D E F G H 1 L M N o P R 3 Inventory cost rate (smart phone) $500 $200 Weekly sales On-hand average inventory 99.31 122 High Demand 102.58 109 High Demand 2.74 16 Low Demand 6.53 24 Low Demand Hot-Smart Hot-Feature Cold-Smart Cold-Feature $500 $0.00 26 weeks 8% of product value Intuition ? Push Pull ? Weekly Inventory Level Inventory Cost Average Demand Shipping Cost Warehouse Cost Total Cost PUSH PULL 122 5 $2,440 $100 99.31 99.31 $238.34 $1,191.72 $10.83 $99.31 $2,689 $1,391 The average store Annual capital cost/52 + (product value- liquidation value) / Product life-cycle $20 140 5 Product value = 6 Liquidation value = 7 Life-cycle 8 Capital return rate = 9 10 Inventory cost /week/unit = 11 12 13 Inventory cost rate (feature phone) 14 15 Product value 16 Liquidation value 17 Life-cycle- 18 Capital return rate= 19 20 Inventory cost /week/unit = 120 100 90 80 $200 0 26 weeks 8% of product value 60 40 20 Annual capital cost/52 + (product value - liquidation value) / Product life-cycle $8 0 Hot Smart Hot Feature Cold Smart Cold Feature $12 Weekdy sales average On hand inventory 2.5 22 23 FedEx freight cost (overnight) = 24 25 Overnight/standard 2D = 26 Volume discount = 27 Standard freight rate = 28 29 First pick 30 followup picks 50% $2.40 $1 $0.10 21 For the decision problem in Data-cost estimation - Amit.xlsx use data tables to perform the following sensitivity analysis for two different categories: (a) Hot Smart and Hot Feature. The goal is to see whether the final decision (Push vs Pull and the associated savings) changes with respect to parameter values. In each part, provide a brief explanation of the results. (i) Let the liquidation value in cell B6 vary from $0 to $200 in increments of $20. The capital return rate should be set to default (8%) (ii) Let the capital return rate in cell B8 vary from 1% to 10% in increments of 1%. The liquidation value should be set to default ($0) (iii) Use a two-way data table to let the inputs in parts (i) and (ii) vary simultaneously over the indicated range. A B D E F G H 1 L M N o P R 3 Inventory cost rate (smart phone) $500 $200 Weekly sales On-hand average inventory 99.31 122 High Demand 102.58 109 High Demand 2.74 16 Low Demand 6.53 24 Low Demand Hot-Smart Hot-Feature Cold-Smart Cold-Feature $500 $0.00 26 weeks 8% of product value Intuition ? Push Pull ? Weekly Inventory Level Inventory Cost Average Demand Shipping Cost Warehouse Cost Total Cost PUSH PULL 122 5 $2,440 $100 99.31 99.31 $238.34 $1,191.72 $10.83 $99.31 $2,689 $1,391 The average store Annual capital cost/52 + (product value- liquidation value) / Product life-cycle $20 140 5 Product value = 6 Liquidation value = 7 Life-cycle 8 Capital return rate = 9 10 Inventory cost /week/unit = 11 12 13 Inventory cost rate (feature phone) 14 15 Product value 16 Liquidation value 17 Life-cycle- 18 Capital return rate= 19 20 Inventory cost /week/unit = 120 100 90 80 $200 0 26 weeks 8% of product value 60 40 20 Annual capital cost/52 + (product value - liquidation value) / Product life-cycle $8 0 Hot Smart Hot Feature Cold Smart Cold Feature $12 Weekdy sales average On hand inventory 2.5 22 23 FedEx freight cost (overnight) = 24 25 Overnight/standard 2D = 26 Volume discount = 27 Standard freight rate = 28 29 First pick 30 followup picks 50% $2.40 $1 $0.10 21 For the decision problem in Data-cost estimation - Amit.xlsx use data tables to perform the following sensitivity analysis for two different categories: (a) Hot Smart and Hot Feature. The goal is to see whether the final decision (Push vs Pull and the associated savings) changes with respect to parameter values. In each part, provide a brief explanation of the results. (i) Let the liquidation value in cell B6 vary from $0 to $200 in increments of $20. The capital return rate should be set to default (8%) (ii) Let the capital return rate in cell B8 vary from 1% to 10% in increments of 1%. The liquidation value should be set to default ($0) (iii) Use a two-way data table to let the inputs in parts (i) and (ii) vary simultaneously over the indicated range