EOQ - ANS ROUND(SQRT( (2DCo)/(UCc) ), 0)
AVG inventory - ANS SS + Order Q / 2
Inventory turnover - ANS AVG Sales / AVG Inventory
AVG Co - ANS Co * ( D/Q )
AVG Cc - ANS U * Cc * (Q/2 )
TAC - ANS AVG Co + AVG Cc (+ AVG Cp)
(If quantity discount)
stdDDLT - ANS SQRT( AVGLT * stdD^2 + AVGD^2 * stdLT^2 )
SS - ANS stdDDLT * z(SL)
Reorder point - ANS DDLT + SS
Spec width (S) - ANS USL -LSL
Process width (P) - ANS 6 * std