Spreadsheet: 44834d1243558667-finding-the-earliest-time-employee-schedule
Sheet: Week 2

 | Labor Cost Analysis |  |  |  | (Complete the boxes below) |  |  |  |  |  | Hours Available |  |  |  |  |  |  |  |  |  |  |  |  |  | CLOSE/EO LEGEND
 | For week beginning |  |  |  | 2009-06-03 00:00:00 |  |  |  |  |  |  |  |  |  | Hours | Cost
 | Labor Target |  |  |  | 0.16 |  |  |  |  |  | Total Labor Hours + Mger
 | Avg hourly wage |  |  |  | 7 |  |  |  |  |  | Scheduled labor hours |  |  |  |  |  |  |  |  |  |  |  |  |  | GREEN EO
 | Expected NET Sales |  |  |  | 25000 |  |  |  |  |  | Hours Under (Over) |  |  |  |  |  |  |  |  |  |  |  |  |  | RED CLOSE
 |  | Weekly Schedule
 |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday |  |  | Monday |  |  | Tuesday
 |  | 2009-06-03 00:00:00
Rate |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | TOTAL | Est. Cost
0 | Culinary
11.5 | [NAME] | 06:00:00 | 15:00:00 |  | 07:30:00 | 14:00:00 |  | 11:00:00 | 17:00:00 |  | 09:00:00 | 14:00:00 |  | 08:00:00 | 16:00:00 |  | X | X |  | X | X
 |  |  |  |  |  |  |  |  |  |  | 16:00:00 | 21:30:00
0
10.75 | [NAME] | 09:00:00 | 14:00:00 |  | 11:00:00 | 16:00:00 |  | 09:00:00 | 14:00:00 |  | X | X |  | X | X |  | 09:00:00 | 17:00:00 |  | 09:00:00 | 17:00:00
10.5 | Tiffany | 17:00:00 | 00:00:00 |  | 16:00:00 | 00:00:00 |  | 16:00:00 | 21:00:00 |  | 11:00:00 | 16:00:00 |  | 11:00:00 | 15:00:00 |  | X | X |  | X | X
 |  |  |  |  |  |  |  |  |  |  | 17:00:00 | 21:00:00
10 | [NAME] | X | X |  | X | X |  | 17:00:00 | 01:00:00 |  | 15:00:00 | 01:00:00 |  | 12:00:00 | 13:30:00 |  | 17:00:00 | 21:00:00 |  | 17:00:00 | 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 | 23:00:00
9 | [NAME] | 15:00:00 | 20:00:00 |  | 17:00:00 | 00:00:00 |  | 17:00:00 | 00:00:00 |  | X | X |  | X | X |  | X | X |  | X | X
9.5 | Bradley | 17:00:00 | 00:00:00 |  | X | X |  | 16:00:00 | 20:00:00 |  | 18:00:00 | 01:00:00 |  | 17:00:00 | 23:00:00 |  | X | X |  | 17:00:00 | 20:00:00
9 | Tara | X | X |  | X | X |  | X | X |  | X | X |  | X | X |  | 11:00:00 | 14:00:00 |  | 11:00:00 | 14:00:00
9 | [NAME] | X | X |  | 16:00:00 | 20:30:00 |  | X | X |  | 17:00:00 | 23:00:00 |  | 12:00:00 | 14:00:00 |  | 17:00:00 | 20:00:00 |  | X | X
9 | Ramone | 09:30:00 | 13:00:00 |  | 09:30:00 | 13:00:00 |  | 09:30:00 | 13:00:00 |  | 09:30:00 | 13:00:00 |  | X | X |  | X | X |  | 09:30:00 | 13:00:00
9.5 | Virginia | 17:00:00 | 21:00:00 |  | 17:00:00 | 12:00:00 |  | 17:00:00 | 21:00:00 |  | X | X |  | X | X |  | 09:30:00 | 13:00:00 |  | X | X
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 | 21:00:00
9.5 | Reyna | X | X |  | X | X |  | 17:00:00 | 00:00:00 |  | 17:00:00 | 01:00:00 |  | 17:00:00 | 23:00:00 |  | 18:00:00 | 00:00:00 |  | 17:00:00 | 00:00:00
9 | Sandra | 10:00:00 | 15:00:00 |  | 10:00:00 | 15:00:00 |  | 10:00:00 | 15:00:00 |  | 10:00:00 | 15:00:00 |  | 10:00:00 | 15:00:00 |  | X | X |  | X | X
10 | Sayon | 17:00:00 | 00:00:00 |  | 17:00:00 | 21:00:00 |  | X | X |  | 17:00:00 | 21:00:00 |  | 17:00:00 | 21:00:00 |  | X | X |  | 18:00:00 | 21:00:00
0
 |  | WED |  |  | THUR |  |  | FRI |  |  | SAT |  |  | SUN |  |  | MON |  |  | TUES
 | OPEN
 | OPENING
 | MID
 | SBA
 | PREP
 | CLOSING
 | CLOSER 1
 | CLOSER 2
 | EO 1
 | EO 2
 | DISH
 | EXPO