Attachment_5_-_Volume_II_-_Direct_and_Indirect_Labor_Summary_(v1).xlsx

XLSX spreadsheet 59 KB Posted

Attached to
Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial Operations for the Fort Lewis Commissary
Solicitation number
HQC00822R0020
Issued by

About this file

Written by GovTribe AI ·

This document contains a direct and indirect labor summary template for a solicitation seeking shelf stocking, receiving/storage/holding area (RSHA), and custodial operations services at the Fort Lewis Commissary in Washington state. The template requires offerors to input yearly workload quantities, proposed productivity rates in cases or square feet per person per hour, and total direct labor hours for shelf stocking, RSHA receiving and storage, transporting merchandise, segregating merchandise, storing merchandise, pulling merchandise, and custodial services for administrative areas, storage areas, a meat processing room, and outside areas. Offerors must also specify proposed total supervision hours and ensure total direct and indirect hours match the volumes submitted in their cost worksheets.

View the file

Other files

File Type Posted
HQC00822R0020_FORT_LEWIS_SOLICITATION_AMENDMENT_0004.pdf PDF
HQC00822R0020_FORT_LEWIS_SOLICITATION_AMENDMENT_0003.pdf PDF
Amendment_0003_ Attachment_ 3_ Volume_I_Pricing_Schedule_Cost_Breakout.xlsx XLSX spreadsheet
Attachment_1_-_Performance_Work_Statement_Fort_Lewis_dated_3-8-22.docx DOCX document
Amendment 0002 - Attachment_4_-_Volume II_-_Technical_Capability_and_Personnel_(v1).doc DOC document
Amendment_0001_ Attachment_ 3_ Volume_I_Pricing_Schedule_Cost_Breakout.xlsx XLSX spreadsheet
HQC00822R0020_FORT_LEWIS_SOLICITATION.pdf PDF
Attachment_2_-_Collective_Bargaining_Agreement.pdf PDF
Attachment_6_-_Past_Performance_Information_(v1).docx DOCX document
Attachment_7_-_Bereavement_Leave_Certification.doc DOC document
HQC00822R0020_FORT_LEWIS_SOLICITATION_AMENDMENT_0002.pdf PDF
Attachment_3_-_Volume_ I_-_Pricing_Schedule_-_Cost_Breakout.xlsx XLSX spreadsheet
HQC00822R0020_FORT_LEWIS_SOLICITATION_AMENDMENT_0001.pdf PDF
Attachment_4_-_Volume II_-_Technical_Capability_and_Personnel_(v1).doc DOC document
Show all 14

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Direct-Indirect Labor Summary

(Enter data in cells with red font only.)
Shelf Stocking Direct Labor
Night Shelf Stocking
Cases per YearProductivity Rate (cases per person per productive hour)Direct Productive Hrs Required (cases/productivity rate)
896,4000ERROR:#DIV/0!
Displays (includes 100% of displays)
Cases per YearProductivity Rate (cases per person per productive hour)Direct Productive Hrs Required (cases/productivity rate)
189,0000ERROR:#DIV/0!
Day Shelf Stocking
Cases per YearProductivity Rate (cases per person per productive hour)Direct Productive Hrs Required (cases/productivity rate)
84,3840ERROR:#DIV/0!
Shelf Stocking Direct LaborDirect Productive Hrs RequiredTotal Annual Cases
SubtotalERROR:#DIV/0!1,169,784
D
Receiving/Storage/Holding Area Direct Labor
Offload Trucks
Cases per YearProductivity Rate (cases per person per productive hour)Direct Productive Hrs Required (cases/productivity rate)
1,181,7840ERROR:#DIV/0!
Transport Merchandise
Cases per YearProductivity Rate (cases per person per productive hour)Direct Productive Hrs Required (cases/productivity rate)
408,0000ERROR:#DIV/0!
Segregate Merchandise
Cases per YearProductivity Rate (cases per person per productive hour)Direct Productive Hrs Required (cases/productivity rate)
1,169,7840ERROR:#DIV/0!
Store Merchandise
Cases per YearProductivity Rate (cases per person per productive hour)Direct Productive Hrs Required (cases/productivity rate)
120,0000ERROR:#DIV/0!
Pull Merchandise
Cases per YearProductivity Rate (cases per person per productive hour)Direct Productive Hrs Required (cases/productivity rate)
120,0000ERROR:#DIV/0!
RSHA Coverage for Contractor Work ScheduleDirect Productive Hrs Required
(if required)0
Receiving/Storage/Holding Area Direct LaborDirect Productive Hrs Required
SubtotalERROR:#DIV/0!
Custodial Direct Labor
Administrative/Store/Patron Area
Square Feet per YearProductivity Rate (sq ft per crew per productive hour)Direct Productive Hrs Required (sq ft/productivity rate)
17,476,6840ERROR:#DIV/0!
Receiving/Storage/Holding Area
Square Feet per YearProductivity Rate (sq ft per crew per productive hour)Direct Productive Hrs Required (sq ft/productivity rate)
8,509,1720ERROR:#DIV/0!
Meat Processing Room
Square Feet per YearProductivity Rate (sq ft per crew per productive hour)Direct Productive Hrs Required (sq ft/productivity rate)
1,198,2200ERROR:#DIV/0!
Outside Areas
Square Feet per YearProductivity Rate (sq ft per crew per productive hour)Direct Productive Hrs Required (sq ft/productivity rate)
4,552,1500ERROR:#DIV/0!
Day Custodial RequirementsDirect Productive Hrs Required
0
Custodial Direct LaborDirect Productive Hrs Required
SubtotalERROR:#DIV/0!
Total Direct Productive Hours
Direct Productive Hrs Required
ERROR:#DIV/0!
SUPERVISION HOURS (Indirect Labor)
(Identify only those hours used exclusively in a supervisory capacity-DO NOT include hours spent performing direct labor tasks)
Indirect Labor Requirements
(MUST match total indirect hours shown in the Volume I, Cost Breakout)Indirect Hrs Required
0
TOTAL SUPERVISION (Indirect Labor AND DIRECT HOURS
Direct/Indirect Labor Requirements
Direct/Indirect Hrs Required
ERROR:#DIV/0!
Offeror Name: _________________&"Arial,Bold"&12&E
Direct Labor Summary&"Arial,Bold"ATTACHMENT 5

HQC008-22-R-0003

&"Arial,Regular"

DLS Instructions

DIRECT AND INDIRECT LABOR SUMMARY
INSTRUCTIONS

1. Offeror. Use the name shown on the SF 33, block 15A.

2. Solicitation. HQC008-22-R-0003

3. Work Load. The yearly workload quantities are already shown on the form in
the left-handed column. Do not make any adjustments to the quantities shown.
Offerors are to insert their productivity rates and total direct labor hours for each
function only.
4. Productivity Rate. For shelf stocking and RSHA services, enter the
productivity rate in terms of cases per person per productive hour. For custodial,
enter the productivity rate in terms of square feet per crew per productive hour.

5. Coverage and Supervision. Input direct hours proposed only.

6. Total Productive Hours. Equals the total direct hours for shelf stocking,
RSHA, and custodial services combined.
7. Direct Productive Hours Proposed. Enter the total number of hours
shown for each function on your cost worksheets in this block. (Note: The
numbers shown in this block should match exactly the direct productive hours
shown on your cost worksheets.)

File details come from the government source that posted it. Updated .