J.34_Proposed_Productive_Hours_6-21-17.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
DLA Distribution Bahrain, Southwest Asia Contractor Owned Contractor Operated (COCO) Distribution Center
Solicitation number
SP330017R5010
Issued by

About this file

From the source

J.34 Proposed Productive Hours

View the file

Other files

File Type Posted
SP3300-17-R-5010_0008.pdf PDF
Industry_Questions_and_Government_Responses.docx DOCX document
RFP_SP3300-17-R-5010_Sections_B-M_Amendment_0007.docx DOCX document
Industry_Questions_and_Government_Responses.docx DOCX document
J.33,_DDNB_Training_as_of_Aug_14_2017.xlsx XLSX spreadsheet
J.1_Section_C_-_PWS_with_amendment_0007_changes.docx DOCX document
RFP_SP3300-17-R-5010_Sections_B-M_with_Amendment_0007_Changes.docx DOCX document
SP3300-17-R-5010_0007.pdf PDF
SP3300-17-R-5010_0006.pdf PDF
J.5,_CLIN_X008_Labor_Rate_Table.xlsx XLSX spreadsheet
Industry_Questions_and_Government_Responses.docx DOCX document
J.16_TE_2.1_Definitions_Acronyms_and_Abbreviations.docx DOCX document
J.30_TE_5.9_DSS_Load_and_Maintain.docx DOCX document
J.18_TE_3.2_Government_Training_.docx DOCX document
J.33,_DDNB_Training_as_of_Aug_2_2017.xlsx XLSX spreadsheet
J.4_Meclift_and_HATS_waiting_data.xlsx XLSX spreadsheet
RFP_SP3300-17-R-5010_Sections_B-M_Amendment_0006.docx DOCX document
J.20_TE_4.1_Contractor_Training.docx DOCX document
J.35,_Proposed_Training_Hours_for_Management,_Support_and_Distribution_Areas.xlsx XLSX spreadsheet
RFP_SP3300-17-R-5010_Sections_B-M_with_Amendment_0006_Changes.docx DOCX document
J.1_Section_C_-_PWS_with_amendment_0006_changes.docx DOCX document
J.2_Section_C-N_-_PWS_with_amendment_0006_changes.docx DOCX document
J.32_TE_6.2_Guard_Services_SOP.docx DOCX document
SP3300-17-R-5010_0005.pdf PDF
SP3300-17-R-5010_0004.pdf PDF
RFP_SP3300-17-R-5010_Sections_B-M_with_Amendment_0004_Changes.docx DOCX document
J.1_Section_C_-_PWS_with_amendment_0004_changes.docx DOCX document
Question_and_Answers.docx DOCX document
Attendance_Sheet.xlsx XLSX spreadsheet
Pre_Proposal_Conference_Presentation.pptx PPTX presentation
SP3300-17-R-5010_0003.pdf PDF
DLA_Distribution_Command_Presentation.PPTX PPTX presentation
SP3300-17-R-5010_0002.pdf PDF
J.1_Section_C_-_PWS.docx DOCX document
J.4_GE.xlsx XLSX spreadsheet
J.33_Draft_Distribution_Ops_Training_Schedule_June_15_2017.xlsx XLSX spreadsheet
A018_-_DBA_Insurance_Reporting_CLIN_X007.pdf PDF
J.6_IT_and_Misc_equipment.xlsx XLSX spreadsheet
J.32_TE_5.6_Guard_Services_SOP.docx DOCX document
RFP_SP3300-17-R-5010_Sections_B-M_with_Amendment_0002_Changes.docx DOCX document
J.2_Section_C-N_-_PWS.docx DOCX document
Updated_DDNB_Preproposal_Conference_Instructions.docx DOCX document
RFP_Revised_Page_73.pdf PDF
SP3300-17-R-5010_0001.pdf PDF
RFP_Revised_Page_72.pdf PDF
J.36_Subcontracting_Plan_Template_Updated_1.15.16.docx DOCX document
J.4_GE_MHE_(Meclift_and_other_forklifts_etc).zip ZIP file
J.8_Past_Performance_Questionnaire.docx DOCX document
Notice_Regarding_Restricted_Access.docx DOCX document
J.34,_DDNB_Proposed_Productive_Hours_2-27-17.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 62 listed here. See the rest on GovTribe.

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.

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 ParagraphProposed Labor CategorySpecific Activity and Labor Category ResponsibilitiesTime StandardY1 4mo TransitionY1 Workload (8mo)Y1 (8M0) HoursY2 WorkloadY2 HoursY3 WorkloadY3 HoursY4 WorkloadY4 HoursY5 WorkloadY5 Hours
C-1.3.1 Key Personnel
C-1.3.1 Key Personnel: Site Manager (Bahrain)
C-1.3.1 Key Personnel: Alternate Site Manager (Bahrain)
C-1.3.1 Key Personnel: Quality Control Specialist
C-1.3.1 Key Personnel: Supply Systems Analyst
C-1.3.1 Key Personnel: Transportation Manager
C-1.3.1 Key Personnel: Safety and Occupational Health (SOH) Representative
C-1.3.1 Key Personnel:Inventory Manager
C-1.3.1 Key Personnel:Security Manager
C-1.8 Transition Plan
Transition Team/SMEs (not to include Key Personnel)
C-4.6 Training
SMEs (not to include Key Personnel)
Section C-5 Specific Tasks
*Offerors shall factor in the processes described in C-5.2.5.1 through C-5.2.5.13, 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 110,88316,32516,28216,39516,395
C-5.2.2 Off-Load and Tally: Weight Band 23,5605,3395,3255,3635,360
C-5.2.2 Off-Load and Tally: Weight Band 32,8464,2704,2584,2884,286
C-5.2.2 Off-Load and Tally: Weight Band 4438625655660660
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 12,3512,3512,3512,3512,351
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 2769769769769769
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 3615615615615615
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 49595959595
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 18,8528,8528,8528,8528,852
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 22,8962,8962,8962,8962,896
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 32,3152,3152,3152,3152,315
C-5.2.3 /C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 4356356356356356
C-5.2.3/C-5.2.4.3 New Procurement (NP): Weight Band 19141,0281,0281,0281,028
C-5.2.3/C-5.2.4.3 New Procurement (NP): Weight Band 2299336336336336
C-5.2.3/C-5.2.4.3 New Procurement (NP): Weight Band 3239269269269269
C-5.2.3/C-5.2.4.3 New Procurement (NP): Weight Band 43741414141
Total C-5.2 Receiving Hours
Total C-5.2 Receiving FTEs
*Offerors shall factor in the processes described in C-5.3.4, Additional Storage Requirements, and in C-5.3.9, Additional Issue Requirements, in their prpoposed 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 110,88316,32516,28216,39516,395
C-5.3.1 Stow of Receipts: Weight Band 23,5605,3395,3255,3635,360
C-5.3.1 Stow of Receipts: Weight Band 32,8464,2704,2584,2884,286
C-5.3.1 Stow of Receipts: Weight Band 4438625655660660
C-5.3.3 Visual Inspections8441,1251,1251,1251,125
C-5.3.3 Cyclic Inspections1,2381,6501,6501,6501,650
C-5.3.3.1 Special Inspections275366366366366
C-5.3.7 Rewarehousing: Weight Band 14,9606,6146,6146,6146,614
C-5.3.7 Rewarehousing: Weight Band 2424566566566566
C-5.3.7 Rewarehousing: Weight Band 3401535535535535
C-5.3.7 Rewarehousing: Weight Band 43141414141
C-5.3.5 Autocad Planographs/DSS Location Identification/Storage Space Management Report*
C-5.3.8 Issue of Material (On-base): Weight Band 112,19618,29418,24518,37318,362
C-5.3.8 Issue of Material (On-Base): Weight Band 21,0861,6291,6251,6361,635
C-5.3.8 Issue of Material (On-Base): Weight Band 3513769767772772
C-5.3.8 Issue of Material (On-Base): Weight Band 45277777777
C-5.3.8 Issue of Material (Off-Base): Weight Band 147,23470,85170,66471,16071,117
C-5.3.8 Issue of Material (Off-Base): Weight Band 23,7845,6765,6615,7005,697
C-5.3.8 Issue of Material (Off-Base): Weight Band 33,4425,1625,1495,1855,182
C-5.3.8 Issue of Material (Off-Base): Weight Band 4231347346348348
C-5.3.8 Issue of Material (Transshipments On-Base)16,78125,17325,10625,28225,267
C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 16,76610,15010,12310,19410,188
C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 27921,1881,1851,1931,192
C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 31,3992,0992,0932,1082,106
C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 4126189189190190
C-5.3.8 Issue of Material (DROs): Weight Band 1525788787792791
C-5.3.8 Issue of Material (DROs): Weight Band 2103154154155155
C-5.3.8 Issue of Material (DROs): Weight Band 389133133134134
C-5.3.8 Issue of Material (DROs): Weight Band 4812121212
C-5.3.8 Rewarehousing Picks5,8167,7557,7557,7557,755
C-5.3.12 Shipment Preparation: Weight Band 154,00081,00180,78781,35481,305
C-5.3.12 Shipment Preparation: Weight Band 24,5766,8646,8466,8936,889
C-5.3.12 Shipment Preparation: Weight Band 34,8417,2617,2427,2937,288
C-5.3.12 Shipment Preparation: Weight Band 4357536535538538
Total C-5.3 Warehousing Hours
Total C-5.3 Warehousing FTEs
Section C-5.4 Physical Inventory Control
C-5.4 Physical Inventory (1st & 2nd Counts)8171,0891,0891,0891,089
C-5.4 3rd Count83111111111111
C-5.4.1 Physical Inventory Control (F2B 1st Counts)621621621621621
C-5.4.1 Physical Inventory Control (F2B 2nd Counts)6262626262
C-5.4.1 Physical Inventory Control (F2B TPIC M)6868686868
C-5.4.1 Physical Inventory Control (F2B 3rd Counts)6565656565
C-5.4.1 Physical Inventory Control (F2B Causative Research)33333
C-5.4.1.2 Causative Research11111
C-5.4.4 Location Surveys12,18712,18712,18712,18712,187
Total C-5.4 Physical Inventory Control Hours
Total C-5.4 Physical Inventory Control FTEs
Section C-5.5 Transportation
C-5.5.2 Freight Terminal/Ship: Weight Band 34,8417,2617,2427,2937,288
C-5.5.2 Freight Terminal/Ship: Weight Band 4357536535538538
Total C-5.5 Transportation Hours
Total C-5.5 Transportation FTEs
Section C-5.6 Packaging
C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): X-Small3652525252
C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM):Small4558585858
C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): Medium3656565656
C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): Large3655555555
C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): X-Large3656565656
C-5.6.1 Preservation, Packaging, Packing and Marking (PPPM): XX-Large2740404040
C-5.6 Remarks90121121121121
C-5.6.3 Container Fabrication Support: Small22222
C-5.6.3 Container Fabrication Support: Medium66666
C-5.6.3 Container Fabrication Support: Large22222
C-5.6.3 Container Fabrication Support: X-Large11111
Total C-5.6 Packaging Hours
Total C-5.6 Packaging FTEs
J2 Requirements
C1.5.1N MPC Bahrain MIS Element 627005,5038,2258,2258,2258,225
C1.5.1N MPC Bahrain Trans On2,1833,2743,2653,2883,286
C1.7N Guard Forces

C-6.6 Mandatory Reports/Other Administrative Duties

Total C-1 through C-6 & J2 Productive Hours
Total C-1 through C-6 & J2 FTEs

Sheet2

ReceiptsY1%Y2Y3Y4Y5SOURCE
WB110,88361.4%16,32516,28216,39516,395J3-OW
WB23,56020.1%5,3395,3255,3635,360J3-OW
WB32,84616.1%4,2704,2584,2884,286J3-OW
WB44382.5%625655660660J3-OW
REW STOWS5,8167,7557,7557,7557,755J3-OW
Total23,543100%34,31434,27534,46134,456J3-OW
17,727
NPY1Y2Y3Y4Y5SOURCEMETHOD TO DISTRIBUTE NP, CR, RDO/STO PROJ WL BY WB
WB19141,0281,0281,0281,028WB distribution in cell C2 applied to total receipts less REW STOWSREC TYPEQTY% OF TOTAL
WB2299336336336336WB distribution in cell C3 applied to total receipts less REW STOWSNP14898.4%
WB3239269269269269WB distribution in cell C4 applied to total receipts less REW STOWSCR/RFM340419.2%
WB43741414141WB distribution in cell C5 applied to total receipts less REW STOWSRDO/STO1281772.3%
Total1,4891,6751,6751,6751,675Derived from percent of histical total receipts (14%)TOTAL WB1-417,727100%
NP is 8.4% of total receipts. See note to right
C/RY1Y2Y3Y4Y5SOURCEMETHOD TO DISTRIBUTE NP, CR, RDO/STO PROJ WL BY WB
WB12,3512,3512,3512,3512,351WB distribution in cell C1 applied to total receipts less REW STOWSREC TYPEQTY% OF TOTAL
WB2769769769769769WB distribution in cell C2 applied to total receipts less REW STOWSNP16759.5%
WB3615615615615615WB distribution in cell C3 applied to total receipts less REW STOWSCR382919.2%
WB49595959595WB distribution in cell C4 applied to total receipts less REW STOWSRDO/STO1441972.3%
Total3,8293,8293,8293,8293,829Derived from percent of histical total receipts (19.2%)TOTAL WB1-417,727101%
CR is 19.2% of total receipts. See note to right.
RDO/STOY1Y2Y3Y4Y5SOURCEMETHOD TO DISTRIBUTE NP, CR, RDO/STO PROJ WL BY WB
WB18,8528,8528,8528,8528,852WB distribution in cell C1 applied to total receipts REW STOWSREC TYPEQTY% OF TOTAL
WB22,8962,8962,8962,8962,896WB distribution in cell C2 applied to total receipts less REW STOWSNP16759%
WB32,3152,3152,3152,3152,315WB distribution in cell C3 applied to total receipts less REW STOWSCR/RFM382919.2%
WB4356356356356356WB distribution in cell C4 applied to total receipts less REW STOWSRDO/STO1441972.3%
Total14,41914,41914,41914,41914,419Derived from percent of histical total receipts (72.3%)TOTAL WB1-417,727101%
RDO/STO is 72.3% of total receipts. See note to right
NSNs in StorageY1Y2Y3Y4Y5SOURCE
13,00113,00113,00113,00113,001J3-OW
Issues On-BaseY1Y2Y3Y4Y5SOURCE
WB112,19618,29418,24518,37318,362J3-OW
WB21,0861,6291,6251,6361,635J3-OW
WB3513769767772772J3-OW
WB45277777777J3-OW
Total13,84620,76920,71420,85820,846J3-OW
Issues Off-BaseY1Y2Y3Y4Y5SOURCE
WB147,23470,85170,66471,16071,117J3-OW
WB23,7845,6765,6615,7005,697J3-OW
WB33,4425,1625,1495,1855,182J3-OW
WB4231347346348348J3-OW
Total54,69182,03681,82082,39382,344J3-OW
Trans OffY1Y2Y3Y4Y5SOURCE
WB16,76610,15010,12310,19410,188J3-OW
WB27921,1881,1851,1931,192J3-OW
WB31,3992,0992,0932,1082,106J3-OW
WB4126189189190190J3-OW
Total9,08413,62613,59013,68513,676J3-OW
Trans OnY1Y2Y3Y4Y5SOURCE
16,78125,17325,10625,28225,267J3-OW
MPC Bahrain Trans OnY1Y2Y3Y4Y5SOURCE
2,1833,2743,2653,2883,286J3-OW
MPC MIS Element 62700Y1Y2Y3Y4Y5SOURCE
DDNB5,5038,2258,2258,2258,225J3-OW
DROY1Y2Y3Y4Y5SOURCE
WB1525788787792791J3-OW
WB2103154154155155J3-OW
WB389133133134134J3-OW
WB4812121212J3-OW
Total7251,0871,0861,0931,092J3-OW
Freight-WB3 and WB4 Off base IssuesY1Y2Y3Y4Y5SOURCE
WB34,8417,2617,2427,2937,288WB3 off-base issues + WB3 off-base transshipments
WB4357536535538538WB4 off-base issues + WB4 off-base transshipments
Includes off base issues and off-base transshipments
RewarehousingY1Y2Y3Y4Y5SOURCEMETHOD TO DISTRIBUTE REWAREHOUSING BY WB
WB14,9606,6146,6146,6146,614Because J3-OW did not breakdown in to WB, workload was determined based on the percent of total issues (less all Transshipments on base) by WB using the table at rightWB166,19685.28%
WB2424566566566566Because J3-OW did not breakdown in to WB, workload was determined based on the percent of total issues (less all Transshipments on base) by WB using the table at rightWB25,6627.29%
WB3401535535535535Because J3-OW did not breakdown in to WB, workload was determined based on the percent of total issues (less all Transshipments on base) by WB using the table at rightWB35,3546.90%
WB43141414141Because J3-OW did not breakdown in to WB, workload was determined based on the percent of total issues (less all Transshipments on base) by WB using the table at rightWB44090.53%
Total5,8167,7557,7557,7557,755Historical averageTOTAL77,620100.00%
PackingY1Y2Y3Y4Y5SOURCE
WB154,00081,00180,78781,35481,305Off base issues + off-base transshipments
WB24,5766,8646,8466,8936,889Off base issues + off-base transshipments
WB34,8417,2617,2427,2937,288Off base issues + off-base transshipments
WB4357536535538538Off base issues + off-base transshipments
Total63,77495,66295,41096,07896,020Sum of WB1 through WB4
Stock ReadinessY1Y2Y3Y4Y5SOURCE
Visual Inspections8441,1251,1251,1251,125J3-OW
Cyclic Inspections1,2381,6501,6501,6501,650J3-OW
Special Inspections275366366366366J3-OW
Physical InventoryY1Y2Y3Y4Y5SOURCE
Physical Inventory8171,0891,0891,0891,089J3-OW
Causative Research11111J3-OW
3rd Count83111111111111J3-OW
Location Survey (1st & 2nd counts)12,18712,18712,18712,18712,187J3-OW
Floor to BookY1Y2Y3Y4Y5SOURCE
Floor to Book 1st Count621621621621621Floor to Book workload is 5% of total locations (12,415)
2nd Floor to Book for Count Mismatches62626262622nd Floor to Book for Unresolved Count Mismatches is 10% of Floor to Book workload
TPIC M Inventories6868686868TPIC M workload is 11% of F2B workload
3rd Counts65656565653rd count workload is 95% of TPIC M workload
Causative Research33333Causative research workload is 5% of 3rd count workload
PPP&MY1Y2Y3Y4Y5SOURCE
PPP&M XSmall3652525252J3-OW
PPP&M (Small)4558585858J3-OW
PPP&M (Medium)3656565656J3-OW
PPP&M (Large)3655555555J3-OW
PPP&M (X-Large)3656565656J3-OW
PPP&M (XX-Large)2740404040J3-OW
Total216317317317317J3-OW
RemarksY1Y2Y3Y4Y5SOURCE
Wholesale Remarks90121121121121J3-OW
Container FabricationY1Y2Y3Y4Y5SOURCE
Container Fabrication(XSmall)0J3-OW
Container Fabrication(Small)22222J3-OW
Container Fabrication(Medium)66666J3-OW
Container Fabrication(Large)22222J3-OW
Container Fabrication(XL)11111J3-OW
Container Fabrication (XXL)J3-OW

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