Spreadsheet: 715073d1611540736-google-sheets-calculating-breaks-on-the-rota-rota
Sheet: WE31012021

 |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sales Forcast/Actual |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 |  |  |  | 500 |  |  |  | 500 |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  |  | Productivity/Hour:
 |  |  | Hours | Cost | % |  | Hours | Cost | % |  | Hours | Cost | % |  | Hours | Cost | % |  | Hours | Cost | % |  | Hours | Cost | % |  | Hours | Cost | % |  |  |  |  |  |  |  |  |  |  | Forcast Sales:
 | Forecast |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ave wage cost: |  |  |  | Forcast Hours:
 | Mgmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecasted Hours: |  |  |  | [NAME]:
 | KA's |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KA Wage %:
 | Labour Forcast % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Wage cost:
 | 2021-01-25 00:00:00 |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  |  |  |  |  |  |  |  |  |  |  | Total %:
 | Emp. Name | Shift | In | Out | Hrs | Hol | In | Out | Hrs | Hol | In | Out | Hrs | Hol | In | Out | Hrs | Hol | In | Out | Hrs | Hol | In | Out | Hrs | Hol | In | Out | Hrs | Hol |  |  | Update | Total Hrs | Hours Worked | Holiday Hours | Hour Adjustment (Breaks) | Total Hours | [NAME] | [NAME] | Er.NI | Wage Cost | Holiday Accrual | Comments, [NAME], Reasons for Adjusted Hours
 |  | AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  | PM
 |  | AM |  |  |  |  | 11 | 15 |  |  |  |  |  |  | 11 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.5
 |  | PM |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 23 |  |  | 15 | 23 |  |  | 15 | 23 |  |  | 15 | 23
 |  | AM | 11 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  | 9.8 |  |  |  |  | 5 hours
 |  | PM | 15 | 23 |  |  | 15 | 23 |  |  | 15 | 23
 |  | AM |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  | 5 hours
 |  | PM | 17 | 23 |  |  | 17 | 23 |  |  | 15 | 23 |  |  | 19 | 23 |  |  | 19 | 23
 |  | AM |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  |  |  | 11 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  | 5 hours
 |  | PM |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 23 |  |  | 15 | 23 |  |  |  |  |  |  | 15 | 23
 |  | AM | 12 | 17 |  |  | 12 | 15 |  |  |  |  |  |  |  |  |  |  | 12 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  | 5 hours
 |  | PM |  |  |  |  | 15 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 23 |  |  | 17 | 23
 |  | AM |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  | 5 hours
 |  | PM |  |  |  |  |  |  |  |  | 15 | 23 |  |  | 15 | 23 |  |  | 15 | 23 |  |  | 17 | 23
 |  | AM |  |  |  | AM |  |  |  | AM |  |  |  | AM |  |  |  | AM
 |  | PM |  |  |  | PM |  |  |  | PM |  |  |  | PM |  |  |  | PM |  |  |  | PM |  |  |  | PM |  |  |  |  |  |  |  |  |  | Staff Hours
 | Required Staff | PM | 3 |  |  | PM | 3 |  |  | PM | 3 |  |  | PM | 4 |  |  | PM | 4 |  |  | PM | 3 |  |  | PM | 3