Lesson ProgressPhase 5 of 6
Phase 5Assessment
Assessment: Schedule-to-Pay: Building the Weekly Labor Engine
Mastery check: technical accuracy and business judgment
Prove Your Schedule-to-Pay Workflow Works
Answer the questions below using your own workbook as evidence. Be ready to show the exact cell, formula, or conditional formatting rule that backs up your answer.
Schedule Integrity Check
Use your roster, schedule, and hours sheets to justify each answer.
1. What formula turns the WeeklySchedule grid into total hours for Employee MK02?
2. If Leo (MK03) is scheduled every night for the 6p-close block, how many regular hours and overtime hours does he earn?
3. A conditional formatting rule highlights cell F3 (Thu 10a-2p) red. What should you check first?
4. Why must the Hours & Gross sheet list Department totals as well as employee totals?
0 of 4 questions answered
Evidence to Capture
- Screenshot of your WeeklySchedule grid with duplicate-ID highlighting turned on.
- Copy of the SUMIFS formula that totals hours for one employee.
- Gross pay calculation showing regular vs overtime hours for at least one worker.
Upload these artifacts to your class notebook or LMS so feedback is fast.
Need a recheck? Trade devices with a partner and have them try to break your workbook. If they find a duplicate shift or an overtime miscalculation, fix it now so Lesson06 can rely on clean data.