Attachment_J.33_Proposed_Productive_Hours.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- Distribution and Warehouse Services Federal contract opportunity
- Solicitation number
- SP3300-18-R-5004
- Issued by
- Defense Logistics Agency Distribution
About this file
Attachment J.33 - Proposed Productive Hours
View the file
Other files for this federal contract opportunity
Show all 50
Distribution and Warehouse Services has more files on GovTribe.
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Proposed Productive Labor Hours | ||||||||||||||
| Instructions: See Section L of the RFP. *Note - The standard mearsurement of time to be used for the Standard Times in Column D shall be number of hours e.g. 5 minutes =.0833 hours. All figures shall be rounded to the tenthousandths decimal place. | ||||||||||||||
| Offerors may add rows to this document to account for tasks to be performed by more than one specific labor category. | ||||||||||||||
| PWS Paragraph | Proposed Labor Category, only one per row | Labor Category Responsibilities | Time Standard | Y1 3mo Transition Hours | Y1 Workload (9mo) | Y1 (9M0) Hours | Y2 Workload | Y2 Hours | Y3 Workload | Y3 Hours | Y4 Workload | Y4 Hours | Y5 Workload | Y5 Hours |
| C-1.3.1 Key Personnel | ||||||||||||||
| C-1.3.1 Key Personnel: Site Manager | ||||||||||||||
| C-1.3.1 Key Personnel: Alternate Site Manager | ||||||||||||||
| C-1.3.1 Key Personnel: Quality Control Specialist | ||||||||||||||
| C-1.3.1 Key Personnel: Supply Systems Analyst | ||||||||||||||
| C-1.3.1 Key Personnel: Inventory Manager | ||||||||||||||
| C-1.3.1 Key Personnel: Transportation Manager | ||||||||||||||
| Total C-1.3.1 Key Personnel Hours | ||||||||||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||||||||||
| Total C-1.3.1 Key Personnel FTEs | ||||||||||||||
| Government Estimated FTEs | 6 | 6 | 6 | 6 | 6 | 6 | ||||||||
| Difference between Proposed and Government Estimated FTEs |
| C-1.3.2 Non-Key Personnel (list personnel not covered in any other functional area | ||||||
| C-1.3.2 EXAMPLE - Administrative Assistant | 1,335 | 1,780 | 1,780 | 1,780 | 1,780 | |
| Total C-1.3.2 Non-Key Personnel Hours | ||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||
| Total C-1.3.2 Non-Key Personne FTEs | ||||||
| Government Estimated FTEs | 0 | 1 | 1 | 1 | 1 | 1 |
| Difference between Proposed and Government Estimated FTEs |
| C-1.4 Security | ||||||
| C-1.4 Security | ||||||
| Total C-1.4 Security Hours | ||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||
| Total C-1.4 Security FTEs | ||||||
| Government Estimated FTEs | 0 | 1 | 1 | 1 | 1 | 1 |
| Difference between Proposed and Government Estimated FTEs |
| C-1.4N Facility Security | ||||||
| C-1.4N Facility Security | ||||||
| Total C-1.4N Facility Security Hours | ||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||
| Total C-1.4N Facility Security FTEs | ||||||
| Government Estimated FTEs | 0 | 1 | 1 | 1 | 1 | 1 |
| Difference between Proposed and Government Estimated FTEs |
| C-1.5 Safety & Occupational Health (SOH) | ||||||
| C-1.5 Safety & Occupational Health (SOH) | ||||||
| Total C-1.5 SOH Hours | ||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||
| Total C-1.5 SOH FTEs | ||||||
| Government Estimated FTEs | 0 | 1 | 1 | 1 | 1 | 1 |
| Difference between Proposed and Government Estimated FTEs |
| C-4.4 Equipment Maintenance | ||||||
| C-4.4 Equipment Maintenance | ||||||
| Total C-4.4 Equipment Maintenance Hours | ||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||
| Total C-4.4 Equipment Maintenance FTEs | ||||||
| Government Estimated FTEs | 0 | 1 | 1 | 1 | 1 | 1 |
| Difference between Proposed and Government Estimated FTEs |
| C-5.1.4 Quality Control Plan (QCP) | ||||||
| C-5.1.4 QCP* | ||||||
| Total C-5.1.4 QCP Hours | ||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||
| Total C-5.1.4 QCP FTEs | ||||||
| Government Estimated FTEs | 0 | 2 | 2 | 2 | 2 | 2 |
| Difference between Proposed and Government Estimated FTEs |
| C-5.1.5 Customer Service Plan (CSP) and Support | |||||||||||
| C-5.1.5 CSP and Support* | |||||||||||
| Total C-5.1.5 CSP and Support Hours | |||||||||||
| FTE Productive Hours e.g. 1,780hrs | |||||||||||
| Total C-5.1.5 CSP and Support FTEs | |||||||||||
| Government Estimated FTEs | 0 | 1 | 1 | 1 | 1 | 1 | |||||
| Difference between Proposed and Government Estimated FTEs | |||||||||||
| Section C-5 Specific Tasks | |||||||||||
| *Offerors shall factor in the processes described in C-5.2.5 through C-5.2.5.15, Additional Receiving Requirements, in their prpoposed time standards for the Non-Procurement and New Procurement receiving tasks listed below in section C-5.2* | |||||||||||
| Section C-5.2 Receiving | |||||||||||
| C-5.2.1 In-Bound Traffic Management* | |||||||||||
| C-5.2.2 Off-Load and Tally: Weight Band 1 | 6,809 | 9,077 | 9,050 | 9,077 | 9,077 | ||||||
| C-5.2.2 Off-Load and Tally: Weight Band 2 | 1,544 | 2,059 | 2,053 | 2,059 | 2,059 | ||||||
| C-5.2.2 Off-Load and Tally: Weight Band 3 | 1,113 | 1,484 | 1,480 | 1,484 | 1,484 | ||||||
| C-5.2.2 Off-Load and Tally: Weight Band 4 | 178 | 238 | 237 | 238 | 238 | ||||||
| C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 1 | 1,747 | 2,719 | 2,711 | 2,719 | 2,719 | ||||||
| C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 2 | 396 | 617 | 615 | 617 | 617 | ||||||
| C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 3 | 286 | 445 | 443 | 445 | 445 | ||||||
| C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 4 | 46 | 71 | 71 | 71 | 71 | ||||||
| C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 1 | 3,508 | 5,459 | 5,444 | 5,459 | 5,459 | ||||||
| C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 2 | 796 | 1,238 | 1,235 | 1,238 | 1,238 | ||||||
| C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 3 | 574 | 893 | 890 | 893 | 893 | ||||||
| C-5.2.3 /C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 4 | 92 | 143 | 143 | 143 | 143 | ||||||
| C-5.2.3/C-5.2.4.4 New Procurement (NP): Weight Band 1 | 577 | 899 | 896 | 899 | 899 | ||||||
| C-5.2.3/C-5.2.4.4 New Procurement (NP): Weight Band 2 | 131 | 204 | 203 | 204 | 204 | ||||||
| C-5.2.3/C-5.2.4.4 New Procurement (NP): Weight Band 3 | 94 | 147 | 146 | 147 | 147 | ||||||
| C-5.2.3/C-5.2.4.4 New Procurement (NP): Weight Band 4 | 15 | 24 | 23 | 24 | 24 | ||||||
| C-5.2 Receiving: Subject Matter Expert | |||||||||||
| Total C-5.2 Receiving Hours | |||||||||||
| FTE Productive Hours e.g. 1,780hrs | |||||||||||
| Total C-5.2 Receiving FTEs | |||||||||||
| Government Estimated FTEs | 1 | 6 | 6 | 6 | 6 | 6 | |||||
| Difference between Proposed and Government Estimated FTEs |
| *Offerors shall factor in the processes described in C-5.3.4.1 through C-5.3.4.5, Additional Storage Requirements, and in C-5.3.9, Additional Issue Requirements and C-5.3.11 Issues to DLA Disposition Services, in their proposed time standards for tasks listed below for section C-5.3* | |||||||||||
| Section C-5.3 Warehousing | |||||||||||
| C-5.3.1 Stow of Receipts: Weight Band 1 | 6,809 | 9,077 | 9,050 | 9,077 | 9,077 | ||||||
| C-5.3.1 Stow of Receipts: Weight Band 2 | 1,544 | 2,059 | 2,053 | 2,059 | 2,059 | ||||||
| C-5.3.1 Stow of Receipts: Weight Band 3 | 1,113 | 1,484 | 1,480 | 1,484 | 1,484 | ||||||
| C-5.3.1 Stow of Receipts: Weight Band 4 | 178 | 238 | 237 | 238 | 238 | ||||||
| C-5.3.3 Visual Inspections | 1,697 | 2,262 | 2,262 | 2,262 | 2,262 | ||||||
| C-5.3.3.1 Special Inspections & Quality | 650 | 867 | 867 | 867 | 867 | ||||||
| C-5.3.3 Cyclic Inspections | 558 | 743 | 743 | 743 | 743 | ||||||
| C-5.3.5 Autocad Planographs/DSS Location Identification/Storage Space Management Report* | |||||||||||
| C-5.3.8 Issue of Material (On-base): Weight Band 1 | 10,559 | 14,077 | 14,035 | 14,077 | 14,077 | ||||||
| C-5.3.8 Issue of Material (On-Base): Weight Band 2 | 1,026 | 1,368 | 1,364 | 1,368 | 1,368 | ||||||
| C-5.3.8 Issue of Material (On-Base): Weight Band 3 | 787 | 1,049 | 1,046 | 1,049 | 1,049 | ||||||
| C-5.3.8 Issue of Material (On-Base): Weight Band 4 | 81 | 108 | 107 | 108 | 108 | ||||||
| C-5.3.8 Issue of Material (Off-Base): Weight Band 1 | 13,852 | 18,468 | 18,413 | 18,468 | 18,468 | ||||||
| C-5.3.8 Issue of Material (Off-Base): Weight Band 2 | 429 | 572 | 570 | 572 | 572 | ||||||
| C-5.3.8 Issue of Material (Off-Base): Weight Band 3 | 664 | 885 | 882 | 885 | 885 | ||||||
| C-5.3.8 Issue of Material (Off-Base): Weight Band 4 | 60 | 80 | 80 | 80 | 80 | ||||||
| C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 1 | 5,406 | 7,208 | 7,186 | 7,208 | 7,208 | ||||||
| C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 2 | 287 | 382 | 381 | 382 | 382 | ||||||
| C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 3 | 518 | 691 | 689 | 691 | 691 | ||||||
| C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 4 | 114 | 153 | 152 | 153 | 153 | ||||||
| C-5.3.8 Issue of Material (DROs): Weight Band 1 | 176 | 234 | 234 | 234 | 234 | ||||||
| C-5.3.8 Issue of Material (DROs): Weight Band 2 | 27 | 35 | 35 | 35 | 35 | ||||||
| C-5.3.8 Issue of Material (DROs): Weight Band 3 | 16 | 21 | 21 | 21 | 21 | ||||||
| C-5.3.8 Issue of Material (DROs): Weight Band 4 | 0 | 0 | 0 | 0 | 0 | ||||||
| C-5.3.8 Issue of Material (Transshipments On-Base): NLC | 1,430 | 1,906 | 1,901 | 1,906 | 1,906 | ||||||
| C-5.3.8 Issue of Material (Transshipments On-Base): MPC | 27,868 | 37,154 | 37,042 | 37,154 | 37,154 | ||||||
| C-5.3.12 Shipment Preparation: Weight Band 1 | 19,434 | 25,910 | 25,833 | 25,910 | 25,910 | ||||||
| C-5.3.12 Shipment Preparation: Weight Band 2 | 743 | 989 | 15,626 | 15,645 | 989 | ||||||
| C-5.3.12 Shipment Preparation: Weight Band 3 | 1,198 | 1,597 | 9,656 | 9,668 | 1,597 | ||||||
| C-5.3.12 Shipment Preparation: Weight Band 4 | 174 | 233 | 504 | 776 | 233 | ||||||
| C-5.3 Warehousing: Subject Matter Expert | |||||||||||
| Total C-5.3 Warehousing Hours | |||||||||||
| FTE Productive Hours e.g. 1,780hrs | |||||||||||
| Total C-5.3 Warehousing FTEs | |||||||||||
| Government Estimated FTEs | 1 | 13 | 13 | 13 | 13 | 13 | |||||
| Difference between Proposed and Government Estimated FTEs |
| Section C-5.4 Physical Inventory Control | |||||||||||
| C-5.4 Physical Inventory | 1,137 | 1,214 | 1,214 | 1,214 | 1,214 | ||||||
| C-5.4.1 Physical Inventory Control (F2B 1st Counts) | 425 | 567 | 567 | 567 | 567 | ||||||
| C-5.4.1 Physical Inventory Control (F2B 2nd Counts) | 0 | 0 | 0 | 0 | 253 | ||||||
| C-5.4.1 Physical Inventory Control (F2B TPIC M) | 0 | 0 | 0 | 0 | 0 | ||||||
| C-5.4.1 Physical Inventory Control (F2B 3rd Counts) | 0 | 0 | 0 | 0 | 0 | ||||||
| C-5.4.1 Physical Inventory Control (F2B Causative Research) | 0 | 0 | 0 | 0 | 0 | ||||||
| C-5.4.1.2 Causative Research | 0 | 0 | 0 | 0 | 0 | ||||||
| 5.4.1.2 Research of Potential or Actual Physical inventory adjustments (3rd Count) | 2 | 4 | 4 | 4 | 4 | ||||||
| C-5.4.4 Location Surveys (1% of locations) | 204 | 272 | 272 | 272 | 272 | ||||||
| C-5.4 Inventory: Subject Matter Expert | |||||||||||
| Total C-5.4 Physical Inventory Control Hours | |||||||||||
| FTE Productive Hours e.g. 1,780hrs | |||||||||||
| Total C-5.4 Physical Inventory Control FTEs | |||||||||||
| Government Estimated FTEs | 1 | 3 | 3 | 3 | 3 | 3 | |||||
| Difference between Proposed and Government Estimated FTEs |
| *Offerors shall factor in the processes described in C-5.5.2 through C-5.5.5 in their proposed time standards for tasks listed below for section C-5.5* | |||||||||||
| Section C-5.5 Transportation | |||||||||||
| C-5.5 Transportation Weight Band 1 | 19,258 | 25,676 | 25,599 | 25,676 | 25,676 | ||||||
| C-5.5 Transportation Weight Band 2 | 716 | 954 | 951 | 954 | 954 | ||||||
| C-5.5 Transportation Weight Band 3 | 1,182 | 1,576 | 1,571 | 1,576 | 1,576 | ||||||
| C-5.5 Transportation Weight Band 4 | 174 | 233 | 232 | 233 | 233 | ||||||
| C-5.5 Transportation: Subject Matter Expert | |||||||||||
| Total C-5.5 Transportation Hours | |||||||||||
| FTE Productive Hours e.g. 1,780hrs | |||||||||||
| Total C-5.5 Transportation FTEs | |||||||||||
| Government Estimated FTEs | 1 | 7 | 7 | 7 | 7 | 7 | |||||
| Difference between Proposed and Government Estimated FTEs |
| Section C-5.6 Packaging | |||||||||||
| C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): X-Small | 174 | 233 | 232 | 233 | 233 | ||||||
| C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM):Small | 546 | 729 | 726 | 729 | 729 | ||||||
| C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): Medium | 372 | 497 | 496 | 497 | 497 | ||||||
| C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): Large | 108 | 144 | 144 | 144 | 144 | ||||||
| C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): X-Large | 29 | 39 | 39 | 39 | 39 | ||||||
| C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): XX-Large | 81 | 107 | 107 | 107 | 107 | ||||||
| C-5.6 Remarks | 472 | 628 | 630 | 628 | 628 | ||||||
| C-5.5 Packaging: Subject Matter Expert | |||||||||||
| Total C-5.6 Packaging Hours | |||||||||||
| FTE Productive Hours e.g. 1,780hrs | |||||||||||
| Total C-5.6 Packaging FTEs | |||||||||||
| Government Estimated FTEs | 1 | 3 | 3 | 3 | 3 | 3 | |||||
| Difference between Proposed and Government Estimated FTEs |
C-6.6 Mandatory Reports/Other Administrative Duties
| C-5.7N Material Processing Center (MPC) | ||||||||||
| C-5.7N Material Processing Center (MPC) | 47,401 | 63,201 | 63,201 | 63,201 | 63,201 | |||||
| Total C-5.7N Hours | ||||||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||||||
| Total C-5.7N FTEs | ||||||||||
| Government Estimated FTEs | 4 | 4 | 4 | 4 | 4 | |||||
| Difference between Proposed and Government Estimated FTEs |
| C-5.8N Theater Consolidation & Shipping Point (TCSP) & Air/Surface Pallet-Seavan Breakdown | ||||||||||
| C-5.8N TCSP & Air / Surface Pallet-Seavan Breakdown | 6,059 | 8,078 | 8,078 | 8,078 | 8,078 | |||||
| Total C-5.8N Hours | ||||||||||
| FTE Productive Hours e.g. 1,780hrs | ||||||||||
| Total C-5.8N FTEs | ||||||||||
| Government Estimated FTEs | 3 | 3 | 3 | 3 | 3 | |||||
| Difference between Proposed and Government Estimated FTEs |
| Total C-1 through C-5.8N Productive Hours | ||||||
| Total C-1 through C-5.8N FTEs | ||||||
| Government Estimated FTEs for C-1 through C-5.8N | 11 | 53 | 53 | 53 | 53 | 53 |
| Overall Difference between Proposed and Government Estimated FTEs |
&"-,Bold"Proposed Productive Hours &"-,Bold"SP3300-18-R-5004 Attachment J.33
&"-,Bold"1 of &N
File details come from the government source that posted it.