Hi All, I need a formula that provides the date inventory will run out based on a quantity on hand and a demand forecast. I'm assuming an array function will be necessary.
I would like to assume that the demand per month is evenly spread per day. For example, Item 123A has 500 units on hand. Based on the forecast, I would run out of inventory sometime in July. I would like the run out date to assume a demand of 11.29 units per day in July (350/31) and give me a run out date of 7/17/19.
Appreciate your help!
<tbody>
</tbody>
I would like to assume that the demand per month is evenly spread per day. For example, Item 123A has 500 units on hand. Based on the forecast, I would run out of inventory sometime in July. I would like the run out date to assume a demand of 11.29 units per day in July (350/31) and give me a run out date of 7/17/19.
Appreciate your help!
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 325 | 370 | 500 | 200 | 100 | 350 | 400 | 100 | ||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 200 | 100 | 700 | 600 | 400 | 300 | 500 | 300 | 300 | ||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 50 | 20 | 18 | 20 | 5 | 75 | 80 | 75 | 30 |
<tbody>
</tbody>