Formula to Forecast Material Quantity Received vs Consumed
I am hoping there is a formula to see what I will need to forecast to purchase for material received vs consumed. Any help would be greatly appreciated!
Best Answer
-
Got this figured out. Wanted to put the formula in the thread.
=[Consumed Quantity-KCCI]182 / [Quantity Received]182 * [Remaining Quantity-KCCI]182
This figures the rate of consumption and gives an estimated amount to stay ahead of the material being consumed.
Answers
-
Hi, there probably is but it's hard to say with this level of info. Can you be more specific about how you are trying to forecast, what data is being factored in, etc.? A screenshot of your Sheet or published link would be helpful too.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
I want to forecast how much material we need to order. I want to do they by forecasting the Consumed Quantity vs. Quantity Ordered. I think we may need to put dates in but kind of at a stand still
-
@Dan Palenchar Have you had time to review? I actually have added date columns now. But really hoping I can forecast material that we may need at the rate we consume it. We can go through material so quickly and will help us with ordering.
Thanks for your assistance.
-
Got this figured out. Wanted to put the formula in the thread.
=[Consumed Quantity-KCCI]182 / [Quantity Received]182 * [Remaining Quantity-KCCI]182
This figures the rate of consumption and gives an estimated amount to stay ahead of the material being consumed.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!