Skip to content

Instantly share code, notes, and snippets.

@fireflysemantics

fireflysemantics/local-optimization.csv

Last active December 5, 2020 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fireflysemantics/054716730103cd205c39167054542f68 to your computer and use it in GitHub Desktop.
Save fireflysemantics/054716730103cd205c39167054542f68 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
local-optimization.csv
stockingLevel annualDemandLevel leadTimeDemand unitsFulfilled marginalUnitsFulfilled serviceLevel marginalServiceLevel averageInventoryLevel marginalAverageInventoryLevel inventoryCarryingCost marginalInventoryCarryingCost cycleTimeDays marginalCycleTimeDays profit marginalProfit marginalNetProfit
1 5 9.615384615384615 0.0026239506631956237 0.0026239506631956237 0.0002728908689723449 0.0002728908689723449 0.09420289855072464 0.09420289855072464 434.78260869565213 434.78260869565213 6.857971014492754 6.857971014492754 52.47901326391248 52.47901326391248 -382.30359543173967
2 5 9.615384615384615 0.048988955182987584 0.04636500451979196 0.005094851339030709 0.004821960470058364 0.18840579710144928 0.09420289855072464 869.5652173913043 434.78260869565213 13.715942028985507 6.857971014492754 979.7791036597516 927.3000903958391 492.51748170018703
3 5 9.615384615384615 0.23081004185594023 0.18182108667295266 0.024004244353017786 0.01890939301398708 0.28260869565217395 0.09420289855072467 1304.3478260869567 434.78260869565247 20.573913043478264 6.857971014492756 4616.200837118805 3636.421733459053 3201.6391247634006
4 5 9.615384615384615 0.6214216554192585 0.3906116135633183 0.0646278521636029 0.040623607810585105 0.37681159420289856 0.09420289855072461 1739.1304347826085 434.7826086956518 27.431884057971015 6.857971014492751 12428.43310838517 7812.232271266365 7377.449662570714
5 5 9.615384615384615 1.235642337982122 0.6142206825628634 0.12850680315014068 0.06387895098653779 0.4710144927536232 0.09420289855072467 2173.913043478261 434.78260869565247 34.28985507246377 6.857971014492758 24712.846759642438 12284.413651257268 11849.631042561616
6 5 9.615384615384615 2.034813204804871 0.7991708668227491 0.2116205732997066 0.08311377014956592 0.5652173913043479 0.09420289855072467 2608.6956521739135 434.78260869565247 41.14782608695653 6.857971014492755 40696.264096097424 15983.417336454986 15548.634727759334
7 5 9.615384615384615 2.9507197946507726 0.9159065898459016 0.30687485864368036 0.09525428534397376 0.6594202898550725 0.09420289855072461 3043.478260869565 434.78260869565156 48.00579710144928 6.857971014492755 59014.395893015455 18318.13179691803 17883.349188222375
8 5 9.615384615384615 3.909273399235697 0.9585536045849246 0.4065644335205125 0.09968957487683217 0.7536231884057971 0.09420289855072461 3478.260869565217 434.782608695652 54.86376811594203 6.8579710144927475 78185.46798471395 19171.072091698494 18736.289483002845
9 5 9.615384615384615 4.846328123038113 0.9370547238024156 0.5040181247959638 0.09745369127545123 0.8478260869565217 0.09420289855072461 3913.0434782608695 434.78260869565247 61.721739130434784 6.857971014492755 96926.56246076226 18741.09447604831 18306.311867352662
10 5 9.615384615384615 5.715007353210409 0.8686792301722965 0.5943607647338826 0.0903426399379188 0.884615384615385 0.036789297658863296 4082.840236686392 169.7967584255225 64.40000000000003 2.67826086956525 114300.14706420818 17373.584603445925 17203.7878450204
11 5 9.615384615384615 6.486842378824565 0.7718350256141555 0.6746316073977547 0.08027084266387219 1.884615384615385 1 8698.224852071007 4615.384615384615 137.20000000000005 72.80000000000001 129736.8475764913 15436.700512283118 10821.315896898494
12 5 9.615384615384615 7.149217796574546 0.6623754177499812 0.7435186508437528 0.06888704344599805 2.884615384615385 1 13313.609467455624 4615.384615384617 210.00000000000003 72.79999999999998 142984.35593149092 13247.50835499962 8632.12373961501
13 5 9.615384615384615 7.701402939540582 0.552185142966036 0.8009459057122206 0.05742725486846778 3.884615384615385 1 17928.99408284024 4615.384615384615 282.8 72.79999999999998 154028.05879081163 11043.702859320707 6428.318243936083
14 5 9.615384615384615 8.150599493469924 0.4491965539293421 0.8476623473208722 0.04671644160865163 4.884615384615385 1 22544.37869822485 4615.38461538461 355.6 72.80000000000001 163011.98986939847 8983.931078586844 4368.546463202249
15 5 9.615384615384615 8.508422714117193 0.3578232206472691 0.8848759622681881 0.0372136149473159 5.884615384615385 1 27159.763313609466 4615.384615384617 428.40000000000003 72.80000000000001 170168.45428234385 7156.464412945381 2541.0797975607566
16 5 9.615384615384615 8.788319367225707 0.27989665310851386 0.9139852141914735 0.029109251923285395 6.884615384615385 1 31775.147928994083 4615.384615384617 501.20000000000005 72.80000000000001 175766.38734451414 5597.933062170283 982.5484467856586
17 5 9.615384615384615 9.003802128542459 0.2154827613167516 0.9363954213684158 0.02241020717694231 7.884615384615385 1 36390.5325443787 4615.384615384617 574 72.79999999999995 180076.04257084918 4309.655226335046 -305.72938904957846
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment