| Carlene
Hatcher |
|
|
|
|
|
|
|
|
|
|
|
|
| Capability
Examples |
|
|
|
|
|
|
|
|
|
|
|
| Mackie's
Clothing Boutique |
|
|
|
|
|
|
|
|
|
|
|
| Employees |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Employees |
|
|
|
|
|
|
|
|
|
|
|
Total Wages for Q1 |
|
|
|
|
=VLOOKUP(D8,'Company
Info'!$B$7:$C$9,2) |
|
|
|
|
|
|
$16,640.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| EmpFirst |
EmpLast |
EmpID |
Store # |
Store Name |
EmpDept |
EmpTitle |
EmpStartDate |
Wage/Hr |
Hours/wk |
Total/wk |
#wks/Qtr |
Total Wages for Q1 |
| Melisa |
Mack |
|
1 |
Mackie's Clothing Boutique |
Management |
Owner/GenMgr/Accountant |
1/1/2021 |
$15.00 |
50 |
$750.00 |
13 |
$9,750.00 |
| Samantha |
Gregory |
|
1 |
Mackie's Clothing Boutique |
Management |
Assistant Manager |
1/1/2021 |
$12.00 |
30 |
$360.00 |
13 |
$4,680.00 |
| Randy |
Jones |
|
1 |
Mackie's Clothing Boutique |
Management |
Assistant Manager |
1/1/2021 |
$12.00 |
0 |
$0.00 |
13 |
$0.00 |
| Joanne |
Bridley |
|
1 |
Mackie's Clothing Boutique |
Sales Floor |
Salesperson |
1/1/2021 |
$8.50 |
10 |
$85.00 |
13 |
$1,105.00 |
| Brittney |
Smith |
|
1 |
Mackie's Clothing Boutique |
Sales Floor |
Salesperson |
1/1/2021 |
$8.50 |
10 |
$85.00 |
13 |
$1,105.00 |
| Matt |
Molone |
|
1 |
Mackie's Clothing Boutique |
Sales Floor |
Salesperson |
1/1/2021 |
$8.50 |
0 |
$0.00 |
13 |
$0.00 |
| Stephen |
James |
|
1 |
Mackie's Clothing Boutique |
Sales Floor |
Salesperson |
1/1/2021 |
$8.50 |
0 |
$0.00 |
13 |
$0.00 |
| Rick |
Mattheson |
|
1 |
Mackie's Clothing Boutique |
Warehouse |
Stocker |
1/1/2021 |
$8.50 |
0 |
$0.00 |
13 |
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|