Amend 02 - B.2 Cost Breakout - REVISED.xlsx

Instructions

Detailed Labor and Fringe

Supplies

Aggregate

Labor & Fringe Totals

Microsoft_Word_Document.docx Price Sheets (Return the completed excel price sheets below with your Price Proposal)

Offerors are required to classify the cost of their proposal annually for Operations, Maintenance, and Repairs as indicated in the supplemental pricing sheets and defined in this contract’s specifications. This is not to be considered as an alternative bid! The costs included on the price sheets are required for Government evaluation purposes only. The aggregate total of such costs must be the same as the respective dollar amounts in CLIN 0001 and the corresponding CLINs for the Option Period(s).

Some cells are purposefully locked and are not to be edited. With the exception of locked cells, the Price Sheet must be completed for all proposed costs and as thoroughly as possible.

SEE PRICE SHEETS ATTACHMENT TO SOLICITATION

INSTRUCTIONS FOR COMPLETION OF PRICE SHEETS

1. Instructions Tab (READ FIRST)

a. All tabs that are highlighted yellow can be edited for the offeror to add data (dollars, percentages or text)

b. Cells highlighted grey or white are locked and aren’t editable.

c. For ease of completion, it is recommended that you progress through the tabs in order from left to right.

d. Some data entered such as solicitation number, project title and vendor name will carry forward to the supplemental tabs.

2. Detailed Labor and Fringe Tab

a. The O&M In House (Onsite) Labor & Fringe and Administrative Labor & Fringe cells allow for offerors to add additional labor categories, as needed in the base year. If completed, those categories will auto populate in each of the option periods.

a. For positions identified as “Other”, enter the title of the position and the applicable Department of Labor Wage Determination Labor Classification Number (see current positions for examples).

b. Enter information in the appropriate cells for FICA Rate, FUTA Rate, SUTA Rate, Worker’s Compensation Rate for O&M, and Worker’s Compensation Rate for Admin. All amounts entered must be listed as percentages (%). Once these cells are filled in, they will apply for all Option years automatically.

c. Enter information in the appropriate cells for FUTA Wage Threshold and SUTA Wage Threshold. This information must be listed as dollars ($). Once these cells are filled in, they will apply for all Option years automatically.

d. For each position enter the number of employees (#), total hours (#), wage rate ($), health and welfare rate ($), and benefits ($).

a. Total Hours should represent all productive (working) hours, all vacation hours, all sick hours, and all holiday hours. Hours per employee should not exceed 2080 hours.

b. Any benefits amount should be entered as the total for all employees. If an amount is entered into this field a brief description of the benefits must be entered in the appropriate column..

3. Supplies Tab

a. Enter information in the appropriate cells for supplies and the associated dollar values ($) for those supplies for the base and all option periods. The total supply costs calculated in the last row will carry forward to the aggregate spreadsheet tab.

4. Aggregate Tab

a. The aggregate tab is based on annual values.

b. In these worksheets enter information into the appropriate cells that are highlighted yellow. Items that are highlighted grey can’t be edited, and they are pre-populated based on the information entered in previous tabs.

c. O&M Subcontracts Category - You will need to enter the name of any subcontracts not listed. If a prelisted subcontract is not applicable, enter zero or leave the corresponding dollar cell(s) empty.

a. If additional fields are required to enter all necessary subcontractors, please contact the Contract Specialist for an updated document.

d. BAS and CMMS Category - If any of the prelisted categories are not applicable enter zero or leave the corresponding dollar cell(s) empty.

e. Utility Hours and Repairs Under Categories – Enter the number of hours and dollar value for the repair threshold based on the requirements listed in the solicitation. Then, enter the associated proposed dollar value in the corresponding cells for each option period.

f. Overhead, G&A, and Profit – Enter the percentages (%) associated with these categories. The total amounts for each option period will auto-populate based on the subtotal in row 45.

g. The annual and monthly price will be auto-calculated based on the information entered above. Ensure that those totals are equivalent to the prices submitted on the CLIN pricing sheet(s) for the standard base services.

5. The Labor & Fringe Tab are for Government Use Only. Those tabs auto-populate based on information the offerors enter on the detailed labor and fringe tab.

image1.emf