SPE8E3-21-R0001 Attachment R- VOLUME III-Storefront Support Pricing for the Northeast Zone 1- REVISED.xlsx

XLSX spreadsheet 59 KB Posted

Attached to
SOLICITATION SPE8E321R0001 AMENDMENT 0003 Federal contract opportunity
Solicitation number
Not on record
Issued by
Defense Logistics Agency Troop Support Construction and Equipment

View the file

Other files for this federal contract opportunity

Other files attached to SOLICITATION SPE8E321R0001 AMENDMENT 0003, newest first.
File Type Posted
SPE8E3-21-R0001 Attachment U- VOLUME III-Storefront Support Pricing for the South Central Zone 2- REVISED.xlsx XLSX spreadsheet
SF30_SPE8E321R00010003.pdf PDF
SPE8E3-21-R0001 Attachment S- VOLUME III-Storefront Support Pricing for the Northeast Zone 2- REVISED.xlsx XLSX spreadsheet

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

Tab 1- Pentagon Storefront PEL

PRICING PERIOD 1 (24 Months)PRICING PERIOD 2 (24 Months)PRICING PERIOD 3 (24 Months)PRICING PERIOD 4 (24 Months)PRICING PERIOD 5 (24 Months)
PEL LINE ITEM #MANUFACTURERPART NUMBERITEM DESCRIPTIONALTERNATE MANUFACTURER*ALTERNATE
PART NUMBER*ALTERNATE
ITEM DESCRIPTION*COUNTRY OF ORIGINPRODUCT CATEGORYQUANTITYUNIT OF ISSUEACQUISITION CEILING PRICE (PER UNIT OF ISSUE)TOTAL ACQUISITION PRICEQUANTITYUNIT OF ISSUEACQUISITION CEILING PRICE (PER UNIT OF ISSUE)TOTAL ACQUISITION PRICEQUANTITYUNIT OF ISSUEACQUISITION CEILING PRICE (PER UNIT OF ISSUE)TOTAL ACQUISITION PRICEQUANTITYUNIT OF ISSUEACQUISITION CEILING PRICE (PER UNIT OF ISSUE)TOTAL ACQUISITION PRICEQUANTITYUNIT OF ISSUEACQUISITION CEILING PRICE (PER UNIT OF ISSUE)TOTAL ACQUISITION PRICECOUNTRY OF ORIGINOFFEROR NOTES
0013M33+Vinyl Electrical Tape Super 33+GermanyELECTRICAL143EA$ - 0143EA$ - 0143EA$ - 0143EA$ - 0143EA$ - 0
0023MCT15NT120S-LScrew Mount Cable Tie WhiteUSACHEMICALS, LUBRICANTS, PAINTS667EA$ - 0667EA$ - 0667EA$ - 0667EA$ - 0667EA$ - 0
003Alexandria MouldingWM 201Outside CORNER, PROFILE WM-201, 1 5/16 X 1 5/16,USAOTHER512EA$ - 0512EA$ - 0512EA$ - 0512EA$ - 0512EA$ - 0
004Appleton4075SConnector, 3/4 EMT SET-SCREWUSAOTHER378EA$ - 0378EA$ - 0378EA$ - 0378EA$ - 0378EA$ - 0
005ARLINGTON441Bushing, Gray, Plastic, , ARL 144, 105DMexicoAPPLIANCE195EA$ - 0195EA$ - 0195EA$ - 0195EA$ - 0195EA$ - 0
006ARLINGTON443ARL 443 1-1/4 105D Plastic INS BushingMexicoAPPLIANCE209EA$ - 0209EA$ - 0209EA$ - 0209EA$ - 0209EA$ - 0
007ARLINGTON4010ASTCONNECTORS, MC CABLE, SINGLEMexicoAPPLIANCE503EA$ - 0503EA$ - 0503EA$ - 0503EA$ - 0503EA$ - 0
008ARLINGTON404010ASTCONNECTORS, MC CABLE, DUALMexicoAPPLIANCE311EA$ - 0311EA$ - 0311EA$ - 0311EA$ - 0311EA$ - 0
009ARLINGTONGF75GF75ST Screw - In Connector 3/4, Snap TiteMexicoAPPLIANCE324EA$ - 0324EA$ - 0324EA$ - 0324EA$ - 0324EA$ - 0
010Armstrong574BArmstrong Wht Sq Edge Ceiling Armstrong Wht Sq EdMexicoAPPLIANCE888EA$ - 0888EA$ - 0888EA$ - 0888EA$ - 0888EA$ - 0
011Brass CraftS1-12KC F3/8 COMP X 3/8 OD COMP 12LENGHMexicoAPPLIANCE8EA$ - 08EA$ - 08EA$ - 08EA$ - 08EA$ - 0
012DURACELLDL123ABPKBATTERY,123, LITHIUM, 3VUSAELECTRICAL349EA$ - 0349EA$ - 0349EA$ - 0349EA$ - 0349EA$ - 0
013Eaton (B-Line)BW4Rod and Wire Armored Cable Support, Use with 14/3USACHEMICALS, LUBRICANTS, PAINTS250EA$ - 0250EA$ - 0250EA$ - 0250EA$ - 0250EA$ - 0
014ENERGIZEREN93Battery, CUSACONSTRUCTION207EA$ - 0207EA$ - 0207EA$ - 0207EA$ - 0207EA$ - 0
015ENERGIZEREN95D INDUSTRIAL ALKALINE BATTERYJapanPLUMBING28EA$ - 028EA$ - 028EA$ - 028EA$ - 028EA$ - 0
016FaboryU51122.013.0200G2497 Machine Screw Head Type Pan 18-8 Stainless SUSACONSTRUCTION5EA$ - 05EA$ - 05EA$ - 05EA$ - 05EA$ - 0
017FERGUSONLH06010PIPE, COPPER, 3/4X10, TYPE L HARDUSACONSTRUCTION263EA$ - 0263EA$ - 0263EA$ - 0263EA$ - 0263EA$ - 0
018FERGUSONLH400104 X 10 L HARD COP TUBE310EA$ - 0310EA$ - 0310EA$ - 0310EA$ - 0310EA$ - 0
019GatesXPA730Belt. XPA730 Cogged Metric Belt6EA$ - 06EA$ - 06EA$ - 06EA$ - 06EA$ - 0
020JOHNSON CONTROLM9106-AGA-2HEAT VALVE MOTOR109EA$ - 0109EA$ - 0109EA$ - 0109EA$ - 0109EA$ - 0
021JOHNSON CONTROLVG7241ETVG7000 SERIES BRASS TRIM GLOBE VALVE36EA$ - 036EA$ - 036EA$ - 036EA$ - 036EA$ - 0
022JOHNSON CONTROLVA-4233-GGA-2Cooling Valve Actuator (240V)187EA$ - 0187EA$ - 0187EA$ - 0187EA$ - 0187EA$ - 0
023JOHNSON CONTROLVG7841GT1/2 NPT 3 WAY Mixixng Valve Body (4.6Cv)15EA$ - 015EA$ - 015EA$ - 015EA$ - 015EA$ - 0
024LEATHERMAN831102MULTI-TOOL, SUPER TOOL 30030EA$ - 030EA$ - 030EA$ - 030EA$ - 030EA$ - 0
025PHILLIPS38336-4COMPACT FLUORESCENT LAMPS. PL-C 26W/835/4P/ALTO779EA$ - 0779EA$ - 0779EA$ - 0779EA$ - 0779EA$ - 0
026PHILLIPS280909Philips 280909 - F17T8/TL850 ALTO, 17 Watt - T8 -95EA$ - 095EA$ - 095EA$ - 095EA$ - 095EA$ - 0
027PHILLIPS692545NAP F54T5/850/HO-ALTO54W FLR LAMP157EA$ - 0157EA$ - 0157EA$ - 0157EA$ - 0157EA$ - 0
028PIGTLS620Roof Diverter3EA$ - 03EA$ - 03EA$ - 03EA$ - 03EA$ - 0
029PPG IndustriesCB1010OZ COVE BASE ADHESIVE245EA$ - 0245EA$ - 0245EA$ - 0245EA$ - 0245EA$ - 0
030Prime SourceMTD8121SCREW, SELF DRILLING. K-LATH H, 1/2, ZINC, Philli69EA$ - 069EA$ - 069EA$ - 069EA$ - 069EA$ - 0
031Purell3639-12Hand Sanitizer,Size 12 oz.,order in multiples of 1184EA$ - 0184EA$ - 0184EA$ - 0184EA$ - 0184EA$ - 0
032RACO523SWITCH BOX, 2-1/2D OWB W/GRIP BXC, 1G131EA$ - 0131EA$ - 0131EA$ - 0131EA$ - 0131EA$ - 0
033Sloan33010371.5GPF A37A Urinal Regal Repair Kit196EA$ - 0196EA$ - 0196EA$ - 0196EA$ - 0196EA$ - 0
034Sloan5P211Toilet Repair Kit, Replacement, 4.5 gpf198EA$ - 0198EA$ - 0198EA$ - 0198EA$ - 0198EA$ - 0
035SloanRoyal 110Sloan 110 Closet Flushometer. 1.5 TSPUD 3.5 GPF24EA$ - 024EA$ - 024EA$ - 024EA$ - 024EA$ - 0
036SloanV551A. V-500-AValve repair kit. Sloan V551A. V-500-A111EA$ - 0111EA$ - 0111EA$ - 0111EA$ - 0111EA$ - 0
037SYLVANIA1610439 PAR 20 / HAL / FL / 30176EA$ - 0176EA$ - 0176EA$ - 0176EA$ - 0176EA$ - 0
038SYLVANIA20318Lamp. CF13DS/E/841128EA$ - 0128EA$ - 0128EA$ - 0128EA$ - 0128EA$ - 0
039SYLVANIA20901Lamp. SYL FP28/835/ECO (20901) Flourescent148EA$ - 0148EA$ - 0148EA$ - 0148EA$ - 0148EA$ - 0
040SYLVANIAFO32/835/ECO32 watt 48 T8 3,500K 800 Series Ecologic OCTRON F471EA$ - 0471EA$ - 0471EA$ - 0471EA$ - 0471EA$ - 0
041SYLVANIA20585 DULUX LOSRAM DULUX L BULB. 40W/3500K/RS460EA$ - 0460EA$ - 0460EA$ - 0460EA$ - 0460EA$ - 0
042UNIVERSALB432IUNVHP-A000I120/277V 4 LIGHT BALLAST (CS=10)43EA$ - 043EA$ - 043EA$ - 043EA$ - 043EA$ - 0
043UNIVERSALC240PUNVHP-B000CBallast, 2-40PS UNV Ballast7EA$ - 07EA$ - 07EA$ - 07EA$ - 07EA$ - 0
044VERISU006-0007DRIP PAN SENSOR54EA$ - 054EA$ - 054EA$ - 054EA$ - 054EA$ - 0
045VIEGA77367Elbow,90 Degree,1 1/2 In,Copper,200 PSI18EA$ - 018EA$ - 018EA$ - 018EA$ - 018EA$ - 0
046VIEGA78057LF 2X2 BRZ PXM ADPT3EA$ - 03EA$ - 03EA$ - 03EA$ - 03EA$ - 0
047VIEGA79290Coupling, W/ST LF 1 PXP23EA$ - 023EA$ - 023EA$ - 023EA$ - 023EA$ - 0
048VIEGA773523/4 Ftgxp 90 Elbow Street 90

De La Cruz, Linnette S CIV DLA TROOP SUPPORT (USA): De La Cruz, Linnette S CIV DLA TROOP SUPPORT (USA):

COO identified on recent KOP history as USA55EA$ - 055EA$ - 055EA$ - 055EA$ - 055EA$ - 0
049Wago222-412222-412-Pluggable Terminal Block, 2 Position 28 AW133EA$ - 0133EA$ - 0133EA$ - 0133EA$ - 0133EA$ - 0
050Wago222-413222-413 Pluggable Terminal Block, 3 Position, 28AW233EA$ - 0233EA$ - 0233EA$ - 0233EA$ - 0233EA$ - 0

SPE8E3-21-R0001 Attachment R- VOLUME III-Storefront Support Pricing for the Northeast Zone 1 Price Proposal Tab 1- PEL (Non-Drop Ship) for Pentagon Storefront

Tab 2 - Storefront Labor

PRICING PERIOD 1 (24 Months)PRICING PERIOD 2 (24 Months)PRICING PERIOD 3 (24 Months)PRICING PERIOD 4 (24 Months)PRICING PERIOD 5 (24 Months)
STOREFRONT SCENARIOEMPLOYEE JOB TITLESNUMBER OF EMPLOYEES REQUIRED UNDER JOB TITLEEMPLOYEE JOB DESCRIPTIONSUNBURDENED HOURLY WAGE RATE PER EACH EMPLOYEEBURDENED HOURLY WAGE RATE PER EACH EMPLOYEE*BURDENED DAILY WAGE RATE PER EACH EMPLOYEE**BURDENED WEEKLY WAGE RATE PER EACH EMPLOYEE***BURDENED MONTHLY WAGE RATE PER EACH EMPLOYEE****TOTAL BURDENED MONTHLY WAGE RATE PER PERIODUNBURDENED HOURLY WAGE RATEBURDENED HOURLY WAGE RATE*BURDENED DAILY WAGE RATE**BURDENED WEEKLY WAGE RATE***BURDENED MONTHLY WAGE RATE****TOTAL BURDENED MONTHLY WAGE RATE PER JOB POSITION FOR THE PERIODUNBURDENED HOURLY WAGE RATE PER EACH EMPLOYEEBURDENED HOURLY WAGE RATE PER EACH EMPLOYEE*BURDENED DAILY WAGE RATE PER EACH EMPLOYEE**BURDENED WEEKLY WAGE RATE PER EACH EMPLOYEE***BURDENED MONTHLY WAGE RATE PER EACH EMPLOYEE****TOTAL BURDENED MONTHLY WAGE RATE PER JOB POSITION FOR THE PERIODUNBURDENED HOURLY WAGE RATE PER EACH EMPLOYEEBURDENED HOURLY WAGE RATE PER EACH EMPLOYEE*BURDENED DAILY WAGE RATE PER EACH EMPLOYEE**BURDENED WEEKLY WAGE RATE PER EACH EMPLOYEE***BURDENED MONTHLY WAGE RATE PER EACH EMPLOYEE****TOTAL BURDENED MONTHLY WAGE RATE PER JOB POSITION FOR THE PERIODUNBURDENED HOURLY WAGE RATE PER EACH EMPLOYEEBURDENED HOURLY WAGE RATE PER EACH EMPLOYEE*BURDENED DAILY WAGE RATE PER EACH EMPLOYEE**BURDENED WEEKLY WAGE RATE PER EACH EMPLOYEE***BURDENED MONTHLY WAGE RATE PER EACH EMPLOYEE****TOTAL BURDENED MONTHLY WAGE RATE PER JOB POSITION FOR THE PERIOD
The Storefront shall operate as a small industrial supply store.

A storefront space shall be provided by the customer as detailed in the Pentagon Storefront Statement of Work.

Hours of operation shall be: Mon-Fri 1st Shift - 7:00 am to 3:30pm 2nd Shift – 3:30 pm to 11:00 pm

The operation of the Storefront shall require nine employees. Please note column C identifies the number of employees required under the Column B "employee Job Title". The job descriptions are listed in Column D.Store Clerk1This full-time on-site individual’s primary function is the resale of merchandise in a retail environment. Will keep inventory forms of merchandise stocked or merchandise returned to storage; will offer customer assistance with the location and selection of merchandise and use the contractor’s information technology system to conduct a material transaction. Other duties include: cleaning merchandise on or in display fixtures, maintaining the sales area by straightening merchandise to give a neat, full, and saleable appearance, removing damaged or outdated merchandise, and displaying merchandise in such a manner as to maintain freshness and sales dates.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Material Handlers4These full-time on-site individuals will transport or store merchandise. Duties include the following: manually loading and unloading freight cars, trucks, and other transporting devices; unpacking shelving, or placing items in proper storage locations; and transporting goods by hand, truck, cart, or wheelbarrow. Other activities will include all aspects of inventory management, staging material for pick up and deliveries, quality assurance of products, emergency order processing and customer service.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Storefront Emergency Delivery Driver1This full-time on-site individual is responsible for driving the Pentagon-owned van to pick up emergency merchandise or packages from local suppliers and deliver to the Pentagon shop store. Upon pick up at the vendor location, the driver ensures material matches order detail, inspects the material for damage, loads and secures material into van, obtains receipt from vendor and maintains log of pickups/deliveries. Driver is responsible for reading and interpreting maps and/or GPS directions both to and from vendor locations, monitoring traffic conditions to avoid delays, and following all local and municipal traffic and safety laws. Upon return to the Pentagon, the Driver is responsible for unloading material.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Procurement Analyst1One full time on-site person responsible for providing support to acquire goods and services, or works from an external source via the competitive bidding process. Individual will be responsible for the processing and monitoring of RFQs and POs associated with the Pentagon’s Spot-buy program. Personnel will serve as a liaison within the Property Management Branch a the storefront location.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Inventory Assistant1Individual is required to manage supply sources for items stocked in the shop stores; monitor product usage and report results to the Storefront Manager in order to adjust the inventory plan based on activity; monitor and manage any product returns due to discrepancies; coordinate with Storefront Manager on products to replenish (timing and quantity) to prevent stock outages; coordinate with Storefront Manager on cycle counts including resolving any discrepancies; generate data for Monthly Performance Metric Reports and Pre-Expended Bin Forms/Reports.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Storefront Manager1This full-time on-site person will coordinate and perform all necessary functions to establish and maintain adequate stock and supply levels, oversee the warehouse, ensure successful and timely deliveries to the shops and manage the on-site staff. This individual will act as a liaison with the contractor’s procurement and customer support operation.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL$ - 0

SPE8E3-21-R0001 Attachment R- VOLUME III-Storefront Support Pricing for the Northeast Zone 1 Tab 2- STOREFRONT LABOR FOR PENTAGON STOREFRONT *The Contractor is required to provide unburdened and fully burdened hourly labor rates in United States Dollars for each of the employees listed. Please note, fully burdened hourly labor rates must include all the direct, indirect, general and administrative costs, and profit associated with providing the required personnel (employee costs only).

The burdened hourly wage rate per employee is calculated into a burdened monthly wage rate per employee as follows:

**Burden Hourly Wage Rate per employee x 8 = Burden Daily Wage Rate per employee.

***Burden Daily Wage Rate per employee x 5 = Burden Weekly Wage Rate per employee.

****Burden Weekly Wage Rate per employee x 4 = Burden Monthly Wage Rate per employee.

Burden Monthly Wage Rate per employee x number of employees on colunm C= Total Burdened Monthly Wage Rate Per Period.

The Contractor must take into consideration the requirements for employing personnel in the Northeast Region Zone 1 including minimum wage rates.

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