Operations Process Flow Analysis

ModelSheet: Custom spreadsheets in minutes

Optimize manufacturing, supply chain, business processes 

This model simulates flow of work units and unit costs through a process with discrete stages.

Improvements you might make include:

  1. 1. Increase/decrease capacity
  2. 2. Decrease scrap rates
  3. 3. Re-route process flow
  4. 4. Add buffer stocks

The model has these features:

  • Process stages
  • Transition rates between stages
  • Input, WIP, buffer stock & ouput units
  • Scrap rates & costs
  • Processing costs by stage
  • Labor, material, overhead
  • Equipment, investment, capacity
  • Market model for finished goods
  • Financial summary of operations
  • Scenarios

Fully Customizable

Using our automated modelling technology you can create a report that exactly suits your needs. Turn on and off major features, specify time line, "dimensions" such as process stages, currency symbols, and date formats in a simple online form.

Easy to Use

Once downloaded, your data is presented, in a logical and intuitive format in Excel. Your Customer Support spreadsheet contains:
  • A carefully arranged layout
  • Comments on every variable table
  • Collapsible groups hide detail until needed
  • Easy to understand symbolic formulas
  • Easy modifiable data and preferences

This model explores many ways to improve customer support operations.

 
StandardProPower 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 $397 day free trial or $59$89
Microsoft Office Marketplace logo
Works with Microsoft® Excel® 2003 - 2010
 

Customize spreadsheets by filling in a simple form

Step 11. Choose
The model you want
Step 22. Customize
Online form does the work
Step 33. 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
 
 

Copyright © 2010, 2011 by ModelSheet Software LLC | All Rights Reserved | Privacy

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.