Operations Manager contains 35 templates for manufacturing and operations decision support. All templates have a simple, consistent interface and include an actual application. Runs with Excel, Lotus & Quattro Pro. Benefits include: adjust for seasonality and predict trends, optimize economic order quantity, determine best inventory (includes reorder points & safety stocks) and workforce levels, improve production throughput and enhance customer service.
These templates are:
FORECASTING
OM-SIMPLE: Simple exponential smoothing
OM-TRENDSMOOTH: Smoothing linear, exponential, and damped trends
OM-MULTIMON: Ratio-to-moving-average seasonal adjustment
OM-ADDITMON: Difference-to-moving-average seas. adj. for mo. data
INVENTORY MANAGEMENT
M-EOQ: Economic order quantity Info
M-EOQBACK: EOQ with backorders Info
M-EOQDISC: EOQ with quantity discounts
M-EOQPROD: EOQ for production lot sizes
M-ROP: Reorder points and safety stocks
MATERIAL REQUIREMENTS PLANNING
OM-MRP1: MRP inventory plan
OM-POQ: Period-order-quantity
PRODUCTION PLANNING
OM-APP: Aggregate production planning
OM-RUNOUT: Run-out time production planning
OM-LEARN: Learning curves
FACILITY LOCATION
OM-CENTER: Center-of-gravity method for locating dist. cntrs
SCHEDULING
OM-SKED1A: Job sequencing for a single work station
OM-SKED2A: Job sequencing for 2 work stations in a series
OM-SKED3A: Job sequencing for 3 work stations in a series
QUALITY CONTROL
OM-ACCEPTSA: Acceptance sampling
OM-MR_CHART: Control chart for mean and range
OM-I_CHART: Control chart for individual observations
OM-P_CHART: Control chart for percent defective
OM-CU_CHART: Control chart for number of defects
OM-LIMIT: Control limit calculator
ANALYSIS OF WAITING LINES
OM-SINGLEQ: Single-server queues
OM-MULTIQ: Multiple-server queues |
