23R2001_SOL_Attachment X9 Tutorial.pdf

DoDEA Transportation Division Attachment X9 “Tutorial”

How to fill out Attachment X2 “Personnel”

The tabs on the bottom of Attachment X2 are identified as Personnel List Example; Personnel List; and Personnel Action Plan.

Tab “Personnel List Example”

The Offeror does not need to make changes to this tab. It is to serve as an example of how to fill out the Personnel List tab.

Attachment X10 “Tutorial”

Tab “Personnel List”

Column B:

For each personnel list their last name.

Column C:

For each personnel list their first name.

Column D:

For each personnel list their position.

NOTE: You must select from the drop down Menu.

Column F:

For each personnel list if they meet the age requirement.

Column K:

For each personnel required please list their drivers license class.

Columns G through J:

For each personnel list if the meet the following credintals by selecting X, if they do not keep cell blank.

Column AC:

List ALL Subcontractors in yellow cells only.

Column U:

Select “X” if the employee is under the prime, if not leave cell blank.

Column W:

Select “X” if the employee is under a subcontractor, if not leave cell blank.

Column Y:

If the employee is under a subcontractor, then type in from the list in Column AB based on which Subcontractor you are usng.

Example from above:

“ABC Drivers” type “Sub 1” “123 Contractor” type “Sub 2”

If not a subcontractor leave cell blank.

Tab “Personnel Action Plan”

Fill in the # of personnel you plan to get for each area here.

Fill in as applicable your plan to obtain personnel. Use up to but no more than 500 words per section.

Example:

Your proposing using one subcontractor.

Fill in Cells C9; C21; C69; and C81. (up to 500 words for each cell)

Also, complete as applicable for your plan to retain personnel (below these cells rows 69 through 128).

How to fill out Attachment X3 “Vehicles”

The tabs on the bottom of Attachment X3 are identified as Vehicle List Example; Vehicle List; Vehicle Specification Form Ex (Example);Vehicle Specification Form; and Vehicle Action Plan.

Tab “Vehicle List Example”

The Offeror does not need to make changes to this tab. It is to serve as an example of how to fill out the Vehicle List tab.

Tab “Vehicle List”

Column B:

For each vehicle list the Make of the vehicle.

Column C:

For each vehicle list the Model of the vehicle.

Column D:

For each vehicle list the Year of the vehicle.

Column E:

For each vehicle list the Passenger Capcity of the vehicle (not to include the driver).

Column F:

For each vehicle list yes or no.

Colums H through Q:

List any vehicle specifications in the orange columns.

Anything noted in an orange cell with an “*” is a required specification.

For each vehicle list “Yes” or “No” for each specification that the Offeror listed in the Orange Cells.

Example: If the offeror listed GPS in the orange cell in Column L and vehicle 1 does have a GPS they select “Yes.” Vehicle 2 does not have GPS they select “No.”

Column R:

Type “Yes” where each vehicle will be used.

Type “No” if it will not be used for these routes.

Example: if a vehicle is being used for Daily Commute type “Yes”.

Column AC:

List ALL Subcontractors in yellow cells only.

Note: this should match the list in your personnel attachment X2.

Column U:

Select “X” if the employee is under the prime, if not leave cell blank.

Column W:

Select “X” if the employee is under a subcontractor, if not leave cell blank.

Column Y:

If the employee is under a subcontractor, then type in from the list in Column AB based on which Subcontractor you are usng.

If not a subcontractor leave cell blank.

Column AE:

List ALL passenger capacity in yellow cells only.

Example: if all the vehicles you are proposing are 45 passenger vehicles then you will like 45.

The passenger capacity already listed in the cells can be replaced with what you have. This was put there as an example.

Passenger capacities should only be listed as a number no letters should be put into these cells.

Tab “Vehicle Specification Form Ex (Example)”

The Offeror does not need to make changes to this tab.

It is to serve as an example of how to fill out the Vehicle Specification Form tab

Tab “Vehicle Specification Form”

Columns A & B:

These cells are auto popuated based on what you filled out in your Vehicle List

Column C:

List the name of the product.

Column D:

Write a discription of the product.

Column E:

Disctibe when it will be used. Column F:

Identify if the Government will have access.

Tab “Vehicle Action Plan”

Fill in the # of vehicles you plan to get for each area here.

If not in need of vehicles type “0” in cell.

Fill in as applicable your plan to obtain vehicles. Use up to but no more than 500 words per section.

Example:

Your proposing using one subcontractor.

Fill in Cells C18; C31; C83; and C86. (up to 500 words for each cell)

Also, complete as applicable for your plan to retain vehicles (below these cells rows 83 through 147).

How to fill out Attachment X4 “Risk”

The tabs on the bottom of Attachment X4 are identified as Action Plan Example;

Action Plan Drivers; Action Plan Vehicles; Action Plan Fuel; Action Plan Unions; and Action Plan Pandemic.

Tab “Action Plan Example”

The Offeror does not need to make changes to this tab. It is to serve as an example of how to fill out the Action Plan Example tab

Tabs “Action Plan Drivers; Action Plan Vehicles; Action Plan Fuel; Action Plan Unions; and Action Plan Pandemic”

Address the Impact of the Problem identified in the orange cell.

Use up to but no more than 500 words.

Insure the Problem in the orange cell matches the tab name you are in.

Address the Action Plan to address the Problem identified in the orange cell.

Use up to but no more than 500 words.

Address the Risks Associated with your Proposed Action Plan for the Problem identified in the orange cell.

Use up to but no more than 500 words.

Address the Timeline for Execution of your Action Plan for the Problem identified in the orange cell.

Use up to but no more than 500 words.

How to fill out Attachment X5 “Price”

The tabs on the bottom of Attachment X5 are identified as Summary and Daily Commute.

Tab “Summary”

The Offeror does not need to make changes to this tab it is self tabulated.

Tab “Daily Commute”

The Offeror will fill in each cell highlighted in yellow. No other cells shall be updated.

Note: When filling in the prices in the yellow cells do not use an equation. Instead type in the price to the second decimal place for accurate pricing.

Example: In Cell F17 instead of using the equation “=F9*1.03” type in the value of that equation and round to the second decimal point.