Attachment C.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
VERTICAL TRANSPORTATION MAINTENANCE
Solicitation number
5400026929
Issued by
Richland County, Columbia City, South Carolina

About this file

This document is an Attachment C.xlsx file related to a Vertical Transportation Maintenance contract opportunity for the South Carolina Department of Administration. The file contains a pricing schedule for preventative maintenance services on elevators, dumbwaiters, and other vertical transportation equipment located in various state and local government facilities. Vendors must provide unit pricing per month for each piece of equipment, as well as hourly labor rates for any additional work not covered under the preventative maintenance program. Vendors must complete the pricing schedule and submit it as part of their overall proposal response. The contract term is for one year, with the potential for renewal options.

The pricing schedule identifies 74 individual vertical transportation units across 28 different locations, including the State House, Governor's Mansion, and various other state and local government buildings. Vendors must provide pricing for all items in the schedule to be considered eligible for award. The total estimated value of the contract is $30,000 for materials not covered under the preventative maintenance program.

View the file

Other files

File Type Posted
Amendment 1.docx DOCX document
Amendment 2.docx DOCX document
Amendment 3.docx DOCX document
Attachment A revised.docx DOCX document
Attachment C.xlsx XLSX spreadsheet
Solicitation Document.docx DOCX document
Attachment C Revision #2.xlsx XLSX spreadsheet
Attachment C revised.xlsx XLSX spreadsheet
Amendment 1.docx DOCX document
Amendment 2.docx DOCX document
Amendment 3.docx DOCX document
Attachment A revised.docx DOCX document
Attachment C revised.xlsx XLSX spreadsheet
Attachment C Revision #2.xlsx XLSX spreadsheet
Solicitation Document.docx DOCX document
Show all 15

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

Bid Schedule price Calc.

Attachment C - Bid Schedule
Vertical Transportation Maintenance for Dept. of Administration
Vendor Name:

This worksheet replaces the Bidding Schedule typically found in Section VIII of the solicitation and is designed to easily calculate each offeror's "Evaluated Amount". A response is required for all cells shaded BLUE. Enter your price markup rounded to the nearest penny ($0.XX) in the "Unit Price" or BLUE cells below for all corresponding line items. The extended prices or RED cells below will automatically calculate based on your input. A bid is required below for cells shaded BLUE in order for your offer to be considered. Be sure to scroll down to the bottom of the page to see all cells. This completed spreadsheet should be saved and attached as an Excel file online with your offer.

To be eligible to receive an award, the Unit Prices for all items highlighted in BLUE below must be bid upon.

BuildingLocationUnit #Design TypeSpeedCapacity# of FloorsOpeningsManufacturerControl ManufacturerPM Unit Price (per month)PM Extended Price (one year)
Adjutant General1 National Guard Rd.1/PassHydraulic120200031OtisOtis$0.00
Adjutant General1 National Guard Rd.2/PassHydraulic120200031OtisOtis$0.00
Blatt1105 Pendleton St.1/PassGeared350300081DoverMCE$0.00
Blatt1105 Pendleton St.2/PassGeared350300081DoverMCE$0.00
Blatt1105 Pendleton St.3/PassGeared350300081DoverMCE$0.00
Blatt1105 Pendleton St.4/PassGeared350300081DoverMCE$0.00
Blatt1105 Pendleton St.5/DWDwaiter2540051EnergyEnergy$0.00
Brown1205 Pendleton St.1/PassGeared350350081OtisOtis$0.00
Brown1205 Pendleton St.2/PassGeared350350081OtisOtis$0.00
Brown1205 Pendleton St.3/PassGeared350350081OtisOtis$0.00
Brown1205 Pendleton St.4/PassGeared350350081OtisOtis$0.00
Columbia Mills301 Gevais St.1/PassHydraulic125250041WestMCE$0.00
Columbia Mills301 Gevais St.2/PassHydraulic125250041WestMCE$0.00
Columbia Mills301 Gevais St.3/FrtHydraulic100500051EscoEsco$0.00
Columbia Mills Parking Garage301 Gervais St.1/PassHydraulic150250021SchindlerSchindler$0.00
Columbia Mills Museum301 Gervais St.1/PassHydraulic125350031WsthouseWsthouse$0.00
Columbia Mills Museum301 Gervais St.2/SvcHydraulic1001000042MCEMCE$0.00
Columbia Mills Museum301 Gervais St.3/FrtHydraulic50/751200032EscoEsco$0.00
Columbia Mills Museum301 Gervais St.4/HLHand. Lift2550022Amer. StairAmer. Stair$0.00
Commission for the Blind1430 Confederate Ave.1/PassHydraulic125/150200021MCEMCE$0.00
Commission for the Blind1430 Confederate Ave.2/PassHydraulic125/150200031MCEMCE$0.00
Dennis1000 Assembly St.1/PassGeared350300071OtisOtis$0.00
Dennis1000 Assembly St.2/PassGeared350300071OtisOtis$0.00
Dennis1000 Assembly St.3/PassGeared350200071OtisOtis$0.00
Dennis1000 Assembly St.4/PassGeared350200071OtisOtis$0.00
Dennis1000 Assembly St.5/SvcsGeared300300071OtisOtis$0.00
DSS/Harden St3150 Harden St Ext.1/PassHydraulic135250031DoverDover$0.00
DSS/Harden St3150 Harden St Ext.2/PassHydraulic135250031DoverDover$0.00
DSS/North Tower1535 Confederate Avenue1/PassGeared250300071OtisOtis$0.00
DSS/North Tower1535 Confederate Avenue2/PassGeared250300061OtisOtis$0.00
DSS/North Tower1535 Confederate Avenue3/PassGeared250300061OtisOtis$0.00
Hayne (DHEC LAB)8231 Parklane Rd.1/PassHydraulic125/150250041DoverDover$0.00
Hayne (DHEC LAB)8231 Parklane Rd.2/FrtGeared2001000041SoutheasternSwift Futura$0.00
Mills/Jarrett2100 Bull St.1/PassHydraulic125250041DoverDover$0.00
Mills/Jarrett2100 Bull St.2/PassHydraulic125250041DoverDover$0.00
Mills/Jarrett2100 Bull St.3/PassHydraulic125210041DoverDover$0.00
Assembly Street Parking Deck1101 Assembly St.1/PassHydraulic75350082EscoEsco$0.00
Gressette Collins202 Arbor Lake Dr.1/PassHydraulic150250031WsthouseWsthouse$0.00
Gressette Collins202 Arbor Lake Dr.2/PassHydraulic150250031WsthouseWsthouse$0.00
HR Senate Street1401 Senate St.1/PassHydraulic95210021DoverDover$0.00
Sims/Aycock2600 Bull St.1/PassGeared200250041OtisOtis$0.00
Sims/Aycock2600 Bull St.2/PassGeared2002500041OtisOtis$0.00
Sims/Aycock2600 Bull St.3/SvcsHydraulic105400031OtisOtis$0.00
Sims/Aycock2600 Bull St.4/PassHydraulic200300041MCEMCE$0.00
Sims/Aycock2600 Bull St.5/PassHydraulic200300041MCEMCE$0.00
State Library1500 Senate St.1/PassHydraulic150150061DoverMCE$0.00
State Library1500 Senate St.2/PassHydraulic150150061DoverMCE$0.00
State Library1500 Senate St.3/PassHydraulic100150021DoverMCE$0.00
Sumter Street1026 Sumter St.1/PassHydraulic125250031DoverDover$0.00
Supreme Court1231 Gervais St.1/PassHydraulic150/200200041MCEMCE$0.00
Supreme Court1231 Gervais St.2/PassHydraulic150/200150041MCEMCE$0.00
Calhoun120 Senate1/PassGeared350200061SoutheasternMCE$0.00
Calhoun120 Senate2/PassGeared350200061SoutheasternMCE$0.00
Calhoun120 Senate3/SvcsGeared200400062SoutheasternMCE$0.00
Gressette1101 Pedleton St.1/PassGeared350300091DoverMCE$0.00
Gressette1101 Pedleton St.2/PassGeared350300091DoverMCE$0.00
Gressette1101 Pedleton St.3/PassGeared350300091DoverMCE$0.00
Data Center4430 Broad River Rd.1/PassHydraulic100350021SchindlerSchindler$0.00
Data Center4430 Broad River Rd.2/PassHydraulic100450021SchindlerSchindler$0.00
Archives & History8301 Parklane Rd.1/PassHydraulic150350031SoutheasternMCE$0.00
Archives & History8301 Parklane Rd.2/PassHydraulic150350031SoutheasternMCE$0.00
Archives & History8301 Parklane Rd.3/SvcsHydraulic100400031SoutheasternMCE$0.00
Wade Hampton1200 Senate St.1/PassGearless500250071OtisMCE$0.00
Wade Hampton1200 Senate St.2/PassGearless500250071OtisMCE$0.00
Wade Hampton1200 Senate St.3/SvcsGearless350250071OtisMCE$0.00
Governor's Mansion800 Richland St.1/PassHydraulic100210031SchindlerSchindler$0.00
State House1100 Gervais1/PassHydraulic150400031SoutheasternMCE$0.00
State House1100 Gervais2/PassHydraulic15040041SoutheasternMCE$0.00
State House1100 Gervais3/PassHydraulic150350021SoutheasternMCE$0.00
State House1100 Gervais4/PassHydraulic15030041OtisMCE$0.00
State House1100 Gervais7H/LScrew1075022Porch-LiftAccess Ind.$0.00
Total PM Extended Price:$0.00
In the space below, Offeror's must enter the hourly bid rate (BLUE cells) for the corresponding type of work NOT included in the Preventative Maintenance Program.
NOTE: OFFERORS MUST PROVIDE THE FOLLOWING LABOR RATES FOR ANY WORK PERFORMED THAT IS NOT INCLUDED IN PREVENTATIVE MAINTENANCE.
DescriptionType of Technician(s)Total Estimated Hours (1 Year)Hourly Rate Unit PriceEstimated Extended Labor Amount
Regular Working HoursOne (1) Mechanic80$0.00
Regular Working HoursOne (1) Mechanic and Helper160$0.00
Overtime Working HoursOne (1) Mechanic60$0.00
Overtime Working HoursOne (1) Mechanic and Helper120$0.00
Weekends and HolidaysOne (1) Mechanic24$0.00
Weekends and HolidaysOne (1) Mechanic and Helper40$0.00
Estimated Extended Labor Amount Total:$0.00

In the space below, Offeror's must enter percentage markup above cost (BLUE cell) for all materials NOT included in the Preventative Maintenance Program (see Section III).

NOTE: OFFERORS MUST PROVIDE THE FOLLOWING PERCENTAGE MARKUP ON MATERIALS FOR ANY WORK PERFORMED THAT IS NOT INCLUDED IN PREVENTATIVE MAINTENANCE.

DescriptionTotal Estimated Amount for Materials (1 Year)Percentage Markup Above Cost on MaterialsEstimated Extended Amount for Materials w/ Markup
All Materials$30,000.00$30,000.00
***Calculation for Total Evaluated Amount***
NOTE: THE BELOW CALCULATIONS AUTOMATICALLY POPULATE BASED ON THE INPUTS ABOVE.
Total PM Extended Price:$0.00
Estimated Extended Labor Amount Total:$0.00
Estimated Extended Amount for Materials w/ Markup:$30,000.00
Total Evaluated Amount:$30,000.00

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