SP330023R5001 Attachment J.8 Staffing Matrix.xls

XLS spreadsheet 1 MB Posted

Attached to
DLA Distribution Guam Marianas Distribution and Warehousing Services
Solicitation number
SP330023R5001
Issued by

View the file

Other files

File Type Posted
SF33 SP330023R5001 conformed via Amendment 0003.pdf PDF
SP330023R5001 Attachment J.5 TE 4.1 Contractor Training.docx DOCX document
SP330023R5001 Amendment 0003.pdf PDF
SP3300-23-R-5001 Sections B - M conformed via Amendment 0003.docx DOCX document
SP3300-23-R-5001 Sections B - M conformed via Amendment 0002.docx DOCX document
SF33 SP330023R5001 conformed via Amendment 0002.pdf PDF
SP330023R5001 Amendment 0002.pdf PDF
Attachment J.7 CDRL A023 - Storage and Warehousing Plan - 6.20.23 - Conformed via Amendment 0001.pdf PDF
QA Document-Amendment 0001 - FINAL.pdf PDF
SP330023R5001 Amendment 0001.pdf PDF
Attachment J.5 TE 5.0 APLs - 6.20.23 - Conformed via Amendment 0001.docx DOCX document
DDGM - J.1 - 6.20.23 - Conformed via Amendment 0001.docx DOCX document
Attachment J.7 CDRL A003 - Electrostatic Discharge (ESD) Control Program - 6.20.23 - Conformed via Amendment 0001.pdf PDF
SP3300-23-R-5001 Sections B - M conformed via Amendment 0001.docx DOCX document
DDGM Pre-Proposal Conf Agenda - 5.23.23 - Final.doc DOC document
SP330023R5001 Attachment J.6 - Past Performance Questionnaire.docx DOCX document
SP330023R5001 FINAL for posting 5-22-2023.pdf PDF
SP330023R5001 Attachment J.10 - Accounting System Self-Certification.docx DOCX document
SP330023R5001 Attachment J.9 Proposed Training Hours.xlsx XLSX spreadsheet
SP330023R5001 Attachment J.5 TEs.ZIP ZIP file
SP330023R5001 Attachment J.3 - DDGM CBA 2020-2025.pdf PDF
SP330023R5001 Attachment J.12 - DD254.pdf PDF
SP330023R5001 Attachment J.7 CDRLs.ZIP ZIP file
SP330023R5001 Attachment J.2.docx DOCX document
SP330023R5001 Attachment J.11 - CUI Marking Guidance.pptx PPTX presentation
SP330023R5001 Attachment J.1.docx DOCX document
SP330023R5001 Attachment J.4, CLIN X006 Labor Rate Table.xlsx XLSX spreadsheet
SP330023R5001 Attachment J.3 - Wage Determination.pdf PDF
Show all 28

On GovTribe

Work with this file

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

Text version

J.XX (2)

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 Category, only one per rowLabor Category ResponsibilitiesComposite Time StandardIndividual Time StandardY1 3mo Transition HoursY1 Workload (9mo)Y1 (9M0) HoursY2 WorkloadY2 HoursY3 WorkloadY3 HoursY4 WorkloadY4 HoursY5 WorkloadY5 Hours
C-1.3.1 Key Personnel(Gov't Est in FTE for Key Personnel)(Gov't Est in FTE for Key Personnel)(Gov't Est in FTE for Key Personnel)(Gov't Est in FTE for Key Personnel)(Gov't Est in FTE for Key Personnel)(Gov't Est in FTE for Key Personnel)
PWS ParagraphProposed Labor Category, only one per rowLabor Category ResponsibilitiesComposite Time StandardIndividual Time StandardY1 3mo Transition HoursY1 Workload (9mo)Y1 (9M0) HoursY2 WorkloadY2 HoursY3 WorkloadY3 HoursY4 WorkloadY4 HoursY5 WorkloadY5 Hours
C-1.3.1 Key Personnel: Site ManagerSite Manager445.001,335.001,780.001,780.001,780.001,780.00
C-1.3.1 Key Personnel: Alternate Site ManagerAlternate Site Manager445.001,335.001,780.001,780.001,780.001,780.00
C-1.3.1 Key Personnel: Quality Control SpecialistQuality Control Specialist445.001,335.001,780.001,780.001,780.001,780.00
C-1.3.1 Key Personnel: Supply Systems AnalystSupply Systems Analyst445.001,335.001,780.001,780.001,780.001,780.00
C-1.3.1 Key Personnel: Inventory ManagerInventory Manager445.001,335.001,780.001,780.001,780.001,780.00
C-1.3.1 Key Personnel: Transportation ManagerTransportation Manager445.001,335.001,780.001,780.001,780.001,780.00
C-1.3.1 Key Personnel: Safety and Occupational Health (SOH) RepresentativeSafety and Occupational Health (SOH) Representative445.001,335.001,780.001,780.001,780.001,780.00
C-1.3.1 Key Personnel: Security Spec (C-1.4 functions)Security Specialist445.001,335.001,780.001,780.001,780.001,780.00
C-1.3.2 EXAMPLE - Administrative AssistantAdministrative Assistant1,335.001,780.001,780.001,780.001,780.00
C-1.3.1 N GUARDGuard1,335.001,780.001,780.001,780.001,780.00
C-4.4 Equipment MaintenanceMotor Vehicle Maintenance Mechanic2,670.003,560.003,560.003,560.003,560.00
C-5.1.4 QCP*Warehouse Specialist1,335.001,780.001,780.001,780.001,780.00
C-5.1.5 CSP and Support*Warehouse Specialist1,335.001,780.001,780.001,780.001,780.00
C-5.2.1 In-Bound Traffic Management*Warehouse Specialist
C-5.2.2 Off-Load and Tally: Weight Band 1Shipping/Receiving Clerk0.150011,4931,723.9512,7611,914.1500.0000.0000.00
C-5.2.2 Off-Load and Tally: Weight Band 2Shipping/Receiving Clerk0.150012,7011,905.1514,1022,115.3000.0000.0000.00
C-5.2.2 Off-Load and Tally: Weight Band 3Shipping/Receiving Clerk0.166713,7852,297.5015,3062,551.0000.0000.0000.00
C-5.2.2 Off-Load and Tally: Weight Band 4Shipping/Receiving Clerk0.166712,1602,026.6713,5012,250.1700.0000.0000.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 1Shipping/Receiving Clerk0.15002,633394.952,653397.952,674401.102,695404.2500.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 2Shipping/Receiving Clerk0.150000.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 3Shipping/Receiving Clerk0.166700.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 4Shipping/Receiving Clerk0.166700.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 1Shipping/Receiving Clerk0.150000.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 2Shipping/Receiving Clerk0.150000.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 3Shipping/Receiving Clerk0.1667Year 1 (9mo)0.00Year 20.00Year 30.00Year 40.00Year 50.00
C-5.2.3 /C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 4Shipping/Receiving Clerk0.16672,984497.334,009668.174,039673.174,070678.334,103683.83
C-5.2.3/C-5.2.4.3 New Procurement (NP): Weight Band 1Warehouse Specialist0.150000.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.3 New Procurement (NP): Weight Band 2Warehouse Specialist0.150000.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.3 New Procurement (NP): Weight Band 3Warehouse Specialist0.1667Year 1 (9mo)0.00Year 20.00Year 30.00Year 40.00Year 50.00
C-5.2.3/C-5.2.4.3 New Procurement (NP): Weight Band 4Warehouse Specialist0.16675,137856.176,8981,149.676,9501,158.337,0041,167.337,0591,176.50
C-5.2 Receiving: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.3.1 Stow of Receipts: Weight Band 1Warehouse Specialist0.073300.0000.0000.0000.0000.00
C-5.3.1 Stow of Receipts: Weight Band 2Warehouse Specialist0.083000.0000.0000.0000.0000.00
C-5.3.1 Stow of Receipts: Weight Band 3Warehouse Specialist0.0900Year 1 (9mo)0.00Year 20.00Year 30.00Year 40.00Year 50.00
C-5.3.1 Stow of Receipts: Weight Band 4Warehouse Specialist0.250017,8184,454.5024,1136,028.2524,2986,074.5024,4856,121.2524,6776,169.25
C-5.3.3 Visual InspectionsStock Clerk0.2900818237.221,108321.321,116323.641,125326.251,133328.57
C-5.3.3 Cyclic InspectionsStock Clerk0.4000556222.40752300.80758303.20764305.60770308.00
C-5.3.3.1 Special Inspections & QualityStock Clerk0.35005418.907325.557325.557425.907526.25
C-5.3.5 Autocad Planographs/DSS Location Identification/Storage Space Management Report*Supply Systems Analyst0.000.000.000.000.00
C5.3.7 Rewarehousing of MaterialWarehouse Specialist0.16709,1721,531.7212,4122,072.8012,5062,088.5012,5992,104.0312,7032,121.40
C-5.3.8 Issue of Material (On-base): Weight Band 1Material Handler0.0200Year 1 (9mo)0.00Year 20.00Year 30.00Year 40.00Year 50.00
C-5.3.8 Issue of Material (On-Base): Weight Band 2Material Handler0.033341313.7756018.6756418.8056918.9757319.10
C-5.3.8 Issue of Material (On-Base): Weight Band 3Material Handler0.03331103.671484.931494.971515.031525.07
C-5.3.8 Issue of Material (On-Base): Weight Band 4Material Handler0.0333541.80732.43732.43742.47752.50
C-5.3.8 Issue of Material (Off-Base): Weight Band 1Shipping Packer0.0333112,9013,762.99152,7995,092.79153,9675,131.72155,1555,171.32156,3725,211.88
C-5.3.8 Issue of Material (Off-Base): Weight Band 2Shipping Packer0.033300.0000.0000.0000.0000.00
C-5.3.8 Issue of Material (Off-Base): Weight Band 3Shipping Packer0.083300.0000.0000.0000.0000.00
C-5.3.8 Issue of Material (Off-Base): Weight Band 4Shipping Packer0.083300.0000.0000.0000.0000.00
C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 1Shipping Packer0.050050,6772,533.855,953297.651,76188.0570935.4510.03
C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 2Shipping Packer0.083332,3362,694.673,798316.501,12493.6745237.6700.03
C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 3Shipping Packer0.13337,063941.73830110.6724532.679913.2000.01
C-5.3.8 Issue of Material (Transshipments Off-Base): Weight Band 4Shipping Packer0.15002,689403.3531647.409313.95385.7000.00
C-5.3.8 Issue of Material (Transshipments On-Base): MPCMaterial Handler0.166700.0000.0000.0000.0000.00
C-5.3.8 NLC Transshipments On-BaseMaterial Handler0.08331,16196.7513611.33413.42161.3300.00
C-5.3.8 Issue of Material (DROs): Weight Band 1Material Handler0.050000.0000.0000.0000.0000.00
C-5.3.8 Issue of Material (DROs): Weight Band 2Material Handler0.083300.0000.0000.0000.0000.00
C-5.3.8 Issue of Material (DROs): Weight Band 3Material Handler0.133300.0000.0000.0000.0000.00
C-5.3.8 Issue of Material (DROs): Weight Band 4Material Handler0.150000.0000.0000.0000.0000.00
C-5.3.12 Shipment Preparation: Weight Band 1Shipping Packer0.02500.1514,832370.8015,680392.0015,680392.0015,680392.0015,680392.00
C-5.3.12 Shipment Preparation: Weight Band 2Shipping Packer0.02500.16700.0000.0000.0000.0000.00
C-5.3.12 Shipment Preparation: Weight Band 3Shipping Packer0.02500.18300.0000.0000.0000.0000.00
C-5.3.12 Shipment Preparation: Weight Band 4Shipping Packer0.02500.200.0000.0000.0000.0000.00
C-5.3 Warehousing: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.4 Physical Inventory (all TPICs)Stock Clerk0.361028,60310,325.6828,60310,325.6828,60310,325.6828,60310,325.6800.00
C-5.4.1 Physical Inventory Control (F2B 1st Counts)Stock Clerk0.371000.0000.0000.0000.0000.00
C-5.4.1 Physical Inventory Control (F2B 2nd Counts)Stock Clerk0.320000.0000.0000.0000.0000.00
C-5.4.1 Physical Inventory Control (F2B TPIC M)Stock Clerk1.000000.0000.0000.0000.0000.00
C-5.4. Denial ResearchSupply Technician1.000000.0000.0000.0000.0000.00
C-5.4.1.2 Item Data MaintenanceStock Clerk0.045000.0000.0000.0000.0000.00
C-5.4.5 Location SurveysStock Clerk1.000000.0000.0000.0000.0000.00
C 5.4.6 V00 Adhocs (COSIS only)Stock Clerk0.166700.0000.0000.0000.0000.00
C-5.4 Inventory: Subject Matter ExpertSupply Technician445.00445.00445.00445.00445.00445.00
C-5.5.2 Traffic ManagementTransportation Assistant
C-5.5.3 Shipping Weight Band 1Warehouse Specialist0.04205,621236.085,621236.085,621236.085,621236.085,621236.08
C-5.5.3 Shipping Weight Band 2Warehouse Specialist0.042000.0000.0000.0000.0000.00
C-5.5.3 Shipping Weight Band 3Warehouse Specialist0.283300.0000.0000.0000.0000.00
C-5.5.3 Shipping Weight Band 4Warehouse Specialist0.283300.0000.0000.0000.0000.00
C-5.5.5 FMSShipping Packer0.500000.0000.0000.0000.0000.00
C-5.5.6 Transportation RequirmentsTruck Driver Heavy4,004.005,340.005,340.005,340.005,340.00
C-5.5.6 Transportation RequirmentsTruck Driver Medium2,669.003,560.003,560.003,560.003,560.00
C-5.5.6 Transportation RequirmentsTruck Driver Light1,334.001,780.001,780.001,780.001,780.00
C-5.5 Transportation: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.6.1 X-SmallShipping Packer0.170000.0000.0000.0000.0000.00
C-5.6.1 SmallShipping Packer0.200000.0000.0000.0000.0000.00
C-5.6.1 MediumShipping Packer0.3000Year 20.00Year 30.00Year 40.00Year 50.0000.00
C-5.6.1 LargeShipping Packer0.400020.8020.8020.8020.8000.00
C-5.6.1 X-LargeShipping Packer0.75002921.752921.752921.752921.7500.00
C-5.6.1 XX-LargeShipping Packer1.0000192192.00193193.00195195.00196196.0000.00
C-5.6.1 RemarksShipping Packer0.166700.0000.0000.0000.0000.00
C-5.6.3 Container Fabrication Support: X- SmallWoodworker0.2500Year 1 (9mo)0.00Year 20.00Year 30.00Year 40.00Year 50.00
C-5.6.3 Container Fabrication Support: MediumWoodworker0.300019658.8019658.8019658.8019658.8019658.80
C-5.6.3 Container Fabrication Support: LargeWoodworker0.75006,3274,745.256,3274,745.256,3274,745.256,3274,745.256,3274,745.25
C-5.6.3 Container Fabrication Support: X-LargeWoodworker1.50002,9544,431.003,9695,953.503,9995,998.504,0306,045.004,0626,093.00
C-5.6.3 Container Fabrication Support: XX- LargeWoodworker10.000000.0000.0000.0000.0000.00
C-5.6.3 Container Fabrication Support: Fiberboard ContainersWoodworker10.000000.0000.0000.0000.0000.00
C-5.6.3 Container Fabrication Support: Other Type ContainersWarehouse Specialist10.000000.0000.0000.0000.0000.00
C-5.5 Packaging: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.2.5.1N DLRs w/ Project Code Z5SShipping/Receiving Clerk0.333300.0000.0000.0000.0000.00
C-5.2.5.1N CIIC w/Project Code Z5TShipping/Receiving Clerk0.333300.0000.0000.0000.0000.00
C-5.2.5.1N Consumables >$2500 w/Project Code Z5UShipping/Receiving Clerk0.333300.0000.0000.0000.0000.00
C-5.2.5.1N Consumables < $2500 w/Project Code Z5VShipping/Receiving Clerk0.333300.0000.0000.0000.0000.00
C-5.2.5.1N All Other w/o PMRD w/Project Code Z5WShipping/Receiving Clerk0.333300.0000.0000.0000.0000.00
C-5.2.5.1N MTIS: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.7N MPC Transshipments ClosedStock Clerk0.166500.0000.0000.0000.0000.00
C-5.7N MPC TransportationTruck Driver Heavy2,669.003,560.003,560.003,560.003,560.00
C-5.5 MPC Transshipments: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-6.6 Mandatory Reports/Other Administrative DutiesWarehouse Specialist
C-5.2.2N Off-Load and Tally: Weight Band 1Material Handler0.075000.0000.0000.0000.0000.00
C-5.2.2N Off-Load and Tally: Weight Band 2Material Handler0.075000.0000.0000.0000.0000.00
C-5.2.2N Off-Load and Tally: Weight Band 3Material Handler0.080000.0000.0000.0000.0000.00
C-5.2.2N Off-Load and Tally: Weight Band 4Material Handler0.090000.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.2N Non-Procurement Receipts (Customer Returns): Weight Band 1Material Handler0.150000.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.2N Non-Procurement Receipts (Customer Returns): Weight Band 2Material Handler0.150000.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (Customer Returns): Weight Band 3Material Handler0.166700.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.2N Non-Procurement Receipts (Customer Returns): Weight Band 4Material Handler0.166700.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.2N Non-Procurement Receipts (STOs/RDOs): Weight Band 1Material Handler0.150000.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.2N Non-Procurement Receipts (STOs/RDOs): Weight Band 2Material Handler0.150000.0000.0000.0000.0000.00
C-5.2.3/C-5.2.4.2 Non-Procurement Receipts (STOs/RDOs): Weight Band 3Material Handler0.166700.0000.0000.0000.0000.00
C-5.2.3N /C-5.2.4.2N Non-Procurement Receipts (STOs/RDOs): Weight Band 4Material Handler0.166700.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.3N New Procurement (NP): Weight Band 1Material Handler0.150000.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.3N New Procurement (NP): Weight Band 2Material Handler0.150000.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.3N New Procurement (NP): Weight Band 3Material Handler0.166700.0000.0000.0000.0000.00
C-5.2.3N/C-5.2.4.3N New Procurement (NP): Weight Band 4Material Handler0.166700.0000.0000.0000.0000.00
C-5.37N Rewarehouse Stow at Depot after Pick at RetailMaterial Handler0.250000.0000.0000.0000.0000.00
C-5.2N Receiving: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.3.1N Stow of Receipts: Weight Band 1Warehouse Specialist0.083300.0000.0000.0000.0000.00
C-5.3.1N Stow of Receipts: Weight Band 2Warehouse Specialist0.116700.0000.0000.0000.0000.00
C-5.3.1N Stow of Receipts: Weight Band 3Warehouse Specialist0.116700.0000.0000.0000.0000.00
C-5.3.1N Stow of Receipts: Weight Band 4Warehouse Specialist0.350000.0000.0000.0000.0000.00
C-5.3.XN Rewarehouse Stow at Depot after Pick at RetailWarehouse Specialist0.123000.0000.0000.0000.0000.00
C-5.3.3N Visual InspectionsStock Clerk0.333300.0000.0000.0000.0000.00
C-5.3.3N Cyclic InspectionsStock Clerk0.350000.0000.0000.0000.0000.00
C-5.3.3.1N Special Inspections & QualityStock Clerk0.400000.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (On-base): Weight Band 1Material Handler0.166700.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (On-Base): Weight Band 2Material Handler0.033300.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (On-Base): Weight Band 3Material Handler0.033300.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (On-Base): Weight Band 4Material Handler0.033300.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (Off-Base): Weight Band 1Material Handler0.033300.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (Off-Base): Weight Band 2Material Handler0.033300.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (Off-Base): Weight Band 3Material Handler0.833300.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (Off-Base): Weight Band 4Material Handler0.833300.0000.0000.0000.0000.00
C-5.3.8.5N Issue of Material (Transshipments Off-Base): Weight Band 1Material Handler0.050000.0000.0000.0000.0000.00
C-5.3.8.5N Issue of Material (Transshipments Off-Base): Weight Band 2Material Handler0.083300.0000.0000.0000.0000.00
C-5.3.8.5N Issue of Material (Transshipments Off-Base): Weight Band 3Material Handler0.133300.0000.0000.0000.0000.00
C-5.3.8 Issue of Material (Transshipments Off-Base): WEIGHT Band 4Material Handler0.150000.0000.0000.0000.0000.00
C-5.3.8 NLC Transshipments On-BaseWarehouse Specialist0.050000.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (DROs): Weight Band 1Warehouse Specialist0.050000.0000.0000.0000.0000.00
C-5.3.8.5N Issue of Material (DROs): Weight Band 2Warehouse Specialist0.083300.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (DROs): Weight Band 3Warehouse Specialist0.133300.0000.0000.0000.0000.00
C-5.3.8N Issue of Material (DROs): Weight Band 4Warehouse Specialist0.150000.0000.0000.0000.0000.00
C-5.3.12N Shipment Preparation: Weight Band 1Shipping Packer0.025000.0000.0000.0000.0000.00
C-5.3.12N Shipment Preparation: Weight Band 1Shipping Packer0.025000.0000.0000.0000.0000.00
C-5.3.12N Shipment Preparation: Weight Band 3Shipping Packer0.025000.0000.0000.0000.0000.00
C-5.3.12N Shipment Preparation: Weight Band 4Shipping Packer0.025000.0000.0000.0000.0000.00
C-5.3 Warehousing: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.4N Physical InventoryWarehouse Specialist0.25000.13300.0000.0000.0000.0000.00
C-5.4.4N Location SurveysStock Clerk1.000000.0000.0000.0000.0000.00
C 5.4 Denial ResearchSupply Technician1.000000.0000.0000.0000.0000.00
C-5.4N Inventory: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.5.3N Shipping Weight Band 1Shipping Packer0.083300.0000.0000.0000.0000.00
C-5.5.3N Shipping Weight Band 2Shipping Packer0.083300.0000.0000.0000.0000.00
C-5.5.3N Shipping Weight Band 3Shipping Packer0.283300.0000.0000.0000.0000.00
C-5.5.3N Shipping Weight Band 4Shipping Packer0.283300.0000.0000.0000.0000.00
C-5.5.6N Shipping/Outloading FMSShipping Packer0.5000000.0000.0000.0000.0000.00
C-5.5N Transportation: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.6.1 X-SmallShipping Packer0.170000.0000.0000.0000.0000.00
C-5.6.1 SmallShipping Packer0.200000.0000.0000.0000.0000.00
C-5.6.1 MediumShipping Packer0.300000.0000.0000.0000.0000.00
C-5.6.1 LargeShipping Packer0.400000.0000.0000.0000.0000.00
C-5.6.1 X-LargeShipping Packer0.750000.0000.0000.0000.0000.00
C-5.6.1 XX-LargeShipping Packer1.000000.0000.0000.0000.0000.00
C-5.6.1 RemarksStock Clerk0.166700.0000.0000.0000.0000.00
C-5.6.3 Container Fabrication Support: X- SmallWoodworker0.833300.0000.0000.0000.0000.00
C-5.6.3 Container Fabrication Support: MediumWoodworker1.000000.0000.0000.0000.0000.00
C-5.6.3 Container Fabrication Support: LargeWoodworker4.000000.0000.0000.0000.0000.00
C-5.6.3 Container Fabrication Support: X-LargeWoodworker6.000000.0000.0000.0000.0000.00
C-5.6.3 Container Fabrication Support: XX- LargeWoodworker28.000000.0000.0000.0000.0000.00
C-5.5 Packaging: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
C-5.9.N G Store Material Components ReceivedWarehouse Specialist0.500000.0000.0000.0000.0000.00
C-5.9.N G Store Piece Parts ReceivedWarehouse Specialist0.500000.0000.0000.0000.0000.00
C-5.9.N G Store Components PulledWarehouse Specialist0.500000.0000.0000.0000.0000.00
C-5.9.N G Piece Parts PulledWarehouse Specialist0.500000.0000.0000.0000.0000.00
C-5.9N G Store: Subject Matter ExpertWarehouse Specialist Team Lead445.00445.00445.00445.00445.00445.00
Row LabelsSum of Y1 3mo Transition HoursSum of Y1 (9M0) HoursSum of Y2 HoursSum of Y3 HoursSum of Y4 HoursSum of Y5 Hours
Administrative Assistant1,335.001,780.001,780.001,780.001,780.00
Alternate Site Manager445.001,335.001,780.001,780.001,780.001,780.00
Guard1,335.001,780.001,780.001,780.001,780.00
Material Handler25,924.1034,708.1334,713.9234,776.4834,782.60
Motor Vehicle Maintenance Mechanic2,670.003,560.003,560.003,560.003,560.00
Quality Control Specialist445.001,335.001,780.001,780.001,780.001,780.00
Safety and Occupational Health (SOH) Representative445.001,335.001,780.001,780.001,780.001,780.00
Security Specialist445.001,335.001,780.001,780.001,780.001,780.00
Shipping Packer34,842.2346,574.9846,582.7346,590.9446,599.36
Stock Clerk41,073.8748,204.6948,489.0048,489.9748,490.97
Supply Systems Analyst445.001,335.001,780.001,780.001,780.001,780.00
Supply Technician445.001,868.002,343.002,343.002,343.002,343.00
Transportation Assistant
Transportation Manager445.001,335.001,780.001,780.001,780.001,780.00
Truck Driver Heavy6,673.008,900.008,900.008,900.008,900.00
Truck Driver Light1,334.001,780.001,780.001,780.001,780.00
Truck Driver Medium2,669.003,560.003,560.003,560.003,560.00
Warehouse Specialist36,926.6845,405.6345,414.4845,450.6145,455.55
Warehouse Specialist Team Lead5,340.005,340.005,340.005,340.005,340.005,340.00
Woodworker7,963.0410,617.3810,617.3810,617.3810,617.38
Site Manager445.001,335.001,780.001,780.001,780.001,780.00
Inventory Manager445.001,335.001,780.001,780.001,780.001,780.00
Shipping/Receiving Clerk10,530.7214,060.5614,073.8614,076.3214,078.55
Grand Total9,345.00191,164.63242,854.37243,174.36243,284.70243,307.40

IGCE

Independent Government Cost Estimate (IGCE)
DLA Distribution DDJF, Flordia
PROCUREMENT SENSITIVE INFORMATION
Year 1Year 2Year 3Year 4Year 5TOTAL
C-1.3.1 Key PersonnelFTEsEstimated Hours3 Month TransitionEstimated Hours9 Month Full PerformanceEstimated HoursEstimated HoursEstimated HoursEstimated Hours
Site ManagerExempt1.00445$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
Alternate Site ManagerExempt1.00445$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
Quality Control SpecialistExempt1.00445$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
Supply Systems AnalystExempt1.00445$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
Inventory ManagerExempt1.00445$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
Transportation ManagerExempt1.00445$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
C-1.3.2 Non-Key Personnel (not related to C-5)
Administrative Assistant (Secretary III)Exempt1.00- 0$0.001335$0.001780$0.001780$0.001780$0.001780$0.00$0.00
C-1.4 Security
Security SpecialistExempt1.00- 0$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
C-1.5 Safety and Occupational Health (SOH)
Safety & Occupational Health RepresentativeExempt1.00- 0$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
C-4.4 Equipment Maintenance
Motor Vehicle Maintenance MechanicExempt2.00- 0$0.001335$22,187.701780$30,411.941780$31,263.481780$32,138.851780$33,038.74$149,040.71
C-5.1 Distribution Services and Performance Requirements
Quality Control Evaluator -General ClerkIII/QC SpecialistCBA3.00- 0$0.004005$81,862.205340$112,205.795340$115,347.555340$118,577.285340$121,897.45$549,890.27
C-5.2 Receiving Operations
Warehouse Specialist SupervisorExempt1.00- 00.001335$30,331.201,780$41,573.961,780$42,738.041,780$43,934.701,780$45,164.87$203,742.77
Warehouse Specialist Lead (SME)SCA1.00445$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
Warehouse SpecialistSCA2.00- 0$0.002670$0.003,560$0.003,560$0.003,560$0.003,560$0.00$0.00
Warehouse Specialist (HAZMAT)SCA0.00- 0$0.000$0.000$0.000$0.000$0.000$0.00$0.00
Supply TechicianSCA1.00- 0$0.001335$23,469.301,780$32,168.591,780$33,069.311,780$33,995.251,780$34,947.12$157,649.56
Shipping/Receiving ClerkSCA1.00- 0$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$44,091.41$44,091.41
C-5.3 Warehousing Operations
Warehouse Specialist Lead (SME)SCA1.00445$0.001335$0.001780$0.001780$0.001780$0.001780$0.00$0.00
Warehouse SpecialistSCA6.00- 0$0.008010$0.0010680$0.0010680$0.0010680$0.0010680$0.00$0.00
Warehouse Specialist (HAZMAT)SCA2.00- 0$0.002670$0.003560$0.003560$0.003560$0.003560$0.00$0.00
Supply TechnicianSCA1.00$0.001335$23,469.301780$32,168.591780$33,069.311780$33,995.251780$34,947.12$157,649.56
Shipping/Receiving ClerkSCA1.00$0.001335$0.001780$0.001780$0.001780$0.001780$0.00$0.00
Shipping PackerSCA2.00- 0$0.002670$0.003560$0.003560$0.003560$0.003560$0.00$0.00
C-5.4 Physical Inventory
Warehouset SpecialistSCA1.00- 0$0.001335$0.001780$0.001780$0.001780$0.001780$0.00$0.00
Supply TechnicianSCA1.00$0.001335$23,469.301780$32,168.591780$33,069.311780$33,995.251780$34,947.12$157,649.56
Supply Technician (SME)SCA1.00445$7,823.101335$23,469.301780$32,168.591780$33,069.311780$33,995.251780$34,947.12$165,472.66
C-5.5 Transportation
Traffic Management Specialist (SME)Exempt1.00445$0.001335$0.001780$0.001780$0.001780$0.001780$0.00$0.00
Transportation AssistantSCA2.00- 0$0.002670$59,220.603560$81,171.703560$83,444.513560$85,780.963560$88,182.82$397,800.59
Truck Driver, HeavySCA4.00- 0$0.005340$0.007120$0.007120$0.007120$0.007120$0.00$0.00
C-5.6 Packaging
Packaging Specialist (SME)Exempt1.00445$0.001335$0.001780$0.001780$0.001780$0.001780$0.00$0.00
Shipping PackerSCA1.00- 0$0.001335$0.001780$0.001780$0.001780$0.001780$0.00$0.00
Wood WorkerSCA1.00- 0$0.001335$0.001780$0.001780$0.001780$0.001780$0.00$0.00
C-1.4.1N
GuardSCA1.00- 0$0.001335$0.001,780$0.001,780$0.001,780$0.001,780$0.00$0.00
C-5.7N MPC
Warehouse SpecialistSCA3.00- 0$0.004005$0.005340$0.005340$0.005340$0.005340$0.00$0.00
Warehouse Specialist (HAZMAT)SCA0.00- 0$0.000$0.000$0.000$0.000$0.000$0.00$0.00
Supply TechnicianSCA1.00- 0$0.001335$23,469.301780$32,168.591780$33,069.311780$33,995.251780$34,947.12$157,649.56
C-5.8N TCSP
Warehouse SpecialistSCA3.00- 0$0.004005$0.005340$0.005340$0.005340$0.005340$0.00$0.00
Warehouse Specialist (HAZMAT)SCA0.00- 0$0.000$0.000$0.000$0.000$0.000$0.00$0.00
Total Productive Hours
Total FTEs115353535353
Overtime (@Composite Rate - SCA Only)- 0$0.001068$0.001424$0.001424$0.001424$0.001424$0.00$0.00
Total Direct Labor Costs$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Fringe35.00%$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Subtotal Labor + Fringe$0.00$0.00$0.00$0.00$0.00$0.00$0.00
G&A7.50%$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Subtotal Labor, Fringe and G&A$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Profit5.00%$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Subtotal Labor, Fringe, G&A and Profit$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CLIN X002 GE Maintenance labor (All indirects included)$0.00$41,737.00$55,649.00$55,649.00$55,649.00$55,649.00$264,333.00
Parts$0.00$0.00$0.00$0.00$0.00$0.00$0.00
G&A @ 7.5% (Applied to parts only)7.50%$0.00$3,130.28$4,173.68$4,173.68$4,173.68$4,173.68$19,824.98
Total for CLIN X002$0.00$44,867.28$59,822.68$59,822.68$59,822.68$59,822.68$284,157.98
CLIN X003 Non-Capital Equipment Replacement$0.00$10,000.00$10,000.00$10,000.00$10,000.00$10,000.00$50,000.00
G&A @ 7.5%7.50%$0.00$750.00$750.00$750.00$750.00$750.00$3,750.00
Total for CLIN X003$0.00$10,750.00$10,750.00$10,750.00$10,750.00$10,750.00$53,750.00
CLIN X004 Material Support Costs$0.00$105,035.00$140,046.00$140,046.00$140,046.00$140,046.00$665,219.00
G&A @ 7.5%7.50%$0.00$7,877.63$10,503.45$10,503.45$10,503.45$10,503.45$49,891.43
Total for CLIN X004$0.00$112,912.63$150,549.45$150,549.45$150,549.45$150,549.45$715,110.43
CLIN X005 Travel (CR)$0.00$30,000.00$30,000.00$30,000.00$30,000.00$30,000.00$150,000.00
G&A @ 7.5%7.50%$0.00$2,250.00$2,250.00$2,250.00$2,250.00$2,250.00$11,250.00
Total for CLIN X005$0.00$32,250.00$32,250.00$32,250.00$32,250.00$32,250.00$161,250.00
CLIN X006 Special Projects (All indirects included)$0.00$25,000.00$25,000.00$25,000.00$25,000.00$25,000.00$125,000.00
Total Direct Labor and Other Direct Costs$0.00$0.00$0.00$0.00$0.00$0.00$0.00
KEY
All labor not related to Workload Highlighted
All labor related to Workload Highlighted
Final Cost Element of Total Price
Performance Period 1 - Transition (3 months)$0.00
9 Months Full Performance$0.00
Performance Period 2 - 12 months$0.00
Performance Period 3 - 12 months$0.00
Performance Period 4 - 12 months$0.00
Performance Period 5 - 12 months$0.00
Total$0.00

&L&D page &P&CSource Selection Information See FAR 2.101 and 3.104 Crusey, Shane M CIV (US):

see igce narrative

Receipt

C-5.2.4.2 NON-PROCUREMENT (CUSTOMER RETURNS AND REDISTRIBUTION ORDERS)
C-5.2.4.3 NEW PROCUREMENT
Measurement is Lines
Types of receipts processed within the above stated weight bandsYear 1Year 2Year 3Year 4Year 5
New Procurement27,42034119.678250135734119.678250135734119.678250135734119.6782501357
Customer Returns119,635148868.311432024148868.311432024148868.311432024148868.311432024
Redistributions44,82255774.512515187555774.512515187555774.512515187555774.5125151875
Receipts from Maintenance29,34736518.339286637536518.339286637536518.339286637536518.3392866375
Serviceable Returns (wholesale)13,38616656.857382441916656.857382441916656.857382441916656.8573824419
Unserviceable Returns52,41065216.993430576765216.993430576765216.993430576765216.9934305767
Unit Cost Receipt Reversals1,0371290.04321342711290.04321342711290.04321342711290.0432134271
Hazardous Receipts1,7272148.67858620072148.67858620072148.67858620072148.6785862007
REW STOWs3,5994478.78256275374478.78256275374478.78256275374478.7825627537
22,210
3,016
1,645
548
106,475
9,413
2,641
803

Ship Prep

C-5.3.8 ISSUE OF MATERIAL WORKLOAD
On-Base IssuesYear 1Year 2Year 3Year 4Year 5y1Y2Y3Y4Y5
Weight Band 1123,354164,096164,087164,091164,138wb1381,686507,749507722507735507879
Weight Band 211,27514,99914,99814,99815,003wb230,40940,452404504045040463
Weight Band 35,4787,2877,2877,2877,289wb316,63622,129221282212922134
Weight Band 4338450450450450wb42,8133,741374137413743
TOTAL140,445186,832186,822186,826186,880
Off-Base IssuesYear 1Year 2Year 3Year 4Year 5
Weight Band 1204,562272,125272,110272,117272,194
Weight Band 210,82814,40414,40314,40314,407
Weight Band 34,9186,5426,5416,5426,543
Weight Band 4307408408408408
TOTAL220,614293,479293,462293,470293,552
Issues From Receiving (IFRs)Year 1Year 2Year 3Year 4Year 5
Weight Band 133,28344,27544,27344,27444,286
Weight Band 23,7254,9544,9544,9544,956
Weight Band 32,5343,3713,3713,3713,372
Weight Band 41013131313
TOTAL39,55152,61352,61152,61252,627
Transshipments-Off-BaseYear 1Year 2Year 3Year 4Year 5
Weight Band 19,30012,37212,37112,37212,375
Weight Band 21,4571,9381,9381,9381,938
Weight Band 31,2711,6911,6911,6911,691
Weight Band 4566753753753754
TOTAL12,59416,75416,75316,75416,758
Transshipments On-BaseYear 1Year 2Year 3Year 4Year 5
TOTAL1,4811,9691,9691,9691,970
NLC DROsYear 1Year 2Year 3Year 4Year 5
Weight Band 13,8515,1225,1225,1225,124
Weight Band 2331440440440440
Weight Band 3215286286286286
Weight Band 43749494949
TOTAL4,4335,8975,8975,8975,899
NLC DRO IFRsYear 1Year 2Year 3Year 4Year 5
Weight Band 15,8567,7907,7907,7907,792
Weight Band 21,3141,7481,7481,7481,749
Weight Band 3739983983983983
Weight Band 47499999999
TOTAL7,98310,62010,62010,62010,623

TE 5.1

DDJF Whole Sale
C-5.1 Total Receipt and Issue Workload
Measurement is Lines
Source Data CollectionFY15FY16FY17FY18 MTD
Receipts9114086,69086,96871,94829,740
Issues92440373,145419,326434,470183,082
TOTAL98400459,835506,294506,418212,822
C-5.1.5.1 On-Call Response
Measurement is Lines
Source Data CollectionFY15FY16FY17FY18 MTD
Emergency Requisitions After HoursManual Logs123312075
C-5.1.5 CUSTOMER SERVICE SUPPORT PLAN AND SUPPORT
Source Data CollectionFY15FY16FY17FY18 MTD
Item Manager/Service Support (Occurrences)Technical EstimateN/AN/AN/AN/A
Call-in Special Inspections (Occurrences)Technical Estimate2735391,485497
Repacking and Stowing Assets (Number of NSNs)Technical Estimate88676386523
C-5.1.5.36 STOCK IN TRANSIT SUPPLY DISCREPANCY REPORTS (SIT SDRS)NAVSUP Weapons Systems Support (NAVSUP WSS) In-Transit Accountability (NITA)
Source Data CollectionFY15FY16FY17FY18 MTD
Number of SIT SDRs ReceivedTechnical Estimate3,1274,1204,2522,119
Number of SIT SDRs Researched & CompletedTechnical Estimate3,1274,1204,2522,119
C-5.2 and C-5.3 Total Receipt and Issue Workload
FY15 SECONDARY MONTHLY WORKLOAD
Measurement is Lines
MonthReceipts (91140 )Issues (92440)TOTAL Receipts and Issues (98400)
OCT7,52130,56738,088
NOV6,18431,54937,733
DEC6,95128,79935,750
JAN6,82728,16634,993
FEB6,37529,19935,574
MAR6,82934,03440,863
APR8,45432,96641,420
MAY6,55129,13835,689
JUN7,70131,54939,250
JUL7,37835,26142,639
AUG7,74631,36039,106
SEP8,17330,55738,730
TOTAL86,690373,145459,835
FY16 SECONDARY MONTHLY WORKLOAD
Measurement is Lines
MonthReceipts (91140)Issues (92440)TOTAL Receipts and Issues (98400)
OCT7,55734,46242,019
NOV8,46728,76637,233
DEC8,62030,93039,550
JAN6,63829,27635,914
FEB7,19833,36040,558
MAR7,39640,62148,017
APR8,01436,38844,402
MAY6,69436,69043,384
JUN6,96935,53242,501
JUL6,45835,62642,084
AUG6,59740,51247,109
SEP6,36037,16343,523
TOTAL86,968419,326506,294
FY17 SECONDARY MONTHLY WORKLOAD
Measurement is Lines
MonthReceipts (91140)Issues (92440)TOTAL Receipts and Issues (98400)
OCT5,99438,00944,003
NOV6,54836,36642,914
DEC6,21532,49238,707
JAN5,31133,37138,682
FEB5,51636,33441,850
MAR6,12539,55845,683
APR5,27832,67337,951
MAY5,96934,96540,934
JUN6,00637,76743,773
JUL6,43136,64743,078
AUG6,91242,08448,996
SEP5,64334,20439,847
TOTAL71,948434,470506,418
FY18 MTD SECONDARY MONTHLY WORKLOAD
Measurement is Lines
MonthReceipts (91140)Issues (92440)TOTAL Receipts and Issues (98400)
OCT6,43838,16544,603
NOV6,74937,44344,192
DEC6,15036,13042,280
JAN5,22936,60041,829
FEB5,17434,74439,918
MAR
APR
MAY
JUN
JUL
AUG
SEP
TOTAL29,740183,082212,822
C-5.1.7.3N SHIPS SUPPORT SERVICES (Non-duty Hours - Sat, Sun and After Hours)
Measurement is Over-Time Hours
MonthFY15FY16FY17FY18 MTD
OCTN/AN/AN/AN/A
NOVN/AN/AN/AN/A
DECN/AN/AN/AN/A
JANN/AN/AN/AN/A
FEBN/AN/AN/AN/A
MARN/AN/AN/AN/A
APRN/AN/AN/AN/A
MAYN/AN/AN/AN/A
JUNN/AN/AN/AN/A
JULN/AN/AN/AN/A
AUGN/AN/AN/AN/A
SEPN/AN/AN/AN/A
TOTALN/AN/AN/AN/A
C-5.2 Receiving
Measurement is Lines
NLC Weight Bands By LinesNLC MIS DEFY15FY16FY17FY18 MTD
Weight Band 113001+6130172,53072,96858,31924,304
Weight Band 213002+613028,7798,7958,3393,406
Weight Band 313003+613035,1034,9245,0531,929
Weight Band 413004+61304278281234101
Rew Stow at Depot after Pick at Retail402250030
RDOs with Special Project129600000
Total Receipts9114086,69086,96871,94829,740
Value Added Lines (Depiction of extra effort to process these types of Receipts within the above stated weight bands)MIS Data ElementFY15FY16FY17FY18 MTD
Return Lines13010+613101,6091,0503,186970
Hazardous Lines13011+6131133195290
Hard to Handle13012+613125,2585,4254,7561,868
FY17 Percentage of Quantity per Line by Total Receipts in NLC
Quantity (Number of Individual Receipts processed per line.)Total LinesTotal Lines by Weight Band
Weight Band 1Weight Band 2Weight Band 3Weight Band 4
131,29720,5953,7662,8854,050
2 to 916,04910,5621,9311,4802,077
10 to 195,6783,737683523735
20 to 292,9791,960358275386
30 to 493,0652,017369283397
50 to 993,5682,348429329462
100+9,3126,1281,1208581,205
Totals71,94847,3478,6566,6339,312
C-5.2.2 OFFLOAD AND TALLY
Inbound TrucksSource Data CollectionFY15FY16FY17FY18 MTD
ConveyancesManual CountsN/AN/AN/AN/A
PiecesManual CountsN/AN/AN/AN/A
PalletsManual CountsN/AN/AN/AN/A
C-5.2.12.14N MATERIAL TURNED INTO STORE (MTIS)
MIS Data ElementFY15FY16FY17FY18 MTD
DLRs w/ Project Code Z5S140023411290
CIIC w/Project Code Z5T141021935
Consumables >$2500 w/Project Code Z5U142021,413406132165
Consumables < $2500 w/Project Code Z5V143023291,0859121,363
All Other w/o PMRD w/Project Code Z5W144028521027
C-5.2.4.2-CUSTOMER RETURNS, C-5.2.4.2 REDISTRIBUTION ORDERS (RDOs), AND C-5.2.1.4.3 NEW PROCUREMENT
Measurement is Lines
Types of Receipts processed within the above stated weight bandsMIS Data ElementFY15FY16FY17FY18 MTD
New Procurement1210112,98020,44020,5798,103
Customer Returns (less retrograde)1210211,11810,45912,6214,847
Redistributions1210362,55956,05138,73516,788
Receipts from Maintenance104029,2289,1888,7223,338
Serviceable Returns (includes wholesale and MTIS returns)108021,5271,0363,6591,330
Unserviceable Returns1030214,24115,59013,8055,283
Unit Cost Receipt Reversals12950388582479194
Hazardous Receipts11703+60370+6029733195290
C-5.2.4.1 SUPPLY DISCREPANCY REPORTS (SDR) (Type 8 or 9)
Measurement is Each
Type DiscrepancySource Data CollectionFY15FY16FY17FY18 MTD
Quantity Short (S_)QMF216511442227
Quantity Over (O_)QMF11816715691
Condition of Material (C_)QMF117633497209
Misdirected Material (M_)QMF1551391049
Missing Documentation (D_)QMF278616631158
Hazardous (H)QMF01610
Packaging Discrepancy (P_)QMF9752,0232,3971,149
Technical (T)QMF3864
Unique Identification Data (U)QMF0010
Wrong Item (W_)QMF23603025
Product Quality Deficiencies/Safety (Q_)QMF817213
Other Discrepancies (Z_)QMF1,2353,6725,9873,213
Total3,1287,86210,2735,088
C-5.2.5N Additional Requirements
Measurement is Lines
Classified/Controlled ReceiptsSource Data CollectionFY15FY16FY17FY18 MTD
Classified/Confidential/Secret Wholesale Receipts162020380
Controlled/Pilferable/Sensitive Wholesale Receipts163021,7473,0393,1441,047
Classified/Confidential/Secret Wholesale and MTIS Returns165020000
Controlled/Pilferable/Sensitive Wholesale and MTIS Returns1660225710121545
Classified/Confidential/Secret Redistributions16802577210927
Controlled/Pilferable/Sensitive Redistributions169025,4585,4435,0512,147
Controlled Cryptographic Items (CCI)SAS0124
Compressed Gas CylinderSAS570442529154
CorrosiveSAS22934
ExplosiveSAS0000
FlammableSAS122020
Low HazardSAS21919421180
OxidizerSAS0000
PoisonSAS37522610
ESDSSAS0000
MagneticSAS001000
RadioactiveSAS29138499
Level 1/SubsafeSAS0733
Nuclear Reactor Plant Material-TotalSASN/AN/AN/AN/A
SMIC-X2SAS0000
SMIC-X3SAS0260
SMIC-X4SAS0000
SMIC-X5SAS0000
463L Air PalletsTechnical Estimate0000
*Receipts may fall into multiple types above. (Ex: One receipt may be a combination of classified, ESD, and radioactive)
**Non-Accountable Material received at the Center is systemically tracked within DSS as a Receipt workload, thus it is included in the total workload under Receipts.
C-5.3 Storage
Source Data CollectionFY15FY16FY17FY18 MTD
NSNs in StorageNSNs In Store Report43,32342,95742,92343,147
ODS (Ozone Depleting Substance) NSNs in Storage0000
ODS (Ozone Depleting Substance) Cylinders in Storage0000
C-5.3.3.1 COSIS
COSIS SPECIAL INSPECTIONS
Measurement is Each
Source Data CollectionFY15FY16FY17FY18 MTD
Cyclic Inspections (Shelf-Life)QMF341617494263
OtherQMF0000
Routine COSIS (Visual Inspections) (V00, V06, V12, V24, V30, & V60)QMF12,90515,25515,6736,621
Special Inspections (SIR)QMF7153,0072,393976
Special Quality Inspections (QN1, QN2, QN3, CSI, CS2, CS3, SOF, SO2, SO3, RSI, RS2, RS3)QMF2761,1311,182545
C-5.3.1.1.4 COSIS Actions Exceeding Minor Repair
Recording, Reporting, and Performing COSIS Actions Exceeding Minor Repair
Measurement is Each
Source Data CollectionFY15FY16FY17FY18 MTD
DD 1225s CompletedQMF77557364206
C-5.3.7 REWAREHOUSING ACTIONS
Measurement is Lines
Rewarehousing/RoutinesMIS Data ElementFY15FY16FY17FY18 MTD
Total Rewarehousing (Locations Rewarehoused)4020020,44841,91038,94712,025
C-5.3.8 ISSUE
Measurement is Lines
On-Base IssuesNLC DEFY15FY16FY17FY18 MTD
Weight Band 124002+6240224,60197,04283,30225,268
Weight Band 224003+624033,0872,4932,8041,072
Weight Band 324004+624041,5281,5661,587567
Weight Band 424005+6240580779125
TOTAL24001+6240188,530101,17887,78426,932
Off-Base IssuesNLC DEFY15FY16FY17FY18 MTD
Weight Band 124007+62407157,554202,847225,920101,081
Weight Band 224008+624084,2844,4824,9122,154
Weight Band 324009+624092,6652,5512,6581,177
Weight Band 424010+62410125123107119
TOTAL24006+62406164,628210,003233,597104,531
Transshipments Off-BaseNLC DEFY15FY16FY17FY18 MTD
Weight Band 124083+6261022,22122,29419,4276,592
Weight Band 224084+626113,9073,6933,7891,081
Weight Band 324085+626122,9762,6722,412759
Weight Band 424086+62613573448381130
TOTAL24082+6260229,67729,10726,0098,523
Transshipments On-BaseNLC DEFY15FY16FY17FY18 MTD
TOTAL24081+ 6260126,57818,18318,0386,101
MPC On-Base Transshipments2262051,10548,61046,40127,432
NLC DROsFY15FY16FY17FY18 MTD
Weight Band 1241021,6762,4172,0751,577
Weight Band 22410322822225671
Weight Band 32410425520325634
Weight Band 4241052431483
TOTAL241012,1832,8732,6352,163
Rewhse Pick at Depot for Stow at RetailNLC DEFY15FY16FY17FY18 MTD
TOTAL4021510,4449,37220,0067,839
Grand TOTAL92440373,145419,326434,470183,082
Value Added (VA) Lines (Depiction of extra effort to process these types of Issues within the above stated weight bands)
Measurement is Lines
MIS Data ElementFY15FY16FY17FY18 MTD
Hazardous24032+624323,3701,5841,005345
Controlled Items24033+6243316,25819,53620,2307,309
Hard to Handle Items24034+6243414,61417,05818,6757,705
FMS24036+624368,02911,10512,6565,657
Out of Cycle (Bearer Pick-Up)240614073,87681244
Out of Cycle24037+624378341,1351,03648
Local Delivery24035+6243588,527101,17887,78426,931
RDO Issues2076219,76817,1449,6454,330
Retail MROs on Base2156214110
Issues to Maintenance (On Base)2046210,81310,70711,4134,399
Issues to Maintenance (Off-Base)2036283146206133
ISSUE - FY17 Percentage Of Quantity Per Line By NLC Weight Bands
Measurement is Lines
Quantity (Number of Individual Issues processed per line.)Total LinesTotal Lines by Weight Bands
Weight Band 1Weight Band 2Weight Band 3Weight Band 4
1202,144152,38424,16012,74612,855
2 to 9125,37694,51314,9857,9057,973
10 to 1933,93125,5794,0552,1392,158
20 to 2917,99613,5662,1511,1351,144
30 to 4912,8599,6931,537811818
50 to 9914,53510,9571,737916924
100+27,62920,8283,3021,7421,757
Totals434,470327,52051,92727,39427,629
C-5.3.8 ISSUE TRANSACTIONS BY HOUR AND TYPE
(Historical Data for a 30 Day Period – For Illustration Purposes)
HOUR/TYPE999IPG1IPG2IPG3RDODROTotal by Hour% by Hour
0000-0100294212775401101,2783.47%
0100-020025427541458311,4553.95%
0200-0300202862491821407512.04%
0300-0400353436964901221,5784.29%
0400-0500121571681655325571.51%
0500-0600191332511417356221.69%
0600-0700331,1143492556801,8194.94%
0700-0800391,3806237476982,8667.79%
0800-0900361,1023025581272,0175.48%
0900-1000261,4322872611142,0215.49%
1000-1100451,3212623634302,0255.50%
1100-12003569641035723201,5414.19%
1200-1300591,64048635055142,6047.08%
1300-1400341,02366451710842,3506.39%
1400-150030805413432159191,8585.05%
1500-1600474814433586031,3923.78%
1600-1700283373923991771,1803.21%
1700-1800373192904433971,1353.09%
1800-1900705124255221581,5524.22%
1900-2000324035314302021,4183.85%
2000-210032346294480511,1583.15%
2100-220048268279386939932.70%
2200-2300272423373141009302.53%
2300-240046435724475901,6894.59%
Total by Type84415,6239,6939,62385914736,789100.00%
% by Type2.29%42.47%26.35%26.16%2.33%0.40%100.00%
C-5.3.8 ISSUE TRANSACTIONS BY DAY OF WEEK AND TYPE

This is the start of the file's text. The full file is on GovTribe.

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