Question: Task: Create an Excel sheet that calculates safety stock for six different products. For a given set of historical demand, you should be able to

Task: Create an Excel sheet that calculates

Task: Create an Excel sheet that calculates

Task: Create an Excel sheet that calculates safety stock for six different products. For a given set of historical demand, you should be able to experiment with different desired service levels, and lead times. (That is, you should have service level and lead time as parameters.) Test your spreadsheet on the following data: demand data below for the six products (A, AA, AB, AQ, AU, AY) calculate the safety stock assuming a lead-time of 2.5 months and service level of 95%. A AA AB Month 1 2 142 133 132 115 135 140 AY 131 123 127 115 123 3 135 4 137 AU 123 115 122 114 126 144 138 131 130 5 122 130 126 126 121 141 119 135 128 120 133 127 128 122 142 6 116 7 141 8 128 120 125 140 145 9 118 10 137 130 121 123 139 134 125 145 11 146 132 AQ 129 113 122 142 137 128 129 124 144 122 138 131 122 149 136 145 129 136 131 145 149 137 141 12 125 121 148 13 140 14 143 128 126 15 126 147 124 148 134 128 16 134 127 134 128 142 146 134 139 157 138 123 140 123 132 137 151 146 131 138 17 135 125 135 130 143 147 136 18 19 139 152 148 20 21 150 143 141 144 125 131 154 134 140 132 132 125 127 22 23 146 150 139 134 135 135 24 126 126 120 138 141

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!