Operations Process Flow Analysis
ModelSheet: Custom spreadsheets in minutes
Optimize manufacturing, supply chain, business processes
This model is offered in a number of fully customizable versions. Compare these below and choose
the one that suits your business size and needs. Once selected, customizing your spreadsheet is quick and
easy. Your business could be using powerful, professional Excel analysis in minutes.
Each version is free to customize and preview.
| Standard | Pro | Power Pro |
|---|
- Units flow thru process
- Processing costs
- Value of units in process
| All features in Standard version plus:
- Sale of finished units
- Financial summary
- Pivot tables and charts
- Scenarios
| All features in Pro version plus:
- Work Groups
- Larger models with more stages
- More time periods
| | 7 day free trial or $39 | 7 day free trial or $59 | $89 |
|
|
|
|
|
Compare Versions
| | Standard | Pro | Power Pro |
| Process flow - work units | | | |
|---|
| Process stages |  | | |
|
| Transition rates between stages | | | |
|
| Scrap rates | | | |
|
| Units flow: input units, good output, scrap units | | | |
|
| Work in process units and buffer stocks | | | |
|
| Processing capacity & utilization: number & capacities of work stations | | | |
| Processing costs by stage | | | |
|---|
| Material, labor, variable overhead, fixed costs | | | |
|
| Processing cost: total and cost per unit | | | |
|
| Work in process: value and value per unit | | | |
|
| Work in process: value and value per unit | | | |
|
| Finished good: value and value per unit | | | |
|
| Scrap value and salvage value | | | |
| Scenarios | | | |
|---|
| Scenarios for low-medium-high settings for many model features | | | |
|
| Scenarios Transition rates between process stages | | | |
|
| Scenarios for yield rates (= 1 – scrap rates) for each process stage in each time period | | | |
|
| Scenarios for processing capacities for each process stage at each stage and time period | | | |
|
| Scenarios for processing costs (material, labor, overhead, fixed costs) and cost of purchased input units at each stage and time period | | | |
|
| Scenarios for number of purchased units entered into the process at each stage and time period | | | |
| Work Groups | | | |
|---|
| Work Groups, each with its own process flow, yields, and costs | | | |
| Sales model and financial results | | | |
|---|
| Demand and sales of finished goods | | | |
|
| Gross margin (revenue - direct costs) | | | |
| Display Features | | | |
|---|
| Pivot tables | | | |
|
| Pivot charts | | | |
| Custom Model Size Limits | | | |
|---|
| Time periods | 12 | 30 | 90 |
|
| Process stages | 8 | 32 | 90 |
|
| Work Groups | 0 | 0 | 20 |
Works with Microsoft® Excel® 2003 - 2010
Watch our video on how easy it is to customize our models
Customize spreadsheets by filling in a simple form
 | 1. Choose
The model you want |
 | 2. Customize
Online form does the work |
 | 3. Download
And it's ready to use |
Each spreadsheet offers:
- Carefully organized layout
- Comments on every variable table
- Collapsible groups hide details until wanted
- Easy-to-read symbolic formulas show what the model does
- Easily change input data, start date, label text...
Meet your exact needs better than any static template.
Learn more about ModelSheet spreadsheet customization solutions
Related spreadsheet models
Can't find your solution
Need to know more?
Find out how our consulting services can help you create and manage your ideal custom spreadsheet models.
Go to Consulting Services