FN1461-18_Workbook.xlsx

XLSX spreadsheet 1 MB Posted Sep 28, 2018

Attached to: Ergomonic Seating Components
Solicitation number: FN1461-18
Issued by: Department of Justice Bureau of Prisons Correctional Facilities

About this file

Written by GovTribe AI · Dec 30, 2023

This workbook template requests proposals from suppliers for ergonomic seating components to be provided under solicitation number FN1461-18 issued by the Department of Justice Bureau of Prisons Correctional Facilities. Suppliers are to provide itemized pricing and lead times for chair components in their bill of materials across various product categories, with tiered pricing proposed for different order quantities. The workbook includes templates for suppliers to submit information on their company, proposed account teams, pricing terms, distribution facilities, and ability to meet specific service level commitments. Suppliers also complete templates indicating their capabilities at serving individual UNICOR facility locations. Key response dates include questions due by October 11th and final submissions due October 29th, with oral presentations scheduled December 3rd through 7th if selected.

View the file

Other files

File	Type	Posted
FN1461_Q&A.pdf	PDF	Oct 12, 2018
AMD1_fn1461-18_Q&A.pdf	PDF	Oct 12, 2018
FN1461-18_seating_Workbook.xlsx	XLSX spreadsheet	Oct 12, 2018
fn1461_seating_sol.pdf	PDF	Sep 28, 2018

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.

Instructions

UNICOR (Federal Prison Industries) Ergonomic Seating

Instructions

Thank you for your interest and participation in this Ergonomic Seating Solicitation. UNICOR is excited to offer suppliers this opportunity, and looks forward to working with your team throughout the solicitation process.

Please read the directions below carefully to ensure that you will be providing UNICOR with everything needed to evaluate your company and your offering.

Instructions PLEASE DO NOT modify the structure or format of the templates in any way, unless instructed to do so. All communications concerning this solicitation, in any respect, must be directed only to Tatea Cavanaugh at Tatea.Cavanaugh@usdoj.gov

This solicitation document consists of 23 worksheets, in addition to this Instructions page. The purpose of each sheet is detailed below. Please review each worksheet, as your input is required, and they each contain information that will be pertinent to your response.

Cells & Sheets shaded in GREEN are intended for the supplier responses. Cells & Sheets shaded light grey or blue are NOT to be populated or edited.

Response Requested Do Not Respond Do Not Respond

Timeline

Key Dates:

Solicitation Publication: September 28, 2018 Solicitation Q&A Questions Due: Thursday October 11, 2018 at 10:00 am Solicitation Submission Deadline: October 29, 2018 OralPresentations Held (onsite at Unicor Headquarters): December 3-7, 2018

Acceptable Submissions

Proposals must be submitted electronically via email. Hard copy and faxed proposals will not be accepted.

All questions from suppliers or requests for clarification regarding this RFP must be submitted in writing via email. To ensure equitable access to all relevant information, answers to significant questions will be consolidated and distributed to all bidding suppliers, rather than answered individually. Any supplier-specific identifying information that may appear within a question will be removed prior to general distribution.

Supplier Information

Please answer all questions listed in the "Supplier Information" worksheet to the best of your ability. Please also attach any additional information that you feel would be valuable for UNICOR to review in evaluating your company. Please note that your answers will be used to evaluate your organization on its service performance and capabilities, and your company may be penalized for excluding pertinent information or details asked for in specific questions.

Service Levels

These service levels are expected for a national enterprise-wide program within UNICOR. In order to ensure a fair bidding process it is critical suppliers note their agreement or disagreement to meet these service levels and requirements. Please mark "Yes" or "No" for each service level. If you answer "No," please comment as to why you cannot commit to this service level. Please consider all of these service levels in your proposal to ensure there are no additional fees associated with meeting any of these commitments.

There is no requirement that a supplier must be able to propose each chair style configuration.

Chair Pricing - BOM

This section contains the fields where each supplier is required to provide Firm Fixed Pricing for each chair style you are proposing. When proposing a chair style, the complete Bill of Materials (BOM) for that chair should be included in one of the "Chair Pricing - BOM" tabs of this workbook. There are 20 "Chair Pricing - BOM" tabs to allow for the submission of up to 20 different chair styles. Please do not include more than one chair BOM on each tab.

Cell D3: Insert the name of the proposed chair

Columns C & D: For each individual component of the chair BOM, list the component SKU / part number & include a short description of each component

Columns E - H: Select the appropriate categorization for each component associated with the chair style you are proposing. Selections should be made from the included drop-down menu in each cell

Columns I - K: Specifiy the unit of measure, minimum order quantity for that unit of measure, and the associated unit pricing for each component part listed in the BOM

Column L: Specify the lead time associated for each component part listed in the BOM - please ensure delivery time is in accordance with delivery specified in solicaition

Tier Pricing - Columns M - Q: Enter the various product quantity tiers for each component in cells M3 - Q3 and the associated discount for each quantity tier in the subsequent columns cells.

Locations

Please complete this section by providing your company's service capabilities for each of the UNICOR facilities that are listed. If there is a facility that your company is either unable or not willing to service, please indicate that in the appropriate column.

Supplier Information

UNICOR (Federal Prison Industries) Ergonomic Seating RFP Workbook

SECTION 1 - CONTACT INFORMATION
#	QUESTION	ANSWER
1.01	Primary Contact for this Sourcing Event	Name

Phone Email Title

		SECTION 2 - SERVICE INFORMATION
		2.01	Please describe the structure (positions & duties) of your proposed account team. If you already have an account team and personnel in place supporting UNICOR, please describe how any additional responsibilities or duties will be handled with more volume and during our busy seaon June through January .
		SECTION 3 - PRICING
		3.01	Are you willing to hold pricing firm for longer than 12 months?
		SECTION 4 - OPERATIONS
		4.01	Please provide details on all major distribution facilities that would be utilized to service and supply the products provided in this RFP. Please feel free to add additional lines if needed.
			Facility Name and Address	Square
Footage	# of Employees
		A
		B
		C
		D
		E
		F
		G
		H
		I
		J

Client

Service Levels

UNICOR (Federal Prison Industries) Ergonomic Chairs

		#	Requirement	Expectation	Offeror Agreement
(Please answer "Yes" or "No")	Comments / Assumptions
		CUSTOMER SERVICE
		1	Communication	UNICOR Contracting Officers, Factory Managers, Warehouse Supervisors and Quality Assurance Managers\Specialist are encouraged to establish and maintain open communication with their local vendor representatives. Vendor shall provide and maintain a current representative list to UNICOR with written proposal. Any changes to the representative shall be provided to all above in writing. The communication shall be limited to the contract as written. Any changes to the contract SHALL be communicated in wirting to the contracting officer and once accepted by UNICOR, a contract modification will be issued.
		2	Emergency Orders	Offeror will define and document their emergency ordering process and lead times, and will provide this service free of charge to UNICOR on an as-needed basis. Any delivery resulting from an incorrect part, damaged during delivery or defective part must be delivered using expedited shipping and the cost will be incurred by the offeror.
		3	Site Assessments	Offeror will perform, at minimum, annual local site assessments and solution recommendations to drive cost reduction.
		PRODUCT FULFILLMENT, MANAGEMENT & INVENTORY
		5	Notice of Rejection	When an item is identified through UNICOR Quality Inspection as being non-conforming, UNICOR shall forward an official "Notice of Rejection" to the vendor’s local representative assigned to the UNICOR account. Order replacement of non-conforming items shall occur immediately, excluding federal holidays, of receiving the "Notice of Rejection". In cases where the non-conformance results in production delays, the vendor shall provide for expedited delivery of a sufficient quantity to maintain production, until such time the balance of the shipment can arrive via standard means. Offeror may be responsibe for cost associated with custmer delays.
		6	Product Conformance	Components provided by offeror shall meet the specification as stated in the solicitation document and contract. UNICOR reserves the right to require proof of specification conformance.
		PRICING AND INVOICING
		7	Freight Terms	All goods shall be shipped F.O.B. Destination.
		8	Payment Terms	At a minimum, Small Businesses are Net 15 day payment terms and Large Businesses are Net 30 day payment terms
		9	P-Cards	Offeror may be required to accept a government issued purchase card for payment from UNICOR locations at no additional charge. Vendor shall state in soliciation if their company will accept payment through the P-Card.
		10	Customer Specific Price List	Unicor Pricing will be uniform for each site regardless of volume.
		11	Pricing tiers	Will you provide tier based pricing where greater quantity orders result in lower unit pricing? See 'Chair Pricing - BOM' tabs

Client

Chair Pricing - BOM1

Instructions: Offerors shall complete all cells in green. Provide a comprehensive breakdown of the bill of materials for each chair style across the various product categories requested to include itemized pricing for each component and all requested amplifying information. Refer to the Statement of Work provided in this solicitation for additional details. Each Bill of Materials should be specified on an individual "Chair Pricing - BOM" tab. There are 20 tabs numbered 1 - 20 for each chair style you may propose.

It is requested that you propose pricing tiers for various order quantities to include proposing tier quantities and associated pricing discounts by each component in the BOM. This is in Columns M - Q													Tier 1 Quantity	Tier 2 Quantity	Tier 3 Quantity	Tier 4 Quantity	Tier 5 Quantity
		Chair Style Name		Bill of Material Itemized Proposal
	Internal ID	Vendor Part # (SKU)	Short Text / Item Description	Product Category	Cylinder Option	Back Option	Part Type	UOM	Minimum order quantity for pricing provided?	Price per UOM year 1 ($)	Price per UOM year 2 ($)	Price per UOM year 3 ($)	Price per UOM year 4 ($)	Price per UOM year 5 ($)	Lead Time	Tier Pricing Tier 1	Tier Pricing Tier 2	Tier Pricing Tier 3	Tier Pricing Tier 4	Tier Pricing Tier 5
	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
	20
	21
	22
	23
	24
	25
	26
	27
	28
	29
	30
	31
	32
	33
	34
	35
	36
	37
	38
	39
	41
	159
	160
	161
	162
	163
	164
	165
	166
	167
	168
	169
	170
	171
	172
	173
	174
	175
	176
	177
	178
	179
	180
	181
	182
	183
	184
	185
	186
	187
	188
	189
	190
	191
	192
	193
	194
	195
	196
	197
	198
	199
	200
	201
	202
	203
	204
	205
	206
	207
	208
	209
	210
	211
	212
	213
	214
	215
	216
	217
	218
	219
	220
	221
	222
	223
	224
	225
	226
	227
	228
	229
	230
	231
	232
	233
	234
	235
	236
	237
	238
	239
	240
	241
	242
	243
	244
	245
	246
	247
	248
	249
	250
	251
	252
	253
	254
	255
	256
	257
	258
	259
	260
	262
	263
	264
	265
	266
	267
	268
	269
	270
	271
	272
	273
	274
	275
	276
	277
	278
	279
	280
	281
	282
	283
	284
	285
	286
	287
	288
	289
	290
	291
	292
	293
	294
	295
	296
	297
	298
	299
	300
	301
	302
	303
	304
	305
	306
	307
	308
	309
	310
	311
	312
	313
	314
	315
	316
	317
	318
	319
	320
	321
	322
	323
	324
	325
	326
	327
	328
	329
	330
	331
	332
	333
	334
	335
	336
	337
	338
	339
	340
	341
	342
	343
	344
	345
	346
	347
	348
	349
	350
	351
	352
	353
	354
	355
	356
	357
	358
	359
	360
	361
	362
	363
	364
	365
	366
	367
	368
	369
	370
	371
	372
	373
	374
	375
	376
	377
	378
	379
	380
	381
	382
	383
	384
	385
	386
	387
	388
	389
	390
	391
	392
	393
	394
	395
	396
	397
	398
	399
	400
	401
	402
	403
	404
	405
	406
	407
	408
	409
	410
	411
	412
	413
	414
	415
	416
	417
	418
	419
	420
	421
	422
	423
	424
	425
	426
	427
	428
	429
	430
	431
	432
	433
	434
	435
	436
	437
	438
	439
	440
	441
	442
	443
	444
	445
	446
	447
	448
	449
	450
	451
	452
	453
	454
	455
	456
	457
	458
	459
	460
	461
	462
	463
	464
	465
	466
	467
	468
	469
	470
	471
	472
	473
	474
	475
	476
	477
	478
	479
	480
	481
	482
	483
	484
	485
	486
	487
	488
	489
	490
	491
	492
	493
	494
	495
	496
	497
	498
	499
	500
	501
	502
	503
	504
	505
	506
	507
	508
	509
	510
	511
	512
	513
	514
	515
	516
	517
	518
	519
	520
	521
	522
	523
	524
	525
	526
	527
	528
	529
	530
	531
	532
	533
	534
	535
	536
	537
	538
	539
	540
	541
	542
	543
	544
	545
	546
	547
	548
	549
	550
	551
	552
	553
	554
	555
	556
	557
	558
	559
	560
	561
	562
	563
	564
	565
	566
	567
	568
	569
	570
	571
	572
	573
	574
	575
	576
	577
	578
	579
	580
	581
	582
	583
	584
	585
	586
	587
	588
	589
	590
	591
	592
	593
	594
	595
	596
	597
	598
	599
	600
	601
	602
	603
	604
	605
	606
	607
	608
	609
	610
	611
	612
	613
	614
	615
	616
	617
	618
	619
	620
	621
	622
	623
	624
	625
	626
	627
	628
	629
	630
	631
	632
	633
	634
	635
	636
	637
	638
	639
	640
	641
	642
	643
	644
	645
	646
	647
	648
	649
	650
	651
	652
	653
	654
	655
	656
	657
	658
	659
	660
	661
	662
	663
	664
	665
	666
	667
	668
	669
	670
	671
	672
	673
	674
	675
	676
	677
	678
	679
	680
	681
	682
	683
	684
	685
	686
	687
	688
	689
	690
	691
	692
	693
	694
	695
	696
	697
	698
	699
	700
	701
	702
	703
	704
	705
	706
	707
	708
	709
	710
	711
	712
	713
	714
	715
	716
	717
	718
	719
	720
	721
	722
	723
	724
	725
	726
	727
	728
	729
	730
	731
	732
	733
	734
	735
	736
	737
	738
	739
	740
	741
	742
	743
	744
	745
	746
	747
	748
	749
	750
	751
	752
	753
	754
	755
	756
	757
	758
	759
	760
	761
	762
	763
	764
	765
	766
	767
	768
	769
	770
	771
	772
	773
	774
	775
	776
	777
	778
	779
	780
	781
	782
	783
	784
	785
	786
	787
	788
	789
	790
	791
	792
	793
	794
	795
	796
	797
	798
	799
	800
	801
	802
	803
	804
	805
	806
	807
	808
	809
	810

Chair Pricing - BOM2

It is requested that you propose pricing tiers for various order quantities to include proposing tier quantities and associated pricing discounts by each component in the BOM. This is in Columns M - Q													Tier 1 Quantity	Tier 2 Quantity	Tier 3 Quantity	Tier 4 Quantity	Tier 5 Quantity
		Chair Style Name		Bill of Material Itemized Proposal
	Internal ID	Vendor Part # (SKU)	Short Text / Item Description	Product Category	Cylinder Option	Back Option	Part Type	UOM	Minimum order quantity for pricing provided?	Price per UOM year 1 ($)	Price per UOM year 2 ($)	Price per UOM year 3 ($)	Price per UOM year 4 ($)	Price per UOM year 5 ($)	Lead Time	Tier Pricing Tier 1	Tier Pricing Tier 2	Tier Pricing Tier 3	Tier Pricing Tier 4	Tier Pricing Tier 5
	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
	20
	21
	22
	23
	24
	25
	26
	27
	28
	29
	30
	31
	32
	33
	34
	35
	36
	37
	38
	39
	41
	159
	160
	161
	162
	163
	164
	165
	166
	167
	168
	169
	170
	171
	172
	173
	174
	175
	176
	177
	178
	179
	180
	181
	182
	183
	184
	185
	186
	187
	188
	189
	190
	191
	192
	193
	194
	195
	196
	197
	198
	199
	200
	201
	202
	203
	204
	205
	206
	207
	208
	209
	210
	211
	212
	213
	214
	215
	216
	217
	218
	219
	220
	221
	222
	223
	224
	225
	226
	227
	228
	229
	230
	231
	232
	233
	234
	235
	236
	237
	238
	239
	240
	241
	242
	243
	244
	245
	246
	247
	248
	249
	250
	251
	252
	253
	254
	255
	256
	257
	258
	259
	260
	262
	263
	264
	265
	266
	267
	268
	269
	270
	271
	272
	273
	274
	275
	276
	277
	278
	279
	280
	281
	282
	283
	284
	285
	286
	287
	288
	289
	290
	291
	292
	293
	294
	295
	296
	297
	298
	299
	300
	301
	302
	303
	304
	305
	306
	307
	308
	309
	310
	311
	312
	313
	314
	315
	316
	317
	318
	319
	320
	321
	322
	323
	324
	325
	326
	327
	328
	329
	330
	331
	332
	333
	334
	335
	336
	337
	338
	339
	340
	341
	342
	343
	344
	345
	346
	347
	348
	349
	350
	351
	352
	353
	354
	355
	356
	357
	358
	359
	360
	361
	362
	363
	364
	365
	366
	367
	368
	369
	370
	371
	372
	373
	374
	375
	376
	377
	378
	379
	380
	381
	382
	383
	384
	385
	386
	387
	388
	389
	390
	391
	392
	393
	394
	395
	396
	397
	398
	399
	400
	401
	402
	403
	404
	405
	406
	407
	408
	409
	410
	411
	412
	413
	414
	415
	416
	417
	418
	419
	420
	421
	422
	423
	424
	425
	426
	427
	428
	429
	430
	431
	432
	433
	434
	435
	436
	437
	438
	439
	440
	441
	442
	443
	444
	445
	446
	447
	448
	449
	450
	451
	452
	453
	454
	455
	456
	457
	458
	459
	460
	461
	462
	463
	464
	465
	466
	467
	468
	469
	470
	471
	472
	473
	474
	475
	476
	477
	478
	479
	480
	481
	482
	483
	484
	485
	486
	487
	488
	489
	490
	491
	492
	493
	494
	495
	496
	497
	498
	499
	500
	501
	502
	503
	504
	505
	506
	507
	508
	509
	510
	511
	512
	513
	514
	515
	516
	517
	518
	519
	520
	521
	522
	523
	524
	525
	526
	527
	528
	529
	530
	531
	532
	533
	534
	535
	536
	537
	538
	539
	540
	541
	542
	543
	544
	545
	546
	547
	548
	549
	550
	551
	552
	553
	554
	555
	556
	557
	558
	559
	560
	561
	562
	563
	564
	565
	566
	567
	568
	569
	570
	571
	572
	573
	574
	575
	576
	577
	578
	579
	580
	581
	582
	583
	584
	585
	586
	587
	588
	589
	590
	591
	592
	593
	594
	595
	596
	597
	598
	599
	600
	601
	602
	603
	604
	605
	606
	607
	608
	609
	610
	611
	612
	613
	614
	615
	616
	617
	618
	619
	620
	621
	622
	623
	624
	625
	626
	627
	628
	629
	630
	631
	632
	633
	634
	635
	636
	637
	638
	639
	640
	641
	642
	643
	644
	645
	646
	647
	648
	649
	650
	651
	652
	653
	654
	655
	656
	657
	658
	659
	660
	661
	662
	663
	664
	665
	666
	667
	668
	669
	670
	671
	672
	673
	674
	675
	676
	677
	678
	679
	680
	681
	682
	683
	684
	685
	686
	687
	688
	689
	690
	691
	692
	693
	694
	695
	696
	697
	698
	699
	700
	701
	702
	703
	704
	705
	706
	707
	708
	709
	710
	711
	712
	713
	714
	715
	716
	717
	718
	719
	720
	721
	722
	723
	724
	725
	726
	727
	728
	729
	730
	731
	732
	733
	734
	735
	736
	737
	738
	739
	740
	741
	742
	743
	744
	745
	746
	747
	748
	749
	750
	751
	752
	753
	754
	755
	756
	757
	758
	759
	760
	761
	762
	763
	764
	765
	766
	767
	768
	769
	770
	771
	772
	773
	774
	775
	776
	777
	778
	779
	780
	781
	782
	783
	784
	785
	786
	787
	788
	789
	790
	791
	792
	793
	794
	795
	796
	797
	798
	799
	800
	801
	802
	803
	804
	805
	806
	807
	808
	809
	810

Chair Pricing - BOM3

It is requested that you propose pricing tiers for various order quantities to include proposing tier quantities and associated pricing discounts by each component in the BOM. This is in Columns M - Q													Tier 1 Quantity	Tier 2 Quantity	Tier 3 Quantity	Tier 4 Quantity	Tier 5 Quantity
		Chair Style Name		Bill of Material Itemized Proposal
	Internal ID	Vendor Part # (SKU)	Short Text / Item Description	Product Category	Cylinder Option	Back Option	Part Type	UOM	Minimum order quantity for pricing provided?	Price per UOM year 1 ($)	Price per UOM year 2 ($)	Price per UOM year 3 ($)	Price per UOM year 4 ($)	Price per UOM year 5 ($)	Lead Time	Tier Pricing Tier 1	Tier Pricing Tier 2	Tier Pricing Tier 3	Tier Pricing Tier 4	Tier Pricing Tier 5
	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
	20
	21
	22
	23
	24
	25
	26
	27
	28
	29
	30
	31
	32
	33
	34
	35
	36
	37
	38
	39
	41
	159
	160
	161
	162
	163
	164
	165
	166
	167
	168
	169
	170
	171
	172
	173
	174
	175
	176
	177
	178
	179
	180
	181
	182
	183
	184
	185
	186
	187
	188
	189
	190
	191
	192
	193
	194
	195
	196
	197
	198
	199
	200
	201
	202
	203
	204
	205
	206
	207
	208
	209
	210
	211
	212
	213
	214
	215
	216
	217
	218
	219
	220
	221
	222
	223
	224
	225
	226
	227
	228
	229
	230
	231
	232
	233
	234
	235
	236
	237
	238
	239
	240
	241
	242
	243
	244
	245
	246
	247
	248
	249
	250
	251
	252
	253
	254
	255
	256
	257
	258
	259
	260
	262
	263
	264
	265
	266
	267
	268
	269
	270
	271
	272
	273
	274
	275
	276
	277
	278
	279
	280
	281
	282
	283
	284
	285
	286
	287
	288
	289
	290
	291
	292
	293
	294
	295
	296
	297
	298
	299
	300
	301
	302
	303
	304
	305
	306
	307
	308
	309
	310
	311
	312
	313
	314
	315
	316
	317
	318
	319
	320
	321
	322
	323
	324
	325
	326
	327
	328
	329
	330
	331
	332
	333
	334
	335
	336
	337
	338
	339
	340
	341
	342
	343
	344
	345
	346
	347
	348
	349
	350
	351
	352
	353
	354
	355
	356
	357
	358
	359
	360
	361
	362
	363
	364
	365
	366
	367
	368
	369

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 Dec 30, 2023.