The following entity relationship diagram depicts the

This preview shows page 2 - 6 out of 11 pages.

example, we will use the default Material Color list to define the changeover attribute. The following entity relationship diagram depicts the data tables that are used in this example, along with the relations between the tables (Note: see Appendix A Data Tables for a detailed description of the fields in each table). This data schema assumes a product-based routing where the routing is
Image of page 2

Subscribe to view the full document.

defined for each material that can be produced in the facility, and the manufacturing orders refer to each material being produced for that order. It is also possible to configure the tables where a unique routing is specified for each order. This later approach is useful in an engineered to order manufacturing environment. Although the default Gantt display and Logs work fine for many applications, it is convenient to be able to extend the Logs with additional information, and to use this extra information to augment the Gantt display. This add-in will also add three new custom columns to the Resource Usage Log for this purpose. The first specifies the name of the material being produced on the resource. The second is the desired fill color for drawing bars on the Gantt. The third is the desired outline color for drawing these same bars. In addition to creating the tables, the Scheduling button will also automatically generate the sub-classed objects that are used for scheduling. These objects are the same as their Standard Library objects except the default value for the object properties are mapped to the Scheduling tables. In the case of the Server, task sequences are also added to model the setup and processing phases of the server. As the objects are added to the model, they will already be mapped to use the data in the scheduling tables. All the objects in the Navigation window that start with “Sched” are the sub -classed scheduling objects.
Image of page 3
Import the Resources Next, we will populate the Resources table by importing the data from the Resources.csv data file. To do so we first bind to the file by selecting Bind To CSV on the Content ribbon of the Data window, and then browse to and select the Resources.csv file in the Examples folder: C:\Users\Public\Documents\Simio\Examples\DiscretePartProductionFiles. We then set our binding option to manual, and then click on Import to import the resource data into the table. As the data is imported into the table, the objects are automatically added to the model. They are placed in the model at the XLocation and ZLocation coordinates in the Resources table. The resulting model is depicted below:
Image of page 4

Subscribe to view the full document.

Import the remaining csv files Next, we will import the remaining csv files to populate the remaining set of data tables. In each case, we bind to the appropriate csv file, select the binding option to manual, and then import the data. During this process, you may generate errors because of references to undefined items, but these errors will all be removed once all the data has been imported and the references are fully resolved. Also, note that the Manufacturing Orders Output table has no imported data rows of data are added to this table as the simulation executes. The following shows the imported relational data for the Material table.
Image of page 5
Image of page 6
  • Fall '18
  • ivan
  • Comma-separated values, Data element

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern