Attachment_1_-_Pricing_Workbook.xlsx

XLSX spreadsheet 42 KB Posted Sep 25, 2024

Attached to: Extractors and Dryers
Solicitation number: 0000030279
Issued by: Alameda County, California

About this file

Written by GovTribe AI · Sep 27, 2024

This document is an Attachment 1 - Pricing Workbook for an Invitation for Bid (IFB) issued by the North Area Department of General Services - Procurement Division for Extractors and Dryers. The IFB has an Event ID of 0000030279 and a due date of 09/25/2024.

The IFB requests pricing for various sizes of soft mount and hard mount extractors, tumble dryers, and portable air dryers in accordance with specification 3510-BS-0189764. Estimated quantities are provided for a 3-year contract term. The pricing workbook includes line items for installation costs, trip charges for later installation, and optional take-back costs per unit. Bidders are instructed to complete the yellow input cells with pricing details.

View the file

Other files

File	Type	Posted
Addendum_Cover_Sheet_Addendum_3.docx	DOCX document	Sep 25, 2024
APP_Cover_Page.docx	DOCX document	Sep 25, 2024
Attachment_2_-_Bid_Specification_3510-BS-0189764.pdf	PDF	Sep 25, 2024
IFB_Event_ID_0000030279_Addendum_2.docx	DOCX document	Sep 25, 2024
Question___Answer_Set_1.docx	DOCX document	Sep 25, 2024
Addendum_Cover_Sheet_Addendum_4.docx	DOCX document	Sep 25, 2024
Question___Answer_Set_2.docx	DOCX document	Sep 25, 2024
Addendum_Cover_Sheet_Addendum_2.docx	DOCX document	Sep 25, 2024
IFB_Event_ID_0000030279_Addendum_4.docx	DOCX document	Sep 25, 2024
Attachment_2A_-_Technical_Questionnaire_3510-TQ-0189764.xlsx	XLSX spreadsheet	Sep 25, 2024
Attachment_3_-_Narrative_Response.docx	DOCX document	Sep 25, 2024
IFB_Event_ID_0000030279.docx	DOCX document	Sep 25, 2024
Addendum_Cover_Sheet_Addendum_1.docx	DOCX document	Sep 25, 2024
Attachment_1_addendum_1-_Pricing_Workbook.xlsx	XLSX spreadsheet	Sep 25, 2024

Show all 14

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.

Pricing Workbook Key

PRICING WORKBOOK KEY

Column Number

Column 1

Column 2

Column 3

Column 4

Column 5

Column 6

Column 7

Column 8

Column 9

Column 10

Column 11

Column 12

Column 13

Column 14

Column Name

Contract Line Item Number (CLIN)

Three (3) Year Estimated Quantity

Commodity Description

UNSPSC Code

Manufacturer Part Number (OEM #)

Manufacturer (OEM)

SKU # / Item #

Item Description

Unit of Measure

Quantity in

Unit of Measure

List Price/MSRP

Contract Discount

Contract Unit Price

Extension

Description

Unique line item number.

The State's estimated quantity; used for evaluation purpose only.

The State's description of the product.

The United Nations Standard Products and Services Code. It’s a global multi-sector standard for efficient, accurate classification of products and services.

This field should document the appropriate UNSPSC Commodity Code for each line item.

Website for codes: http://www.unspsc.org/Search.asp

Identifies manufacturer's unique identifier for a particular line item.

Identifies the manufacturer's name for each line item.

Identifies supplier's unique identifier for a particular line item.

Informational text about the commodity being purchased. Description should be descriptive enough to show the item is consistent with the specifications (high-level).

Unit of Measure - Descriptor of the packaging unit (i.e. EA is defined as Each).

This field will carry the number of base units in the packaging of the products

(i.e. # of pencils in a box).

An independently verifiable public price available to the general public.

For commodities with a fixed price structure, discount is derived based on the following calculation: ((List Price - Contract Price)/List Price) = Contract Discount %.

This is the contractual price for a given line item based on the price that was bid, as relative to the

unit of measure.

Quantity in Column 2 multiplied by the Contract Unit Price in Column 13.

Format

Variable Character

Number

Variable Character

Number

Variable Character

Number

Currency

Percentage

Currency

Example

625

1,000

Extractor

43211503

PT-674344457

4576543245-JH/4567C

HP Compaq 8710p Notebook PC

$2,500.00

66%

$1,650.00

$1,650,000.00

CORE - Often refers to a Fixed Price.

NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.).

END OF SHEET.

Extractor North Area

Department of General Services - Procurement Division
Event ID: 0000030279, Extractors and Dryers
Attachment 1 - Pricing Workbook, 09/25/2024
Bidder:			Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)	Three (3) Year Estimated Quantity	Commodity Description	UNSPSC Code	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in

Unit of Measure

List Price/MSRP	Contract Discount	Contract Unit Price	Extension
101-N	15	Soft Mount Extractor 20 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
102-N	21	Soft Mount Extractor 30 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
103-N	21	Soft Mount Extractor 35 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
104-N	21	Soft Mount Extractor 40 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
105-N	21	Soft Mount Extractor 55 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
106-N	21	Soft Mount Extractor 60 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
107-N	21	Soft Mount Extractor 70 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
108-N	15	Soft Mount Extractor 80 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
109-N	15	Soft Mount Extractor 90 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
110-N	12	Hard Mount Extractor 35 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
111-N	12	Hard Mount Extractor 40 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
112-N	12	Hard Mount Extractor 45 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
113-N	12	Hard Mount Extractor 55 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
114-N	12	Hard Mount Extractor 65 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
115-N	12	Hard Mount Extractor 70 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
116-N	1	Installation cost per unit (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
117-N	1	Trip charge fee for installation at a later date (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
118-N	1	Take-Back cost per unit - Non-Mandatory (not included in evaluated price)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculated by (Contract Unit Price x Quantity)
Note: EA is defined as each
Note: Evaluated Price = Individual CLIN Extension + CLIN 116-N Extension + CLIN 117-N Extension
Note: Trip charge fee is a one-time fee for installation scheduled at a later date, after delivery.
End of Sheet

Page &P

Tumble Dryer North Area

Department of General Services - Procurement Division
Event ID: 0000030279, Extractors and Dryers
Attachment 1 - Pricing Workbook, 09/25/2024
Bidder:			Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)	Three (3) Year Estimated Quantity	Commodity Description	UNSPSC Code	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in

Unit of Measure

List Price/MSRP	Contract Discount	Contract Unit Price	Extension
201-N	12	Tumble Dryer 20 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
202-N	12	Tumble Dryer 30 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
203-N	12	Tumble Dryer 35 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
204-N	12	Tumble Dryer 40 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
205-N	12	Tumble Dryer 55 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
206-N	12	Tumble Dryer 60 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
207-N	12	Tumble Dryer 70 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
208-N	12	Tumble Dryer 75 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
209-N	1	Installation cost per unit (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
210-N	1	Trip charge fee for installation at a later date (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
211-N	1	Take-Back cost per unit - Non-Mandatory (not included in evaluated price)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculated by (Contract Unit Price x Quantity)
Note: EA is defined as each
Note: Evaluated Price = Individual CLIN Extension + CLIN 209-N Extension + CLIN 210-N Extension
Note: Trip charge fee is a one-time fee for installation scheduled at a later date, after delivery.
End of Sheet

Page &P

Portable Air Dryer North Area

Department of General Services - Procurement Division
Event ID: 0000030279, Extractors and Dryers
Attachment 1 - Pricing Workbook, 09/25/2024
Bidder:			Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)	Three (3) Year Estimated Quantity	Commodity Description	UNSPSC Code	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in

Unit of Measure

List Price/MSRP	Contract Discount	Contract Unit Price	Extension
301-N	12	Portable Air Dryer 2 Person in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
302-N	33	Portable Air Dryer 4 Person in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
303-N	33	Portable Air Dryer 6 Person in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
304-N	33	Portable Air Dryer 8 Person in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
305-N	1	Installation cost per unit (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
306-N	1	Trip charge fee for installation at a later date (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
307-N	1	Take-Back cost per unit - Non-Mandatory (not included in evaluated price)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculated by (Contract Unit Price x Quantity)
Note: EA is defined as each
Note: Evaluated Price = Individual CLIN Extension + CLIN 305-N Extension + CLIN 306-N Extension
Note: Trip charge fee is a one-time fee for installation scheduled at a later date, after delivery.
End of Sheet

Page &P

Extractor South Area

Department of General Services - Procurement Division
Event ID: 0000030279, Extractors and Dryers
Attachment 1 - Pricing Workbook, 09/25/2024
Bidder:			Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)	Three (3) Year Estimated Quantity	Commodity Description	UNSPSC Code	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in

Unit of Measure

List Price/MSRP	Contract Discount	Contract Unit Price	Extension
101-S	15	Soft Mount Extractor 20 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
102-S	21	Soft Mount Extractor 30 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
103-S	21	Soft Mount Extractor 35 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
104-S	21	Soft Mount Extractor 40 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
105-S	21	Soft Mount Extractor 55 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
106-S	21	Soft Mount Extractor 60 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
107-S	21	Soft Mount Extractor 70 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
108-S	15	Soft Mount Extractor 80 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
109-S	15	Soft Mount Extractor 90 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
110-S	12	Hard Mount Extractor 35 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
111-S	12	Hard Mount Extractor 40 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
112-S	12	Hard Mount Extractor 45 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
113-S	12	Hard Mount Extractor 55 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
114-S	12	Hard Mount Extractor 65 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
115-S	12	Hard Mount Extractor 70 LB in accordance with specification 3510-BS-0189764.	47111506			EA	1	ERROR:#DIV/0!	$ - 0
116-S	1	Installation cost per unit (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
117-S	1	Trip charge fee for installation at a later date (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
118-S	1	Take-Back cost per unit - Non-Mandatory (not included in evaluated price)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculated by (Contract Unit Price x Quantity)
Note: EA is defined as each
Note: Evaluated Price = Individual CLIN Extension + CLIN 116-S Extension + CLIN 117-S Extension
Note: Trip charge fee is a one-time fee for installation scheduled at a later date, after delivery.
End of Sheet

Page &P

Tumble Dryer South Area

Department of General Services - Procurement Division
Event ID: 0000030279, Extractors and Dryers
Attachment 1 - Pricing Workbook, 09/25/2024
Bidder:			Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)	Three (3) Year Estimated Quantity	Commodity Description	UNSPSC Code	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in

Unit of Measure

List Price/MSRP	Contract Discount	Contract Unit Price	Extension
201-S	12	Tumble Dryer 20 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
202-S	12	Tumble Dryer 30 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
203-S	12	Tumble Dryer 35 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
204-S	12	Tumble Dryer 40 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
205-S	12	Tumble Dryer 55 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
206-S	12	Tumble Dryer 60 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
207-S	12	Tumble Dryer 70 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
208-S	12	Tumble Dryer 75 LB in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
209-S	1	Installation cost per unit (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
210-S	1	Trip charge fee for installation at a later date (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
211-S	1	Take-Back cost per unit - Non-Mandatory (not included in evaluated price)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculated by (Contract Unit Price x Quantity)
Note: EA is defined as each
Note: Evaluated Price = Individual CLIN Extension + CLIN 209-S Extension + CLIN 210-S Extension
Note: Trip charge fee is a one-time fee for installation scheduled at a later date, after delivery.
End of Sheet

Page &P

Portable Air Dryer South Area

Department of General Services - Procurement Division
Event ID: 0000030279, Extractors and Dryers
Attachment 1 - Pricing Workbook, 09/25/2024
Bidder:			Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)	Three (3) Year Estimated Quantity	Commodity Description	UNSPSC Code	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in

Unit of Measure

List Price/MSRP	Contract Discount	Contract Unit Price	Extension
301-S	12	Portable Air Dryer 2 Person in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
302-S	33	Portable Air Dryer 4 Person in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
303-S	33	Portable Air Dryer 6 Person in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
304-S	33	Portable Air Dryer 8 Person in accordance with specification 3510-BS-0189764.	47111503			EA	1	ERROR:#DIV/0!	$ - 0
305-S	1	Installation cost per unit (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
306-S	1	Trip charge fee for installation at a later date (included in evaluated price - see Note below)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
307-S	1	Take-Back cost per unit - Non-Mandatory (not included in evaluated price)	N/A	N/A	N/A	EA	1	ERROR:#DIV/0!	$ - 0
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculated by (Contract Unit Price x Quantity)
Note: EA is defined as each
Note: Evaluated Price = Individual CLIN Extension + CLIN 305-S Extension + CLIN 306-S Extension
Note: Trip charge fee is a one-time fee for installation scheduled at a later date, after delivery.
End of Sheet

Page &P

File details come from the government source that posted it. Updated Sep 27, 2024.