File_Name: Cookie Making.xls Table Name Table Tabs Rows 49 Cols 2 Table Format 0 Table Note Each table and its associated tab are defined here. Field Notes Select table and use DB Menu|Go to Selected Table Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Tab Name Table Name 1 Table Outline Table Tabs 2 Database Structure Indexed Fields 3 Database Structure Yes/no 4 Database Structure Records/Fields 5 Database Structure Start Modes 6 Database Structure End Modes 7 Database Structure Days 8 Database Structure System Status 9 Database Structure Scheduled DT Cycles 10 Database Structure Time Units 11 Database Structure Order Status 12 Database Structure Priorities 13 Database Structure Shipment Status 14 Database Structure Units 15 Database Structure Model Start Date 16 Materials Materials Directory 17 Materials Material Types 18 Materials Formulations 19 Materials Materials Data 20 Materials Item Types 21 Locations Location Types 22 Locations Location Data 23 Bill of Materials Bill of Materials 24 Inventories Inventories 25 Demand Base Demand 26 Demand Forecast Error 27 Demand Profile Projection Tulsa 28 Demand Profile Projection Spokan 29 Demand Profile Projection San Diego 30 Demand Profile Projection Albuquerque 31 Demand Profile Projection Billings 32 Demand Profile Projection Minneapolis 33 Demand Profile Projection Shreveport 34 Demand Profile Projection Birmingham 35 Demand Profile Projection Columbia 36 Demand Profile Projection Albany 37 Demand Profile Projection Grand Rapids 38 Demand Profile Projection Des Moines 39 Orders Orders 40 Shipments Shipments 41 Shipments Shipment Routing 42 Shipments Trip Routes 43 Shipments Trip Times 44 Plant Plant Schedule 45 Plant Packing Failures 46 Plant Packing Rates by SKU 47 Plant Setup Time by SKU 48 Plant Production Line Schedule 49 Shipments Material Trip Times Table Name Indexed Fields Rows 35 Cols 5 Table Format 0 Table Note Child fields are defined here. A child field allows you to represent a string value as an integer inside the model. As an integer, it can be reported by connectors, and thus used in block-to-block communications. It effectively eliminates the simulation p Field Notes Name of Table with Child Field Name of Field containing non-unique strings, all of which must match a string in the Parent Field. Name of Table with Parent Field Name of Field containing unique strings. Enter a 1 if the child field can have blanks. If it cannot have blanks, then it must match one of the Parent Field values. Field Types 1 1 1 1 2 Field Formats 0 0 0 0 0 Field Access 0 0 0 0 0 Field Names Child Table Child Field Parent Table Parent Field Optional 1 Materials Data Formulation Formulations Formulation 1 2 Location Data Type Location Types Name 0 3 Bill of Materials Material Materials Data Material 1 4 Bill of Materials Part Materials Data Material 1 5 Materials Data Units Units Name 0 6 Materials Data Type Material Types Type 0 7 Inventories Location Location Data Name 0 8 Inventories Material Materials Data Material 0 9 Inventories Supplier Location Data Name 1 10 Base Demand Product Materials Data Material 0 11 Orders Customer Location Data Name 1 12 Orders Supplier Location Data Name 1 13 Orders Item Type Item Types Name 1 14 Orders Item Materials Data Material 1 15 Orders Priority Priorities Name 1 16 Orders Status Order Status Name 1 17 Shipments From Location Location Data Name 1 18 Shipments To Location Location Data Name 1 19 Shipments Priority Priorities Name 1 20 Shipments Item Type Item Types Name 1 21 Shipments Item Materials Data Material 1 22 Shipments Current Location Location Data Name 1 23 Shipments Status Shipment Status Name 1 24 Shipments Auto Route Yes/no Name 1 25 Shipment Routing Priority Priorities Name 1 26 Shipment Routing Item Type Item Types Name 1 27 Shipment Routing Location Location Data Name 1 28 Shipment Routing Customer Location Data Name 1 29 Setup Time by SKU SKU Materials Data Material 0 30 Packing Rates by SKU SKU Materials Data Material 0 31 Trip Routes Location Location Data Name 0 32 Trip Times From Location Location Data Name 0 33 Trip Times To Location Location Data Name 0 34 Material Trip Times From Location Location Data Name 1 35 Material Trip Times To Location Location Data Name 1 Table Name Yes/no Rows 2 Cols 1 Table Format 0 Table Note Field Notes Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 yes 2 no Table Name Records/Fields Rows 2 Cols 1 Table Format 0 Table Note Field Notes Field Types 1 Field Formats 0 Field Access 0 Field Names name 1 Records 2 Fields Table Name Start Modes Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Modes Description 1 Start Time Specified start time. 2 When Ready When setup complete from prior run. 3 Users Start When any user run has started. Table Name End Modes Rows 8 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Modes Description 1 Next ST End at next start time. 2 End Time Specified end time. 3 Goal Use the specified goal. 4 1st of ET & goal First of end time and goal. 5 1st of ST & goal First of start time of next run and goal. 6 2nd of ET & goal Second of end time and goal. 7 Users Goals met All user goals are met. 8 Source Empty End when source is empty. Table Name Days Rows 7 Cols 1 Table Format 0 Table Note Field Notes Parent Field Field Types 1 Field Formats 0 Field Access 0 Field Names Day 1 Mon 2 Tue 3 Wed 4 Thu 5 Fri 6 Sat 7 Sun Table Name System Status Rows 4 Cols 1 Table Format 0 Table Note Field Notes Field Types 1 Field Formats 0 Field Access 0 Field Names Status 1 Ready 2 Running 3 Emptying 4 Empty Table Name Scheduled DT Cycles Rows 8 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Cycle Description 1 Once only no cycle 2 Shift (8 hrs) every eight hours 3 Shift (10 hrs) every ten hours 4 Shift (12 hrs) every twelve hours 5 Daily every twenty-four hours 6 Weekly every seven days 7 Bi-Weekly every fourteen days 8 Monthly every twenty-eight days Table Name Time Units Rows 5 Cols 1 Table Format 0 Table Note Field Notes Parent Field Field Types 1 Field Formats 0 Field Access 0 Field Names Units 1 seconds 2 minutes 3 hours 4 days 5 weeks Table Name Order Status Rows 8 Cols 2 Table Format 0 Table Note Field Notes Parent table for Orders field ""Status"" Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 placing Placed with a delay 2 placed Placed and awaits assignment 3 assigning Assigned with a delay 4 assigned Assigned and awaits being filled 5 filling Partially filled 6 filled filled 7 delivering partially delivered 8 delivered delivered Table Name Priorities Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent table for Orders field ""Priority"" Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 urgent Below safety level 2 regular Below order point 3 low Above order point Table Name Shipment Status Rows 3 Cols 2 Table Format 0 Table Note "Defines the status categories for shipments. Field Notes Provides choice list for the units of materials Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Ready Ready to be Routed 2 Filling Other shipments may be added to it, so don not route 3 Routing On the way somewhere, or being loaded or unloaded. Table Name Units Rows 5 Cols 1 Table Format 0 Table Note Field Notes Provides chcoice list for the units of materials. Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 litres 2 cases 3 kg 4 Pieces 5 Pallets Table Name Model Start Date Rows 1 Cols 1 Table Format 0 Table Note Field Notes Provides choice list for the units of materials Field Types 0 Field Formats 71 Field Access 0 Field Names Start Date 1 36380 Table Name Materials Directory Rows 2 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Formulations 0 2 Materials Data 0 Table Name Material Types Rows 3 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Type Description 1 Raw Material 0 2 Formulations 0 3 SKU 0 Table Name Formulations Rows 1 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 0 0 Field Formats 0 0 14 Field Access 0 0 0 Field Names Formulation Batch Size Density 1 Cookie Dough 0 0 Table Name Materials Data Rows 3 Cols 4 Table Format 0 Table Note Field Notes Lists both SKUs and Raw Materials, but not formulations Field Types 1 1 1 1 Field Formats 0 0 0 0 Field Access 0 0 0 0 Field Names Material Formulation Units Type 1 Cookies Cookie Dough cases SKU 2 Cookie Dough kg Formulations 3 Flour kg Raw Material Table Name Item Types Rows 1 Cols 4 Table Format 0 Table Note Field Notes Field Types 1 1 1 1 Field Formats 0 0 0 0 Field Access 0 0 0 0 Field Names Name Data Table Inventory Table Bill of Materials Table 1 Material Materials Data Inventories Bill of Materials Table Name Location Types Rows 2 Cols 1 Table Format 0 Table Note Field Notes Field Types 1 Field Formats 10 Field Access 0 Field Names Name 1 Plant 2 DC Table Name Location Data Rows 13 Cols 3 Table Format 0 Table Note Field Notes Locations in the Supply Chain where inventories exist or shipments are routed through. Field Types 1 1 1 Field Formats 10 0 0 Field Access 0 0 0 Field Names Name Type Report Finished Cases 1 Nashville Plant Plant Yes 2 DC Tulsa OK DC Yes 3 DC Spokan WA DC Yes 4 DC San Diego CA DC Yes 5 DC Albuquerque NM DC Yes 6 DC Billings MT DC Yes 7 DC Minneapolis MN DC Yes 8 DC Shreveport LA DC Yes 9 DC Birmingham AL DC Yes 10 DC Columbia SC DC Yes 11 DC Albany NY DC Yes 12 DC Grand Rapids MI DC Yes 13 DC Des Moines IA DC Yes Table Name Bill of Materials Rows 2 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names Material Part Quantity 1 Cookies Cookie Dough 1 2 Cookie Dough Flour 1 Table Name Inventories Rows 15 Cols 28 Table Format 0 Table Note Field Notes Field Types 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 2 2 2 2 2 0 0 0 0 0 0 0 Field Formats 10 0 0 0 10 0 0 21 21 20 20 22 20 20 20 20 0 0 0 0 0 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Location Material Initial Amount Current Amount Supplier Safety Level Target Level Forecast Daily Demand Order Point Amount on Order Unfilled Orders Minimum Order Maximum Order Time to Fill Order Default Average Contents Max Shipment Size Consumption Block Check Inventory Block Fill Order Block Assign Order Block Assemble Order Block Time of Last Change Time to Fill Order Total Orders Percent of Orders Filled Amount In Amount Out Multiplier 1 Nashville Plant Cookies 28495 0 Nashville Plant 10 24 0 0 0 0 58500 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 2 DC Tulsa OK Cookies 3614 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 3 DC Spokan WA Cookies 4021 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 4 DC San Diego CA Cookies 2405 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 5 DC Albuquerque NM Cookies 4130 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 6 DC Billings MT Cookies 0 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 7 DC Minneapolis MN Cookies 1162 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 8 DC Shreveport LA Cookies 0 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 9 DC Birmingham AL Cookies 4975 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 10 DC Columbia SC Cookies 3379 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 11 DC Albany NY Cookies 11458 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 12 DC Grand Rapids MI Cookies 643 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 13 DC Des Moines IA Cookies 2323 0 Nashville Plant 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 14 Nashville Plant Cookie Dough 500 0 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 15 Nashville Plant Flour 10000000 0 10 24 0 0 0 0 2200 100000 0 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 Table Name Base Demand Rows 1 Cols 13 Table Format 0 Table Note Field Notes Field Types 1 0 0 0 0 0 0 0 0 0 0 0 0 Field Formats 0 20 0 0 0 0 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Product DC Tulsa OK DC Spokan WA DC San Diego CA DC Albuquerque NM DC Billings MT DC Minneapolis MN DC Shreveport LA DC Birmingham AL DC Columbia SC DC Albany NY DC Grand Rapids MI DC Des Moines IA 1 Cookies 100 100 100 100 100 100 100 100 100 100 100 100 Table Name Forecast Error Rows 1 Cols 14 Table Format 0 Table Note Field Notes Note for Field 1 Note for Field 2 Field Types 1 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Formats 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Material Nashville Plant DC Tulsa OK DC Spokan WA DC San Diego CA DC Albuquerque NM DC Billings MT DC Minneapolis MN DC Shreveport LA DC Birmingham AL DC Columbia SC DC Albany NY DC Grand Rapids MI DC Des Moines IA 1 Cookies "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" "[Normal,1,0.2,,,]" Table Name Projection Tulsa Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 2366.732571 2 36387 1419.927429 3 36394 2027.586857 4 36401 3940.817143 5 36408 3983.981143 6 36415 1423.851429 7 36422 6327.730286 8 36429 2920.577143 9 36436 4857.912 10 36443 2431.198286 11 36450 3240.663429 12 36457 3292.236 13 36464 1160.943429 14 36471 848.1445714 15 36478 230.9554286 16 36485 122.2045714 17 36492 244.9697143 18 36499 288.6942857 19 36506 431.0794286 20 36513 660.3531429 21 36520 236.0005714 22 36527 154.7177143 23 36534 270.756 24 36541 324.0102857 25 36548 1114.976571 26 36555 5263.765714 27 36562 6084.442286 28 36569 4509.797143 29 36576 2961.498857 30 36583 1163.746286 31 36590 249.4542857 32 36597 1084.145143 33 36604 1064.525143 34 36611 616.6285714 35 36618 428.8371429 36 36625 153.036 37 36632 353.16 38 36639 378.9462857 39 36646 1117.218857 40 36653 1140.762857 41 36660 825.1611429 42 36667 1039.299429 43 36674 638.4908571 44 36681 335.7822857 45 36688 3034.933714 46 36695 1002.862286 47 36702 424.3525714 48 36709 578.5097143 49 36716 151.9148571 50 36723 484.8942857 51 36730 540.9514286 52 36737 -95.85771429 Table Name Projection Spokan Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 606.5382857 2 36387 511.2411429 3 36394 841.4177143 4 36401 456.8657143 5 36408 661.4742857 6 36415 1238.302286 7 36422 554.4051429 8 36429 1107.689143 9 36436 827.4034286 10 36443 785.9211429 11 36450 279.1645714 12 36457 233.1977143 13 36464 168.1714286 14 36471 288.1337143 15 36478 465.2742857 16 36485 314.4805714 17 36492 264.0291429 18 36499 189.4731429 19 36506 154.1571429 20 36513 261.7868571 21 36520 417.0651429 22 36527 760.6954286 23 36534 457.9868571 24 36541 335.7822857 25 36548 631.2034286 26 36555 621.1131429 27 36562 631.764 28 36569 1076.857714 29 36576 3292.236 30 36583 1303.889143 31 36590 177.7011429 32 36597 179.9434286 33 36604 151.3542857 34 36611 197.3211429 35 36618 120.5228571 36 36625 117.1594286 37 36632 234.3188571 38 36639 119.9622857 39 36646 165.3685714 40 36653 185.5491429 41 36660 53.81485714 42 36667 274.68 43 36674 379.5068571 44 36681 157.5205714 45 36688 190.5942857 46 36695 295.9817143 47 36702 371.0982857 48 36709 272.4377143 49 36716 187.7914286 50 36723 461.3502857 51 36730 381.7491429 52 36737 169.8531429 Table Name Projection San Diego Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 60.54171429 2 36387 274.68 3 36394 182.7462857 4 36401 289.8154286 5 36408 168.1714286 6 36415 645.2177143 7 36422 459.6685714 8 36429 398.5662857 9 36436 337.464 10 36443 199.0028571 11 36450 91.37314286 12 36457 30.27085714 13 36464 121.0834286 14 36471 153.5965714 15 36478 121.644 16 36485 60.54171429 17 36492 91.37314286 18 36499 0 19 36506 60.54171429 20 36513 122.2045714 21 36520 182.1857143 22 36527 276.9222857 23 36534 593.0845714 24 36541 686.7 25 36548 330.7371429 26 36555 53.81485714 27 36562 21.30171429 28 36569 418.1862857 29 36576 799.3748571 30 36583 186.6702857 31 36590 3.924 32 36597 348.6754286 33 36604 45.40628571 34 36611 47.088 35 36618 91.37314286 36 36625 60.54171429 37 36632 0 38 36639 28.58914286 39 36646 338.0245714 40 36653 45.96685714 41 36660 383.9914286 42 36667 45.96685714 43 36674 30.27085714 44 36681 0 45 36688 91.37314286 46 36695 60.54171429 47 36702 30.27085714 48 36709 30.27085714 49 36716 90.81257143 50 36723 30.27085714 51 36730 61.10228571 52 36737 30.27085714 Table Name Projection Albuquerque Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 967.5462857 2 36387 412.5805714 3 36394 382.3097143 4 36401 1211.955429 5 36408 2228.832 6 36415 1690.683429 7 36422 1259.604 8 36429 859.9165714 9 36436 521.3314286 10 36443 148.5514286 11 36450 290.9365714 12 36457 61.10228571 13 36464 151.9148571 14 36471 -96.41828571 15 36478 244.4091429 16 36485 -151.9148571 17 36492 290.9365714 18 36499 91.37314286 19 36506 106.5085714 20 36513 521.3314286 21 36520 582.9942857 22 36527 675.4885714 23 36534 1126.748571 24 36541 367.7348571 25 36548 547.6782857 26 36555 316.7228571 27 36562 387.3548571 28 36569 1242.786857 29 36576 457.4262857 30 36583 447.336 31 36590 75.11657143 32 36597 160.884 33 36604 110.4325714 34 36611 130.0525714 35 36618 91.37314286 36 36625 306.6325714 37 36632 168.732 38 36639 91.37314286 39 36646 399.1268571 40 36653 556.0868571 41 36660 160.884 42 36667 38.67942857 43 36674 221.9862857 44 36681 82.404 45 36688 251.136 46 36695 125.0074286 47 36702 161.4445714 48 36709 294.3 49 36716 61.10228571 50 36723 229.8342857 51 36730 367.1742857 52 36737 76.23771429 Table Name Projection Billings Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 602.6142857 2 36387 6355.758857 3 36394 952.4108571 4 36401 3182.924571 5 36408 1497.286286 6 36415 1271.936571 7 36422 2485.573714 8 36429 1010.149714 9 36436 1248.392571 10 36443 716.9708571 11 36450 709.6834286 12 36457 1115.537143 13 36464 531.4217143 14 36471 221.4257143 15 36478 1242.226286 16 36485 482.652 17 36492 664.8377143 18 36499 42.60342857 19 36506 79.04057143 20 36513 60.54171429 21 36520 1108.810286 22 36527 1680.032571 23 36534 563.3742857 24 36541 864.4011429 25 36548 1224.848571 26 36555 1902.579429 27 36562 1537.086857 28 36569 4676.286857 29 36576 3733.405714 30 36583 2343.188571 31 36590 276.3617143 32 36597 195.0788571 33 36604 404.7325714 34 36611 287.0125714 35 36618 368.2954286 36 36625 909.8074286 37 36632 315.0411429 38 36639 45.96685714 39 36646 867.204 40 36653 1247.832 41 36660 155.2782857 42 36667 238.2428571 43 36674 1151.413714 44 36681 61.10228571 45 36688 778.0731429 46 36695 1079.1 47 36702 92.49428571 48 36709 142.3851429 49 36716 183.3068571 50 36723 469.7588571 51 36730 671.5645714 52 36737 236.5611429 Table Name Projection Minneapolis Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 1043.223429 2 36387 793.2085714 3 36394 759.0137143 4 36401 1959.197143 5 36408 3091.551429 6 36415 1973.211429 7 36422 1474.863429 8 36429 2025.344571 9 36436 521.3314286 10 36443 401.9297143 11 36450 364.3714286 12 36457 121.644 13 36464 368.856 14 36471 91.37314286 15 36478 114.9171429 16 36485 244.4091429 17 36492 145.188 18 36499 121.644 19 36506 122.2045714 20 36513 182.7462857 21 36520 151.9148571 22 36527 399.1268571 23 36534 260.1051429 24 36541 202.9268571 25 36548 408.6565714 26 36555 1298.283429 27 36562 2072.993143 28 36569 1364.430857 29 36576 1492.801714 30 36583 690.0634286 31 36590 199.5634286 32 36597 365.4925714 33 36604 334.1005714 34 36611 364.932 35 36618 164.808 36 36625 230.9554286 37 36632 122.7651429 38 36639 152.4754286 39 36646 108.1902857 40 36653 433.8822857 41 36660 223.668 42 36667 221.9862857 43 36674 283.6491429 44 36681 127.8102857 45 36688 96.97885714 46 36695 79.60114286 47 36702 500.0297143 48 36709 186.1097143 49 36716 121.0834286 50 36723 182.7462857 51 36730 151.9148571 52 36737 152.4754286 Table Name Projection Shreveport Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 254.4994286 2 36387 556.6474286 3 36394 1250.074286 4 36401 3763.676571 5 36408 1698.531429 6 36415 1814.009143 7 36422 3732.284571 8 36429 431.64 9 36436 430.5188571 10 36443 258.984 11 36450 202.9268571 12 36457 62.784 13 36464 98.66057143 14 36471 181.0645714 15 36478 42.60342857 16 36485 125.568 17 36492 91.37314286 18 36499 65.58685714 19 36506 285.3308571 20 36513 169.2925714 21 36520 94.73657143 22 36527 162.5657143 23 36534 147.9908571 24 36541 81.28285714 25 36548 597.0085714 26 36555 484.8942857 27 36562 5866.940571 28 36569 2284.889143 29 36576 1558.388571 30 36583 272.4377143 31 36590 121.0834286 32 36597 167.0502857 33 36604 168.732 34 36611 129.492 35 36618 91.93371429 36 36625 147.9908571 37 36632 5.605714286 38 36639 86.328 39 36646 413.1411429 40 36653 15.696 41 36660 54.936 42 36667 179.9434286 43 36674 68.38971429 44 36681 154.1571429 45 36688 2594.885143 46 36695 808.344 47 36702 33.63428571 48 36709 146.8697143 49 36716 0 50 36723 86.88857143 51 36730 75.11657143 52 36737 103.7057143 Table Name Projection Birmingham Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 367.1742857 2 36387 744.4388571 3 36394 807.2228571 4 36401 1466.454857 5 36408 1137.96 6 36415 1967.045143 7 36422 3784.978286 8 36429 4859.033143 9 36436 431.64 10 36443 1575.766286 11 36450 242.1668571 12 36457 297.6634286 13 36464 451.26 14 36471 57.73885714 15 36478 269.6348571 16 36485 353.16 17 36492 89.69142857 18 36499 60.54171429 19 36506 90.81257143 20 36513 183.3068571 21 36520 183.3068571 22 36527 922.14 23 36534 614.3862857 24 36541 121.644 25 36548 214.6988571 26 36555 736.0302857 27 36562 1137.399429 28 36569 3892.608 29 36576 2245.649143 30 36583 614.3862857 31 36590 1289.874857 32 36597 553.284 33 36604 305.5114286 34 36611 122.2045714 35 36618 123.3257143 36 36625 60.54171429 37 36632 152.4754286 38 36639 60.54171429 39 36646 151.9148571 40 36653 1105.446857 41 36660 491.6211429 42 36667 244.9697143 43 36674 367.1742857 44 36681 0 45 36688 -431.64 46 36695 1412.64 47 36702 392.9605714 48 36709 229.2737143 49 36716 302.7085714 50 36723 479.2885714 51 36730 424.3525714 52 36737 269.0742857 Table Name Projection Columbia Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 183.8674286 2 36387 245.5302857 3 36394 91.93371429 4 36401 2706.999429 5 36408 1071.252 6 36415 1118.900571 7 36422 142.3851429 8 36429 470.88 9 36436 170.9742857 10 36443 20.18057143 11 36450 246.0908571 12 36457 197.8817143 13 36464 400.248 14 36471 96.41828571 15 36478 21.30171429 16 36485 22.98342857 17 36492 62.784 18 36499 17.93828571 19 36506 0 20 36513 30.27085714 21 36520 95.85771429 22 36527 30.27085714 23 36534 129.492 24 36541 872.8097143 25 36548 542.0725714 26 36555 422.1102857 27 36562 690.624 28 36569 1515.224571 29 36576 915.9737143 30 36583 707.4411429 31 36590 554.4051429 32 36597 57.17828571 33 36604 114.9171429 34 36611 23.544 35 36618 0 36 36625 8.408571429 37 36632 0 38 36639 0 39 36646 0 40 36653 28.58914286 41 36660 58.86 42 36667 105.948 43 36674 784.2394286 44 36681 30.27085714 45 36688 0 46 36695 0 47 36702 0 48 36709 91.93371429 49 36716 91.93371429 50 36723 61.10228571 51 36730 122.7651429 52 36737 91.93371429 Table Name Projection Albany Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 644.6571429 2 36387 612.7045714 3 36394 792.648 4 36401 2767.541143 5 36408 1598.749714 6 36415 1906.503429 7 36422 2552.281714 8 36429 2398.685143 9 36436 861.0377143 10 36443 614.3862857 11 36450 491.6211429 12 36457 183.3068571 13 36464 122.2045714 14 36471 306.072 15 36478 183.8674286 16 36485 152.4754286 17 36492 152.4754286 18 36499 153.5965714 19 36506 152.4754286 20 36513 183.8674286 21 36520 30.27085714 22 36527 60.54171429 23 36534 307.1931429 24 36541 122.7651429 25 36548 1568.478857 26 36555 1814.569714 27 36562 1229.893714 28 36569 3722.194286 29 36576 3938.014286 30 36583 2091.492 31 36590 1660.973143 32 36597 1169.352 33 36604 1290.996 34 36611 798.8142857 35 36618 214.6988571 36 36625 122.2045714 37 36632 213.5777143 38 36639 60.54171429 39 36646 30.27085714 40 36653 153.036 41 36660 60.54171429 42 36667 214.1382857 43 36674 244.4091429 44 36681 91.93371429 45 36688 183.8674286 46 36695 275.2405714 47 36702 244.4091429 48 36709 274.68 49 36716 276.3617143 50 36723 398.0057143 51 36730 213.5777143 52 36737 183.3068571 Table Name Projection Grand Rapids Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 711.9257143 2 36387 443.9725714 3 36394 302.7085714 4 36401 563.3742857 5 36408 317.2834286 6 36415 152.4754286 7 36422 354.2811429 8 36429 330.1765714 9 36436 211.896 10 36443 265.1502857 11 36450 357.084 12 36457 216.3805714 13 36464 222.5468571 14 36471 208.5325714 15 36478 326.8131429 16 36485 352.0388571 17 36492 294.3 18 36499 219.1834286 19 36506 213.0171429 20 36513 103.1451429 21 36520 195.6394286 22 36527 97.53942857 23 36534 307.7537143 24 36541 314.4805714 25 36548 327.9342857 26 36555 821.7977143 27 36562 491.0605714 28 36569 364.3714286 29 36576 330.7371429 30 36583 4290.613714 31 36590 117.72 32 36597 164.808 33 36604 89.69142857 34 36611 241.6062857 35 36618 51.012 36 36625 242.1668571 37 36632 133.416 38 36639 164.2474286 39 36646 215.2594286 40 36653 111.5537143 41 36660 142.3851429 42 36667 199.0028571 43 36674 339.1457143 44 36681 75.11657143 45 36688 153.5965714 46 36695 156.96 47 36702 160.884 48 36709 138.4611429 49 36716 148.5514286 50 36723 335.2217143 51 36730 199.0028571 52 36737 278.604 Table Name Projection Des Moines Rows 52 Cols 2 Table Format 0 Table Note Field Notes Date of demand. Actual data is weekly. Field Types 0 0 Field Formats 61 10 Field Access 0 0 Field Names Date Cookies 1 36380 1168.230857 2 36387 952.4108571 3 36394 1044.905143 4 36401 3260.283429 5 36408 2598.248571 6 36415 1967.605714 7 36422 1287.632571 8 36429 1445.713714 9 36436 2245.088571 10 36443 506.7565714 11 36450 188.9125714 12 36457 438.3668571 13 36464 501.1508571 14 36471 216.9411429 15 36478 158.6417143 16 36485 168.1714286 17 36492 61.10228571 18 36499 121.644 19 36506 182.7462857 20 36513 121.644 21 36520 182.7462857 22 36527 0 23 36534 183.8674286 24 36541 490.5 25 36548 1968.166286 26 36555 3282.706286 27 36562 1822.417714 28 36569 2182.865143 29 36576 1938.456 30 36583 860.4771429 31 36590 2092.052571 32 36597 61.10228571 33 36604 182.7462857 34 36611 60.54171429 35 36618 151.9148571 36 36625 30.27085714 37 36632 152.4754286 38 36639 121.644 39 36646 60.54171429 40 36653 90.81257143 41 36660 245.5302857 42 36667 152.4754286 43 36674 30.27085714 44 36681 60.54171429 45 36688 91.37314286 46 36695 206.8508571 47 36702 126.1285714 48 36709 153.036 49 36716 594.2057143 50 36723 193.9577143 51 36730 65.58685714 52 36737 160.3234286 Table Name Orders Rows 1 Cols 14 Table Format 0 Table Note " Field Notes Run table filled in by SC blocks. Field Types 2 1 1 1 1 1 0 0 0 0 1 2 0 0 Field Formats 10 0 0 0 20 20 20 20 20 20 0 0 71 71 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Order Number Customer Supplier Item Type Item Priority Order Amount Amount Assigned Amount Filled Amount Delivered Status First Shipment Number Time placed Time Assigned 1 0 0 0 0 0 0 0 0 Table Name Shipments Rows 1 Cols 19 Table Format 0 Table Note Records in this table are created by Fill Order handlers as the model runs. Field Notes Run table filled in by SC blocks. All fields filled out by the model. Indexed to Location Data table Indexed to Location Data table This is the index number of the specific instance of the shipment type. E.g. type is material, instance is material 1. Indexed to Location Data table If this shipment has parts, pointer to first part. If this shipment is a part, pointer to next part. Part of what shipment A shipment becomes ready when filling and routing are completed. The model will tie shipments to the orders that generated them Field Types 2 1 1 1 0 0 1 1 1 2 2 2 1 1 2 2 0 0 0 Field Formats 10 10 10 10 20 51 10 10 10 10 10 10 10 10 10 10 71 71 71 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Shipment Number From Location To Location Priority Amount Percent Full Item Type Item Current Location First Part Next Part Part Of Status Auto Route Order Number Next Shipment in Order Time Created Time Delivered Time of Last Change 1 1 0 0 0 0 0 Ready no 1 1 36161 36161 36162 Table Name Shipment Routing Rows 1 Cols 6 Table Format 0 Table Note "This table is used during the model run to determine which block will handle shipment routing for each type of shipment. Field Notes Run table filled in by SC blocks. All fields filled out by the model. material, container, vehicle etc Specific material, container vehicle, etc If blank, applies to all If blank, applies to all Pass doRouteShipment message to this block Field Types 1 1 1 1 1 2 Field Formats 10 10 10 10 10 10 Field Access 0 0 0 0 0 0 Field Names Priority Item Type Item Location Customer Routing Block 1 regular 0 0 Table Name Trip Routes Rows 1 Cols 14 Table Format 0 Table Note Field Notes Starting point of trip Final destination Final destination Final destination Final destination Final destination Final destination Final destination Final destination Final destination Final destination Final destination Final destination Final destination Field Types 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Field Formats 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Location Nashville Plant DC Tulsa OK DC Spokan WA DC San Diego CA DC Albuquerque NM DC Billings MT DC Minneapolis MN DC Shreveport LA DC Birmingham AL DC Columbia SC DC Albany NY DC Grand Rapids MI DC Des Moines IA 1 Nashville Plant 0 DC Tulsa OK DC Spokan WA DC San Diego CA DC Albuquerque NM DC Billings MT DC Minneapolis MN DC Shreveport LA DC Birmingham AL DC Columbia SC DC Albany NY DC Grand Rapids MI DC Des Moines IA Table Name Trip Times Rows 12 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names From Location To Location Trip days 1 Nashville Plant DC Tulsa OK 1.5 2 Nashville Plant DC Spokan WA 0.5 3 Nashville Plant DC San Diego CA 3 4 Nashville Plant DC Albuquerque NM 2 5 Nashville Plant DC Billings MT 1.5 6 Nashville Plant DC Minneapolis MN 1.5 7 Nashville Plant DC Shreveport LA 5 8 Nashville Plant DC Birmingham AL 5 9 Nashville Plant DC Columbia SC 2 10 Nashville Plant DC Albany NY 1.5 11 Nashville Plant DC Grand Rapids MI 1 12 Nashville Plant DC Des Moines IA 5 Table Name Plant Schedule Rows 20 Cols 2 Table Format 0 Table Note Field Notes Referenced by SC Order (Plant/SKU), Capacity tab. Field Types 0 0 Field Formats 61 20 Field Access 0 0 Field Names Date Value 1 36770 1 2 36771 1 3 36772 1 4 36773 1 5 36774 1 6 36775 1 7 36776 1 8 36777 1 9 36778 1 10 36779 1 11 36780 1 12 36781 1 13 36782 1 14 36783 1 15 36784 1 16 36785 1 17 36786 1 18 36787 1 19 36788 1 20 36789 1 Table Name Packing Failures Rows 1 Cols 3 Table Format 0 Table Note Field Notes Index=Systems;Name Field Types 1 0 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names Line TBF TTR 1 Packline 1 "[Exponential,100,,,,]" "[Normal,10,1,,,]" Table Name Packing Rates by SKU Rows 1 Cols 2 Table Format 0 Table Note Field Notes Listed in same order as SKUs table. Field Types 1 0 Field Formats 0 20 Field Access 0 0 Field Names SKU Packline 1 1 Cookies 11700 Table Name Setup Time by SKU Rows 1 Cols 2 Table Format 0 Table Note Field Notes Listed in same order as SKUs table. Field Types 1 0 Field Formats 0 0 Field Access 0 0 Field Names SKU Setup Time 1 Cookies 30 Table Name Production Line Schedule Rows 1 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 0 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names Line Days Up Days Down 1 Nashville Plant 18.67 2.33 Table Name Material Trip Times Rows 13 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names From Location To Location Trip Days 1 Nashville Plant Nashville Plant 0 2 Nashville Plant DC Tulsa OK 2 3 Nashville Plant DC Spokan WA 3 4 Nashville Plant DC San Diego CA 3 5 Nashville Plant DC Albuquerque NM 2.5 6 Nashville Plant DC Billings MT 3 7 Nashville Plant DC Minneapolis MN 1.5 8 Nashville Plant DC Shreveport LA 1 9 Nashville Plant DC Birmingham AL 0.5 10 Nashville Plant DC Columbia SC 1 11 Nashville Plant DC Albany NY 2 12 Nashville Plant DC Grand Rapids MI 1.5 13 Nashville Plant DC Des Moines IA 2 EndofFile