INVENTORY CALCULATOR
Starting Inventory: Safety Stock Level Percentage: Initial Demand (Sales) per week: Lead Time (in weeks): Annual Growth Rate of Demand (Sales): 2000 10 % 1000 4 50 % Week 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
Minimum Inventory Observed: Maximum Inventory Observed: Starting Safety Stock: Ending Safety Stock: Total Inventory Held (in units*weeks): Total Inventory Backordered Inventory (units*weeks): Number of Orders Placed:
-2,058 4,591 100 149 100,755 -3,097 13
Inventory 5000 4000 3000 2000
1000 0
Safety Stock
-1000 -2000 -3000
50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
NTORY CALCULATOR
Initial Inv. 2,000 1,000 -10 -1,029 -2,058 3,280 2,232 1,174 107 3,400 2,313 1,217 111 3,518 2,393 1,258 114 3,637 2,474 1,301 118 3,757 2,555 1,343 122 3,876 2,636 1,386 126 3,995 2,716 1,428 130 4,115 2,798 1,471 134 4,234 2,878 1,513 138 4,352 2,958 1,554 141 4,472 3,039 1,597 145 Order Qt 6,376 0 0 0 4,370 0 0 0 4,522 0 0 0 4,677 0 0 0 4,831 0 0 0 4,985 0 0 0 5,138 0 0 0 5,293 0 0 0 5,446 0 0 0 5,599 0 0 0 5,754 0 0 0 5,908 0 0 0 6,062 Incoming Qt 0 0 0 0 6,376 0 0 0 4,370 0 0 0 4,522 0 0 0 4,677 0 0 0 4,831 0 0 0 4,985 0 0 0 5,138 0 0 0 5,293 0 0 0 5,446 0 0 0 5,599 0 0 0 5,754 0 0 0 5,908 Sales Qt 1,000 1,010 1,019 1,029 1,038 1,048 1,058 1,067 1,077 1,087 1,096 1,106 1,115 1,125 1,135 1,144 1,154 1,163 1,173 1,183 1,192 1,202 1,212 1,221 1,231 1,240 1,250 1,260 1,269 1,279 1,288 1,298 1,308 1,317 1,327 1,337 1,346 1,356 1,365 1,375 1,385 1,394 1,404 1,413 1,423 1,433 1,442 1,452 1,462 Ending Inv. 2,000 1,000 -10 -1,029 -2,058 3,280 2,232 1,174 107 3,400 2,313 1,217 111 3,518 2,393 1,258 114 3,637 2,474 1,301 118 3,757 2,555 1,343 122 3,876 2,636 1,386 126 3,995 2,716 1,428 130 4,115 2,798 1,471 134 4,234 2,878 1,513 138 4,352 2,958 1,554 141 4,472 3,039 1,597 145 4,591 Safety St. 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 139 140 141 142 143 144 145 146
4,591 3,120 1,639 149 -1351 -2861 -4380 -5909 -7447 -8995 -10553 -12120 -13697 -15284 -16880 -18486 -20101 -21726 -23361 -25005 -26659 -28322 -29995 -31678 -33370 -35072 -36784 -38505 -40236 -41976 -43726 -45486 -47255 -49034 -50822 -52620 -54428 -56245 -58072 -59909 -61755 -63611 -65476 -67351 -69236 -71130 -73034 -74947 -76870 -78803 -80745 -82697 -84659 -86630 -88611
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1,471 1,481 1,490 1500 1510 1519 1529 1538 1548 1558 1567 1577 1587 1596 1606 1615 1625 1635 1644 1654 1663 1673 1683 1692 1702 1712 1721 1731 1740 1750 1760 1769 1779 1788 1798 1808 1817 1827 1837 1846 1856 1865 1875 1885 1894 1904 1913 1923 1933 1942 1952 1962 1971 1981 1990
3,120 1,639 149 -1351 -2861 -4380 -5909 -7447 -8995 -10553 -12120 -13697 -15284 -16880 -18486 -20101 -21726 -23361 -25005 -26659 -28322 -29995 -31678 -33370 -35072 -36784 -38505 -40236 -41976 -43726 -45486 -47255 -49034 -50822 -52620 -54428 -56245 -58072 -59909 -61755 -63611 -65476 -67351 -69236 -71130 -73034 -74947 -76870 -78803 -80745 -82697 -84659 -86630 -88611 -90601
147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 189 190 191 192 193 194 195 196 197 198 199
case1? n
TRUE -2
first rep week 1 safety stock percentage 10% annual growth rate 0.50
winc
9.615
Week >=5 Week >=7 Week >=9 Week >=11 Week >=13 Week >=15 Week >=17 Week >=19 Week >=21 Week >=23 Week >=25 Week >=27 Week >=29 Week >=31 Week >=33
Week <=8 Week <=10 Week <=12 Week <=14 Week <=16 Week <=18 Week <=20 Week <=22 Week <=24 Week <=26 Week <=28 Week <=30 Week <=32 Week <=34 Week <=36
Week >=6 Week >=8 Week >=10 Week >=12 Week >=14 Week >=16 Week >=18 Week >=20 Week >=22 Week >=24 Week >=26 Week >=28 Week >=30 Week >=32 Week
Week <=9 Week <=11 Week <=13 Week <=15 Week <=17 Week <=19 Week <=21 Week <=23 Week <=25 Week <=27 Week <=29 Week <=31 Week <=33 Week <=35 Week
order qt 6376 0 0 0 4370 0 0 0 4522 0 0 0 4677 0 0 0 4831 0 0 0 4985 0 0 0 5138 0 0 0 5293
ws ss 4211 107 4250 108 4289 109 4327 110 4366 111 4404 112 4442 113 4481 114 4519 114 4558 115 4596 116 4634 117 4673 118 4711 119 4750 120 4789 121 4827 122 4866 123 4904 124 4942 125 4981 126 5019 127 5058 128 5096 129 5134 130 5173 131 5211 132 5250 133 5289 134
bi incoming -2058 0 3280 0 2232 0 1174 0 107 6376 3400 0 2313 0 1217 0 111 4370 3518 0 2393 0 1258 0 114 4522 3637 0 2474 0 1301 0 118 4677 3757 0 2555 0 1343 0 122 4831 3876 0 2636 0 1386 0 126 4985 3995 0 2716 0 1428 0 130 5138
Week >=35 Week >=37 Week >=39 Week >=41 Week >=43 Week >=45 Week >=47 Week >=49 Week >=51 Week >=53 Week >=55
Week <=38 Week <=40 Week <=42 Week <=44 Week <=46 Week <=48 Week <=50 Week <=52 Week <=54 Week <=56 Week <=58
>=34 Week >=36 Week >=38 Week >=40 Week >=42 Week >=44 Week >=46 Week >=48 Week >=50 Week >=52 Week >=54 Week >=56
<=37 Week <=39 Week <=41 Week <=43 Week <=45 Week <=47 Week <=49 Week <=51 Week <=53 Week <=55 Week <=57 Week <=59
0 0 0 5446 0 0 0 5599 0 0 0 5754 0 0 0 5908 0 0 0 6062 0 0 0
5327 5366 5404 5442 5481 5519 5558 5596 5634 5673 5711 5750 5789 5827 5866 5904 5942 5981 6019 6058 6096 6134 6173
135 136 137 138 139 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156
4115 2798 1471 134 4234 2878 1513 138 4352 2958 1554 141 4472 3039 1597 145 4591 3120 1639 149 -1351 -2861 -4380
0 0 0 5293 0 0 0 5446 0 0 0 5599 0 0 0 5754 0 0 0 5908 0 0 0
Chart Order Qt >0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Inventory Safety Stock 2000 100 1000 100 -10 101 -1029 102 -2058 103 3280 104 2232 105 1174 106 107 107 3400 108 2313 109 1217 110 111 111 3518 112 2393 113 1258 114 114 114 3637 115 2474 116 1301 117 118 118 3757 119 2555 120 1343 121 122 122 3876 123 2636 124 1386 125 126 126 3995 127
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
2716 1428 130 4115 2798 1471 134 4234 2878 1513 138 4352 2958 1554 141 4472 3039 1597 145 4591 3120 1639 149
128 129 130 131 132 133 134 135 136 137 138 139 139 140 141 142 143 144 145 146 147 148 149
Follow the steps to enable your online Inventory Calculator.
>> >> >> >> 1)
2) 3) >>
It is assumed in this template that annual demand growth is distributed uniformly on the 52 weeks. Safety Stock is calculated by multiplying the Safety Stock Level Percentage by the Demand of the week. Since Safety Stock policy is applied, backordering is avoided if possible. Your Inventory Calculator is ready to use. Following steps are for online use. Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information. Click "Add Web Application" to upload this file. Your online file will be created automatically. You can simply use the file from that link or place it on your website. Your online Inventory Tracker will look like: http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=1060d618-c988-4596-8363-b2ab0f4a6 In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm
Copyright (c) 2009 Pagos, Inc., http://www.pagos.com/
8-c988-4596-8363-b2ab0f4a6390