Forum Discussion
df_knapp
May 27, 2020Copper Contributor
Calculating MoQ Against a Forecasted Demand
I need assistance in calculating a Minimum Order Quantity (MoQ) against a Forecast when the Forecast is greater than the MoQ:
For Example:
Cell A1 contains an MoQ of "75": Cell B1 contains a Forecast of "100": Cell C1 contains Order Quantity
Cell A2 contains an MoQ of "150: Cell B2 contains a Forecast of "500": Cell C2 contains Order Quantity
I know that C1 result is 150 and C2 is 600, but I want a flexible formula that calculates this without my having to change it for every cell, since my MoQ's vary.
Anybody with any ideas?
Hopefully this makes sense. Thanks in advance.
4 Replies
- Jos_WoolleyIron Contributor
- PeterBartholomew1Silver Contributor
- df_knappCopper Contributor
- Jos_WoolleyIron Contributor