| 1.OM-FORECASTING |
|
21/Jun/2007 |
|
|
Operations Manager Forecasting Templates include: Simple exponential smoothing, Smoothing linear, exponential, and damped trends, and two additional models for managing seasonal adjustments.
|
|
|
| 2.OM-ADDITMON |
|
21/Jun/2007 |
|
|
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. Seasonal adjustment removes the seasonal pattern so that you can concentrate on forecasting the mean or trend
|
|
|
|
|
| 4.OM-APP |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Aggregate production planning. APP.xls is a strategic planning model that helps management develop targets for aggregate production and inventory quantities, work force levels, and overtime usage for up to 12 months ahead.
|
|
|
| 5.OM-INVENTORY MANAGEMENT |
|
|
22/Jun/2007 |
|
|
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).
|
|
|
| 6.OM-QUALITY CONTROL |
|
|
22/Jun/2007 |
|
|
Excel Templats 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.
|
|
|
| 7.OM-FACILITY LOCATION |
|
|
22/Jun/2007 |
|
|
Excel Template for Facility Location includes model for Center-of-gravity method for locating distribution centers.
|
|
|
| 8.OM-ANALYSIS OF WAITING LINES |
|
|
22/Jun/2007 |
|
|
Excel Templates for analysis of Waiting Lines include 2 models: Single-server queues and Multiple-server queues.
|
|
|
| 9.OM-EOQ |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Economic order quantity (EOQ). The basic EOQ model in finds that particular quantity to order which minimizes the total variable costs of inventory.
|
|
|
| 10.OM-PRODUCTION PLANNING |
|
|
22/Jun/2007 |
|
|
Excel Templates for Production Planning include: Aggregate production planning, Run-out time production planning, and Learning curves.
|
|
|
| 11.OM-ROP |
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Reorder points and safety stocks. When demand is uncertain, the OM-ROP worksheet computes reorder points and safety stocks to meet a variety of customer service goals.
|
|
|
| 12.OM-MRP1 |
|
|
22/Jun/2007 |
|
|
MRP1 computes weekly net requirements for an inventory item for up to 20 weeks in the future. The model then schedules planned order releases and receipts to satisfy those requirements. Leadtimes can range from 0 to 6 weeks.
|
|
|
| 13.Resource Manager for Excel |
|
|
22/Jun/2007 |
|
|
Resource Manager will help you plan and schedule your key resources (workcenters, material, labor) quickly, easily, and affordably. Use just a piece to fill in the gaps of your current system, or use all of it -- Resource Manager for Excel delivers the benefits of manufacturing software without the pain. Guaranteed.
|
|
|
| 14.Resource Manager for Excel/PLAN |
|
|
22/Jun/2007 |
|
|
Resource Manager for Excel/PLAN is a subset of Resource Manager for Excel/FULL and includes all sheets except Orders.
Key features include: -
Build and Maintain multi-level, costed Bills of Material
-
Build and Maintain Routings
-
Multi-Job Scheduling (Forward, Reverse, and more)
-
Batch Rescheduling
-
Order Entry
-
Rough Cut Capacity
-
Full Reporting
-
Gross MRP Reporting
-
Inventory and Adjustments
-
Inventory Reporting
-
Adjusted MRP Schedules
-
Tracking Actuals
-
Rescheduling with Actuals
|
|
|
| 15.Resource Manager for Excel/FORE |
|
|
22/Jun/2007 |
|
|
Resource Manager for Excel/FORE is a subset of Resource Manager for Excel/FULL and includes all sheets except Plan, and Orders.
Key features include: -
Build and Maintain multi-level, costed Bills of Material
-
Build and Maintain Routings
-
Multi-Job Scheduling (Forward, Reverse, and more)
-
Batch Rescheduling
-
Order Entry
-
Rough Cut Capacity
-
Full Reporting
-
Gross MRP Reporting
|
|
|
| 16.Resource Manager for Excel/BOR |
|
|
22/Jun/2007 |
|
|
Resource Manager for Excel/BOR is a subset of Resource Manager for Excel/FULL and includes all sheets except Forecast, Plan, and Orders.
Key features include: -
Build and Maintain multi-level, costed Bills of Material
-
Build and Maintain Routings
-
Single Job Scheduling (Forward and\or Reverse)
-
Rough Cut Capacity
-
Full Reporting
-
Gross MRP Reporting
|
|
|
| 17.Resource Manager for Excel/FULL |
|
|
22/Jun/2007 |
|
Resource Manager for Excel/FULL contains the functionality of high-end systems, without the complexity and expense. An add-on for existing systems, or stand-alone, Resource Manager adapts to your specific needs. Key features include: -
Easily integrates with all systems
-
General purpose resource management tool for projects that contain any combination of people, materials, and equipment
-
Dynamic finite capacity analysis
-
A great stand alone scheduler
-
Priority Scheduling
-
Costing & estimating
-
True Windows GUI
-
Inventory Management & MRP
-
Excel Integration
-
Planning
-
Rough-cut capacity planning
-
Bills-Of- Material/Resources containing material, workcenters, & labor requirements.
|
|
|
| 18.OM-MULTIQ |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Analysis of Waiting Lines, Multiple Queues. In almost every organization, there are examples of processes which generate waiting lines called queues. The worksheets in this chapter automate the most practical models for analyzing the behavior of queues. MULTIQ analyzes problems in which customers form a single queue processed by 2 or more servers. MULTIQ assumes that arrivals are Poisson, service times are exponential, and there is no restriction on queue capacity or the size of the source population.
|
|
|
| 19.OM-SINGLEQ |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Analysis of Waiting Lines, single server queue. In almost every organization, there are examples of processes which generate waiting lines called queues. These worksheets automate the most practical models for analyzing the behavior of queues. SINGLEQ includes 4 alternative models for a single queue processed by a single server or service facility. All models in SINGLEQ assume that arrivals to the queue are generated by a Poisson process. The models differ in the probability distribution that generates service times, the queue capacity or waiting space available, and the size of the source population feeding the queue.
|
|
|
| 20.OM-LIMIT |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Templates for Quality Control, Control limit calculator. If you do not want to prepare a complete control chart, use LIMIT to compute control limits for mean and range, percent defective, and defects per unit.
|
|
|
| 21.OM-CU_CHART |
|
|
22/Jun/2007 |
|
|
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. Common quality characteristics include teh number of defects per unit (CU-CHART). If the process is under control, the quality characteristics should vary about the population mean in a random manner. If a sample mean falls outside the control limits, there is a very small probability that this happened due to randomness or chance alone and the process should be investigated.
|
|
|
| 22.OM-P_CHART |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Templates for Quality Control, Control chart for percent defective. 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. Common quality characteristics include the percent defective (P-CHART). If the process is under control, the quality characteristics should vary about the population mean in a random manner. If a sample mean falls outside the control limits, there is a very small probability that this happened due to randomness or chance alone and the process should be investigated
|
|
|
| 23.OM-I_CHART |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Templates for Quality Control, Control chart for individual observations. Monitor individual quality observations rather than samples with I-CHART.xls. 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. If the process is under control, the quality characteristics should vary about the population mean in a random manner. If a sample mean falls outside the control limits, there is a very small probability that this happened due to randomness or chance alone and the process should be investigated.
|
|
|
| 24.OM-MR_CHART |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Templates for Quality Control, Control chart for mean and range. 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. If the process is under control, the quality characteristics should vary about the population mean in a random manner. If a sample mean falls outside the control limits, there is a very small probability that this happened due to randomness or chance alone and the process should be investigated.
|
|
|
| 25.OM-ACCEPTSA |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Templates for Quality Control, Acceptance sampling. Sampling is the basis for most quality analysis. The ACCEPTSA model is used to sample incoming lots of material. The aim is to prevent lots containing unacceptable numbers of defective units from passing into the manufacturing system.
|
|
|
| 26.OM-SKED3A |
|
|
22/Jun/2007 |
|
|
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. Each job receives exactly the same processing at each station. In such flow shops, there is no attempt to minimize lateness; instead, the objective is to minimize the total time needed to complete a batch of jobs.
|
|
|
| 27.OM-SKED2A |
|
|
22/Jun/2007 |
|
|
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. Each job receives exactly the same processing at each station. In such flow shops, there is no attempt to minimize lateness; instead, the objective is to minimize the total time needed to complete a batch of jobs.
|
|
|
| 28.Spreadsheet QC |
|
|
22/Jun/2007 |
|
|
Spreadsheet QC is a collection of templates for use with Excel, Lotus & Quattro Pro. It is ideally suited for small operations which are just beginning to implement quality improvement programs, as well as for large operations, to complement existing Total Quality Management systems, for flexible, ad-hoc reporting and individual training. By automating the main techniques in a familiar spreadsheet format, Spreadsheet QC makes statistical process and quality control more accessible.
|
|
|
| 29.OM-SKED1A |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Job sequencing a single work station. SKED1A, SKED2A, and SKED3A schedule a group of jobs which can be done in any sequence. These models differ in the number of work stations required to process the jobs. SKED1A schedules jobs for a single work station. This station can be independent of all other processing or it can be part of a manufacturing system so complex that the only option is to schedule each work station independently. In SKED1A, you can choose to minimize flow time, the number of jobs that are late, or the maximum time late for any job.
|
|
|
| 30.OM-LEARN |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Learning curves data. LEARN is a tool for projecting costs or production hours per unit as cumulative production increases.
|
|
|
| 31.OM-RUNOUT |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Run-out time production planning. RUNOUT is a tactical model that balances production for a group of stock items, usually on a weekly basis. The aim is to give each item in the group the same run-out time, defined as the number of weeks stock will last at current demand rates.
|
|
|
| 32.OM-POQ |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Material Requirements Planning (MRP) using Period-order-quantity (POQ). The POQ model is an alternative lot-sizing model for coping with lumpy demand.
|
|
|
| 33.OM-EOQPROD |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Economic order quantity (EOQ) with production lot sizes.The basic EOQ model finds that particular quantity to order which minimizes the total variable costs of inventory. If the EOQ is produced in-house rather than purchased from vendors, use the OM-EOQPROD model.
|
|
|
| 34.OM-EOQDISC |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Economic order quantity (EOQ) with quantity discounts.The basic EOQ model in finds that particular quantity to order which minimizes the total variable costs of inventory. OM-EOQDISC should be used for cases where vendors offer price discounts based on the quantity purchased.
|
|
|
| 35.OM-EOQBACK |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Economic order quantity (EOQ) with quantity discounts and back orders. The basic EOQ model finds that particular quantity to order which minimizes the total variable costs of inventory. When backorders are possible, a modified EOQ model is available in EOQBACK.
|
|
|
| 36.OM-MULTIMON |
|
|
22/Jun/2007 |
|
|
Excel Spreadsheet Template for Ratio-to-moving-average seasonal adjustment. If your data contain a seasonal pattern, perform a seasonal adjustment before you apply exponential smoothing. Seasonal adjustment removes the seasonal pattern so that you can concentrate on forecasting the mean or trend.
|
|
|
| 37.OM-TRENDSMOOTH |
|
|
22/Jun/2007 |
|
|
Demand forecasting models include the trend-adjusted smoothing model. TRENDSMOOTH lets you compare several different types of trend before committing to a forecast.
|
|
|
| 38.OM-SIMPLE |
|
|
22/Jun/2007 |
|
|
The exponential smoothing models extrapolate historical data patterns. Simple exponential smoothing is a short-range forecasting tool that assumes a reasonably stable mean in the data with no trend (consistent growth or decline).
|
|
|
| 39.OM-SCHEDULING |
|
|
22/Jun/2007 |
|
|
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.
|
|
|
