Attach_1_-_Cost_Worksheet.xlsx

XLSX spreadsheet 45 KB Posted Jan 28, 2016

Attached to: Cal Fire Firefighter Helicopters
Solicitation number: 0000000119
Issued by: California

About this file

Written by GovTribe AI · Dec 7, 2024

This is a pricing worksheet template (Attachment 1, Addendum #6) for Cal Fire's helicopter procurement. The document outlines a three-year procurement plan for three helicopters per year, along with associated equipment requirements, mandatory options, services, and non-mandatory options. Each helicopter requires specific equipment including hoists, tank provisions, external load provisions, various radio and communication systems (including FM VHF Hi-band tactical radios, satellite phones, and Becker communication equipment), and installation services. The procurement also includes training requirements for pilots, maintenance staff, and technical equipment operation.

The pricing worksheet is structured to capture costs across multiple categories: base aircraft, equipment requirements, mandatory options (including troop passenger seats, air conditioning, water tanks, and closed circuit fuel options), services (including installation, inspections, and training), and bonds. Non-mandatory options are listed separately and include comfort passenger seats, search light provisions, and 800 MHz radios. The template requires bidders to provide unit pricing for each line item across all three years, with subtotals for each category and grand totals for each year. All prices are to be quoted per unit with quantities specified for each line item.

View the file

Other files

File	Type	Posted
Attach_5A_-_CUF_Form.doc	DOC document	Jan 28, 2016
Attach_2_-_1520-3093r2.pdf	PDF	Jan 28, 2016
Attach_4_-_Customer_Reference_Form.docx	DOCX document	Jan 28, 2016
QA_Set__1.pdf	PDF	Jan 28, 2016
QA_Set__4.pdf	PDF	Jan 28, 2016
QA_Set__3.pdf	PDF	Jan 28, 2016
Add.__6_-_Cal_Fire_Helicopters_IFB.pdf	PDF	Jan 28, 2016
Attach_12_-_Performance_Bond_Document.pdf	PDF	Jan 28, 2016
QA_Set__2.pdf	PDF	Jan 28, 2016

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.

Key Tab

PRICING WORKSHEET TEMPLATE

Minimum Data Elements

Revised 2/29/16

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

Contract Line Item Number (CLIN)

Quantity

Commodity Description

Check box (X) if NOT bidding Reference Brand (Descriptive Literature Required with bid if box is checked)

Manufacturer Part Number (OEM #)

Manufacturer (OEM)

SKU # / Item #

Item Description

Unit of Measure

Quantity in

Unit of Measure

(If Applicable)

Contract Unit Price

Contract Extension

Totals

Unique line item number.

Estimated quantity of units per year

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

If your company is not bidding the reference brand per the specification, put a check box in this column.

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.

Your company's description of the item.

Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc).

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

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

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

unit of measure.

Contract Price multiplied by the Quantity.

Totals for each group and compbined total per year.

Variable Character

Number

Variable Character

Text

Variable Character

Number

Currency

625

HP Compaq 8710p Notebook PC

PT-674344457

4576543245-JH/4567C

HP Compaq 8710p Notebook PC

Each

$1,650.00

Year 1

Event ID#: 0000000119
Revised 2/29/16	ATTACHMENT 1
Addendum #6	Pricing Worksheet
COST WORKSHEET - YEAR 1

Bidder:

Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only.

	Line Item #	Quantity	Commodity Description	Check box (X) if NOT bidding Reference Brand (Descriptive Literature Required with bid if box is checked)	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in
Unit of Measure	Contract Price	Extension	Totals
	CATEGORY PRICES
	NOTE: all numbers listed before the Commodity Description are referencing the specification. For evaluation purpose only, three completed aircraft will be used per year with the minimum number of items required.
	Aircraft
	100	3	Helicopter						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Equipment Requirements
	200	3	Hoist per specification 4.2						Each	1	$ - 0
	205	3	Tank Provision per specification 4.3						Each	1	$ - 0
	210	3	External Load Provision per specification 4.4						Each	1	$ - 0
	215	6	Radio - FM VHF Hi-band 151-159 MHz FM tactical radios per specification 4.5.3						Each	1	$ - 0
	220	3	Radio - anxiliary tactical radio per specification 4.5.4						Each	1	$ - 0
	225	3	Satellite Phone - Flightcell DZMx DZUS per specification 4.6.1						Each	1	$ - 0
	230	3	Satellite Phone - Flightcell 9505 per specification 4.6.2						Each	1	$ - 0
	235	9	Communications Equipment - Becker DVCS ACU6100-2-5300 per specification 4.7.1						Each	1	$ - 0
	240	3	Communications Equipment - Becker REU6100 per specification 4.7.3						Each	1	$ - 0
	245	3	Communications Equipment - Power Sonic PSAIR 22A per specification 4.7.5						Each	1	$ - 0
	250	3	Communications Equipment - U-174/U conpatible jack per specification 4.7.7						Each	1	$ - 0
	255	27	Communications Equipment - Comm Innovations CIX200 per specification 4.7.18						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Mandatory Options (these items are mandatory to bid but Cal Fire has the option to buy)
	300	27	Passenger Seats (Troup) per specification 5.1						Each	1	$ - 0
	305	27	Passenger Seats Installation						Each	1	$ - 0
	310	3	Air Conditioner per specification 5.3						Each	1	$ - 0
	315	3	Air Conditioner Installation						Each	1	$ - 0
	320	3	Water Tank per specification 5.4						Each	1	$ - 0
	325	3	Water Tank Installation						Each	1	$ - 0
	330	3	Closed Circuit Fuel Option per specification 5.2						Each	1	$ - 0
	335	3	Closed Circuit Fuel Option Installation						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Services
	400	3	Installation (includes all Equipment Requirements, Line items 200-255)						Each	1	$ - 0
	405	3	Pre-Work Conference (Cal Fire Designated Staff) (Travel)						Each	1	$ - 0
	410	7	Mid-Point Inspection (Travel)						Each	1	$ - 0
	415	9	Initial/Final Inspection at completion/finishing center(Travel)						Each	1	$ - 0
	420	3	Initial Training at completion/finishing center						Each	1	$ - 0
	425	6	Pilot Training						Each	1	$ - 0
	430	6	Travel for Pilot Training (if not in California)						Each	1	$ - 0
	435	6	Maintenance Training						Each	1	$ - 0
	440	6	Travel Costs for Maintenance Training if not in California						Each	1	$ - 0
	445	6	Technical Equipment Training						Each	1	$ - 0
	450	6	Travel for Technical Equipment costs for Training not in California						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Bond
	500	3	Bond (If required)						Each	1	$ - 0
	SUBTOTAL											$ - 0

GRAND TOTAL, 3 COMPLETE HELICOPTERS, YEAR 1						$ - 0
Non-Mandatory Options (these items are not mandatory to bid but prices are requested. These items are NOT part of the evaluation)
600	27	Passenger Seats (Comfort) per specification 6.1	Each	1	$ - 0
605	27	Passenger Seats Installation	Each	1	$ - 0
610	3	Search Light Provisions per specification 6.2	Each	1	$ - 0
615	3	Search Light Provisions Installation	Each	1	$ - 0
620	3	Search Light per specificatoin 6.3	Each	1	$ - 0
625	3	Search Light Installation	Each	1	$ - 0
630	3	Radio (800 MHz) per specification 6.4	Each	1	$ - 0
635	3	Radio (800 MHz) Installation	Each	1	$ - 0

Page &P

Year 2

Event ID#: 0000000119
Revised 2/29/16	ATTACHMENT 1
Addendum #6	Pricing Worksheet
COST WORKSHEET - YEAR 2

Bidder:

Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only.

	Line Item #	Quantity	Commodity Description	Check box (X) if NOT bidding Reference Brand (Descriptive Literature Required with bid if box is checked)	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in
Unit of Measure	Contract Price	Extension	Totals
	CATEGORY PRICES
	NOTE: all numbers listed before the Commodity Description are referencing the specification. For evaluation purpose only, three completed aircraft will be used per year with the minimum number of items required.
	Aircraft
	100	3	Helicopter						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Equipment Requirements
	200	3	Hoist per specification 4.2						Each	1	$ - 0
	205	3	Tank Provision per specification 4.3						Each	1	$ - 0
	210	3	External Load Provision per specification 4.4						Each	1	$ - 0
	215	6	Radio - FM VHF Hi-band 151-159 MHz FM tactical radios per specification 4.5.3						Each	1	$ - 0
	220	3	Radio - anxiliary tactical radio per specification 4.5.4						Each	1	$ - 0
	225	3	Satellite Phone - Flightcell DZMx DZUS per specification 4.6.1						Each	1	$ - 0
	230	3	Satellite Phone - Flightcell 9505 per specification 4.6.2						Each	1	$ - 0
	235	9	Communications Equipment - Becker DVCS ACU6100-2-5300 per specification 4.7.1						Each	1	$ - 0
	240	3	Communications Equipment - Becker REU6100 per specification 4.7.3						Each	1	$ - 0
	245	3	Communications Equipment - Power Sonic PSAIR 22A per specification 4.7.5						Each	1	$ - 0
	250	3	Communications Equipment - U-174/U conpatible jack per specification 4.7.7						Each	1	$ - 0
	255	27	Communications Equipment - Comm Innovations CIX200 per specification 4.7.18						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Mandatory Options (these items are mandatory to bid but Cal Fire has the option to buy)
	300	27	Passenger Seats (Troup) per specification 5.1						Each	1	$ - 0
	305	27	Passenger Seats Installation						Each	1	$ - 0
	310	3	Air Conditioner per specification 5.3						Each	1	$ - 0
	315	3	Air Conditioner Installation						Each	1	$ - 0
	320	3	Water Tank per specification 5.4						Each	1	$ - 0
	325	3	Water Tank Installation						Each	1	$ - 0
	330	3	Closed Circuit Fuel Option per specification 5.2						Each	1	$ - 0
	335	3	Closed Circuit Fuel Option Installation						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Services
	400	3	Installation (includes all Equipment Requirements, Line items 200-255)						Each	1	$ - 0
	405	3	Pre-Work Conference (Cal Fire Designated Staff) (Travel)						Each	1	$ - 0
	410	7	Mid-Point Inspection (Travel)						Each	1	$ - 0
	415	9	Initial/Final Inspection at completion/finishing center(Travel)						Each	1	$ - 0
	420	3	Initial Training at completion/finishing center						Each	1	$ - 0
	425	6	Pilot Training						Each	1	$ - 0
	430	6	Travel for Pilot Training (if not in California)						Each	1	$ - 0
	435	6	Maintenance Training						Each	1	$ - 0
	440	6	Travel Costs for Maintenance Training if not in California						Each	1	$ - 0
	445	6	Technical Equipment Training						Each	1	$ - 0
	450	6	Travel for Technical Equipment costs for Training not in California						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Bond
	500	3	Bond (If required)						Each	1	$ - 0
	SUBTOTAL											$ - 0

GRAND TOTAL, 3 COMPLETE HELICOPTERS, YEAR 2						$ - 0
Non-Mandatory Options (these items are not mandatory to bid but prices are requested. These items are NOT part of the evaluation)
600	27	Passenger Seats (Comfort) per specification 6.1	Each	1	$ - 0
605	27	Passenger Seats Installation	Each	1	$ - 0
610	3	Search Light Provisions per specification 6.2	Each	1	$ - 0
615	3	Search Light Provisions Installation	Each	1	$ - 0
620	3	Search Light per specificatoin 6.3	Each	1	$ - 0
625	3	Search Light Installation	Each	1	$ - 0
630	3	Radio (800 MHz) per specification 6.4	Each	1	$ - 0
635	3	Radio (800 MHz) Installation	Each	1	$ - 0

Year 3

Event ID#: 0000000119
Revised 2/29/16	ATTACHMENT 1
Addendum #6	Pricing Worksheet
COST WORKSHEET - YEAR 3

Bidder:

Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only.

	Line Item #	Quantity	Commodity Description	Check box (X) if NOT bidding Reference Brand (Descriptive Literature Required with bid if box is checked)	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in
Unit of Measure	Contract Price	Extension	Totals
	CATEGORY PRICES
	NOTE: all numbers listed before the Commodity Description are referencing the specification. For evaluation purpose only, three completed aircraft will be used per year with the minimum number of items required.
	Aircraft
	100	3	Helicopter						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Equipment Requirements
	200	3	Hoist per specification 4.2						Each	1	$ - 0
	205	3	Tank Provision per specification 4.3						Each	1	$ - 0
	210	3	External Load Provision per specification 4.4						Each	1	$ - 0
	215	6	Radio - FM VHF Hi-band 151-159 MHz FM tactical radios per specification 4.5.3						Each	1	$ - 0
	220	3	Radio - anxiliary tactical radio per specification 4.5.4						Each	1	$ - 0
	225	3	Satellite Phone - Flightcell DZMx DZUS per specification 4.6.1						Each	1	$ - 0
	230	3	Satellite Phone - Flightcell 9505 per specification 4.6.2						Each	1	$ - 0
	235	9	Communications Equipment - Becker DVCS ACU6100-2-5300 per specification 4.7.1						Each	1	$ - 0
	240	3	Communications Equipment - Becker REU6100 per specification 4.7.3						Each	1	$ - 0
	245	3	Communications Equipment - Power Sonic PSAIR 22A per specification 4.7.5						Each	1	$ - 0
	250	3	Communications Equipment - U-174/U conpatible jack per specification 4.7.7						Each	1	$ - 0
	255	27	Communications Equipment - Comm Innovations CIX200 per specification 4.7.18						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Mandatory Options (these items are mandatory to bid but Cal Fire has the option to buy)
	300	27	Passenger Seats (Troup) per specification 5.1						Each	1	$ - 0
	305	27	Passenger Seats Installation						Each	1	$ - 0
	310	3	Air Conditioner per specification 5.3						Each	1	$ - 0
	315	3	Air Conditioner Installation						Each	1	$ - 0
	320	3	Water Tank per specification 5.4						Each	1	$ - 0
	325	3	Water Tank Installation						Each	1	$ - 0
	330	3	Closed Circuit Fuel Option per specification 5.2						Each	1	$ - 0
	335	3	Closed Circuit Fuel Option Installation						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Services
	400	3	Installation (includes all Equipment Requirements, Line items 200-255)						Each	1	$ - 0
	405	3	Pre-Work Conference (Cal Fire Designated Staff) (Travel)						Each	1	$ - 0
	410	7	Mid-Point Inspection (Travel)						Each	1	$ - 0
	415	9	Initial/Final Inspection at completion/finishing center(Travel)						Each	1	$ - 0
	420	3	Initial Training at completion/finishing center						Each	1	$ - 0
	425	6	Pilot Training						Each	1	$ - 0
	430	6	Travel for Pilot Training (if not in California)						Each	1	$ - 0
	435	6	Maintenance Training						Each	1	$ - 0
	440	6	Travel Costs for Maintenance Training if not in California						Each	1	$ - 0
	445	6	Technical Equipment Training						Each	1	$ - 0
	450	6	Travel for Technical Equipment costs for Training not in California						Each	1	$ - 0
	SUBTOTAL											$ - 0
	Bond
	500	3	Bond (If required)						Each	1	$ - 0
	SUBTOTAL											$ - 0

GRAND TOTAL, 3 COMPLETE HELICOPTERS, YEAR 3						$ - 0
Non-Mandatory Options (these items are not mandatory to bid but prices are requested. These items are NOT part of the evaluation)
600	27	Passenger Seats (Comfort) per specification 6.1	Each	1	$ - 0
605	27	Passenger Seats Installation	Each	1	$ - 0
610	3	Search Light Provisions per specification 6.2	Each	1	$ - 0
615	3	Search Light Provisions Installation	Each	1	$ - 0
620	3	Search Light per specificatoin 6.3	Each	1	$ - 0
625	3	Search Light Installation	Each	1	$ - 0
630	3	Radio (800 MHz) per specification 6.4	Each	1	$ - 0
635	3	Radio (800 MHz) Installation	Each	1	$ - 0

Totals

PRICING WORKSHEET TOTALS

Revised 2/29/16

Addendum #6

Bidder:

Grand Totals

Year 1	$ - 0
Year 2	$ - 0
Year 3	$ - 0
Grand Total	$ - 0

Event ID#: 0000000119

ATTACHMENT 1

File details come from the government source that posted it. Updated Dec 7, 2024.