Forum Discussion

df_knapp's avatar
df_knapp
Copper Contributor
May 27, 2020

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

Resources