Hello,
I am building an inventory production schedule and need help writing a formula for the following logic.
For example, in Row A, Column A:L (January-December), I have projected sales of 25 units per month (starting in June). Additionally, my minimum monthly production order is for 30 units (Row B).
Therefore, my ending inventory each month is 5 units. At the end of 5 months, I should have accumulated 25 units in inventory and not have to produce any units on the 6th month.
How would I write a formula that displays the following without having to do any manual entry. My main issue is overcoming circular references. Thanks in advance for the help!
<tbody>
</tbody>
I am building an inventory production schedule and need help writing a formula for the following logic.
For example, in Row A, Column A:L (January-December), I have projected sales of 25 units per month (starting in June). Additionally, my minimum monthly production order is for 30 units (Row B).
Therefore, my ending inventory each month is 5 units. At the end of 5 months, I should have accumulated 25 units in inventory and not have to produce any units on the 6th month.
How would I write a formula that displays the following without having to do any manual entry. My main issue is overcoming circular references. Thanks in advance for the help!
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Sales | 0 | 0 | 0 | 0 | 0 | 25 | 25 | 25 | 25 | 25 | 25 | 25 |
Production | 0 | 0 | 0 | 0 | 0 | 30 | 30 | 30 | 30 | 30 | 0 | 30 |
Ending Inv. | 0 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | 20 | 25 | 0 | 5 |
<tbody>
</tbody>