Highlighted
New 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
Highlighted

# Re: Calculating MoQ Against a Forecasted Demand

Hi,

=CEILING(B1/A1,1)*A1

Regards

Highlighted

# Re: Calculating MoQ Against a Forecasted Demand

It worked!

Thank you for the response and the solution, Jos.

Dan

Highlighted

# Re: Calculating MoQ Against a Forecasted Demand

This can be simplified a little to read

= CEILING(Forecast, MoQ)

Highlighted

# Re: Calculating MoQ Against a Forecasted Demand

You're very welcome!