Interpreting Factory.xlt Template Fields

The following table describes the fields included in the Factory.xlt template. This template is used to import and export factory layout data and consists of three tabs: Stations, Products, and Routings. For import steps, see Importing Data. For export steps, see Exporting Data

Station Data

A Station is an area where a manufacturing process is applied to material or a component to generate a product. Each row in the template represents a station.

Name Station name
Identifier Unique identifier for the station
Setup Cost Rate Cost per unit time to set up the station. This is multiplied by the operation Setup Time for a specific job. The resulting cost is then summed to fixed costs to manufacture the product for that job.
Processing Cost Rate Cost per unit time for processing at the station. This is multiplied by the operation Processing Time for a specific job. The resulting cost is then summed to fixed costs to manufacture the product for that job.
Energy Consumption Rate The power consumption rate for a Station. The value is combined with the job processing time for the station to determine the power consumption for the Station.
Uptime Percentage The percentage that the station is available for operation. The value contributes to the Utilization calculation for this station. You can specify an uptime from 0 to 100%.
Base Point The coordinates of the station's location.
Size The dimensions of the station.

Product Data

A Product can be a single component or assembly that is produced as the output of the manufacturing process. Products can be nested within other products and are represented hierarchically in the Material Flow Browser.
Name Product name
Parent Parent product for which this is a sub-product; used when creating product hierarchies

Routing Data

A product routing displays the flow of the manufacturing process for the given product through the factory.
Name Route name
Root Job indicator, value is either True or False. True indicates the line item represents a job.
Product The product being routed.
Quantity The total number of parts that are produced for the job.
Batch Size

The number of parts that can be transported per trip.

For example: A job produces 100 parts (part quantity). Output from four jobs can be placed on a pallet for transport via forklift. The Batch size is 400.
Desired Production Rate per Min The number of parts produced per minute. Machine Utilization for a station = ((setup time + processing time)*desired production rate per minute for all jobs at the station / percent uptime)*100%
Desired Production Rate per Day The number of parts produced per day. Machine Utilization for a station = ((setup time + processing time) * daily desired production rate for all jobs at the station / (N of shifts * shift hours * percent uptime)) *100%

Machine Utilization for a station = Standard time/Takt time

Takt time = Working time/Demand

Standard time = Sum(Setup time + processing time)

Working time = Number of shifts*shift hours*percent uptime

Demand = Daily desired production rate

Station The station producing the product that is being routed.
Operation Type The type of operation performed: Weld, Assemble, Stamp, Drill or Mill
Processing Time The amount of time required for processing.
Setup Time The amount of time required to set up the operation.
Transportation Type List of transportation types used in the manufacturing process
Speed Speed at which the transportation type travels between stations.
Cost Rate Transportation cost per unit of measure.
Load Time Time required to load product onto the transport method.
Unload Time The amount of time needed to unload the product from the transportation.
Bidirectional The material flow direction, either one-way (unidirectional) or two-way (bidirectional)
Continuity The transportation flow, either continuous or discreet. Continuous flow is ongoing; the resource handles product batches continually. Discrete flow is intermittent based on the means of transportation.

If Continuous, the transportation travel time for a single batch is compared with the station processing time and unload time to determine how many batches are active on the transportation segment at any one time. The transportation cost is then reduced relative to the number of active jobs on the transportation segment.