Manufacturing/Operations Excel Templates

Excel Templates for Manufacturing and Operations

BUY | Operations Management Templates

Operations Manager contains 33 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.

30 Day Money Back Guarantee! Fully Editable & Open Source! All templates Run With Excel, Lotus & Quattro Pro

Manufacturing/Operations Excel Templates Consists Of:

OM-ADDITMON Excel Spreadsheet Template for Additive seasonal adjustment for monthly data: If your data contain a seasonal pattern, perform a seasonal adjustment before you apply exponential smoothing.

OM-ACCEPTSA Excel Spreadsheet Templates for Quality Control, Acceptance sampling. Sampling is the basis for most quality analysis.

OM-ANALYSIS OF WAITING LINES Excel Templates for analysis of Waiting Lines include 2 models: Single-server queues and Multiple-server queues.

OM-APP Excel Spreadsheet Template for Aggregate production planning.

OM-CU_CHART Excel Spreadsheet Templates for Quality Control, Control chart for number of defects. In all of the control charts, the basic idea is to sample from a continuous production process at equal intervals of time and record some quality characteristic.

OM-EOQ Excel Spreadsheet Template for Economic order quantity (EOQ). T

OM-EOQBACK Excel Spreadsheet Template for Economic order quantity (EOQ) with quantity discounts and back orders.

OM-EOQPROD Excel Spreadsheet Template for Economic order quantity (EOQ) with quantity discounts

OM-EOQPROD Excel Spreadsheet Template for Economic order quantity (EOQ) with production lot sizes.

OM-FACILITY LOCATION Excel Template for Facility Location includes model for Center-of-gravity method for locating distribution centers.

OM-FORECASTING Operations Manager Forecasting Templates include: Simple exponential smoothing, Smoothing linear, exponential, and damped trends, and two additional models for managing seasonal adjustments.

OM-INVENTORY MANAGEMENT Excel based inventory management templates include: Economic order quantity, EOQ with backorders, EOQ with quantity discounts, EOQ for production lot sizes, and Reorder points and safety stocks (ROP).

OM-I_CHART Excel Spreadsheet Templates for Quality Control, Control chart for individual observations.

OM-LEARN Excel Spreadsheet Template for Learning curves data. LEARN is a tool for projecting costs or production hours per unit as cumulative production increases.

OM-LIMIT Excel Spreadsheet Templates for Quality Control, Control limit calculator.

OM-MATERIAL REQUIREMENTS PLANNING Excel templates for Material Requirements Planning include: MRP inventory plan and Period-order-quantity.

OM-MRP1 Excel Spreadsheet Templates for basic MRP inventory plan. MRP1.xls develops detailed inventory plans for individual items for up to 20 weeks into the future.

OM-MR_CHART Excel Spreadsheet Templates for Quality Control, Control chart for mean and range.

OM-MULTIMON Excel Spreadsheet Template for Ratio-to-moving-average seasonal adjustment.

OM-MULTIQ Excel Spreadsheet Template for Analysis of Waiting Lines, Multiple Queues.

OM-POQ Excel Spreadsheet Template for Material Requirements Planning (MRP) using Period-order-quantity (POQ).

OM-PRODUCTION PLANNING Excel Templates for Production Planning include: Aggregate production planning, Run-out time production planning, and Learning curves.

OM-P_CHART Excel Spreadsheet Templates for Quality Control, Control chart for percent defective.

OM-QUALITY CONTROL Excel Templates for Quality Control include 6 models: Acceptance sampling, Control chart for mean and range, Control chart for individual observations, Control chart for percent defective, Control chart for number of defects and Control limit calculator.

OM-ROP Excel Spreadsheet Template for Reorder points and safety stocks.

OM-RUNOUT Excel Spreadsheet Template for Run-out time production planning.

OM-SCHEDULING Excel Templates for Scheduling incluede three models: Job sequencing for a single work station, Job sequencing for 2 work stations in series, and Job sequencing for 3 work stations in series.

OM Simple The exponential smoothing models extrapolate historical data patterns.

OM-SINGLEQ Excel Spreadsheet Template for Analysis of Waiting Lines, single server queue.

OM-SKED1A Excel Spreadsheet Template for Job sequencing a two work stations in series.

OM-SKED2A Excel Spreadsheet Template for Job sequencing a two work stations in series. SKED2A schedule a group of jobs which can be done in any sequence. SKED2A and SKED3A are designed for flow shops of 2 or 3 work stations arranged in series.

OM-SKED3A Excel Spreadsheet Template for Job sequencing three work stations in series. SKED3A schedule a group of jobs which can be done in any sequence. SKED3A is designed for flow shops of 3 work stations arranged in series.

OM-TRENDSMOOTH Excel Spreadsheet Template for Job sequencing three work stations in series.

All Operation Management Templates Payment Problems/Option 30 Day Money Back Guarantee! Fully Editable & Open Source!

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS