Attachment 4 J.25 TE 5.2 Projected Workload.xlsx

XLSX spreadsheet 26 KB Posted

Attached to
Labor and Logistics Support at DLA Distribution Norfolk at Portsmouth, Virginia, and DLA Land & Maritime at Norfolk Naval Shipyard, Portsmouth, Virginia
Solicitation number
SP3300-20-R-5005
Issued by

About this file

Written by GovTribe AI ·

This document includes an attachment projecting workload requirements and a federal contract opportunity solicitation. The attachment outlines projected monthly and yearly call outs, issue requests, receipts, and other workload metrics for logistics and warehouse support at two Defense Logistics Agency locations in Portsmouth, Virginia. The related solicitation seeks proposals for labor, equipment, transportation and other services to support receipt, storage, issue and delivery of materials at the DLA Distribution Norfolk and DLA Land & Maritime sites. Key requirements include supervision, material handling, fuels, transportation, and administrative functions. Proposals are due by the response date specified in Safe Access File Exchange (SAFE) where restricted solicitation attachments are accessible upon request and review for intention to bid. The incumbent contractor provides similar support services.

View the file

Other files

File Type Posted
Att 2 RFP SP3300-20-R-5005 0009 Tracked Changes.docx DOCX document
Att 5 J.1 PWS SP3300-20-R-5005 0009 Conformed.pdf PDF
Att 4 J.1 PWS SP3300-20-R-5005 0009 Tracked.docx DOCX document
Att 1 Q and A 0009.docx DOCX document
Amendment 0009 SF30 SP330020R5005.pdf PDF
Att 3 RFP SP3300-20-R-5005 0009 Conformed.pdf PDF
Amendment 0008 SF30 SP330020R5005.pdf PDF
Att 2 RFP SP3300-20-R-5005 0008 Conformed.pdf PDF
Att 1 RFP SP3300-20-R-5005 0008 Tracked.docx DOCX document
Att 2 RFP SP3300-20-R-5005 0007 Tracked.docx DOCX document
Att 3 RFP SP3300-20-R-5005 0007 Conformed.pdf PDF
Attachment 1 - Q and A 0007.pdf PDF
Amendment 0007 SF30 SP330020R5005.pdf PDF
Attachment 7 - J.29 - Certification of Offeror's Accounting System.pdf PDF
Att 5 RFP SP3300-20-R-5005 0006 Tracked.docx DOCX document
Attachment 2 J.1 PWS SP3300-20-R-5005 0006 Tracked.docx DOCX document
Attachment 1 - Q and A 0006.pdf PDF
Att 6 RFP SP3300-20-R-5005 0006 Conformed.pdf PDF
Attachment 3 J.1 PWS SP3300-20-R-5005 0006 Conformed.pdf PDF
Amendment 0006 SF30 SP330020R5005.pdf PDF
Att 2 J.1 PWS SP3300-20-R-5005 0005 Tracked.docx DOCX document
Amendment 0005 SF30 SP330020R5005.pdf PDF
Attachment 1 - Amend 0005 Q and A.pdf PDF
Att 3 J.1 PWS SP3300-20-R-5005 0005 Conformed.pdf PDF
Attachment 1 - Amend 0004 Questions.pdf PDF
Amendment 0004 SF30 SP330020R5005.pdf PDF
Att 2 RFP SP3300-20-R-5005 0004 Tracked.docx DOCX document
Att 5 J.1 PWS SP3300-20-R-5005 0004 Conformed.pdf PDF
Att 3 RFP SP3300-20-R-5005 0004 Conformed.pdf PDF
Att 4 J.1 PWS SP3300-20-R-5005 0004 Tracked.docx DOCX document
Amendment 0003 Attach 1 - RFP.pdf PDF
Amendment 0003 SF30 SP330020R5005.pdf PDF
Amendment 0002 Attach 1 Conformed RFP.pdf PDF
Amendment 0002 SF30 SP330020R5005.pdf PDF
Amendment 0001 SF30 SP330020R5005.pdf PDF
Amendment 0001 Attach 1 Conformed RFP.pdf PDF
Attachment J.7 Past Performance Questionnaire.docx DOCX document
SP3300-20-R-5005 All Pages.pdf PDF
Attachment J.3 - 2017 SAWTST NNSY CBA_signed.pdf PDF
Attachment J.2 - Wage Determination NNSY.pdf PDF
Attachment J.4 pt 1 - DD254 DDPV_NNSY 20R5005 2019.pdf PDF
Attachment J.5 CLIN X004 Labor Rate Table.xlsx XLSX spreadsheet
Attachment J.1 - PWS NNSY 2.26.20.pdf PDF
Attachment J.4 pt 2 - DD254 SP3300-20-R-5005 Continuation Pages.pdf PDF
Attachment J.8 CDRLS.pdf PDF
Attachment J.28 Limitation on Subcontracting.xlsx XLSX spreadsheet
Show all 46

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.

PROJECTED WL

Projected Workload

Monthly Projections
(FY 19 + FY 18 Monthly Total)/2 = Monthly ProjectionYearly Projection
OctNovDecJanFebMarAprMayJunJulAugSepYear 1 (8mo)Year 2Year 3Year 4Year 5
Number of Call Outs2,1211,8591,3622,2381,9132,1592,2292,1691,9112,4212,1191,78416,70224,28224,28224,28224,282
Number of Red (Work Stoppage) Call Outs166153992351261731691791872541601401,3872,0402,0402,0402,040
Number of Line Item Issue Requests5,6735,1963,9966,5225,2216,1146,3565,9615,4246,4155,8104,86746,16667,55267,55267,55267,552
Number of Non-Call Out Items9818746157037809798989388229789538377,18310,35510,35510,35510,355
Number of DMI Receipts for Stow1,9441,9891,6531,8131,9292,2191,8902,1862,1061,9502,1181,51515,91123,30923,30923,30923,309
Number of MSM Receipts for Stow9173082252373443783113463253763372662,6814,3674,3674,3674,367
Totals11,80110,3787,94911,74710,31212,02011,85211,77810,77412,39211,4969,40890,030131,904131,904131,904131,904
Average Per Month
1st Count Inventory5,000
2nd Count Inventory3,500
Location Audits/Surveys100
Re-warehousing Actions50
DLRs20
DRMO Receipts50 - 60
COSIS/shelf-life cyclic inspection50 - 60
Rip-out Transactions300-400
Pre-fabricated Material Transactions60-80

Historical Workload used to Calculate Projected Workload

NNSY S&D Industrial Support FY 18Oct-18Nov-18Dec-18Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18TOTALMonth Avg 18Month Avg 17Delta
Number of Call Outs Received2,1382,1331,5112,0111,8652,0612,5131,8611,7422,4632,1101,67124,0792,0072249(243)
Number of Red (Work Stoppage) Call Outs Completed257255112226106181195134220235134742,129177263(86)
Number of Line Item Issue Requests Received5,3805,8564,6495,8565,2605,7106,8615,1575,1386,8815,8784,57867,2045,6006,181(581)
Number of Non-Call Out Items Completed7329617028018569531,0818336669701,01286210,42986981059
Number of DMI Receipts Stowed2,4542,4182,0952,0912,4212,8482,3502,6722,6571,8922,4051,50827,8112,3182,197120
Number of MSM Receipts Stowed1,2584093152723864864273823853794122135,324444464(20)
TOTALS12,21912,0329,38411,25710,89412,23913,42711,03910,80812,82011,9518,906136,976
NNSY S&D Industrial Support FY 19Oct-19Nov-19Dec-19Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19TOTALMonth Avg 19Month Avg 18Delta
Number of Call Outs Received2,1041,5851,2132,4651,9612,2561,9442,4762,0792,3782,1271,89724,4852,0402,00734
Number of Red (Work Stoppage) Call Outs Completed7551862441461651432241542721852061,951163177(15)
Number of Line Item Issue Requests Received5,9664,5353,3437,1875,1816,5175,8516,7655,7105,9495,7415,15567,9005,6585,60058
Number of Non-Call Out Items Completed1,2297875286047041,0047141,04397798589481110,280857869(12)
Number of DMI Receipts Stowed1,4331,5591,2101,5351,4371,5901,4301,6991,5542,0071,8311,52118,8061,5672,318(750)
Number of MSM Receipts Stowed5762061342023012691943092653732623193,410284444(160)
TOTALS11,3838,7236,51412,2379,73011,80110,27612,51610,73911,96411,0409,909126,832

&"-,Bold"&16TE 5.2 Projected Workload SP3300-20-R-5005 Attachment J.25

Sheet1

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