cis 122l

profileagsbwuq1
Employees1.xlsx
Home>Computer Science homework help>cis 122l

Documentation

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
Pay Grade Employee pay grade for bonus Text A, B, C, or D
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
Work Anniversary Employee work anniversary month Text Yes or blank
Eligible for Bonus Employee eligibility for bonus Text No' or blank
Comp Days Employee comp days (paid days off) Number Years of Service <=1 receive none Years of Service >1 and <=5 receive 1 day Years of Service >5 and <=10 receive 2 days Years of Service >10 receive 3 days Integer
Bonus Employee bonus dollars Number Accounting format with two decimal places

Employee Analysis

Employee Analysis
Job Status Total Employees Total Salary Average Salary
FT
PT

Employee Data

Employee ID Last Name First Name Pay Grade Hire Date Years of Service Birth Date Age Store Job Status Current Salary Work Anniversary Eligible for Bonus Comp Days Bonus
1102 Delosreyes Lori B 7/10/14 3.5 4/11/61 55 Bonham FT $ 106,010
1106 Goode Bari B 11/6/15 2.2 11/23/91 25 Graham FT $ 42,182
1110 Reams Linda B 12/4/15 2.1 10/15/66 50 Bonham FT $ 92,254
1114 Rodriguez Richard D 3/24/03 14.8 12/8/64 52 Graham FT $ 69,250
1118 Peters Jessica C 5/23/11 6.6 2/15/62 54 Bonham FT $ 102,567
1122 Cortez Nick D 8/12/02 15.4 10/15/68 48 Bowie FT $ 94,517
1126 Millard Melissa B 11/6/15 2.2 3/20/73 43 Garland FT $ 51,791
1130 Burns Brenda C 6/10/10 7.6 4/20/66 50 Garland FT $ 32,530
1134 Kimball Susan C 1/20/16 1.9 3/21/57 59 Graham FT $ 94,502
1138 Ford Charles A 5/4/12 5.7 6/28/67 49 Bonham PT $ 45,671
1142 Vazquez Johnny C 7/16/11 6.5 2/8/86 30 Graham FT $ 70,346
1146 Whetstone William C 4/12/08 9.7 7/13/86 30 Garland FT $ 34,685
1150 Arnold Leroy C 3/13/12 5.8 7/8/49 67 Bonham FT $ 96,944
1154 Basile Santos B 8/8/15 2.4 12/1/56 60 Bonham FT $ 92,091
1158 Loftis Robert B 7/17/15 2.5 7/12/59 57 Garland FT $ 30,150
1162 Olson Ruth B 1/8/15 3.0 3/6/70 46 Bonham FT $ 81,536
1166 Gridley Marjorie B 10/4/13 4.2 10/25/59 57 Bowie FT $ 96,021
1170 Estevez Lois C 9/7/12 5.3 3/11/61 55 Garland FT $ 58,720
1174 Cannon Eva B 8/7/14 3.4 10/28/56 60 Graham FT $ 76,947
1178 Tyler Shirley B 5/29/15 2.6 8/21/50 66 Graham FT $ 96,449
1182 Smith Robin D 1/18/07 11.0 11/8/51 65 Garland FT $ 45,766
1186 Lee Marvin B 1/1/16 2.0 6/10/66 50 Graham FT $ 96,960
1190 Erwin Erin D 1/8/04 14.0 12/23/91 25 Graham FT $ 94,346
1194 Godrun Earle D 4/20/07 10.7 6/30/56 60 Graham FT $ 94,441
1198 Cannon Ramon D 6/15/07 10.6 9/29/50 66 Graham FT $ 90,338
1302 Chavez Jason A 6/15/12 5.5 7/31/63 53 Graham PT $ 49,890
1306 Poulsen Catherine B 7/10/15 2.5 5/5/60 56 Graham FT $ 68,681
1310 Lunsford Alberta C 1/22/16 1.9 7/11/53 63 Graham FT $ 52,244
1314 Marciano Kathy B 10/16/15 2.2 7/15/84 32 Graham FT $ 92,221
1318 Miller Billy B 8/28/15 2.3 11/24/51 65 Graham FT $ 35,304
1322 Ward Deann D 9/22/06 11.3 1/5/59 57 Bowie FT $ 51,675
1326 Wilt Thomas D 3/19/07 10.8 11/7/82 34 Graham FT $ 90,283
1330 Young Alfonso A 3/11/10 7.8 3/3/58 58 Garland PT $ 45,657
1334 Maddox Nicole B 8/28/15 2.3 2/5/76 40 Bowie FT $ 39,545
1338 Escarcega Michael D 8/11/03 14.4 4/2/67 49 Graham FT $ 125,068
1342 Mizer Joseph B 4/3/15 2.7 2/22/67 49 Graham FT $ 80,407
1346 Larsen Jennifer C 3/7/09 8.8 2/15/65 51 Bonham FT $ 83,415
1350 Jackson Edwin C 12/29/11 6.0 4/4/53 63 Garland FT $ 75,037
1354 Keefer Cynthia C 3/12/16 1.8 3/20/79 37 Garland FT $ 53,826
1358 Melancon Dina B 6/7/15 2.6 5/8/76 40 Garland FT $ 38,083
1362 Foley Pamela C 1/22/16 1.9 4/2/91 25 Bowie FT $ 54,945
1366 Jean Carlos B 10/30/15 2.2 4/27/56 60 Graham FT $ 104,494
1370 Neace Marc B 9/4/15 2.3 11/7/74 42 Bowie FT $ 71,446
1374 Swanson Brandon A 10/12/13 4.2 1/17/70 46 Graham PT $ 49,598
1378 Simpkins James C 2/12/10 7.9 7/12/74 42 Graham FT $ 42,664
1382 Lavalee James C 7/16/11 6.5 6/11/70 46 Garland FT $ 55,551
1386 Beals Vanesa B 10/2/15 2.2 6/10/68 48 Bowie FT $ 125,235
1390 Pearce James C 2/14/08 9.9 3/1/53 63 Garland FT $ 51,065
1394 Gurganus Esther D 8/24/04 13.4 8/11/66 50 Graham FT $ 53,186
1398 Toomer Katherine B 6/19/15 2.5 11/25/63 53 Graham FT $ 63,491
2002 Mortimer John C 5/24/10 7.6 9/6/66 50 Graham FT $ 108,705
2006 Allen Elizabeth B 8/28/14 3.3 12/15/85 31 Bonham FT $ 75,818
2010 Smith Helen B 4/24/15 2.7 9/24/68 48 Bonham FT $ 46,142
2014 Rodriguez Stephen B 7/18/14 3.5 8/9/59 57 Graham FT $ 84,036
2018 Thompson Lane B 8/21/15 2.4 7/15/50 66 Graham FT $ 68,470
2022 O'Donnell Robert B 3/5/15 2.8 5/2/58 58 Bonham FT $ 93,248
2026 Spaulding Sherri B 3/1/13 4.8 12/7/77 39 Bonham FT $ 101,822
2030 McKeown Michael B 12/8/15 2.1 12/4/61 55 Graham FT $ 38,420
2034 Benham Paul A 8/11/11 6.4 1/10/59 57 Graham PT $ 53,582
2038 Laboy Jayma C 6/12/09 8.6 1/30/42 74 Garland FT $ 24,373
2042 Casas Antolin C 5/4/12 5.7 8/27/89 27 Garland FT $ 65,181
2046 Guyer Ian B 12/18/15 2.0 1/6/68 48 Bowie FT $ 71,020
2050 Ramos Robert C 5/4/11 6.7 4/28/58 58 Garland FT $ 60,129
2054 Dunton Robert D 11/26/04 13.1 10/4/71 45 Graham FT $ 64,845
2058 Wall Diana C 2/22/08 9.9 1/4/60 56 Garland FT $ 49,831
2062 Weaver Leanne B 12/4/15 2.1 9/16/70 46 Graham FT $ 76,706
2066 Jung Brenda B 10/12/15 2.2 12/2/85 31 Garland FT $ 91,240
2070 Merritt Vernon B 12/4/15 2.1 5/9/59 57 Bonham FT $ 96,282
2074 Parham Jose C 11/26/10 7.1 5/10/66 50 Graham FT $ 85,412
2078 Hutton Patrice B 3/19/13 4.8 8/31/73 43 Graham FT $ 98,341
2082 Davis Carla D 6/18/04 13.5 10/14/52 64 Graham FT $ 93,243
2086 Griffin Robert B 7/21/15 2.4 11/3/65 51 Bowie FT $ 130,886
2090 Merrill Shannon A 11/27/14 3.1 6/8/52 64 Bowie PT $ 64,826
2094 Blackshear Gregory C 4/19/16 1.7 4/11/62 54 Graham FT $ 76,677
2098 Palmer Angel C 7/5/08 9.5 3/17/59 57 Graham FT $ 46,566
3002 Fallis Ruth C 6/3/10 7.6 6/16/53 63 Bonham FT $ 89,391
3206 Montoya Maria C 1/29/16 1.9 11/1/82 34 Graham FT $ 54,368
3210 Bennett James C 8/2/10 7.4 7/26/62 54 Garland FT $ 36,671
3214 Web Jason B 8/28/15 2.3 9/24/74 42 Graham FT $ 58,309
3218 Whiting Jeffery D 11/5/07 10.2 5/31/51 65 Garland FT $ 37,090
3222 Lloyd Shanika A 7/17/15 2.5 10/15/84 32 Garland PT $ 51,639
3226 Baker Ina C 7/1/10 7.5 10/9/91 25 Garland FT $ 59,138
3230 Rosenberg Robert B 7/17/15 2.5 2/1/49 67 Bowie FT $ 114,254
3234 George Robert A 3/13/11 6.8 5/12/69 47 Graham PT $ 64,598
3238 Trottier James B 7/24/15 2.4 10/25/59 57 Graham FT $ 94,896
3242 Elamin Martin B 2/5/14 3.9 1/18/47 69 Graham FT $ 58,291
3246 Pope Richard C 3/15/09 8.8 3/3/61 55 Garland FT $ 58,161
3250 Burgess Charlotte D 11/11/05 12.1 5/13/78 38 Graham FT $ 99,539
3254 Floyd Bobbi B 9/12/14 3.3 9/24/86 30 Graham FT $ 102,609
3258 Guerrero Maudie D 9/18/06 11.3 6/16/53 63 Graham FT $ 52,125
3262 Roeder Larry B 11/13/15 2.1 10/11/55 61 Graham FT $ 94,452
3266 Joe Ronald B 12/11/14 3.1 3/3/74 42 Graham FT $ 97,543
3270 Holland Patricia C 5/13/10 7.6 6/5/59 57 Bonham FT $ 98,219
3274 Parham Theresa A 11/26/13 4.1 3/2/55 61 Graham PT $ 41,204
3278 Williamson Santina A 8/25/04 13.4 5/13/64 52 Bowie PT $ 65,978
3280 Bennett June A 9/6/08 9.3 6/26/67 49 Bowie PT $ 96,354
3282 Wolfe Larry D 11/20/04 13.1 11/2/50 66 Graham FT $ 38,683
3286 Bradley Thomas B 4/10/15 2.7 7/15/82 34 Bonham FT $ 77,468
3294 Martinez John C 10/17/09 8.2 3/20/67 49 Bonham FT $ 111,426
3298 Bean Douglas B 5/29/15 2.6 4/15/53 63 Graham FT $ 95,552

Data Tables

Employee Dates
Years of service as of 12/31/17
Work Anniversary this month 4
Age as of 1/1/17
Comp Days
<=1 Years of Service 0
>1 and <=5 Years of Service 1
>5 and <=10 Years of Service 2
>10 Years of Service 3
Bonus
A 0
B 300
C 600
D 800