Attachment 4-Colume II Direct and Indirect Labor Summary (DILS).xlsx

This is a Direct and Indirect Labor Summary (DILS) template for the Memphis NSA Commissary shelf stocking, receiving/storage/holding area (RSHA), and custodial services contract. The spreadsheet is designed to calculate labor requirements across three primary service categories: shelf stocking, receiving/storage/holding area operations, and custodial services. The shelf stocking section accounts for 536,352 cases per year and includes subtasks for merchandise placement, fronting and facing, and slack out activities. The receiving/storage section addresses 414,024 cases for offload trucks, 128,232 cases for transport, 412,572 cases for segregation, and 50,652 cases each for both storage and pull operations, with provisions for RSHA coverage if required.

The custodial labor section breaks down cleaning requirements by area: 9,735,064 square feet for administrative/store/patron areas, 7,448,150 square feet for receiving/storage/holding areas, 967,264 square feet for meat processing areas, and 2,036,612 square feet for outside areas. The template requires contractors to input productivity rates (cases per person per productive hour for stocking/receiving tasks, or square feet per crew per productive hour for custodial work) to calculate direct productive hours needed. A separate section captures supervision hours identified exclusively for supervisory capacity. All calculated direct labor hours, indirect/supervision hours, and combined totals must reconcile with the cost breakout submission. The template currently contains calculation errors due to missing productivity rate inputs, indicating this is a blank form awaiting contractor data completion for the base period of January 1, 2027 to December 31, 2027.