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

  • Brendan West
    Brendan West ✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!