MB Hobbies & Crafts
Author Vanessa Beals
Date 12/1/2017
Purpose
To analyze the MBHC employees and
products
Field
Description Data Type Notes
Employee ID Employee ID Number 1000-9999
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
Bonus Employee bonus dollars Number Accounting format with two decimal places
Data Definition Table – Employee Data
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
Years of Service Employee years of service Number One decimal place
Birth Date Employee birth date Date Enter dates using mm/dd/yyyy
Job Status
Total Employees
Total
Salary Average Salary
FT 89 6,624,787$ 74,436$
PT 11 628,997$ 57,182$
Employee Analysis
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 17/10/2014 Invalid hire date 4/11/1961 55 Bonham FT 106,010$ Invalid hire date 3 300$
1106 Goode Bari B 11/6/2015 2.2 11/23/1991 25 Graham FT 42,182$ 1 300$
1150 Arnold Leroy C 3/13/2012 5.8 7/8/1949 67 Bonham FT 96,944$ 2 600$
1154 Basile Santos B 8/8/2015 2.4 12/1/1956 60 Bonham FT 92,091$ 1 300$
1158 Loftis Robert B 7/17/2015 2.5 7/12/1959 57 Garland FT 30,150$ 1 300$
1162 Olson Ruth B 1/8/2015 3.0 3/6/1970 46 Bonham FT 81,536$ 1 300$
1166 Gridley Marjorie B 10/4/2013 4.2 10/25/1959 57 Bowie FT 96,021$ 1 300$
1170 Estevez Lois C 9/7/2012 5.3 3/11/1961 55 Garland FT 58,720$ 2 600$
1174 Cannon Eva B 8/7/2014 3.4 10/28/1956 60 Graham FT 76,947$ 1 300$
1178 Tyler Shirley B 5/29/2015 2.6 8/21/1950 66 Graham FT 96,449$ 1 300$
1182 Smith Robin D 1/18/2007 11.0 11/8/1951 65 Garland FT 45,766$ No 3 –$
1186 Lee Marvin B 1/1/2016 2.0 6/10/1966 50 Graham FT 96,960$ 1 300$
1190 Erwin Erin D 1/8/2004 14.0 12/23/1991 25 Graham FT 94,346$ No 3 –$
1194 Godrun Earle D 4/20/2007 10.7 6/30/1956 60 Graham FT 94,441$ Yes No 3 –$
1198 Cannon Ramon D 6/15/2007 10.6 9/29/1950 66 Graham FT 90,338$ No 3 –$
1302 Chavez Jason A 6/15/2012 5.5 7/31/1963 53 Graham PT 49,890$ No 2 –$
1306 Poulsen Catherine B 7/10/2015 2.5 5/5/1960 56 Graham FT 68,681$ 1 300$
1310 Lunsford Alberta C 1/22/2016 1.9 7/11/1953 63 Graham FT 52,244$ 1 600$
1314 Marciano Kathy B 10/16/2015 2.2 7/15/1984 32 Graham FT 92,221$ 1 300$
1318 Miller Billy B 8/28/2015 2.3 11/24/1951 65 Graham FT 35,304$ 1 300$
1322 Ward Deann D 9/22/2006 11.3 1/5/1959 57 Bowie FT 51,675$ No 3 –$
1326 Wilt Thomas D 3/19/2007 10.8 11/7/1982 34 Graham FT 90,283$ No 3 –$
1330 Young Alfonso A 3/11/2010 7.8 3/3/1958 58 Garland PT 45,657$ No 2 –$
1334 Maddox Nicole B 8/28/2015 2.3 2/5/1976 40 Bowie FT 39,545$ 1 300$
1338 Escarcega Michael D 8/11/2003 14.4 4/2/1967 49 Graham FT 125,068$ No 3 –$
1346 Larsen Jennifer C 3/7/2009 8.8 2/15/1965 51 Bonham FT 83,415$ 2 600$
1350 Jackson Edwin C 12/29/2011 6.0 4/4/1953 63 Garland FT 75,037$ 2 600$
1354 Keefer Cynthia C 3/12/2016 1.8 3/20/1979 37 Garland FT 53,826$ 1 600$
1358 Melancon Dina B 6/7/2015 2.6 5/8/1976 40 Garland FT 38,083$ 1 300$
1362 Foley Pamela C 1/22/2016 1.9 4/2/1991 25 Bowie FT 54,945$ 1 600$
1366 Jean Carlos B 10/30/2015 2.2 4/27/1956 60 Graham FT 104,494$ 1 300$
1370 Neace Marc B 9/4/2015 2.3 11/7/1974 42 Bowie FT 71,446$ 1 300$
1374 Swanson Brandon A 10/12/2013 4.2 1/17/1970 46 Graham PT 49,598$ No 1 –$
1378 Simpkins James C 2/12/2010 7.9 7/12/1974 42 Graham FT 42,664$ 2 600$
1110 Reams Linda B 12/4/2015 2.1 10/15/1966 50 Bonham FT 92,254$ 1 300$
1114 Rodriguez Richard D 3/24/2003 14.8 12/8/1964 52 Graham FT 69,250$ No 3 –$
1118 Peters Jessica C 5/23/2011 6.6 2/15/1962 54 Bonham FT 102,567$ 2 600$
1122 Cortez Nick D 8/12/2002 15.4 10/15/1968 48 Bowie FT 94,517$ No 3 –$
1126 Millard Melissa B 11/6/2015 2.2 3/20/1973 43 Garland FT 51,791$ 1 300$
1130 Burns Brenda C 6/10/2010 7.6 4/20/1966 50 Garland FT 32,530$ 2 600$
1134 Kimball Susan C 1/20/2016 1.9 3/21/1957 59 Graham FT 94,502$ 1 600$
1138 Ford Charles A 5/4/2012 5.7 6/28/1967 49 Bonham PT 45,671$ No 2 –$
1142 Vazquez Johnny C 7/16/2011 6.5 2/8/1986 30 Graham FT 70,346$ 2 600$
1146 Whetstone William C 4/12/2008 9.7 7/13/1986 30 Garland FT 34,685$ Yes 2 600$
1382 Lavalee James C 7/16/2011 6.5 6/11/1970 46 Garland FT 55,551$ 2 600$
1386 Beals Vanesa B 10/2/2015 2.2 6/10/1968 48 Bowie FT 125,235$ 1 300$
2030 McKeown Michael B 12/8/2015 2.1 12/4/1961 55 Graham FT 38,420$ 1 300$
2034 Benham Paul A 8/11/2011 6.4 1/10/1959 57 Graham PT 53,582$ No 2 –$
2038 Laboy Jayma C 6/12/2009 8.6 1/30/1942 74 Garland FT 24,373$ 2 600$
2042 Casas Antolin C 5/4/2012 5.7 8/27/1989 27 Garland FT 65,181$ 2 600$
2046 Guyer Ian B 12/18/2015 2.0 1/6/1968 48 Bowie FT 71,020$ 1 300$
2050 Ramos Robert C 5/4/2011 6.7 4/28/1958 58 Garland FT 60,129$ 2 600$
2054 Dunton Robert D 11/26/2004 13.1 10/4/1971 45 Graham FT 64,845$ No 3 –$
2058 Wall Diana C 2/22/2008 9.9 1/4/1960 56 Garland FT 49,831$ 2 600$
2062 Weaver Leanne B 12/4/2015 2.1 9/16/1970 46 Graham FT 76,706$ 1 300$
2066 Jung Brenda B 10/12/2015 2.2 12/2/1985 31 Garland FT 91,240$ 1 300$
2070 Merritt Vernon B 12/4/2015 2.1 5/9/1959 57 Bonham FT 96,282$ 1 300$
2074 Parham Jose C 11/26/2010 7.1 5/10/1966 50 Graham FT 85,412$ 2 600$
2078 Hutton Patrice B 3/19/2013 4.8 8/31/1973 43 Graham FT 98,341$ 1 300$
2082 Davis Carla D 6/18/2004 13.5 10/14/1952 64 Graham FT 93,243$ No 3 –$
2086 Griffin Robert B 7/21/2015 2.4 11/3/1965 51 Bowie FT 130,886$ 1 300$
2090 Merrill Shannon A 11/27/2014 3.1 6/8/1952 64 Bowie PT 64,826$ No 1 –$
2094 Blackshear Gregory C 4/19/2016 1.7 4/11/1962 54 Graham FT 76,677$ Yes 1 600$
2098 Palmer Angel C 7/5/2008 9.5 3/17/1959 57 Graham FT 46,566$ 2 600$
3002 Fallis Ruth C 6/3/2010 7.6 6/16/1953 63 Bonham FT 89,391$ 2 600$
3206 Montoya Maria C 1/29/2016 1.9 11/1/1982 34 Graham FT 54,368$ 1 600$
3210 Bennett James C 8/2/2010 7.4 7/26/1962 54 Garland FT 36,671$ 2 600$
3214 Web Jason B 8/28/2015 2.3 9/24/1974 42 Graham FT 58,309$ 1 300$
3218 Whiting Jeffery D 11/5/2007 10.2 5/31/1951 65 Garland FT 37,090$ No 3 –$
3222 Lloyd Shanika A 7/17/2015 2.5 10/15/1984 32 Garland PT 51,639$ No 1 –$
3226 Baker Ina C 7/1/2010 7.5 10/9/1991 25 Garland FT 59,138$ 2 600$
3230 Rosenberg Robert B 7/17/2015 2.5 2/1/1949 67 Bowie FT 114,254$ 1 300$
3234 George Robert A 3/13/2011 6.8 5/12/1969 47 Graham PT 64,598$ No 2 –$
3238 Trottier James B 7/24/2015 2.4 10/25/1959 57 Graham FT 94,896$ 1 300$
3242 Elamin Martin B 2/5/2014 3.9 1/18/1947 69 Graham FT 58,291$ 1 300$
3246 Pope Richard C 3/15/2009 8.8 3/3/1961 55 Garland FT 58,161$ 2 600$
3250 Burgess Charlotte D 11/11/2005 12.1 5/13/1978 38 Graham FT 99,539$ No 3 –$
3254 Floyd Bobbi B 9/12/2014 3.3 9/24/1986 30 Graham FT 102,609$ 1 300$
3258 Guerrero Maudie D 9/18/2006 11.3 6/16/1953 63 Graham FT 52,125$ No 3 –$
3262 Roeder Larry B 11/13/2015 2.1 10/11/1955 61 Graham FT 94,452$ 1 300$
3266 Joe Ronald B 12/11/2014 3.1 3/3/1974 42 Graham FT 97,543$ 1 300$
1390 Pearce James C 2/14/2008 9.9 3/1/1953 63 Garland FT 51,065$ 2 600$
1394 Gurganus Esther D 8/24/2004 13.4 8/11/1966 50 Graham FT 53,186$ No 3 –$
1398 Toomer Katherine B 6/19/2015 2.5 11/25/1963 53 Graham FT 63,491$ 1 300$
2002 Mortimer John C 5/24/2010 7.6 9/6/1966 50 Graham FT 108,705$ 2 600$
2006 Allen Elizabeth B 8/28/2014 3.3 12/15/1985 31 Bonham FT 75,818$ 1 300$
2010 Smith Helen B 4/24/2015 2.7 9/24/1968 48 Bonham FT 46,142$ Yes 1 300$
2014 Rodriguez Stephen B 7/18/2014 3.5 8/9/1959 57 Graham FT 84,036$ 1 300$
2018 Thompson Lane B 8/21/2015 2.4 7/15/1950 66 Graham FT 68,470$ 1 300$
2022 O’Donnell Robert B 3/5/2015 2.8 5/2/1958 58 Bonham FT 93,248$ 1 300$
2026 Spaulding Sherri B 3/1/2013 4.8 12/7/1977 39 Bonham FT 101,822$ 1 300$
3270 Holland Patricia C 5/13/2010 7.6 6/5/1959 57 Bonham FT 98,219$ 2 600$
3274 Parham Theresa A 11/26/2013 4.1 3/2/1955 61 Graham PT 41,204$ No 1 –$
3278 Williamson Santina A 8/25/2004 13.4 5/13/1964 52 Bowie PT 65,978$ No 3 –$
3280 Bennett June A 9/6/2008 9.3 6/26/1967 49 Bowie PT 96,354$ No 2 –$
3282 Wolfe Larry D 11/20/2004 13.1 11/2/1950 66 Graham FT 38,683$ No 3 –$
3286 Bradley Thomas B 4/10/2015 2.7 7/15/1982 34 Bonham FT 77,468$ Yes 1 300$
3294 Martinez John C 10/17/2009 8.2 3/20/1967 49 Bonham FT 111,426$ 2 600$
Years of service as
of
12/31/2017
<=1 Years of Service 0
>1 and <=5 Years of
Service
>5 and <=10 Years
of Service
>10 Years of Service 3
A0
B300
C600
D800
Employee Dates
Comp Days
Bonus
Work Anniversary
this month
Age as of 1/1/2017