sign in · new user? sign up
 · feedback
 
Browse Other Models

Browse Other Models
  In Operations Analysis

Customizable Spreadsheet Template: Operations Process Flow

Available Versions

These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.

VersionDescription Download
Price
LightThe Light version has the same features as the Standard version, only it is smaller. It lets you try the customization process and download a customized working template for free. Free
StandardIncludes process transition rates and yield rates, units flow, cost flow in a time-dependent model of operations process flow. $79 $49
AdvancedIncludes everything in the Standard version, plus optional scenarios; an optional selling model with prices, market demand, and statement of operating results; also offers a larger model with more time periods and process stages. $119 $79
Advanced Extra-LargeIncludes all the features in the Advanced version in a larger model with more process stages and time periods. $149 $99
* Customization and preview is always free. If applicable, you'll be asked to buy before downloading a working spreadsheet.
  We offer a money-back guarantee.

Customizable Feature Comparison

Feature Standard & Light
Versions		 Advanced & Extra-Large
Versions		 Comments
Process Setup
Process stages Check Check You choose the number and names of process stages
Time grain and range Check Check You choose the time grain and the number of time periods
Scenarios   Check Supports multiple scenarios for key input data
Flow of Units Through the Process
Transition rates Check Check Matrix of transition rates of good output units to other processing stages for the next time period
Process scrap rates and yield rates Check Check Percentage and number of good input units that become good or reworkable output units at each process stage and each time period; and the percentage and number that become scrap. Includes salvage value of scrap at each processing stage.
Good units available for input Check Check Number of good units available for input to each process stage in each time period
Good units input Check Check Number of goods units input to each process stage, in each time period. Includes number of purchased units input to each process stage.
Good units output Check Check Good units coming out of each process stage in each time period.
Work-in-process inventory units Check Check Number of units of work in process inventory at each process stage at the end of each time period
Processing capacity Check Check Production flow remains within capacity constraints at each process stage in each time period
  • Processing stations/equipment
 Check Check Number of processing stations at each stage and their processing capacities
  • Utilization of capacity
 Check Check Capacity utilization percentage for each processing stage in each time period
Processing Costs
Processing costs Check Check Tracks processing costs by type of cost by stage by time
  • Cost types
 Check Check Tracks several kinds of processing costs (material, labor, capital costs, overhead)
  • Processing costs per unit
 Check Check Processing costs per good and reworkable unit by cost type by stage and time period
  • Scrap costs
 Check Check Cost of scrap and cost per unit, by stage and time period
Cost of processing stations Check Check Period cost of each processing station in each time period
Work-in-process inventory value Check Check Cost of work in process inventory at each processing stage at the end of each time period
Financial results
Demand model Check Market demand model for output units from each process stage in each time period
Units sold Check Units sold from good output of each stage, in each time period
Prices and revenue Check Prices and revenue from sale of good output units from each process stage in each time period
Gross margin Check Gross margin amount and gross margin percent

Version Size Limits

Feature Standard Version Advanced Version Extra Large Version
Time periods 12 30 90
Process Stages 8 32 90
 

Copyright © 2010 by ModelSheet Software LLC | All Rights Reserved | Corporate Home | Privacy

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