FCT Section L Attachment L-2 Bid Model Instructions 2024.pdf

SOURCE SELECTION SENSITIVE 693KA7-23-R-00003

ATTACHMENT L-2

BID MODEL INSTRUCTIONS

Getting Started:

1. Open Excel file, Area XX Adjusted Bid Model.xlm: (Note: XX – represents the two digit area code, 01 to 10.)

Enable Editing prompt appears at top of spreadsheet if this is the first time the file is opened:

2. Select “Enable Editing” to enable editing mode:

SECURITY RISK warning prompt appears at top of spreadsheet:

3. Click the X at the right end of the SECURITY RISK message to close it.

Instructions & Rates Tab:

1. Data can only be entered in cells with yellow shading. The following error appears when attempting to enter data in protected cells:

2. Input the Overhead, General and Administrative (G&A), and Profit/Fee Rates by year. This value will apply to all CLINs equally as a percentage.

3. This tab also provides instructions for completing the Bid Model workbook.

Summary Tab:

1. This tab lists the Contract Line Item Numbers (CLINs) for all the towers within the area that is being priced in Column A.

Note: Data cannot be entered on this tab. The data is automatically populated within the cells once data is entered in the CLIN tabs (i.e., tabs CLIN01 through CLINXX. The number of CLIN tabs vary with each area.)

2. Columns G through T show the total amounts for costs and hours for each year. Columns E and F show the totals for all seven contract years combined for costs and hours. The hours are the total hours entered for Direct and Fringe costs on the CLIN tabs. The dollar amount in Column E reflects the Cost Share percentage shown in Column D. For most locations, the amount shown will reflect 100% of the total calculated; however, for Cost Share locations less than 100%, the total will reflect an amount reduced to the percentage shown in Column D.

3. Find the CLIN for the location (LOC) that will be bid in Column A.

4. Using the CLIN, select the appropriate Excel CLIN tab to enter the information needed to calculate pricing for the desired CLIN.

5. Follow the instructions below under “CLIN Tabs:” to enter the required pricing data. The number of CLIN tabs vary with each area.

CLIN Tabs:

1. Data can only be entered in cells with yellow shading.

Note: Data entered for Year 1 is automatically populated in the tables for Years 2 -7, except for

Other Direct Costs (ODCs) data which can be added manually for each year.

2. Confirm that the CLIN represented in Column C, Rows 1-3, is the appropriate spot for the pricing being entered.

CLIN information appears as shown below:

These fields, which cannot be edited, provide information for the tower including: the CLIN for the tower location, the Location ID, the tower Name and geographic location, and the percent of Cost Share for the area.

3. Row 8 # of Persons (not FTE): Enter the total number of employees for each of the following labor categories:

ATCM – Air Traffic Control Manager – this is the individual responsible for managing the team of

Air Traffic Controllers (ATCs) and cannot be used on the work schedule as a regular controller.

There is only one (1) ATCM per location.

ATCFT – Air Traffic Controller Full-time Employees – this is a full-time staff member; there is no job share involved with these individuals.

ATCJS – Air Traffic Controller Job Share Arrangement – these are part-time employees whose combined hours make full-time equivalency.

Enter the number of individuals for each labor category. Do not enter the number of full-time equivalents under these categories because the information in these cells is used to calculate the Federal Insurance Contributions Act (FICA) and Annual Federal Unemployment (FUTA) taxes.

Note: The following error: MISSING EMPLOYEE HEADCOUNT will appear if the columns in row 8 do not contain a number > 0 and if data in subsequent rows and columns for quantity and rates, contain data.

4. Rows 11 – 15: Direct Labor Columns E, H, and K: Enter the total number of hours for each labor category’s employees Columns F, I, and L: Enter the hourly rate for the labor category

5. Rows 18 – 20: Leave Columns E, H, and K: Enter the total amount of hours for leave for each labor category’s employees

6. Rows 23 – 27: Other Fringe Benefits & Taxes

Note: Health & Welfare (Row 23) is capped at 2,080 hours per year per employee. It’s calculated as a sum of regular hours and fringe hours. This value is automatically calculated based on data entered in previous cells.

Columns E, H, and K: Enter the total amount of hours for each labor category’s employees in the yellow-shaded cells where allowed to enter data

Columns F, I, and L: Enter the rate for the benefit or tax (where the cell is yellow-shaded and not protected.)

7. Rows 29 – 33: Other – Add any other fringe benefits not covered by rows 23 – 27

8. Rows 42 – 51: Other Direct Costs (ODCs) – Add ODCs not covered by the defined cost categories in other rows Note: Data entered for ODCs in Year 1 is automatically populated in the tables for subsequent years. Edit the data for each subsequent year per the instructions below: “ODCs for Years 2 – 7”.

9. ODCs for Years 2 – 7: Other ODCs can be entered for contract years 2 – 7 if these years will have ODCs specific to the requirements for those years. If the rows for entering the Other ODCs for years 2 – 7 are not visible, follow the steps below under “Viewing the Data Groups and Subgroups” to make the rows visible for data entry.

Note: The out-years do not increase rates even if a Collective Bargaining Agreement (CBA) is in place because the CBA is between the incumbent vendor and the location. Vendors awarded contracts under this solicitation may not be under the existing CBA and the CBA may change also.

Even though some out-years may fall under an existing CBA, rates need to remain “flat” .

Adjustments will be made based on existing CBAs and wage determination as appropriate.

Viewing the Data Groups and Subgroups:

Each tab has rows that can be grouped together that minimizes the visible cells to show the data entry fields for each year while hiding the rows for other years. The rows can be expanded to show the details if desired. The amount of viewable detail can be determined by selecting from:

– located in the top left corner of the spreadsheet. These are shortcuts to reveal levels of groupings of details

– located in the left panel of the spreadsheet. Selecting these icons will expand or collapse data within the groups.

1. To display rows for a level, click the appropriate one, two, three, or four group/subgroup symbol in the top left corner. The spreadsheet will show the summary levels and data as follows:

Level 1 contains the total annual price information for each year of the contract (i.e., years 1 – 7) Level 2 contains summary information for the CLIN. It shows the major details for each category

(i.e., Direct Labor, Leave, ODCs, G&A, etc.)

o Note: Years 2 – 7 cannot be edited at this level of detail; however, Year 1 has editable fields for the number of individuals per labor category.

Level 3 contains annual details for each cost category except for ODCs.

Level 4 contains all details for all levels (e.g., data entry rows for ODCs for each year, Other Fringe

Benefits, etc.)

2. The figures below show how each view appears on screen when selecting the subgroup levels.

Level 1: Yearly Totals Summarized:

Level 2: Totals by Cost Category Summary by Year

Level 3: Summary (Other and Other Direct Costs details not shown):

Level 4: All details shown