Spreadsheet: 466539d1466261561-help-with-production-report-formula-production-report
Sheet: Sheet1

Date | Day | Overall Program Forecast | ESC Forecast | Daily Synergy Forecast | Daily QB Forecast | Backlog ESC  8AM | Days Outstanding | Actual Production Backlog | Production/Projected Production | Capacity (# ESCs * throughput * 7 hr) | Esc Agents | Throughput |  |  |  |  |  | NOTES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oldest Date
 | Sat |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0
 | Sun |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0
2016-05-30 00:00:00 | Mon |  |  |  |  |  |  |  |  | 449 |  | 6 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  | 532 |  | 6
 | Wed |  |  |  |  |  |  |  |  | 502 |  | 6
 | Thu |  |  |  |  |  |  |  |  | 353 |  | 6
 | Fri |  |  |  |  |  |  |  |  | 200 |  | 6
 | Sat |  |  |  |  |  |  |  |  | 150 |  | 6 |  |  | 0 | 0
 | Sun |  |  |  |  |  |  |  |  | 0 |  | 6 |  |  | 0 | 0
 | Mon |  |  |  |  |  |  |  |  | 362 |  | 6 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  | 524 |  | 6
 | Wed |  |  |  |  |  |  |  |  | 389 |  | 6
 | Thu |  |  |  |  |  |  |  |  | 421 |  | 6
 | Fri |  |  |  |  |  |  |  |  | 400 |  | 6
 | Sat |  |  |  |  |  |  |  |  | 283 |  | 6 |  |  | 0 | 0
 | Sun |  |  |  |  |  |  |  |  | 182 |  | 6 |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  | 414 |  | 6 |  |  | 0 | 0
 | Tue |  |  |  |  | 12583 | 26 |  |  |  | 15 | 6 |  |  |  |  |  | Start tracking, 12583 inbox 26 days out of TT
 | Wed |  |  |  |  |  |  |  |  |  | 15 | 6
 | Thu |  |  |  |  |  |  |  |  |  | 15 | 6
 | Fri |  |  |  |  |  |  |  |  |  | 15 | 6
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 6 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 8 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 8
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 8
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 8
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 8
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 8 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 9 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 9
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 9
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 9
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 9
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 9 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 9 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 9
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 9
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 9
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 9
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 9 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 10 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 10
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 10
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 10
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 10
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 10 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 10 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 10
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 10
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 10
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 10
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 10 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 10 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 10
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 10
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 10
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 10
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 10 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 11 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 11
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 11
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 11
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 11
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 11 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 11 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 11
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 11
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 11
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 11
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 11 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 11 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 11
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 11
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 11
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 11
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 11 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
 | Mon |  | 8000 |  |  |  |  |  |  |  | 30 | 11 |  |  | 0 | 0
 | Tue |  |  |  |  |  |  |  |  |  | 30 | 11
 | Wed |  |  |  |  |  |  |  |  |  | 30 | 11
 | Thu |  |  |  |  |  |  |  |  |  | 30 | 11
 | Fri |  |  |  |  |  |  |  |  |  | 30 | 11
 | Sat |  |  |  |  |  |  |  |  |  | 10 | 11 |  |  | 0 | 0
 | Sun |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0