By the end of this week you will submit your Excel worksheet with employee data entered and formatted.
To begin, ensure you enter the provided 25 employee records into Excel. The provided information for each employee is needed by ADP and is in compliance with FLSA standards. Click on the following image object titled Compliance with FLSA Standards.PNG to access the 25 employee records:
c H 1 J L M y e A B Middl First 1 Name Initial Last Name SS # Street Address 2 Sean S. gstin XXX-XX-XXXX 2843 Velvet Gate Diversion 3 Cate D. Blanchett XXX-XX-XXXX 2155 Misty Treasure Orchard 4 Billy H. Boyd 9112 Foggy Cider Arbor 5 Scott N. Campbell XXX-XX-XXY 9992 Thunder Bluff Highlands 6 Thomas H. Cook XXX-XX-XXXX 5631 Hidden Plaza 7 Ryan P. Erdly XXX-XX-XXXX 9278 Old Nook 8 Karen A Houchins XXX-XX-XXXX 6193 Dewy Horse Crest 9 Emma L. Kight XXX-XX-XNXX 3047 Sleepy Townline 10 Tabitha C. McDermott XXX-XX-XXXX 3366 Harvest Prairie Circuit 11 Dominic M. Monaghan XXX-XX-XXXX 7360 Quiet Barn Ridge 12 Viggo K. Mortensen 1440 Broad Pine Trail 13 Rick L. Perry XXX-XX-XXXX 8796 Indian Fox Mountain 14 Alex D. Pritt XXX-XX-XXXX 7460 Lost Campus 15 Bonnie P. Quinn XXX-XX-XXXX 4836 Colonial Panda Terrace 16 Treva A. Reid XXX-XX-XXXX 5436 Noble Lake Hollow 17 Andy G. Serkis XXX-XX-XXXX 9839 Honey Island Meadow 18 Bill D. Sorgi XXX-XX-XXXX 8023 Cotton Road 19 Krista A. Stephonopolis XXX-XX-XXXX 1207 Silent Field 20 Liv M. Tyler XXX-XX-XXXX 3715 Iron Acres 21 Graham E. Watkins XXX-XX-XXXX 4983 Shady Pony Dale 22 Hugo V. Weaving XXX-XX-XXXX 9576 Jagged Hills Forest 23 David W. Wenhan XXX-XX-XXXX 8424 Burning Robin Harbour 24 | Kim Williams XXX-XX-XXXX 3156 Quaking Forest Port 25 Elijah N. Wood XXX-XX- XXE 1478 Gentle Oak Carrefour 26 Tom E. Workman XXX-XX-XXXX 6232 Sunny Grounds Stat City Zip Taylors Gut Landing OH 45577-1620 Miami Beach OH 44900-8522 Wakpamani OH 44841-3316 Swamproot OH 44618-0009 Tugwell OH 44576-5868 Frijoles OH 45652-7010 Rushsylvania OH 45836-8913 Stamp OH 44509-5124 Lick OH 43339-3025 Little Chief OH 45758-1959 Congo OH 45854-2081 Humble City OH 43451-3789 Wax OH 45700-1285 Tarhe Town OH 45645-7536 Hoople OH 43004-4614 Cattown OH 44710-3536 Ashtabula OH 43588-1402 Manlove OH 43439-7230 Scituate OH 43569-0938 Wapwallopen OH 44562-7619 Owltown OH 45085-2981 Parsippany OH 45962-6242 Heartstrong OH 45703-5992 Big Lick OH 45348-0406 New Harmony OH 44167-5935 Gend DOB er Job Title 10/29/1980 M Packer 11/18/1990 F HR 3/26/1997 M Receiver 7/7/1969 M Warehouse Worker 9/5/1968 M Order Puller 8/3/1991 M Material Handler 5/23/1961 F Logistics Supervisor 2/27/1997 F Order Puller 6/8/1981 F Logistics Analyst 5/22/1975 M Supply Chain Manager 1/14/1988 M CEO 6/20/1982 M Logistics Director 10/30/1971 M Order Puller 9/28/1993 F Transportation Manager 5/15/1955 F Order Puller 8/15/1995 M Maintenance 5/31/1952 M Order Puller 1/20/1985 F Customs Entry Clerk 8/13/1988 F Controller 10/8/1989 M Warehouse Worker 9/17/1992 M Packer 2/25/1998 M PIC 774/1999 F Distribution Manager 12/2/1993 M Shipping Clerk 11/23/1996 M Material Handler II Workwee Time k Days 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM MF 7:30 AM M-F 7:30 AM M-F 7:30 AM MF N 0 Hours Worked Hourly/Sal Each Day ary 8 Hourly 8 Salary 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Salary 8 Salary 8 Salary 8 Hourly 8 Salary 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Salary 8 Hourly 8 Hourly 8 Salary 8 Salary 8 Hourly 8 Hourly P Hourl Hours Worked Payra Each Week $10.00 40 NIA 40 $12.00 40 $10.00 40 $10.00 40 $11.00 40 $14.00 40 $10.00 40 $12.00 40 NIA 40 NA 40 NIA 40 $10.00 40 NA 40 $10.00 40 $12.00 40 $10.00 40 $12.50 40 NIA 40 $10.00 40 $10.00 40 NA 40 NIA 40 $12.00 40 $13.00 40 R T U Weekl Weekly Straight y OIT Deductio Additio Time Earnings Pay ns ns $400.00 NIA $25.00 NIA $650.00 NA $62.00 NIA $480.00 NA $50.00 NIA $400.00 NA $25.00 NIA $400.00 NIA $25.00 NIA $440.00 NIA $50.00 NIA $560.00 NIA $50.00 NIA $400.00 NIA $25.00 NIA $480.00 NIA $50.00 NA $600.00 NA $62.00 NA $900.00 NIA $62.00 NIA $600.00 NIA $62.00 NA $400.00 NIA $25.00 NIA $600.00 NIA $62.00 NIA $400.00 NIA $25.00 NIA $480.00 NIA $25.00 N/A $400.00 NIA $25.00 NIA $500.00 NIA $25.00 NIA $800.00 NIA $62.00 NIA $400.00 NIA $25.00 NIA $400.00 NA $25.00 NIA $600.00 NIA $62.00 NIA $600.00 NIA $62.00 N/A $480.00 NIA $50.00 NA $520.00 NIA $25.00 NIA V Pay Period Covered Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Pay Date Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday X Wages Paid by Pay Period $375.00 $588.00 $430.00 $375.00 $375.00 $390.00 $510.00 $375.00 $430.00 $538.00 $838.00 $538.00 $375.00 $538.00 $375.00 $455.00 $375.00 $475.00 $738.00 $375.00 $375.00 $538.00 $538.00 $430.00 $495.00 c H 1 J L M y e A B Middl First 1 Name Initial Last Name SS # Street Address 2 Sean S. gstin XXX-XX-XXXX 2843 Velvet Gate Diversion 3 Cate D. Blanchett XXX-XX-XXXX 2155 Misty Treasure Orchard 4 Billy H. Boyd 9112 Foggy Cider Arbor 5 Scott N. Campbell XXX-XX-XXY 9992 Thunder Bluff Highlands 6 Thomas H. Cook XXX-XX-XXXX 5631 Hidden Plaza 7 Ryan P. Erdly XXX-XX-XXXX 9278 Old Nook 8 Karen A Houchins XXX-XX-XXXX 6193 Dewy Horse Crest 9 Emma L. Kight XXX-XX-XNXX 3047 Sleepy Townline 10 Tabitha C. McDermott XXX-XX-XXXX 3366 Harvest Prairie Circuit 11 Dominic M. Monaghan XXX-XX-XXXX 7360 Quiet Barn Ridge 12 Viggo K. Mortensen 1440 Broad Pine Trail 13 Rick L. Perry XXX-XX-XXXX 8796 Indian Fox Mountain 14 Alex D. Pritt XXX-XX-XXXX 7460 Lost Campus 15 Bonnie P. Quinn XXX-XX-XXXX 4836 Colonial Panda Terrace 16 Treva A. Reid XXX-XX-XXXX 5436 Noble Lake Hollow 17 Andy G. Serkis XXX-XX-XXXX 9839 Honey Island Meadow 18 Bill D. Sorgi XXX-XX-XXXX 8023 Cotton Road 19 Krista A. Stephonopolis XXX-XX-XXXX 1207 Silent Field 20 Liv M. Tyler XXX-XX-XXXX 3715 Iron Acres 21 Graham E. Watkins XXX-XX-XXXX 4983 Shady Pony Dale 22 Hugo V. Weaving XXX-XX-XXXX 9576 Jagged Hills Forest 23 David W. Wenhan XXX-XX-XXXX 8424 Burning Robin Harbour 24 | Kim Williams XXX-XX-XXXX 3156 Quaking Forest Port 25 Elijah N. Wood XXX-XX- XXE 1478 Gentle Oak Carrefour 26 Tom E. Workman XXX-XX-XXXX 6232 Sunny Grounds Stat City Zip Taylors Gut Landing OH 45577-1620 Miami Beach OH 44900-8522 Wakpamani OH 44841-3316 Swamproot OH 44618-0009 Tugwell OH 44576-5868 Frijoles OH 45652-7010 Rushsylvania OH 45836-8913 Stamp OH 44509-5124 Lick OH 43339-3025 Little Chief OH 45758-1959 Congo OH 45854-2081 Humble City OH 43451-3789 Wax OH 45700-1285 Tarhe Town OH 45645-7536 Hoople OH 43004-4614 Cattown OH 44710-3536 Ashtabula OH 43588-1402 Manlove OH 43439-7230 Scituate OH 43569-0938 Wapwallopen OH 44562-7619 Owltown OH 45085-2981 Parsippany OH 45962-6242 Heartstrong OH 45703-5992 Big Lick OH 45348-0406 New Harmony OH 44167-5935 Gend DOB er Job Title 10/29/1980 M Packer 11/18/1990 F HR 3/26/1997 M Receiver 7/7/1969 M Warehouse Worker 9/5/1968 M Order Puller 8/3/1991 M Material Handler 5/23/1961 F Logistics Supervisor 2/27/1997 F Order Puller 6/8/1981 F Logistics Analyst 5/22/1975 M Supply Chain Manager 1/14/1988 M CEO 6/20/1982 M Logistics Director 10/30/1971 M Order Puller 9/28/1993 F Transportation Manager 5/15/1955 F Order Puller 8/15/1995 M Maintenance 5/31/1952 M Order Puller 1/20/1985 F Customs Entry Clerk 8/13/1988 F Controller 10/8/1989 M Warehouse Worker 9/17/1992 M Packer 2/25/1998 M PIC 774/1999 F Distribution Manager 12/2/1993 M Shipping Clerk 11/23/1996 M Material Handler II Workwee Time k Days 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM M-F 7:30 AM MF 7:30 AM M-F 7:30 AM M-F 7:30 AM MF N 0 Hours Worked Hourly/Sal Each Day ary 8 Hourly 8 Salary 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Salary 8 Salary 8 Salary 8 Hourly 8 Salary 8 Hourly 8 Hourly 8 Hourly 8 Hourly 8 Salary 8 Hourly 8 Hourly 8 Salary 8 Salary 8 Hourly 8 Hourly P Hourl Hours Worked Payra Each Week $10.00 40 NIA 40 $12.00 40 $10.00 40 $10.00 40 $11.00 40 $14.00 40 $10.00 40 $12.00 40 NIA 40 NA 40 NIA 40 $10.00 40 NA 40 $10.00 40 $12.00 40 $10.00 40 $12.50 40 NIA 40 $10.00 40 $10.00 40 NA 40 NIA 40 $12.00 40 $13.00 40 R T U Weekl Weekly Straight y OIT Deductio Additio Time Earnings Pay ns ns $400.00 NIA $25.00 NIA $650.00 NA $62.00 NIA $480.00 NA $50.00 NIA $400.00 NA $25.00 NIA $400.00 NIA $25.00 NIA $440.00 NIA $50.00 NIA $560.00 NIA $50.00 NIA $400.00 NIA $25.00 NIA $480.00 NIA $50.00 NA $600.00 NA $62.00 NA $900.00 NIA $62.00 NIA $600.00 NIA $62.00 NA $400.00 NIA $25.00 NIA $600.00 NIA $62.00 NIA $400.00 NIA $25.00 NIA $480.00 NIA $25.00 N/A $400.00 NIA $25.00 NIA $500.00 NIA $25.00 NIA $800.00 NIA $62.00 NIA $400.00 NIA $25.00 NIA $400.00 NA $25.00 NIA $600.00 NIA $62.00 NIA $600.00 NIA $62.00 N/A $480.00 NIA $50.00 NA $520.00 NIA $25.00 NIA V Pay Period Covered Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Pay Date Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday Friday X Wages Paid by Pay Period $375.00 $588.00 $430.00 $375.00 $375.00 $390.00 $510.00 $375.00 $430.00 $538.00 $838.00 $538.00 $375.00 $538.00 $375.00 $455.00 $375.00 $475.00 $738.00 $375.00 $375.00 $538.00 $538.00 $430.00 $495.00
