MBE $7$ Column L $$ Demand Filled, the number of orders filled each month

$$ If demand is less than or equal to the available inventory, the entire demand is satisfied. If

demand exceeds the available inventory, only the demand up to the available inventory is

satisfied.

$$ In L$3$ enter: $=$ MIN$($Available Inventory for month $1,$Demand for month $1)$

$$ You are to write the formula for L$3$ yourself copy it to L$4$ thru L$14$

$$ Column M $$ Ending Inventory, the number of units carried over to the next month

$$ If the demand is less than or equal to the available inventory units, carry over the remaining

inventory to the next month, otherwise there is no inventory to start the next month

$$ M$3=$ MAX$($Available Inventory for month $1$Demand Filled for month $1,0)$

$$ You are to write the formula for M$3$ yourself copy it to M$4$ thru M$14$

$$ We use this max function so that we never try to carry a negative inventory; note that

demand not satisfied is not backordered, the sale is simply lost

$$ Column N $$ Stockout, the number of orders not filled

$$ If the demand exceeds the available inventory we have a stockout; if demand is less than

available inventory there is no stockout

$$ N$3=$ IF$($Demand for month $1>$Available inventory for Month $1,$

$$Demand for Month $1-$Available inventory for Month $1,0)$

$$ You are to write the formula for N$3$ yourself copy it to N$4$ thru N$14$ Adding more constraints can lead to a more optimal answer: