# Forecasting remaining stock item availability based on historical use in production

**URL:** <https://community.breww.com/t/forecasting-remaining-stock-item-availability-based-on-historical-use-in-production/1318>\
**Category:** Ideas & feature requests\
**Created:** [21 June 2022 13:06 UTC](https://community.breww.com/t/forecasting-remaining-stock-item-availability-based-on-historical-use-in-production/1318 "2022-06-21T13:06:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lewis-hill](https://community.breww.com/user_avatar/community.breww.com/lewis-hill/32/139_2.png) [@lewis-hill](https://community.breww.com/u/lewis-hill)\
**Post date:** [21 June 2022 13:06 UTC](https://community.breww.com/t/forecasting-remaining-stock-item-availability-based-on-historical-use-in-production/1318/1 "2022-06-21T13:06:39Z")

</div>

A good feature would be having a forecast on the inventory screen like there is on product screens. Based on usage over a prior set period to give an idea of how long items will last without us needing to input (or actually knowing) what our production schedule will be.

E.g. I could click on a hop now and it would tell me based on last 3 month production how long the remaining kilograms would last.

---

<div class="post-metadata">

**Author:** ![lewis-hill](https://community.breww.com/user_avatar/community.breww.com/lewis-hill/32/139_2.png) [@lewis-hill](https://community.breww.com/u/lewis-hill)\
**Post date:** [6 September 2023 08:34 UTC](https://community.breww.com/t/forecasting-remaining-stock-item-availability-based-on-historical-use-in-production/1318/2 "2023-09-06T08:34:27Z")

</div>

Hello again, following up my own post.

I still think the feature I imagine (but perhaps can’t articulate) would be a helpful one…

Basically it’s just the same report function that generates ‘Stock availability forecast’ on the Product side but applied to Inventory items.

So we’d get a graph/chart like this for, say, Citra hops based on how much Citra hops we’ve used over _x_ period.

 ![Screenshot 2023-09-06 at 09.31.29](https://breww-community.fra1.digitaloceanspaces.com/original/2X/d/de6f4cc1e1b53f49443d4da06fcbae5920e26cc4.png)

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [6 September 2023 14:46 UTC](https://community.breww.com/t/forecasting-remaining-stock-item-availability-based-on-historical-use-in-production/1318/3 "2023-09-06T14:46:54Z")

</div>

Thanks, Lewis. I think this would be really useful and I’m sorry that we haven’t got to this yet.

I’ve renamed the thread a little to hopefully attract more votes. If you can vote for it too, that will make a difference to its priority. If anyone else would find this useful, please vote using the button in the top-left 👍