Spreadsheet: 705623d1606232374-calculate-monthly-production-needs-based-on-aggregate-production-table-production-2021
Sheet: Sheet1

 |  | units left on hand at [NAME]
 |  | Aggregate Production |  |  |  |  |  |  |  | Monthly Production
SKU # | Current Inventory | January | February | March | April | May | June |  |  | January | February | March | April | May | June
1 | 994 | 165.65706428899 | -770.482652480306 | -2083.170637010043 | -3514.2879915368 | -5047.624787031697 | -7500.163454593674
2 | 2247 | 2099.146809624081 | 1932.052677719469 | 1697.747418250741 | 1442.303377447156 | 1168.613909762963 | 730.8535922827512
3 | 577 | 204.6290020162053 | -216.2006635213365 | -806.3027984796138 | -1449.643345688645 | -2138.93533837476 | -3241.442804621219
4 | -330 | -988.2204993772372 | -1732.098819930362 | -2775.191123194847 | -3912.390149290812 | -5130.815112833032 | -7079.659192874567
5 | -57 | -691.1259053900504 | -1407.774071114276 | -2412.683295057931 | -3508.254403393311 | -4682.078120349959 | -6559.583481987313
6 | 1364 | 1213.956391988883 | 1044.386791463462 | 806.6103429655675 | 547.3819460019283 | 269.6378195372293 | -174.6078359797264
7 | 1977 | 1790.814501008103 | 1580.399668239332 | 1285.348600760193 | 963.6783271556772 | 619.0323308126199 | 67.77859768939015
8 | 2028 | 1925.78051035739 | 1810.2586413863 | 1648.269820025204 | 1471.666532556058 | 1282.449122799086 | 979.8000144177047
9 | 1604 | 1391.529489385717 | 1151.409033167238 | 814.7036973381029 | 447.6211498129496 | 54.31924810381372 | -574.7585414603425
10 | 2325 | 2264.0333758203 | 2195.132832541114 | 2098.518071229318 | 1993.186824774506 | 1880.33215538374 | 1699.823580027702
11 | 2501 | 2446.604628725897 | 2385.130491309139 | 2298.929297084841 | 2204.951119110188 | 2104.260426060942 | 1943.207864815136
12 | 1702 | 1539.544025389423 | 1355.946769346084 | 1098.500249682914 | 817.8271678123067 | 517.1066415914038 | 36.11073719956607
13 | 1311 | 1121.163804949438 | 906.6231911459853 | 605.7868086182361 | 277.8092747469651 | -73.5944862302697 | -635.6571160814059
14 | 3688 | 3551.463967405942 | 3397.159756708843 | 3180.788973890808 | 2944.897439914163 | 2692.157042595921 | 2287.90430497222
15 | 1400 | 1169.64107869826 | 909.3042954098398 | 544.2509158425133 | 146.2627930102594 | -280.1521554063467 | -962.1935389372447
16 | 48 | -92.55179825858917 | -251.3943680938378 | -474.1289974653445 | -716.9585177354202 | -977.1324561512574 | -1393.274980175656
17 | 7589 | 7411.211101943031 | 7210.285565554029 | 6928.540722686695 | 6621.377147695715 | 6292.274010011267 | 5765.880739362222
18 | -52 | -221.39229712204 | -412.8285371312746 | -681.2671553868047 | -973.9240317642466 | -1287.484310790087 | -1789.017118964947
19 | 3662 | 3502.099512630488 | 3321.390303311426 | 3067.993504182284 | 2791.735504498406 | 2495.745413521427 | 2022.315736839124
20 | 783 | 686.9866936571196 | 578.4786524449888 | 426.3248666665311 | 260.443921650869 | 82.71471177199834 | -201.5592721719417
21 | 665 | 600.7477493675021 | 528.1340031571028 | 426.3124583015569 | 315.3046776066652 | 196.3680200451396 | 6.131437633985797
22 | 1042 | 992.7156032080272 | 937.0175592398232 | 858.9158060835806 | 773.7677924823853 | 682.5379699209877 | 536.6178640942505
23 | 973 | 894.8751043445764 | 806.5833902023862 | 682.7776481621202 | 547.8022784535586 | 403.1861152821582 | 171.8757253049598
24 | 2097 | 2034.573097396834 | 1964.022241703776 | 1865.093354372535 | 1757.239203811021 | 1641.681428566584 | 1456.849294519383