|
|
|
 |
 |
| June: |
Tips and Techniques Modeling Tip: ProModel/MedModel/ServiceModel Many
modelers have asked how to build flexible routings using table inputs
such as Excel worksheets. This is really a simple task if you understand
the use of the Loc() function and Array imports. The following model shows
you how to accomplish this. Model
Description: A
small print shop receives orders via an on-line ordering system.
Orders accumulate throughout the night and begin processing when
the print shop opens in the morning. Orders consist of either Black & White
printing only or both Color and Black & White. Two styles of
binding are used, based on the order type. Process: All orders go through an initial
Preprint process. Black & White only orders are then routed to
the B/W printers and on to Binding area 2. Color + B/W orders are
first sent through the Black & White printers and then on to
the Color printers. The binding process for these orders requires
operations at both Binding area 1 and Binding area 2. The final operation
for all orders occurs at the Shipping area. Solution: The solution begins by creating a
routing table for each product type. The example below shows the
routings for Product 1 and Product 2. Note that the entries in cells
B2 through G3 are simply the names of the locations through which
the products will be routed. This is possible because ProModel automatically
converts Location names to Location Index Numbers when assigning
an expression to an attribute or variable through an Expression Array.
(This conversion also applies to Entity and Resource names that are
referenced in expressions.) That’s
about all there is to it. To download a copy of this model, click
here. Happy
modeling…
|
