The Process Flow Template for Excel (by ModelSheet) analyzes cost and unit flows for manufacturing or business processes to report cost and unit cost breakdowns by time. Process flows are defined by distinct process stages which have accurate and complete transition rates and time dependent behaviors.
The Process Flow Template for Excel can be customized online for specific process dynamics and downloaded with flexible input parameters. Customization and flexibility of the template allow it to be applicable to any process flow such as factory product manufacturing, administrative business flows and finished product delivery in distribution systems.
The Excel Process Flow Template can accommodate several scenarios for the same process flow and employs the following input data.
Definition of each process stage and flow of work units between stages.
Specification of percentage work unit scrap rate and percentage of accurate and complete output for each process stage.
Application of the number of work units into one or more of the stages which then flow through the subsequent process stages.
Inclusion of material quantities, labor, overhead and fixed equipment costs consumed by processing work units for each process stage.
The resulting analytical reports highlight which stages incur the highest costs and why, as well as the cost breakdown of output units. The process flow of units being processed is represented by transition rates between processing stages and varying yield rates over time.
Key features of the Process Flow Template for Excel include:
Work units can move from any stage to another including rework stages. The process flow is not restricted to a straight line and it can include loops.
The process analysis monitors input units, yield percent, output units, scrap units and scrap percent for each process stage in each time period.
Each process has capacity limits determined by the number of pieces of processing equipment.
Transition rates and process accurate and complete yield rates can vary with time.
Purchased input units can be injected into any stage in the process flow.
Each work unit accumulates cost as it proceeds through the process reporting costs and cost per unit for inputs, units processed, and good units out for each stage in each time period. Furthermore, cost of scrapped units (less salvage value) to good output units at each processing stage are allocated and costs with and without breakout of material, labor, allocated capital expense and overhead are reported.
Analysis is made on sales and operating results for one or more products produced.
Output units can be sold at any process stage.
Sales of each finished product are driven by market demand and limited by available finished units.
Operating reports include revenue, units sold, prices, cost of goods and gross margin.
Multiple scenarios can be simulated for which process parameters (e.g. process transition rates, process costs and yields) vary across scenarios.
