47PG0121R0005 Section B.2 - Cost Breakout.xlsx

Instructions

Detailed Labor and Fringe

Other Direct Costs

Aggregate

Labor & Fringe Totals

Microsoft_Word_Document1.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 Janitorial and Related Services 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 Janitorial 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 Custodial/Grounds, 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. Other Direct Costs Tab

a. Enter any additional information in the appropriate cells for supplies, major equipment, minor equipment, vehicle operation, rental, subcontracting, and other at is not listed. Enter the associated dollar values ($) for those categories for the base and all option periods. The total other direct 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. 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 36.

d. 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