Attachment_1_addendum_1-_Pricing_Workbook.xlsx

XLSX spreadsheet 43 KB Posted

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

About this file

This document is an Attachment 1 - Pricing Workbook for an Invitation for Bid (IFB) issued by the State of California, Department of General Services, Procurement Division (DGS-PD) on behalf of the California Department of Forestry and Fire Protection (CAL FIRE) for Extractors and Dryers. The contract resulting from this solicitation will be mandatory for CAL FIRE and available for use by all State of California Departments and participating local agencies, including Alameda County. The workbook contains detailed specifications, quantities, and pricing for a variety of extractor, tumble dryer, and portable air dryer commodities, including soft mount, hard mount, and installation costs. The workbook lists the specific UNSPSC codes, manufacturer details, and unit of measure for each item. The estimated quantities range from 12 to 33 units over a three-year term.

The pricing workbook requires bidders to provide list prices, contract discounts, and contract unit prices for each line item. The contract discount is calculated based on the difference between the list price and the contract unit price. The extension is automatically calculated based on the quantity and contract unit price. The evaluated price includes the individual line item extension, installation costs, and trip charge fees. The workbook also includes a non-mandatory take-back cost per unit option. Bidders must complete the yellow input cells only, and the contract will be awarded to the responsive and responsible bidder offering the lowest evaluated price.

View the file

Other files

File Type Posted
Addendum_Cover_Sheet_Addendum_3.docx DOCX document
APP_Cover_Page.docx DOCX document
Attachment_2_-_Bid_Specification_3510-BS-0189764.pdf PDF
IFB_Event_ID_0000030279_Addendum_2.docx DOCX document
Question___Answer_Set_1.docx DOCX document
Addendum_Cover_Sheet_Addendum_4.docx DOCX document
Question___Answer_Set_2.docx DOCX document
Addendum_Cover_Sheet_Addendum_2.docx DOCX document
IFB_Event_ID_0000030279_Addendum_4.docx DOCX document
Attachment_2A_-_Technical_Questionnaire_3510-TQ-0189764.xlsx XLSX spreadsheet
Attachment_3_-_Narrative_Response.docx DOCX document
Attachment_1_-_Pricing_Workbook.xlsx XLSX spreadsheet
IFB_Event_ID_0000030279.docx DOCX document
Addendum_Cover_Sheet_Addendum_1.docx DOCX document
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

Text version

Pricing Workbook Key

PRICING WORKBOOK KEY
Column NumberColumn 1Column 2Column 3Column 4Column 5Column 6Column 7Column 8Column 9Column 10Column 11Column 12Column 13Column 14
Column NameContract Line Item Number (CLIN)
Three (3) Year Estimated QuantityCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract Unit PriceExtension
DescriptionUnique 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.aspIdentifies 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.
FormatVariable CharacterNumberVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberCurrencyPercentageCurrencyCurrency
Example6251,000Extractor43211503PT-674344457HP4576543245-JH/4567CHP Compaq 8710p Notebook PCEA10$2,500.0066%$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, *10/4/2024 Addendum 1*
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 QuantityCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

List Price/MSRPContract DiscountContract Unit PriceExtension
101-N15Soft Mount Extractor 20 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
102-N21Soft Mount Extractor 30 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
103-N21Soft Mount Extractor 35 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
104-N21Soft Mount Extractor 40 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
105-N21Soft Mount Extractor 55 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
106-N21Soft Mount Extractor 60 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
107-N21Soft Mount Extractor 70 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
108-N15Soft Mount Extractor 80 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
109-N15Soft Mount Extractor 90 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
110-N12Hard Mount Extractor 35 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
111-N12Hard Mount Extractor 40 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
112-N12Hard Mount Extractor 45 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
113-N12Hard Mount Extractor 55 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
114-N12Hard Mount Extractor 65 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
115-N12Hard Mount Extractor 70 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
116-N1*Soft Mount* Installation cost per unit (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
*117-N*1*Hard Mount Installation cost per unit (included in evaluated price - see Note below)*N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
*118-N*1Trip charge fee for installation at a later date (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
*118-N*1Take-Back cost per unit - Non-Mandatory (not included in evaluated price)N/AN/AN/AEA1ERROR:#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 or 117-N Extension + CLIN 118-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 QuantityCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

List Price/MSRPContract DiscountContract Unit PriceExtension
201-N12Tumble Dryer 20 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
202-N12Tumble Dryer 30 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
203-N12Tumble Dryer 35 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
204-N12Tumble Dryer 40 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
205-N12Tumble Dryer 55 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
206-N12Tumble Dryer 60 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
207-N12Tumble Dryer 70 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
208-N12Tumble Dryer 75 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
209-N1Installation cost per unit (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
210-N1Trip charge fee for installation at a later date (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
211-N1Take-Back cost per unit - Non-Mandatory (not included in evaluated price)N/AN/AN/AEA1ERROR:#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 QuantityCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

List Price/MSRPContract DiscountContract Unit PriceExtension
301-N12Portable Air Dryer 2 Person in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
302-N33Portable Air Dryer 4 Person in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
303-N33Portable Air Dryer 6 Person in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
304-N33Portable Air Dryer 8 Person in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
305-N1Installation cost per unit (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
306-N1Trip charge fee for installation at a later date (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
307-N1Take-Back cost per unit - Non-Mandatory (not included in evaluated price)N/AN/AN/AEA1ERROR:#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, *10/4/2024 Addendum 1*
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 QuantityCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

List Price/MSRPContract DiscountContract Unit PriceExtension
101-S15Soft Mount Extractor 20 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
102-S21Soft Mount Extractor 30 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
103-S21Soft Mount Extractor 35 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
104-S21Soft Mount Extractor 40 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
105-S21Soft Mount Extractor 55 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
106-S21Soft Mount Extractor 60 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
107-S21Soft Mount Extractor 70 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
108-S15Soft Mount Extractor 80 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
109-S15Soft Mount Extractor 90 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
110-S12Hard Mount Extractor 35 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
111-S12Hard Mount Extractor 40 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
112-S12Hard Mount Extractor 45 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
113-S12Hard Mount Extractor 55 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
114-S12Hard Mount Extractor 65 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
115-S12Hard Mount Extractor 70 LB in accordance with specification 3510-BS-0189764.47111506EA1ERROR:#DIV/0!$ - 0
116-S1*Soft Mount* Installation cost per unit (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
*117-S*1*Hard Mount Installation cost per unit (included in evaluated price - see Note below)*N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
*118-S*1Trip charge fee for installation at a later date (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
*119-S*1Take-Back cost per unit - Non-Mandatory (not included in evaluated price)N/AN/AN/AEA1ERROR:#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 or 117-N Extension + CLIN 118-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 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 QuantityCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

List Price/MSRPContract DiscountContract Unit PriceExtension
201-S12Tumble Dryer 20 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
202-S12Tumble Dryer 30 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
203-S12Tumble Dryer 35 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
204-S12Tumble Dryer 40 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
205-S12Tumble Dryer 55 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
206-S12Tumble Dryer 60 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
207-S12Tumble Dryer 70 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
208-S12Tumble Dryer 75 LB in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
209-S1Installation cost per unit (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
210-S1Trip charge fee for installation at a later date (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
211-S1Take-Back cost per unit - Non-Mandatory (not included in evaluated price)N/AN/AN/AEA1ERROR:#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 QuantityCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

List Price/MSRPContract DiscountContract Unit PriceExtension
301-S12Portable Air Dryer 2 Person in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
302-S33Portable Air Dryer 4 Person in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
303-S33Portable Air Dryer 6 Person in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
304-S33Portable Air Dryer 8 Person in accordance with specification 3510-BS-0189764.47111503EA1ERROR:#DIV/0!$ - 0
305-S1Installation cost per unit (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
306-S1Trip charge fee for installation at a later date (included in evaluated price - see Note below)N/AN/AN/AEA1ERROR:#DIV/0!$ - 0
307-S1Take-Back cost per unit - Non-Mandatory (not included in evaluated price)N/AN/AN/AEA1ERROR:#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 .