cis 122l
agsbwuq1
MBHC1.xlsxDocumentation
| MB Hobbies & Crafts | |||
| Author | |||
| Date | |||
| Purpose | To analyze the MBHC employees and products | ||
| Data Definition Table - Employee Data | |||
| Field | Description | Data Type | Notes |
| Employee ID | Employee ID | Number | 1000-9999 |
| Last Name | Employee last name | Text | |
| First Name | Employee first name | Text | |
| Hire Date | Employee hire date | Date | Enter dates using mm/dd/yyyy |
| Years of Service | Employee years of service | Number | One decimal place |
| Birth Date | Employee birth date | Date | Enter dates using mm/dd/yyyy |
| Age | Employee age | Number | Integer |
| Store | Employee store | Text | Bonham, Bowie, Garland, or Graham |
| Job Status | Employee job status | Text | FT (Full Time) or PT (Part Time) |
| Current Salary | Employee current salary | Number | Accounting format with two decimal places |
| Birthday Month | Employee birthday month | Text | Yes or blank |
| Eligible for Comp Day | Employee eligibile for comp day | Text | Yes or blank |
| Salary Increase | Employee salary increase | Number | Accounting format with two decimal places |
| Employee Bonus | Employee bonus | Number | Accounting format with two decimal places |
| Name Badge Color | Employee name badge color | Text | Green (0-1.99 Years of Service), Blue (1-3.99 Years of Service), Purple (4-6.99 Years of Service), Silver (7-9.99 Years of Service), Gold (10+ Years of Service) |
| Data Definition Table - Product List | |||
| Field | Description | Data Type | Notes |
| Product Number | Product number | Number | 1000-99999 |
| Product Category | Product category | Text | Dressmaking, Floral Crafting, Jewelry Making, Model Ship Building, Model Train Building, Quilting, and Yarn Crafting |
| Product Description | Product description | Text | Description of product |
| Supplier Name | Product supplier name | Text | Fabric Stores, Silk Flowers, Stones and Glass, Hobby Warehouse, Yarn House |
| Specialty Store | Specialty store for product | Text | Bonham, Bowie, Garland, Graham |
Employee Analysis
| Employee Analysis | |||
| Location | Total Employees | Total Salary | Average Salary |
| Bonham | |||
| Bowie | |||
| Garland | |||
| Graham | |||
Employee Data
| Employee ID | Last Name | First Name | Hire Date | Years of Service | Birth Date | Age | Store | Job Status | Current Salary |
| 1102 | Delosreyes | Lori | 7/10/14 | 3.5 | 4/11/61 | 55 | Bonham | FT | $ 106,010 |
| 1106 | Goode | Bari | 11/6/15 | 2.2 | 11/23/91 | 25 | Graham | FT | $ 42,182 |
| 1110 | Reams | Linda | 12/4/15 | 2.1 | 10/15/66 | 50 | Bonham | FT | $ 92,254 |
| 1114 | Rodriguez | Richard | 3/24/03 | 14.8 | 12/8/64 | 52 | Graham | FT | $ 69,250 |
| 1118 | Peters | Jessica | 5/23/11 | 6.6 | 2/15/62 | 54 | Bonham | FT | $ 102,567 |
| 1122 | Cortez | Nick | 8/12/02 | 15.4 | 10/15/68 | 48 | Bowie | FT | $ 94,517 |
| 1126 | Millard | Melissa | 11/6/15 | 2.2 | 3/20/73 | 43 | Garland | FT | $ 51,791 |
| 1130 | Burns | Brenda | 6/10/10 | 7.6 | 4/20/66 | 50 | Garland | FT | $ 32,530 |
| 1134 | Kimball | Susan | 1/20/16 | 1.9 | 3/21/57 | 59 | Graham | FT | $ 94,502 |
| 1138 | Ford | Charles | 5/4/12 | 5.7 | 6/28/67 | 49 | Bonham | PT | $ 45,671 |
| 1142 | Vazquez | Johnny | 7/16/11 | 6.5 | 2/8/86 | 30 | Graham | FT | $ 70,346 |
| 1146 | Whetstone | William | 4/12/08 | 9.7 | 7/13/86 | 30 | Garland | FT | $ 34,685 |
| 1150 | Arnold | Leroy | 3/13/12 | 5.8 | 7/8/49 | 67 | Bonham | FT | $ 96,944 |
| 1154 | Basile | Santos | 8/8/15 | 2.4 | 12/1/56 | 60 | Bonham | FT | $ 92,091 |
| 1158 | Loftis | Robert | 7/17/15 | 2.5 | 7/12/59 | 57 | Garland | FT | $ 30,150 |
| 1162 | Olson | Ruth | 1/8/15 | 3.0 | 3/6/70 | 46 | Bonham | FT | $ 81,536 |
| 1166 | Gridley | Marjorie | 10/4/13 | 4.2 | 10/25/59 | 57 | Bowie | FT | $ 96,021 |
| 1170 | Estevez | Lois | 9/7/12 | 5.3 | 3/11/61 | 55 | Garland | FT | $ 58,720 |
| 1174 | Cannon | Eva | 8/7/14 | 3.4 | 10/28/56 | 60 | Graham | FT | $ 76,947 |
| 1178 | Tyler | Shirley | 5/29/15 | 2.6 | 8/21/50 | 66 | Graham | FT | $ 96,449 |
| 1182 | Smith | Robin | 1/18/07 | 11.0 | 11/8/51 | 65 | Garland | FT | $ 45,766 |
| 1186 | Lee | Marvin | 1/1/16 | 2.0 | 6/10/66 | 50 | Graham | FT | $ 96,960 |
| 1190 | Erwin | Erin | 1/8/04 | 14.0 | 12/23/91 | 25 | Graham | FT | $ 94,346 |
| 1194 | Godrun | Earle | 4/20/07 | 10.7 | 6/30/56 | 60 | Graham | FT | $ 94,441 |
| 1198 | Cannon | Ramon | 6/15/07 | 10.6 | 9/29/50 | 66 | Graham | FT | $ 90,338 |
| 1302 | Chavez | Jason | 6/15/12 | 5.5 | 7/31/63 | 53 | Graham | PT | $ 49,890 |
| 1306 | Poulsen | Catherine | 7/10/15 | 2.5 | 5/5/60 | 56 | Graham | FT | $ 68,681 |
| 1310 | Lunsford | Alberta | 1/22/16 | 1.9 | 7/11/53 | 63 | Graham | FT | $ 52,244 |
| 1314 | Marciano | Kathy | 10/16/15 | 2.2 | 7/15/84 | 32 | Graham | FT | $ 92,221 |
| 1318 | Miller | Billy | 8/28/15 | 2.3 | 11/24/51 | 65 | Graham | FT | $ 35,304 |
| 1322 | Ward | Deann | 9/22/06 | 11.3 | 1/5/59 | 57 | Bowie | FT | $ 51,675 |
| 1326 | Wilt | Thomas | 3/19/07 | 10.8 | 11/7/82 | 34 | Graham | FT | $ 90,283 |
| 1330 | Young | Alfonso | 3/11/10 | 7.8 | 3/3/58 | 58 | Garland | PT | $ 45,657 |
| 1334 | Maddox | Nicole | 8/28/15 | 2.3 | 2/5/76 | 40 | Bowie | FT | $ 39,545 |
| 1338 | Escarcega | Michael | 8/11/03 | 14.4 | 4/2/67 | 49 | Graham | FT | $ 125,068 |
| 1342 | Mizer | Joseph | 4/3/15 | 2.7 | 2/22/67 | 49 | Graham | FT | $ 80,407 |
| 1346 | Larsen | Jennifer | 3/7/09 | 8.8 | 2/15/65 | 51 | Bonham | FT | $ 83,415 |
| 1350 | Jackson | Edwin | 12/29/11 | 6.0 | 4/4/53 | 63 | Garland | FT | $ 75,037 |
| 1354 | Keefer | Cynthia | 3/12/16 | 1.8 | 3/20/79 | 37 | Garland | FT | $ 53,826 |
| 1358 | Melancon | Dina | 6/7/15 | 2.6 | 5/8/76 | 40 | Garland | FT | $ 38,083 |
| 1362 | Foley | Pamela | 1/22/16 | 1.9 | 4/2/91 | 25 | Bowie | FT | $ 54,945 |
| 1366 | Jean | Carlos | 10/30/15 | 2.2 | 4/27/56 | 60 | Graham | FT | $ 104,494 |
| 1370 | Neace | Marc | 9/4/15 | 2.3 | 11/7/74 | 42 | Bowie | FT | $ 71,446 |
| 1374 | Swanson | Brandon | 10/12/13 | 4.2 | 1/17/70 | 46 | Graham | PT | $ 49,598 |
| 1378 | Simpkins | James | 2/12/10 | 7.9 | 7/12/74 | 42 | Graham | FT | $ 42,664 |
| 1382 | Lavalee | James | 7/16/11 | 6.5 | 6/11/70 | 46 | Garland | FT | $ 55,551 |
| 1386 | Beals | Vanesa | 10/2/15 | 2.2 | 6/10/68 | 48 | Bowie | FT | $ 125,235 |
| 1390 | Pearce | James | 2/14/08 | 9.9 | 3/1/53 | 63 | Garland | FT | $ 51,065 |
| 1394 | Gurganus | Esther | 8/24/04 | 13.4 | 8/11/66 | 50 | Graham | FT | $ 53,186 |
| 1398 | Toomer | Katherine | 6/19/15 | 2.5 | 11/25/63 | 53 | Graham | FT | $ 63,491 |
| 2002 | Mortimer | John | 5/24/10 | 7.6 | 9/6/66 | 50 | Graham | FT | $ 108,705 |
| 2006 | Allen | Elizabeth | 8/28/14 | 3.3 | 12/15/85 | 31 | Bonham | FT | $ 75,818 |
| 2010 | Smith | Helen | 4/24/15 | 2.7 | 9/24/68 | 48 | Bonham | FT | $ 46,142 |
| 2014 | Rodriguez | Stephen | 7/18/14 | 3.5 | 8/9/59 | 57 | Graham | FT | $ 84,036 |
| 2018 | Thompson | Lane | 8/21/15 | 2.4 | 7/15/50 | 66 | Graham | FT | $ 68,470 |
| 2022 | O'Donnell | Robert | 3/5/15 | 2.8 | 5/2/58 | 58 | Bonham | FT | $ 93,248 |
| 2026 | Spaulding | Sherri | 3/1/13 | 4.8 | 12/7/77 | 39 | Bonham | FT | $ 101,822 |
| 2030 | McKeown | Michael | 12/8/15 | 2.1 | 12/4/61 | 55 | Graham | FT | $ 38,420 |
| 2034 | Benham | Paul | 8/11/11 | 6.4 | 1/10/59 | 57 | Graham | PT | $ 53,582 |
| 2038 | Laboy | Jayma | 6/12/09 | 8.6 | 1/30/42 | 74 | Garland | FT | $ 24,373 |
| 2042 | Casas | Antolin | 5/4/12 | 5.7 | 8/27/89 | 27 | Garland | FT | $ 65,181 |
| 2046 | Guyer | Ian | 12/18/15 | 2.0 | 1/6/68 | 48 | Bowie | FT | $ 71,020 |
| 2050 | Ramos | Robert | 5/4/11 | 6.7 | 4/28/58 | 58 | Garland | FT | $ 60,129 |
| 2054 | Dunton | Robert | 11/26/04 | 13.1 | 10/4/71 | 45 | Graham | FT | $ 64,845 |
| 2058 | Wall | Diana | 2/22/08 | 9.9 | 1/4/60 | 56 | Garland | FT | $ 49,831 |
| 2062 | Weaver | Leanne | 12/4/15 | 2.1 | 9/16/70 | 46 | Graham | FT | $ 76,706 |
| 2066 | Jung | Brenda | 10/12/15 | 2.2 | 12/2/85 | 31 | Garland | FT | $ 91,240 |
| 2070 | Merritt | Vernon | 12/4/15 | 2.1 | 5/9/59 | 57 | Bonham | FT | $ 96,282 |
| 2074 | Parham | Jose | 11/26/10 | 7.1 | 5/10/66 | 50 | Graham | FT | $ 85,412 |
| 2078 | Hutton | Patrice | 3/19/13 | 4.8 | 8/31/73 | 43 | Graham | FT | $ 98,341 |
| 2082 | Davis | Carla | 6/18/04 | 13.5 | 10/14/52 | 64 | Graham | FT | $ 93,243 |
| 2086 | Griffin | Robert | 7/21/15 | 2.4 | 11/3/65 | 51 | Bowie | FT | $ 130,886 |
| 2090 | Merrill | Shannon | 11/27/14 | 3.1 | 6/8/52 | 64 | Bowie | PT | $ 64,826 |
| 2094 | Blackshear | Gregory | 4/19/16 | 1.7 | 4/11/62 | 54 | Graham | FT | $ 76,677 |
| 2098 | Palmer | Angel | 7/5/08 | 9.5 | 3/17/59 | 57 | Graham | FT | $ 46,566 |
| 3002 | Fallis | Ruth | 6/3/10 | 7.6 | 6/16/53 | 63 | Bonham | FT | $ 89,391 |
| 3206 | Montoya | Maria | 1/29/16 | 1.9 | 11/1/82 | 34 | Graham | FT | $ 54,368 |
| 3210 | Bennett | James | 8/2/10 | 7.4 | 7/26/62 | 54 | Garland | FT | $ 36,671 |
| 3214 | Web | Jason | 8/28/15 | 2.3 | 9/24/74 | 42 | Graham | FT | $ 58,309 |
| 3218 | Whiting | Jeffery | 11/5/07 | 10.2 | 5/31/51 | 65 | Garland | FT | $ 37,090 |
| 3222 | Lloyd | Shanika | 7/17/15 | 2.5 | 10/15/84 | 32 | Garland | PT | $ 51,639 |
| 3226 | Baker | Ina | 7/1/10 | 7.5 | 10/9/91 | 25 | Garland | FT | $ 59,138 |
| 3230 | Rosenberg | Robert | 7/17/15 | 2.5 | 2/1/49 | 67 | Bowie | FT | $ 114,254 |
| 3234 | George | Robert | 3/13/11 | 6.8 | 5/12/69 | 47 | Graham | PT | $ 64,598 |
| 3238 | Trottier | James | 7/24/15 | 2.4 | 10/25/59 | 57 | Graham | FT | $ 94,896 |
| 3242 | Elamin | Martin | 2/5/14 | 3.9 | 1/18/47 | 69 | Graham | FT | $ 58,291 |
| 3246 | Pope | Richard | 3/15/09 | 8.8 | 3/3/61 | 55 | Garland | FT | $ 58,161 |
| 3250 | Burgess | Charlotte | 11/11/05 | 12.1 | 5/13/78 | 38 | Graham | FT | $ 99,539 |
| 3254 | Floyd | Bobbi | 9/12/14 | 3.3 | 9/24/86 | 30 | Graham | FT | $ 102,609 |
| 3258 | Guerrero | Maudie | 9/18/06 | 11.3 | 6/16/53 | 63 | Graham | FT | $ 52,125 |
| 3262 | Roeder | Larry | 11/13/15 | 2.1 | 10/11/55 | 61 | Graham | FT | $ 94,452 |
| 3266 | Joe | Ronald | 12/11/14 | 3.1 | 3/3/74 | 42 | Graham | FT | $ 97,543 |
| 3270 | Holland | Patricia | 5/13/10 | 7.6 | 6/5/59 | 57 | Bonham | FT | $ 98,219 |
| 3274 | Parham | Theresa | 11/26/13 | 4.1 | 3/2/55 | 61 | Graham | PT | $ 41,204 |
| 3278 | Williamson | Santina | 8/25/04 | 13.4 | 5/13/64 | 52 | Bowie | PT | $ 65,978 |
| 3280 | Bennett | June | 9/6/08 | 9.3 | 6/26/67 | 49 | Bowie | PT | $ 96,354 |
| 3282 | Wolfe | Larry | 11/20/04 | 13.1 | 11/2/50 | 66 | Graham | FT | $ 38,683 |
| 3286 | Bradley | Thomas | 4/10/15 | 2.7 | 7/15/82 | 34 | Bonham | FT | $ 77,468 |
| 3294 | Martinez | John | 10/17/09 | 8.2 | 3/20/67 | 49 | Bonham | FT | $ 111,426 |
| 3298 | Bean | Douglas | 5/29/15 | 2.6 | 4/15/53 | 63 | Graham | FT | $ 95,552 |
Product Data
| Part Number | Product Category | Description |
| 1002 | Quilting | English Garden Flowers blue |
| 1005 | Jewelry Making | 2" Head Pins |
| 1022 | Yarn Crafting | Medium Pink Yarn 8oz |
| 1102 | Jewelry Making | Seed Beads Green |
| 1390 | Model Train Building | Austo-Hungarian Armoured |
| 1502 | Jewelry Making | Micro Crimper |
| 1660 | Jewelry Making | Wire Cutter |
| 1690 | Jewelry Making | Silver Plated Memory Wire |
| 1720 | Model Ship Building | Titanic |
| 1800 | Model Ship Building | RMS Lusitania |
| 1820 | Model Ship Building | SS Mauretania |
| 2000 | Model Train Building | HO Baltimore & Ohio Locomotive |
| 2005 | Jewelry Making | 2" Eye Pins |
| 2022 | Yarn Crafting | Set Metal Crochet Hooks |
| 2033 | Yarn Crafting | Navy Blue Yarn8oz |
| 2040 | Quilting | English Garden Flowers yellow |
| 2100 | Model Train Building | Standard Gauge Pullman Observation Car |
| 2105 | Jewelry Making | Seed Beads Blue |
| 2111 | Quilting | Flannel - Flower Patch Black - Bolt |
| 2120 | Yarn Crafting | Light Yellow Yarn - 8oz |
| 2190 | Quilting | White Cotton Quilt Back |
| 2191 | Quilting | Muslin Quilt Back |
| 2200 | Model Train Building | Standard Gauge Coal Hopper Car |
| 2230 | Yarn Crafting | Royal Blue Yarn 8oz |
| 2300 | Model Train Building | O Gauge Caboose - Red |
| 2310 | Yarn Crafting | Light Blue Yarn 8oz |
| 2430 | Yarn Crafting | Variegated Blue Yarn 8oz |
| 2502 | Jewelry Making | Crimp Beads Silver |
| 2503 | Yarn Crafting | Beige Yarn 8oz |
| 2510 | Model Ship Building | Wooden Flying Dutchman |
| 3005 | Jewelry Making | Beeswax |
| 3022 | Yarn Crafting | Set Metal Knitting Needles |
| 3105 | Jewelry Making | Fish Hook Wire |
| 3111 | Quilting | Flannel - Flower Patch Blue - Bolt |
| 3210 | Floral Crafting | Silk Poinsetta Stem |
| 3280 | Floral Crafting | Anemone Stem |
| 3502 | Jewelry Making | Crimp Beads Gold |
| 3510 | Model Ship Building | Priates of the Caribbean |
| 3540 | Floral Crafting | Chrysanthemum Stem |
| 3820 | Model Ship Building | CVN-78 Gerald Ford |
| 4000 | Dressmaking | Tape Measure |
| 4005 | Jewelry Making | Gold Earring Wires |
| 4010 | Floral Crafting | 1-1/2" Scissors |
| 4020 | Quilting | 2-1/2" Scissors |
| 4022 | Yarn Crafting | Light Green Yarn 8 oz |
| 4030 | All | 3-1/2" Scissors |
| 4040 | Model Ship Building | Cement |
| 4050 | Model Train Building | Glue |
| 4105 | Jewelry Making | Silver Earwire Spacer Bead |
| 4111 | Quilting | Ruler - 2 X 2 grid |
| 4210 | Floral Crafting | Silk Fall Leaves Stem |
| 4280 | Floral Crafting | Begonia Stem |
| 4502 | Jewelry Making | 3-Way Connector Gold |
| 4510 | Model Ship Building | USS Constitution |
| 4540 | Floral Crafting | Daisy Stem |
| 4820 | Model Ship Building | CVN-77 GHW Bush |
| 4910 | Model Train Building | Union Pacific Big Boy |
| 5000 | Dressmaking | White Silk - Bolt |
| 5002 | Quilting | Pins - glass head - 250 |
| 5005 | Jewelry Making | Lobster Clasps |
| 5022 | Yarn Crafting | Variegated Green Yarn 8oz |
| 5105 | Jewelry Making | Gold Jump Rings |
| 5111 | Quilting | Ruler - 6 x 6 grid |
| 5210 | Floral Crafting | Floral Crafting Tape - Green |
| 5280 | Floral Crafting | Cherry Blossom Stem |
| 5500 | Dressmaking | Plastic Bobbins - Emply |
| 5502 | Jewelry Making | Seed Beads Red |
| 5510 | Model Ship Building | USS Zumwalt |
| 5540 | Floral Crafting | Tulip Stem |
| 5575 | Dressmaking | Hook & Eye Enclosures Brass |
| 5685 | Jewelry Making | Invisible Cord |
| 5820 | Model Ship Building | CVN-76 Ronald Reagan |
| 5910 | Model Train Building | CSX Diesel Norfolk & Western |
| 6000 | Dressmaking | Halloween Costumes - Child |
| 6002 | Quilting | Flannel - Flower Patch Brown - Bolt |
| 6005 | Jewelry Making | Bead Design Board |
| 6022 | Yarn Crafting | Light Pink Yarn 8oz |
| 6105 | Jewelry Making | Silver Jump Rings |
| 6111 | Quilting | Ruler - 9 x 9 grid |
| 6210 | Floral Crafting | Sun Flower Stem |
| 6230 | Yarn Crafting | Light Brown Yarn 8oz |
| 6280 | Floral Crafting | Calla Lily Stem |
| 6500 | Dressmaking | Plastic Bobbins - Pre wound white |
| 6502 | Jewelry Making | Seed Beads Purple |
| 6510 | Model Ship Building | SS Amerika |
| 6540 | Floral Crafting | Daffodil Stem |
| 6675 | Dressmaking | Bias Tape - Black |
| 6820 | Model Ship Building | Bismarck |
| 6910 | Model Train Building | Pacific Southern Crescent |
| 7000 | Dressmaking | Halloween Costumes - Adult |
| 7002 | Quilting | Ruler - 4 X 4 grid |
| 7005 | Jewelry Making | Glass Bead Set - Dark |
| 7022 | Yarn Crafting | Bright Yellow Yarn 8oz |
| 7105 | Jewelry Making | Toggle Clasp |
| 7111 | Quilting | Rotary Cutter Mat |
| 7125 | Jewelry Making | Stretch Magic |
| 7135 | Jewelry Making | Gold Plated Memory Wire |
| 7210 | Floral Crafting | Spring Group - Blue |
| 7280 | Floral Crafting | Aster Stem |
| 7320 | Yarn Crafting | Medium Brown Yarn 8oz |
| 7500 | Dressmaking | Sewing Needles |
| 7502 | Jewelry Making | Crimp Tubes Gold |
| 7510 | Model Ship Building | RMS Celtic |
| 7775 | Dressmaking | Bias Tape - White |
| 7820 | Model Ship Building | Flying Cloud |
| 7910 | Model Train Building | Prewar O 262 Locomotive |
| 8000 | Dressmaking | Silk Pins - 500 ct |
| 8002 | Quilting | Rotary Cutter |
| 8005 | Jewelry Making | Needle Nosed Pliers |
| 8022 | Yarn Crafting | Light Gold Yarn 8oz |
| 8023 | Yarn Crafting | Dark Brown Yarn 8oz |
| 8105 | Jewelry Making | Barrel Clasp |
| 8111 | Quilting | Rotary Cutter Ruler |
| 8210 | Dressmaking | 3/4" Non-Roll Elastic - Black |
| 8215 | Floral Crafting | Forsythia Stem |
| 8500 | Dressmaking | Fusable Interfacing lightweight |
| 8502 | Jewelry Making | Glass Bead Gold |
| 8503 | Jewelry Making | Glass Bead Silver |
| 8510 | Model Ship Building | RMS Baltic |
| 8670 | Jewelry Making | Lanyard Snaps |
| 8875 | Dressmaking | Flexi-Lace Hem Tape - Black |
| 8910 | Model Train Building | HO Burlington Locomotive |
| 9000 | Dressmaking | Pinking Shears |
| 9001 | Model Train Building | City of New Orleans |
| 9002 | Quilting | English Garden Flowers pink |
| 9005 | Jewelry Making | Large Purple Pearls |
| 9011 | Model Train Building | Polar Express |
| 9022 | Yarn Crafting | Dark Gold Yarn 8oz |
| 9105 | Jewelry Making | Silver Earring Wires |
| 9111 | Quilting | Quilt Batting |
| 9210 | Floral Crafting | Amaryllis Stem |
| 9211 | Model Train Building | Son of the South |
| 9280 | Floral Crafting | Carnation Stem |
| 9500 | Dressmaking | Fusable Interfacing medium weight |
| 9510 | Model Ship Building | SS George Washington |
| 9810 | Model Ship Building | SS President Lincoln |
| 9820 | Model Ship Building | San Felipe |
| 9910 | Model Train Building | HO US Army Amunition Box Car |
| 9975 | Dressmaking | Flexi-Lace Hem Tape -White |
Data Tables
| Specialty Store | |||||||
| Product Category | Dressmaking | Floral Crafting | Jewelry Making | Model Ship Building | Model Train Building | Quilting | Yarn Crafting |
| Specialty Store | Garland | Bowie | Bowie | Bonham | Bonham | Garland | Graham |
| Product Suppliers | Name Badge | ||||||
| Product Category | Supplier | Years of Service | Name Badge Color | ||||
| Dressmaking | Fabric Stores | 0 | Green | ||||
| Floral Crafting | Silk Flowers | 1 | Blue | ||||
| Jewelry Making | Stones and Glass | 4 | Purple | ||||
| Model Ship Building | Hobby Warehouse | 7 | Silver | ||||
| Model Train Building | Hobby Warehouse | 10 | Gold | ||||
| Quilting | Fabric Stores | ||||||
| Yarn Crafting | Yarn House | Employee Dates | |||||
| Years of service as of | 12/31/17 | ||||||
| Bonus Amounts | Birthday this month | 4 | |||||
| Years of Service 0-4.99 | 100 | Age as of | 1/1/17 | ||||
| Years of Service 5-9.99 | 250 | ||||||
| Years of Service10+ | 500 |
