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, AB, AU, AA, AQ, AY) calculate the safety stock assuming a lead-time of 1.5 months and service level of 95%.

Transcribed Image Text:

Month A АВ AU AA AQ AY 1 125 134 121 120 126 134 132 126 140 113 115 123 3 115 126 135 122 122 127 4 137 121 127 142 114 116 122 141 128 137 123 123 6 130 119 122 128 144 115 7 141 135 142 129 138 125 8 128 128 120 124 130 145 9 118 120 137 144 131 140 10 123 133 130 122 125 131 11 139 146 121 138 145 132 12 133 142 135 131 123 126 13 140 127 148 122 140 147 14 128 134 143 136 132 124 15 126 128 128 149 123 141 16 138 142 135 145 137 134 17 135 146 130 129 151 125 18 150 134 143 136 146 139 19 143 139 147 131 131 152 20 154 126 136 145 138 148 21 144 134 140 149 132 132 22 125 125 127 137 146 139 23 131 135 135 141 150 134 24 141 157 126 129 138 148 5. Month A АВ AU AA AQ AY 1 125 134 121 120 126 134 132 126 140 113 115 123 3 115 126 135 122 122 127 4 137 121 127 142 114 116 122 141 128 137 123 123 6 130 119 122 128 144 115 7 141 135 142 129 138 125 8 128 128 120 124 130 145 9 118 120 137 144 131 140 10 123 133 130 122 125 131 11 139 146 121 138 145 132 12 133 142 135 131 123 126 13 140 127 148 122 140 147 14 128 134 143 136 132 124 15 126 128 128 149 123 141 16 138 142 135 145 137 134 17 135 146 130 129 151 125 18 150 134 143 136 146 139 19 143 139 147 131 131 152 20 154 126 136 145 138 148 21 144 134 140 149 132 132 22 125 125 127 137 146 139 23 131 135 135 141 150 134 24 141 157 126 129 138 148 5.

Answer rating: 100% (QA)

With the given information the following should be the spreadsheet model Result Aero B... View the full answer