Pricing Workbook.xlsx

Instructions

Tab 1 - Labor & Equipment

The directions are included on the tab. The information put into this tab is extremely important, as it is the basis of all other calculations throughout the workbook. If you encounter a situation where you have more than 15 pieces of equipment, please reach back to the contract administration team to assist with your specific requirement.

Tabs 2 through 6 - Basic and Option Periods 1 through 4

In cells C2 and E2, fill out the start and end dates of the period of performance that applies to the basic period (or option, as applicable). This calculates the quantity of months and thus the quantity of CLIN XX02 (as well as calculating how equipment is paid for). Invalid dates produce red text.

In cell A11, there is a green block that is checked off by the contractor to provide the certification as required by FAR 52.222-43. Make sure this box is checked off by the contractor when you receive their proposal.

The cells identifying each labor category and piece of equipment within each price element are auto-filled according to how Tab 1 was filled out. However, the information regarding the SCA wage rate, quantity of hours, and markup rate need to be filled in for each item.

In the case of CLINs XX03, XX04, XX05, and XX06, since the quantity of issue is "Hours", the price each is calculated in a more complicated way than the other CLINs. The workbook calculates the weighted hourly labor rate for each labor category and adds them together, producing a single hourly rate for the CLIN. Ordering Contracting Officers and contractors must be aware that contract pricing (and thus payment) is established on an hourly basis.

For evaluation of the price of the Option to Extend Services, the quantity of months for CLIN XX002 will always be 6 (to allow for evaluation of a monthly rate), and CLINS XX03, XX04, XX05, and XX06 will have a quantity based on a proportionate number of hours equal to six months of service. For example, if a contractor proposes 500 hours for 12 months of service for CLIN XX03, the workbook will calculate 250 hours for that CLIN (keeping the same hourly rate). Also notable is that if a performance period is less than 6 months, the workbook will still calculate a proportionate amount of hours for six months of service.

Labor & Equipment In the table below, list all labor categories that you will be proposing along with their current Service Contract Act or Collective Bargaining Agreement wage rate. Then, in each corresponding CLIN, mark an "X" to indicate that the labor category will be used for that CLIN. You will provide the proposed quantity of hours and markup rates for each labor category later in the workbook.

Method A - The cost of the item will be paid according to equal payments within the Basic Period. This method would be most appropriate for CFE that is purchased outright by the contractor for performance on the Task Order.

Method B - The cost of the item will be paid across the full life of the Task Order. This method would be most appropriate for CFE that is leased by the contractor for performance on the Task Order. It should be noted that the Government will not be liable for any unpaid future payments on equipment should an option period not be exercised.

Basic Period

Mark this box to warrant that the proposed prices, including markup rate, do not include any allowance for any contingency to cover increased costs for which adjustment is provided under FAR 52.222-43.

CLIN X002 Total $ - 0

Option Period 1

Mark this box to warrant that the proposed prices, including markup rate, do not include any allowance for any contingency to cover increased costs for which adjustment is provided under FAR 52.222-43.

CLIN X102 Total $ - 0

Option Period 2

Mark this box to warrant that the proposed prices, including markup rate, do not include any allowance for any contingency to cover increased costs for which adjustment is provided under FAR 52.222-43.

CLIN X202 Total $ - 0

Option Period 3

Mark this box to warrant that the proposed prices, including markup rate, do not include any allowance for any contingency to cover increased costs for which adjustment is provided under FAR 52.222-43.

CLIN X302 Total $ - 0

Option Period 4

Mark this box to warrant that the proposed prices, including markup rate, do not include any allowance for any contingency to cover increased costs for which adjustment is provided under FAR 52.222-43.

CLIN X402 Total $ - 0

Total Evaluated Price

Offeror's Total Evaluated Price $ - 0