ATTA_2_-_Cost_Worksheet_IFB_0000032355.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
CATIS Aviation Tracking (DGS-OTA)
Solicitation number
0000032355
Issued by
Sacramento County, San Francisco City, California

About this file

This document is a Cost Worksheet for a state and local contract opportunity issued by the California Department of General Services (DGS) for CATIS Aviation Tracking (IFB #0000032355). The worksheet outlines the pricing structure for the contract, which includes Phase I - Development, Phase II - Enhancements, and Years 1-3 of Maintenance and Operations. The contractor will be responsible for providing services such as automatically filling tracked data points from sensors/hardware installed on aircraft, plotting georeferenced data on a map, tracking air base data, communicating with other CAL FIRE software, and creating customizable "Situational Dashboards". The contract has optional renewal years 4 and 5 for Maintenance and Operations.

The pricing worksheet requires the bidder to complete the yellow input cells with their proposed staff, classifications, quantity/hours, unit cost/hourly rate, and extended totals for each line item. The total contract price for Years 1-3 is to be provided, as well as the optional Years 4-5 totals. The contract opportunity is open to all qualified bidders, and there are no set-asides or incumbent information provided in the document. Funding sources and requirements are not explicitly stated.

View the file

Other files

Show all 12

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

Cost Worksheet Key

PRICING WORKSHEET KEY
Column NameContract Line Item Number (CLIN)
Unit of MeasureManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Proposed Product DescriptionContract Unit Price
DescriptionUnique line item number.Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc).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).This is the contractual price for a given line item based on the price that was bid, as relative to the

unit of measure.

END OF SHEET.
END OF SHEET.

Cost Worksheet

Department of General Services - Procurement Division
BU 3540, Event ID 0000032355, CATIS Aviation Tracking
Attachment 2 - Cost Worksheet
Bidder:Blank
Instructions: Refer to Event's Cost language section, for completion instructions. Bidder must complete the Yellow Input Cells only.
Line Item # (LIN)Phase I - DevelopmentProposed Staff NameClassificationQuantity / Hours

tc={6CBFE333-2BE0-4376-A50D-CE82640AEB80}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Cost worksheet is good. Has hours column. Per Mark.Unit Cost / Hourly RateExtended Total
1-1Development$ - 0
1-2Testing$ - 0
1-3Training$ - 0
1-4Impementation$ - 0
Phase I Subtotal:$ - 0
Line Item # (LIN)Phase II - EnhancementsProposed Staff NameClassificationQuantity / HoursUnit Cost / Hourly RateExtended Total
1-5A. Automatically fill any tracked data points with information sent via TracPlus from sensors/hardware installed on aircraft, should CAL FIRE install necessary hardware on aircraft.$ - 0
1-6B. The ability to plot all georeferenced data gathered from TracPlus on a map for visual reference. (Map data used in Situational Dashboards)$ - 0
1-7C. The ability to track air base data and display on a Situational Dashboard.$ - 0
1-8D. Communicate with other CAL FIRE software.$ - 0
1-9E. Fill CAL FIRE 62 & 63 Forms with information from database when user requests.$ - 0
1-10F. Fill Aviation Cost Worksheet (Air Ops Worksheet) with information from database when user requests.$ - 0
1-11G. Create graphs and other visual representations of data from user requested reports.$ - 0
1-13H. Produce customizable “Situational Dashboards”.$ - 0
Phase II Subtotal:$ - 0
Line Item # (LIN)TaskProposed Staff NameClassificationQuantity / HoursUnit Cost / Hourly RateExtension Cost
2Year 2 Maintenance and Operations$ - 0
Year 2 M&O Subtotal:$ - 0
Line Item # (LIN)TaskProposed Staff NameClassificationQuantity / HoursUnit Cost / Hourly RateExtension Cost
3Year 3 Maintenance and Operations$ - 0
Year 3 M&O Subtotal:$ - 0
Years 1-3 Grand Total$ - 0
Line Item # (LIN)TaskProposed Staff NameClassificationQuantity / HoursUnit Cost / Hourly RateExtension Cost
4(Optional) Year 4 Maintenance and Operations$ - 0
(Optional) Year 4 Total:$ - 0
Line Item # (LIN)TaskProposed Staff NameClassificationQuantity / HoursUnit Cost / Hourly RateExtension Cost
5(Optional) Year 5 Maintenance and Operations$ - 0
(Optional) Year 5 Total:$ - 0

(Optional) Years 4-5 Subtotal: $ - 0

Grand Total without optional years $ - 0

Grand Total with optional years$ - 0
Note: Extension is automatically calculated ("Quantity / Hours" x "Unit Cost / Hourly Rate")
End of Sheet

Page &P

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