Monte Carlo Simulation

I want to do The Inventory Management by Monte Carlo Simulation. Then I want to use solver in the simplex LP How to use it?
I try to do it but have pop-up "The linearity conditions required by this LP solver are not satisfied". I think that formula "if" or "average" not to use in simplex LP?

Thanks.

The Linear solver engine solves linear problems, the GRG nonlinear engine can solve smooth nonlinear problems and the Evolutionary engine can handle non-smooth problems and discontinuous functions.

By far the most common discontinuous function in Excel is the IF function where the conditional test depends on the decision variables, as in the example =IF(C1>10,D1,2*D1) where C1 is a variable. Here is a short list of common discontinuous Excel functions:

IF, CHOOSE

LOOKUP, HLOOKUP, VLOOKUP

COUNT

INT, ROUND

CEILING, FLOOR

And some of the common non-smooth Excel functions: ABS, MIN and MAX

So yes using the IF function will not work trying to run Solver using the Simplex linear engine.

Alf