Docstoc

Sub Contractor Commission Based Agreement Policy

Document Sample
Sub Contractor Commission Based Agreement Policy Powered By Docstoc
					                                             ARRA Contract
                                       Budget Workbook Instructions

  I.    General Instructions for Completing the Spreadsheets in this Workbook

              This workbook contains spreadsheets for the Schedule of Deliverables and Due Dates, Gantt Chart,
              budget forms for the prime contractor and subcontractors, and a List of Contacts. Specific instructions
              for each of the spreadsheets in this workbook are below.


              The electronic version of these documents shows cells of different color. Fill in only the non-colored
              cells for each of the spreadsheets. Do NOT enter data in the blue cells. Blue cells contain formulas or
              data transferred from other worksheets. Blue cells and many of the yellow cells (headings) are
              protected to prevent accidental changes. Please do not attempt to change formulas and references in
              the worksheets unless you are familiar with the operation of the worksheets and you are well-versed in
              MS Excel software.




  II.   Instructions for Exhibit A Attachment A-1, Schedule of Deliverables and the Gantt Chart

 Go      A.   Schedule of Deliverables and Due Dates (Tab: Att A-1 Schedule)
              For each Administrative Task, insert the planned start and completion dates. Please note that it will
              take approximately four months from the date that you complete and turn in these forms to Sparkey until
              there is a final, approved agreement. Pick a start date accordingly so you won't have to rebuild the
              schedule.


              For each Technical Task, insert in the appropriate columns, the name of the task as it is titled in the
              Scope of Work (Exhibit A), the name of the deliverables associated with each task as they are titled in
              the Scope of Work, and the planned start and completion dates. (Note: Dates will display in a red bold
              font if they fall on the weekend. Please correct for this.) Delete or insert rows as necessary. Because
              the task names (up to number 20) are linked with the budget forms, once they are typed onto the
              Schedule, they will carry forward to the budgets. If your project contains more than 20 tasks, you will
              have to link the additional cells or type them into the budget forms.

              For the Final Report Administrative Tasks (1.6, 1.6.1, & 1.6.2), you can either enter the overall start /
              finish dates in task 1.6 or enter the detailed start / finish dates in tasks 1.6.1 & 1.6.2.

              The Critical Project Reviews (and associated CPR Reports) are only shown for example purposes.
              Delete the examples and place CPRs in the appropriate project tasks.


              Do not insert any information in the columns labeled "ARRA Funds" and "Leverage Funds." These cells
              are linked to the budget forms and will automatically fill in once the budget forms are complete.


 Go      B. GANTT Chart (Tab: Att A-1 GANTT) - OPTIONAL
            Starting with Budget template release 04-2008, the Gantt Chart is optional in the contract package. If
            you wish to provide the Gantt Chart as a part of the package, use Excel's <Unhide> feature to reveal
            the Gantt Chart worksheet in this workbook.
            For each Task, insert the planned start and end dates as listed on the Schedule of Deliverables and
            Due Dates. The start and end dates for the overall administrative tasks will be automatically entered
            from the schedule of deliverables. Headings and GANTT bar shadings are automatically
            completed as you enter start and end dates.



04-2008                                                 Page 1 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls           Instructions With Links
                                          ARRA Contract
                                    Budget Workbook Instructions
            Note that the print format is to print the entire Gantt Chart. You may only need a small part of it. Use
            the RED FORMAT BAR at the bottom of the chart as a reference to reduce the print area of your chart.
            (Hint: The bar starts catty-corner to the latest date column in the Gantt Chart.)


            If you have an alternate means of creating a Gantt Chart (such as Microsoft Project), then you may use
            it. However, please make it print one landscape sheet and provide it in a separate electronic file. It
            must be compatible with Energy Commission software programs.

 III. Instructions For Exhibit B Attachments (Budget Forms)

 Go   A.    Budget Summary (Tab: Att B-1 Summary)

            Do not enter any data in this spreadsheet. These are the total task budgets, and the amounts will
            automatically fill in once information is entered on the individual task budgets.

            ARRA Budget (Tabs: Att B-2 - Prime ARRA, Att B-2 - Sub#1 ARRA, etc. if more than one
 Go    B.
            subcontractor)

            Prime and Subcontractor Budget Worksheets: The Prime Contractor and Subcontractors must
       Go
            submit information on all the Exhibit B Budget Attachment forms.

            Generally, fill in the ARRA reimbursable amounts for each Task.

            For Subcontractors, indicate whether they are "Key" and / or Disabled Veteran Business Enterprise
            (DVBE) in the checkboxes.

            Mark the "Key Sub." checkbox if this subcontractor is considered a key subcontractor to the contract.
            Note: All DVBE subcontractors are considered Key subcontractors; mark this key checkbox, too, if
            you've marked the DVBE checkbox.




04-2008                                              Page 2 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls        Instructions With Links
                                         ARRA Contract
                                   Budget Workbook Instructions


           • Instruction Specific to Rows in Attachment B-2
           For Task 1.1, Kick-off Meeting, and Task 1.3, Final Meeting, budget for the number of technical and
           administrative personnel who will be attending the meeting with ARRA staff in Sacramento.

           For Task 1.2, CPR Meetings, and Task 1.11, Conduct PAC Meetings, do not enter travel amounts in
           these rows if travel for these administrative tasks is directly associated with a specific technical
           task. Enter travel expense in those technical tasks.

           Tasks 1.5 and 1.9 do not require funding, which is why the budgets for these tasks are listed as zero.

           For Task 1.6, the Final Report, budget for 1 month for your top technical person and/or best technical
           writer.

           Tasks 1.7 and 1.8 are not reimbursable with ARRA funds. Leverage funds must be used for them.




04-2008                                             Page 3 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls       Instructions With Links
                                            ARRA Contract
                                      Budget Workbook Instructions
            • Instruction Specific to Columns in Attachment B-2
            The Prime Contractor and Subcontractors must provide details of the following expenditures on the
            corresponding tables in worksheet tab "Att B-5 - Project Operating Expense:"
            - For all pre-approved travel contained in the amounts listed in the "Travel" column
            - For any amounts over $5,000 listed in the "Equipment" column (refer to Exhibit G
                Definitions and Exhibit D Special Terms & Conditions)
            - For all contract amounts in either of the columns "Materials" and "Miscellaneous"

            For more information on travel and state reimbursement rates, see this link at the Energy Commission
            Contracts Office website:
            http://www.energy.ca.gov/contracts/TRAVEL_PER_DIEM.PDF


            Do not fill in the column " Subcontractors." This information will fill in automatically from the
            Subcontractor worksheets.

            Regarding the column "Profit":
            • Contractor profit cannot exceed 10% of the ARRA funds allocated to the Task.
            • Prime Contractor cannot derive profit on subcontractor invoices.
            • Subcontractors can derive profit on task work they perform, and their profit cannot exceed
            10% of the ARRA funds allocated to them on the Task.
            • Subcontractors cannot derive profit on sub-subcontractor invoices.


            • Calculating Amounts for the "Fringe Benefit", "Indirect Overhead", "G&A", and
               "Profit" Columns:
            1. The Budget Amounts in these columns shall Leverage the rate ceilings (percentages) on Exhibit B,
            Attachment B-4 (Calculation of Fringe Benefits, Indirect Overhead, General Administrative Expenses,
            and Profit).

            For example, let's assume the Fringe Benefit amount is calculated by multiplying the rate ceiling
            percentage in Attachment B-4 and direct labor. (Your formula for calculating fringe benefit may be
            different.) If the fringe benefit rate is 25%, the amount in the Fringe Benefit column shall be 0.25 times
            Direct Labor for the task.

            2. If there is more than one rate ceiling (i.e., escalating rates each year) in Attachment B-4, use the
            average of these rates for completing the Budget amounts. (It is acknowledged that -- although not
            completely accurate -- this methodology should be close to the actual number and that it would be too
            onerous to otherwise calculate the Budget using multiple rates.)

            For example, if we follow the same calculation as above for the fringe benefit amount, and the Fringe
            Benefit ceiling rate went from 25% to 26% to 28% in a 3-year period, then the amount in the Fringe
            Benefit column shall be (25 + 26 + 28) / 3 = 26.34% times Direct Labor for the task.


            Personnel Hourly Rates (Tabs: Att B-3 - Prime Rates, Att B-3 - Sub#1 Rates, etc. if more than
 Go    C.
            one subcontractor)

          Exhibit B Attachment B-3 Prime Rates Worksheets: In the first two columns, list the names and
          job classifications for everyone from the Prime Contractor (or Subcontractor on its form) that
          may be directly billed to this project. If names are not known, leave them blank and list just the
       Go
          job classifications. Individuals added after the Agreement is awarded must fall into one of the
          classifications and rates listed, so include all classifications that could be directly billed to this
          project.




04-2008                                                Page 4 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls          Instructions With Links
                                          ARRA Contract
                                    Budget Workbook Instructions
           For each person or job classification, first list their current unloaded hourly ceiling rate in the "Current
           Hourly Rates ($)" column. In the remaining columns, enter the rates for each year of the Agreement
           through to the Contract Term End Date (use the start and end dates of your organization's fiscal year for
           each period). If awarded an Agreement from a solicitation, the rates in your proposal become part of
           the signed Agreement and may not be changed. The Energy Commission will reimburse actual
           rates up to the ceilings specified in this Exhibit. Your actual billable rates can not exceed the
           rates specified in this exhibit.

           • Projected rates are acceptable and expected.
           • Average rates for different employees within a classification are not acceptable. If
             different employees are paid at different rates, then list out these employees separately.
           • Enter the total hours on the contract for each employee or position.


          Calculation of Fringe Benefits, Indirect Overhead, General Administrative Expenses, and Profit
 Go    D. Rates (Tabs: Att B-4 - Prime Costs Calc, Att B-4 - Sub#1 Costs Calc, etc. if more than one
          subcontractor)

           In the first table, provide fringe, indirect overhead, G&A and profit rates (%). Profit cannot exceed 10%
           of the ARRA funds allocated to the Contractor / Subcontractor on the project. Add columns on separate
           pages, if appropriate, to add your own unique additional costing categories.


           In the second table, list the budget expense items to which the indirect costs or fees are applied for
           fringe benefits, indirect overhead, G&A, and Profit (select from the list on the worksheet). The Prime
           Contractor may not apply profit to subcontractor invoices, nor may subcontractors apply profit to sub-
           subcontractor invoices. All levels of subcontractors can take a profit on their own work.


           In the third table, list items you include in each category (Fringe Benefits, Indirect Overhead, and G&A).


           Note: If your accounting systems and rate structures have been audited by an external agency, please
           provide a copy of their acceptance/approval of your rates and fees.

           Except as provided for in the contract, Contractor shall use the Federal OMB Circulars A-87, A-21, A-
           122 or FAR Part 31 in determining allowable and unallowable costs.
           Go Here for Guidance on Calculating Indirect Rates


 Go    E. Project Operating Expense Detail (Tabs: Att B-5 - Proj Oper Exp )


           If the ARRA budget forms for the Prime Contractor and all Subcontractors contain amounts in the
           columns listed "Travel," "Equipment," "Materials," and "Miscellaneous," then you must provide details of
           those expenditures that are to be pre-approved on the corresponding tables in this worksheet. (See
           notes in section III.B. above.)

           Task numbers must be entered for all items on each table. The task numbers do not carry forward from
           other worksheets because not all tasks will have funds allocated to these areas.

           List both ARRA funds and Leverage funds that are being used in the appropriate columns. A listing of
           Leverage fund expenditures will assist with overall budget management.

                                                   Pre-approved Travel List

04-2008                                              Page 5 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls        Instructions With Links
                                           ARRA Contract
                                     Budget Workbook Instructions

           For Pre-approved Travel, include at least 3 meetings: the kick-off meeting, critical project review
           meetings, and the final meeting. Also include any other trips that you can identify. Along with the
           purpose, include the destination, names (or titles) of people taking the trip, and the amount for each trip.

           Assign a Trip Number to each trip for reference when invoicing. (Use these trip numbers as a reference
           when filling out invoices for reimbursement.)

           If there are separate trips in each task (for separate purposes), then list them on separate rows in the
           table. Multiple trips within a task for the same purpose can be listed once with a comment on the
           number of trips involved.

           Examples:
           1) three separate trips in task 3 to San Francisco, Los Angeles, and San Diego @ $500 each should be
           listed on three separate rows.
           2) Two trips to Sacramento for PAC Meetings in Task 4 @ $500 each should be described as "PAC
           Meetings - Sacramento (2 trips)" at $1000 total for the task. NOTE: Give these grouped trips a range of
           trip numbers, e.g.: 4-1 and 4-2 .

           Any trips not identified here will need prior written approval by the Commission Contract Manager.
           Please note that travel is reimbursed at state rates.


           For more information on travel and state reimbursement rates, see this link at the Energy Commission
           Contracts Office website:
           http://www.energy.ca.gov/contracts/TRAVEL_PER_DIEM.PDF

                                                           Equipment

           List all equipment that will be purchased partly or in full with ARRA funds by both the Prime and the
           Subcontractors. Include the name, a description, the purpose and the amount of each piece of
           equipment. (Refer to Exhibit D Special Terms & Conditions for an explanation of equipment.) If
           possible, funds other than those from ARRA (including Leverage funds) should be used to purchase
           equipment. A UCC.1 form will be filed with the Secretary of State's Office by the Commission Contracts
           Officer at the start of the Agreement.


                                                             Materials
           Fill out the information requested, and in the "description" field, provide a general (not detailed)
           description of the particulars of the material expenditures.

                                                  Miscellaneous Expenditures




04-2008                                               Page 6 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls         Instructions With Links
                                           ARRA Contract
                                     Budget Workbook Instructions
            Fill out the information requested, and In the "description" field, provide a general (not detailed)
            description of the particulars of the miscellaneous expenditures.



          Contract Leverage Worksheet: The Prime Contractor and all Subcontractors must submit
          information about Leverage funding on the Exhibit B, Attachment B-6 Contract Leverage budget
Go     F.
          form. (Insert columns for additional subcontractors as needed.) Generally, fill in the Leverage-
          dollar amounts for each Task.

            Rows
            Tasks 1.5 and 1.9 do not require funding, which is why the budgets for these tasks are listed as zero.


            Tasks 1.7 and 1.8 are not reimbursable with ARRA funds. Leverage funds must be used for these
            tasks.

 Go    G. Additional Notes Worksheet

            If there are additional notes or commentary that is needed for any parts of the Exhibit B Budget
            Attachments, add them here.



            Direct Labor by Task (Tabs: Att B-5 - Prime Task Labor, Att B-5 - Sub#1 Task Labor, etc. if more
 Go    H.
            than one subcontractor) -- OPTIONAL

            Starting with Budget template release 04-2008, the Per-Task Labor tabs are optional in the contract
            package. If you wish to provide the Gantt Chart as a part of the package, use Excel's <Unhide> feature
            to reveal the Gantt Chart worksheet in this workbook. Total Hours for each employee or position are
            entered on the Labor Costs Worksheet.

            In the first two columns, the names and job classifications as listed on the Personnel Hourly Rates and
            Benefits worksheet are autofilled here. (See C, above)

            Insert the number of hours that each person/position listed will work on the corresponding tasks.


 IV. Instructions for Exhibit F, List of Contacts, (Tab: Exh F - List of Contacts)

          Insert the name, address, phone number, fax number, and e-mail address of the Contractor's Project
       Go Manager, Contracts Administrator, Accounting Invoicing Contact, and Legal Notice Recipient in the
          spaces provided.


            The name and contact information for the Commission Contract Manager shall be entered by the CCM.


            The Commission Contract Officer is assigned after the contract package is handed in to the Contracts
            Office. Select from the dropdown list of Contract Officers (This will be entered by Energy Commission
            personnel.)




04-2008                                               Page 7 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls         Instructions With Links
                                        ARRA Contract
                                  Budget Workbook Instructions

  I.   General Instructions for Completing the Spreadsheets in this Workbook




 II.   Instructions for Exhibit A Attachment A-1, Schedule of Deliverables and the Gantt Chart

        A.




        B.




                                                 Page 8 of 37                                    RFP 500-08-503
o: rg 3/24/09                      Attachment 16, Stage 2 Budget Instructions                            TIBC II
                                     ARRA Contract
                               Budget Workbook Instructions




 III. Instructions For Exhibit B Attachments (Budget Forms)

       A.




       B.




                                              Page 9 of 37                   RFP 500-08-503
o: rg 3/24/09                   Attachment 16, Stage 2 Budget Instructions           TIBC II
                                        ARRA Contract
                                  Budget Workbook Instructions




           Tasks 1.5 and 1.9 do not require funding, which is why the budgets for these tasks are listed as zero.




           Tasks 1.7 and 1.8 are not reimbursable with ARRA funds. Leverage funds must be used for them.

           • Instruction Specific to Columns in Attachment B-2




                                                Page 10 of 37                                        RFP 500-08-503
o: rg 3/24/09                      Attachment 16, Stage 2 Budget Instructions                                TIBC II
                      ARRA Contract
                Budget Workbook Instructions




       C.




                             Page 11 of 37                   RFP 500-08-503
o: rg 3/24/09   Attachment 16, Stage 2 Budget Instructions           TIBC II
                      ARRA Contract
                Budget Workbook Instructions

       D.




       E.




                             Page 12 of 37                   RFP 500-08-503
o: rg 3/24/09   Attachment 16, Stage 2 Budget Instructions           TIBC II
                      ARRA Contract
                Budget Workbook Instructions




                             Page 13 of 37                   RFP 500-08-503
o: rg 3/24/09   Attachment 16, Stage 2 Budget Instructions           TIBC II
                                        ARRA Contract
                                  Budget Workbook Instructions




       F.




       G.




 IV. Instructions for Exhibit F, List of Contacts, (Tab: Exh F - List of Contacts)




                                                Page 14 of 37                        RFP 500-08-503
o: rg 3/24/09                      Attachment 16, Stage 2 Budget Instructions                TIBC II
                                                ARRA Contract
                                          Budget Workbook Instructions

General Instructions for Completing the Spreadsheets in this Workbook

     This workbook contains spreadsheets for the Schedule of Deliverables and Due Dates, Gantt Chart,
     budget forms for the prime contractor and subcontractors, and a List of Contacts. Specific instructions for
     each of the spreadsheets in this workbook are below.


     The electronic version of these documents shows cells of different color. Fill in only the non-colored cells
     for each of the spreadsheets. Do NOT enter data in the blue cells. Blue cells contain formulas or data
     transferred from other worksheets. Blue cells and many of the yellow cells (headings) are protected to
     prevent accidental changes. Please do not attempt to change formulas and references in the worksheets
     unless you are familiar with the operation of the worksheets and you are well-versed in MS Excel
     software.

     Budget requirements are based on ARRA-, Energy Commission-, and CA State Contracting Rules.

Instructions for Exhibit A Attachment A-1, Schedule of Deliverables and the Gantt Chart

     Schedule of Deliverables and Due Dates (Tab: Att A-1 Schedule)

     For each Administrative Task, insert the planned start and completion dates. Please note that it will take
     approximately four months from the date that you complete and turn in these forms to Sparkey until there
     is a final, approved agreement. Pick a start date accordingly so you won't have to rebuild the schedule.


     For each Technical Task, insert in the appropriate columns, the name of the task as it is titled in the
     Scope of Work (Exhibit A), the name of the deliverables associated with each task as they are titled in the
     Scope of Work, and the planned start and completion dates. (Note: Dates will display in a red bold font if
     they fall on the weekend. Please correct for this.) Delete or insert rows as necessary. Because the task
     names (up to number 20) are linked with the budget forms, once they are typed onto the Schedule, they
     will carry forward to the budgets. If your project contains more than 20 tasks, you will have to link the
     additional cells or type them into the budget forms.

     For the Final Report Administrative Tasks (1.6, 1.6.1, & 1.6.2), you can either enter the overall start /
     finish dates in task 1.6 or enter the detailed start / finish dates in tasks 1.6.1 & 1.6.2.

     The Critical Project Reviews (and associated CPR Reports) are only shown for example purposes.
     Delete the examples and place CPRs in the appropriate project tasks.


     Do not insert any information in the columns labeled "ARRA Funds" and "Leverage Funds." These cells
     are linked to the budget forms and will automatically fill in once the budget forms are complete.


     GANTT Chart (Tab: Att A-1 GANTT) - OPTIONAL
     Starting with Budget template release 04-2008, the Gantt Chart is optional in the contract package. If you
     wish to provide the Gantt Chart as a part of the package, use Excel's <Unhide> feature to reveal the
     Gantt Chart worksheet in this workbook.
     For each Task, insert the planned start and end dates as listed on the Schedule of Deliverables and Due
     Dates. The start and end dates for the overall administrative tasks will be automatically entered from the
     schedule of deliverables. Headings and GANTT bar shadings are automatically completed as you
     enter start and end dates.




                                                        Page 15 of 37                                            RFP 500-08-503
     o: rg 3/24/09                         Attachment 16, Stage 2 Budget Instructions                                    TIBC II
                                               ARRA Contract
                                         Budget Workbook Instructions
     Note that the print format is to print the entire Gantt Chart. You may only need a small part of it. Use the
     RED FORMAT BAR at the bottom of the chart as a reference to reduce the print area of your chart. (Hint:
     The bar starts catty-corner to the latest date column in the Gantt Chart.)


     If you have an alternate means of creating a Gantt Chart (such as Microsoft Project), then you may use it.
     However, please make it print one landscape sheet and provide it in a separate electronic file. It must be
     compatible with Energy Commission software programs.

Instructions For Exhibit B Attachments (Budget Forms)

     Budget Summary (Tab: Att B-1 Summary)

     Do not enter any data in this spreadsheet. These are the total task budgets, and the amounts will
     automatically fill in once information is entered on the individual task budgets.

     ARRA Budget (Tabs: Att B-2 - Prime ARRA, Att B-2 - Sub#1 ARRA, etc. if more than one
     subcontractor)

     Prime and Subcontractor Budget Worksheets: The Prime Contractor and Subcontractors must
     submit information on all the Exhibit B Budget Attachment forms.

     Generally, fill in the ARRA reimbursable amounts for each Task.

     For Subcontractors, indicate whether they are "Key" and / or Disabled Veteran Business Enterprise
     (DVBE) in the checkboxes.

     Mark the "Key Sub." checkbox if this subcontractor is considered a key subcontractor to the contract.
     Note: All DVBE subcontractors are considered Key subcontractors; mark this key checkbox, too, if
     you've marked the DVBE checkbox.




                                                       Page 16 of 37                                         RFP 500-08-503
    o: rg 3/24/09                         Attachment 16, Stage 2 Budget Instructions                                 TIBC II
                                           ARRA Contract
                                     Budget Workbook Instructions

• Instruction Specific to Rows in Attachment B-2
For Task 1.1, Kick-off Meeting, and Task 1.3, Final Meeting, budget for the number of technical and
administrative personnel who will be attending the meeting with ARRA staff in Sacramento.

For Task 1.2, CPR Meetings, and Task 1.11, Conduct PAC Meetings, do not enter travel amounts in
these rows if travel for these administrative tasks is directly associated with a specific technical
task. Enter travel expense in those technical tasks.

Tasks 1.5 and 1.9 do not require funding, which is why the budgets for these tasks are listed as zero.

For Task 1.6, the Final Report, budget for 1 month for your top technical person and/or best technical
writer.

Tasks 1.7 and 1.8 are not reimbursable with ARRA funds. Leverage funds must be used for them.

• Instruction Specific to Columns in Attachment B-2
The Prime Contractor and Subcontractors must provide details of the following expenditures on the
corresponding tables in worksheet tab "Att B-5 - Project Operating Expense:"
- For all pre-approved travel contained in the amounts listed in the "Travel" column
- For any amounts over $5,000 listed in the "Equipment" column (refer to Exhibit G
    Definitions and Exhibit D Special Terms & Conditions)
- For all contract amounts in either of the columns "Materials" and "Miscellaneous"


For more information on travel and state reimbursement rates, see this link at the Energy Commission
Contracts Office website:
http://www.energy.ca.gov/contracts/TRAVEL_PER_DIEM.PDF

Do not fill in the column " Subcontractors." This information will fill in automatically from the
Subcontractor worksheets.

Regarding the column "Profit":
• Contractor profit cannot exceed 10% of the ARRA funds allocated to the Task.
• Prime Contractor cannot derive profit on subcontractor invoices.
• Subcontractors can derive profit on task work they perform, and their profit cannot exceed 10%
of the ARRA funds allocated to them on the Task.
• Subcontractors cannot derive profit on sub-subcontractor invoices.




                                                   Page 17 of 37                                         RFP 500-08-503
o: rg 3/24/09                         Attachment 16, Stage 2 Budget Instructions                                 TIBC II
                                          ARRA Contract
                                    Budget Workbook Instructions
• Calculating Amounts for the "Fringe Benefit", "Indirect Overhead", "G&A", and
   "Profit" Columns:
1. The Budget Amounts in these columns shall Leverage the rate ceilings (percentages) on Exhibit B,
Attachment B-4 (Calculation of Fringe Benefits, Indirect Overhead, General Administrative Expenses, and
Profit).

For example, let's assume the Fringe Benefit amount is calculated by multiplying the rate ceiling
percentage in Attachment B-4 and direct labor. (Your formula for calculating fringe benefit may be
different.) If the fringe benefit rate is 25%, the amount in the Fringe Benefit column shall be 0.25 times
Direct Labor for the task.

2. If there is more than one rate ceiling (i.e., escalating rates each year) in Attachment B-4, use the
average of these rates for completing the Budget amounts. (It is acknowledged that -- although not
completely accurate -- this methodology should be close to the actual number and that it would be too
onerous to otherwise calculate the Budget using multiple rates.)

For example, if we follow the same calculation as above for the fringe benefit amount, and the Fringe
Benefit ceiling rate went from 25% to 26% to 28% in a 3-year period, then the amount in the Fringe
Benefit column shall be (25 + 26 + 28) / 3 = 26.34% times Direct Labor for the task.


Personnel Hourly Rates (Tabs: Att B-3 - Prime Rates, Att B-3 - Sub#1 Rates, etc. if more than one
subcontractor)

Exhibit B Attachment B-3 Prime Rates Worksheets: In the first two columns, list the names and
job classifications for everyone from the Prime Contractor (or Subcontractor on its form) that may
be directly billed to this project. If names are not known, leave them blank and list just the job
classifications. Individuals added after the Agreement is awarded must fall into one of the
classifications and rates listed, so include all classifications that could be directly billed to this
project.

For each person or job classification, first list their current unloaded hourly ceiling rate in the "Current
Hourly Rates ($)" column. In the remaining columns, enter the rates for each year of the Agreement
through to the Contract Term End Date (use the start and end dates of your organization's fiscal year for
each period). If awarded an Agreement from a solicitation, the rates in your proposal become part of the
signed Agreement and may not be changed. The Energy Commission will reimburse actual rates up
to the ceilings specified in this Exhibit. Your actual billable rates can not exceed the rates
specified in this exhibit.

• Projected rates are acceptable and expected.
• Average rates for different employees within a classification are not acceptable. If
  different employees are paid at different rates, then list out these employees separately.
• Enter the total hours on the contract for each employee or position.




                                                  Page 18 of 37                                           RFP 500-08-503
o: rg 3/24/09                        Attachment 16, Stage 2 Budget Instructions                                   TIBC II
                                          ARRA Contract
                                    Budget Workbook Instructions
Calculation of Fringe Benefits, Indirect Overhead, General Administrative Expenses, and Profit
Rates (Tabs: Att B-4 - Prime Costs Calc, Att B-4 - Sub#1 Costs Calc, etc. if more than one
subcontractor)

In the first table, provide fringe, indirect overhead, G&A and profit rates (%). Profit cannot exceed 10% of
the ARRA funds allocated to the Contractor / Subcontractor on the project. Add columns on separate
pages, if appropriate, to add your own unique additional costing categories.


In the second table, list the budget expense items to which the indirect costs or fees are applied for fringe
benefits, indirect overhead, G&A, and Profit (select from the list on the worksheet). The Prime Contractor
may not apply profit to subcontractor invoices, nor may subcontractors apply profit to sub-subcontractor
invoices. All levels of subcontractors can take a profit on their own work.


In the third table, list items you include in each category (Fringe Benefits, Indirect Overhead, and G&A).


Note: If your accounting systems and rate structures have been audited by an external agency, please
provide a copy of their acceptance/approval of your rates and fees.

Except as provided for in the contract, Contractor shall use the Federal OMB Circulars A-87, A-21, A-122
or FAR Part 31 in determining allowable and unallowable costs.


Project Operating Expense Detail (Tabs: Att B-5 - Proj Oper Exp )


If the ARRA budget forms for the Prime Contractor and all Subcontractors contain amounts in the
columns listed "Travel," "Equipment," "Materials," and "Miscellaneous," then you must provide details of
those expenditures that are to be pre-approved on the corresponding tables in this worksheet. (See notes
in section III.B. above.)

Task numbers must be entered for all items on each table. The task numbers do not carry forward from
other worksheets because not all tasks will have funds allocated to these areas.

List both ARRA funds and Leverage funds that are being used in the appropriate columns. A listing of
Leverage fund expenditures will assist with overall budget management.




                                                  Page 19 of 37                                          RFP 500-08-503
o: rg 3/24/09                        Attachment 16, Stage 2 Budget Instructions                                  TIBC II
                                          ARRA Contract
                                    Budget Workbook Instructions
                                         Pre-approved Travel List

For Pre-approved Travel, include at least 3 meetings: the kick-off meeting, critical project review
meetings, and the final meeting. Also include any other trips that you can identify. Along with the
purpose, include the destination, names (or titles) of people taking the trip, and the amount for each trip.

Assign a Trip Number to each trip for reference when invoicing. (Use these trip numbers as a reference
when filling out invoices for reimbursement.)

If there are separate trips in each task (for separate purposes), then list them on separate rows in the
table. Multiple trips within a task for the same purpose can be listed once with a comment on the number
of trips involved.

Examples:
1) three separate trips in task 3 to San Francisco, Los Angeles, and San Diego @ $500 each should be
listed on three separate rows.
2) Two trips to Sacramento for PAC Meetings in Task 4 @ $500 each should be described as "PAC
Meetings - Sacramento (2 trips)" at $1000 total for the task. NOTE: Give these grouped trips a range of
trip numbers, e.g.: 4-1 and 4-2 .

Any trips not identified here will need prior written approval by the Commission Contract Manager.
Please note that travel is reimbursed at state rates.


For more information on travel and state reimbursement rates, see this link at the Energy Commission
Contracts Office website:
http://www.energy.ca.gov/contracts/TRAVEL_PER_DIEM.PDF

                                                 Equipment

List all equipment that will be purchased partly or in full with ARRA funds by both the Prime and the
Subcontractors. Include the name, a description, the purpose and the amount of each piece of equipment.
(Refer to Exhibit G Definitions and Exhibit D Special Terms & Conditions for an explanation of
equipment.) If possible, funds other than those from ARRA (including Leverage funds) should be used to
purchase equipment. A UCC.1 form will be filed with the Secretary of State's Office by the Commission
Contracts Officer at the start of the Agreement.




                                                  Page 20 of 37                                          RFP 500-08-503
o: rg 3/24/09                        Attachment 16, Stage 2 Budget Instructions                                  TIBC II
                                                ARRA Contract
                                          Budget Workbook Instructions
                                                        Materials
     Fill out the information requested, and in the "description" field, provide a general (not detailed)
     description of the particulars of the material expenditures.

                                             Miscellaneous Expenditures
     Fill out the information requested, and In the "description" field, provide a general (not detailed)
     description of the particulars of the miscellaneous expenditures.



     Contract Leverage Worksheet: The Prime Contractor and all Subcontractors must submit
     information about Leverage funding on the Exhibit B, Attachment B-6 Contract Leverage budget
     form. (Insert columns for additional subcontractors as needed.) Generally, fill in the Leverage-
     dollar amounts for each Task.

     Rows
     Tasks 1.5 and 1.9 do not require funding, which is why the budgets for these tasks are listed as zero.


     Tasks 1.7 and 1.8 are not reimbursable with ARRA funds. Leverage funds must be used for these tasks.


     Additional Notes Worksheet

     If there are additional notes or commentary that is needed for any parts of the Exhibit B Budget
     Attachments, add them here.



Instructions for Exhibit F, List of Contacts, (Tab: Exh F - List of Contacts)

     Insert the name, address, phone number, fax number, and e-mail address of the Contractor's Project
     Manager, Contracts Administrator, Accounting Invoicing Contact, and Legal Notice Recipient in the
     spaces provided.


     The name and contact information for the Commission Contract Manager shall be entered by the CCM.


     The Commission Contract Officer is assigned after the contract package is handed in to the Contracts
     Office. Select from the dropdown list of Contract Officers (This will be entered by Energy Commission
     personnel.)




                                                        Page 21 of 37                                         RFP 500-08-503
     o: rg 3/24/09                         Attachment 16, Stage 2 Budget Instructions                                 TIBC II
                                                                   Exhibit A
                                                                Attachment A-1
                                                    Schedule of Deliverables and Due Dates
                                                                  Insert Name of Contractor Here
 Project                                                                                                                   Planned
                                                                                                          Planned Start                              Leverage
 or Task                Task Name                                     Deliverable(s)                                      Completion   ARRA Funds
                                                                                                              Date                                    Funds
 Number                                                                                                                      Date
                                           Administration                                                  9/27/2006      10/27/2006
   A.1     Attend Kick-off Meeting           An Updated Schedule of Deliverables                           9/27/2006      10/27/2006     #REF!                  0
                                             An Updated Gantt Chart (optional)
                                             An Updated List of Leverage Funds
                                             An Updated List of Permits
                                             An Updated Financing Plan
                                             Schedule for Recruiting PAC Members (optional)
                Commission Contract Manager
                                             Final report Instructions
                                Deliverables
   A.2     CPR Meetings                      CPR Report(s)                                                                               #REF!                  0
                                                   CPR deliverables identified in this Scope of Work

                 Commission Contract Manager
                                                   Agenda and a List of Expected Participants
                                      Deliverables
                                                   Schedule for Written Determination
                                                   Written Determination
                                                   Written documentation of meeting agreements and
   A.3    Final Meeting                                                                                                                  #REF!                  0
                                                   all pertinent information
                                                   Schedule for completing closeout activities
   A.4    Monthly Progress Reports                 Monthly Progress Reports                                                              #REF!                  0
          Test Plans, Technical Reports and
   A.5                                                                                                        N/A            N/A                 0              0
          Interim Deliverables
   A.6    Final Report                                                                                                                   #REF!                  0
    A.6.1            Final Report Outline                      Draft Outline of the Final Report                                         #REF!                  0
                                                               Final Outline of the Final Report
    A.6.2                Final Report                                  Draft Final Report                                                #REF!                  0
                                                                         Final Report
                                                   A letter regarding Leverage Funds or stating that no
   A.7    Identify and Obtain Leverage Funds                                                                                                     0              0
                                                   Leverage Funds are provided
                                                   Letter(s) for New Leverage Funds
                                                   A copy of each Leverage Fund commitment letter
                                                   Letter that Leverage Funds were Reduced (if
                                                   applicable)
                                                   A letter documenting the Permits or stating that no
   A.8    Identify and Obtain Required Permits                                                                                                   0              0
                                                   Permits are required
                                                   Updated list of Permits as they change during the
                                                   Term of the Agreement
                                                   Updated schedule for acquiring Permits as it
                                                   changes during the Term of the Agreement
                                                                              Page 22 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                                    Att A-1 - Schedule
                                                                    Exhibit A
                                                                 Attachment A-1
 Project                                             Schedule of Deliverables and Due Dates
                                                                                   Planned Start
                                                                                                                         Planned
                                                                                                                                                       Leverage
 or Task                 Task Name                                      Deliverable(s)                                  Completion       ARRA Funds
                                                                                                            Date                                        Funds
 Number                                                                                                                    Date
                                                   Administration approved Permit
                                                    A copy of each
                                                    A Letter requesting exemption from the Electronic
   A.9     Electronic File Format                                                                           N/A             N/A                    0              0
                                                    File Format (if applicable)
  A.10     Establish the PAC (Optional)             Draft List of PAC Members                                                              #REF!                  0
                                                    Final List of PAC Members
                                                    Letters of acceptance, or other comparable
                                                    documentation of commitment for each PAC Member
  A.11     Conduct PAC Meetings (Optional)          Draft PAC Meeting Schedule                                                             #REF!                  0
                                                    Final PAC Meeting Schedule
                                                    PAC Meeting Agenda(s) with Back-up Materials for
                                                    Agenda Items
                                                    Written PAC meeting summaries, including
                                                    recommended resolution of major PAC issues
                                                                                                        Administrative Tasks Sub-Total     #REF!       $          -
                                                  Technical Tasks                                          #NUM!           #NUM!
   1.0     Name of Project 1                                                                                                               #REF!                  0
   1.1     Name of Task 1.1                           1. Name of Deliverable for Task 1.1                                                  #REF!                  0
                                                      1. Name of Deliverable for Task 1.2
   1.2     Name of Task 1.2                                                                                                                #REF!                  0
                                                      2. Name of Deliverable for Task 1.2
               Critical Project Review (example only) 1st Critical Project Review Report
           Name of Task 1.3                           1. Name of Deliverable for Task 1.3
   2.0     Name of Project 2                                                                                                               #REF!                  0
   2.1     Name of Task 2.1                           1. Name of Deliverable for Task 2.1                                                  #REF!                  0
   2.2     Name of Task 2.2                           1. Name of Deliverable for Task 2.2                                                  #REF!                  0
   2.3     Name of Task 2.3                           1. Name of Deliverable for Task 2.3                                                  #REF!                  0
                Critical Project Review(example only) 2nd Critical Project Review Report
                                                                                                            Technical Tasks Sub-Total      #REF!       $          -
                                                                                                                                Total      #REF!       $          -




                                                                               Page 23 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                                     Att A-1 - Schedule
                                                  Exhibit B
                                              Att B-1 Summary

Summary Project Budget                                      ARRA
                                                                        Task Leverage
                                                         Reimbursable                 Total Task Costs
Insert Name of Contractor Here                                              Funds
                                                          Task Costs

    0.0      Administration                                 #REF!                    0       #REF!

             Project Technical Activities

    1.0      Name of Project 1                              #REF!                    0       #REF!

    2.0      Name of Project 2                              #REF!                    0       #REF!

   #REF!     #REF!                                          #REF!                    0       #REF!

   #REF!     #REF!                                          #REF!                    0       #REF!

                     Technical Activities Subtotals             #REF!                0            #REF!

                                                          Total ARRA    Total Leverage    Total Project
                                                             Cost           Funds             Cost
                             Project Totals                 #REF!                     0      #REF!




                                                    Page 24 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls          Att B-1 Summary
                                                                                                      Exhibit B
                                                                                            Att B-2 - Contractor ARRA

    Budget for ARRA Reimbursement
                                                            Personal Services                                      Project Operating Expenses                                             Indirect Costs
             to Contractor                                                                                                                                                                                                     ARRA
                                                                                                                                                                                                                            Reimbursable
Insert Name of Contractor Here                                                                                                                                 Sub-        Indirect                                          Task Costs
                                                                                                                                                                                                                    1
                                                       Direct Labor       Fringe Benefits    Materials       Equipment       Travel             Misc.                                         G&A          Profit
                                                                                                                                                            contractors   Overhead

   1.0    Project Administration Activities

   A.1    Attend Kick-off Meeting                                                                                                                             #REF!                                                            #REF!

   A.2    CPR Meetings                                                                                                                                        #REF!                                                            #REF!

   A.3    Final Meeting                                                                                                                                       #REF!                                                            #REF!

   A.4    Monthly Progress Reports                                                                                                                            #REF!                                                            #REF!

          Test Plans, Technical Reports and Interim
   A.5
          Deliverables

   A.6    Final Report                                                0                0                 0               0            0                 0     #REF!                   0                0                0      #REF!

  A.6.1   Final Report Outline                                                                                                                                #REF!                                                            #REF!

  A.6.2   Final Report                                                                                                                                        #REF!                                                            #REF!

   A.7    Identify and Obtain Leverage Funds

   A.8    Identify and Obtain Required Permits

   A.9    Electronic File Format

   A.10   Establish the PAC (Optional)                                                                                                                        #REF!                                                            #REF!

   A.11   Conduct PAC Meetings (Optional)                                                                                                                     #REF!                                                            #REF!

          Administration Activities Subtotals                         0                0                 0               0            0                 0     #REF!                   0                0                0      #REF!

          Project Technical Activities (Delete or add rows as necessary)

   1.0    Name of Project 1                                                                                                                                   #REF!                                                            #REF!

   1.1    Name of Task 1.1                                                                                                                                    #REF!                                                            #REF!

   1.2    Name of Task 1.2                                                                                                                                    #REF!                                                            #REF!

   2.0    Name of Project 2                                                                                                                                   #REF!                                                            #REF!

   2.1    Name of Task 2.1                                                                                                                                    #REF!                                                            #REF!

   2.2    Name of Task 2.2                                                                                                                                    #REF!                                                            #REF!

   2.3    Name of Task 2.3                                                                                                                                    #REF!                                                            #REF!




                                                                                                         Page 25 of 37
 f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                                                         Att B-2 - Contractor ARRA
                                                                                                   Exhibit B
                                                                                         Att B-2 - Contractor ARRA

    Budget for ARRA Reimbursement
                                                         Personal Services                                      Project Operating Expenses                                             Indirect Costs
             to Contractor                                                                                                                                                                                                  ARRA
                                                                                                                                                                                                                         Reimbursable
Insert Name of Contractor Here                                                                                                                              Sub-        Indirect                                          Task Costs
                                                                                                                                                                                                                 1
                                                    Direct Labor       Fringe Benefits    Materials       Equipment       Travel             Misc.                                         G&A          Profit
                                                                                                                                                         contractors   Overhead

  #REF!   #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

  #REF!   #REF!                                                                                                                                            #REF!                                                            #REF!

               Technical Activities Subtotals                      0                0                 0               0            0                 0         #REF!               0                0                0          #REF!


                                                                                                                                                           Major                                                        Total ARRA
                                                                                                                                                                        Indirect
                      Prime Contractor              Direct Labor       Fringe Benefits    Materials       Equipment       Travel             Misc.        Subcon-                          G&A          Profit         Reimburs- able
                                                                                                                                                                       Overhead
                                                                                                                                                          tractors                                                          Cost
                  ARRA Reimbursable Totals                         0                0                 0               0            0                 0     #REF!                   0                0                0     #REF!
                     Percent of the Total              #REF!               #REF!           #REF!           #REF!          #REF!          #REF!             #REF!        #REF!             #REF!         #REF!               #REF!
                                                                                                                                                           #REF!           Total overhead & profit =                 0


          (1) Prime Contractor profit not allowed on Subcontractor invoices and profit cannot exceed 10% of the ARRA funds allocated to the Task.




                                                                                                      Page 26 of 37
 f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                                                      Att B-2 - Contractor ARRA
                                                                                                      Exhibit B
                                                                                                 Att B-2 - Sub ARRA
     Budget for ARRA Reimbursement
                                                               Personal Services                                     Project Operating Expenses                                                 Indirect Costs
       to Major Subcontractor #1 (1)
                                                                                                                                                                                                                                ARRA Reimburs-
      DVBE Sub                                                                                                                                                                                                                  ableTask Costs
                                                                                                                                                                 Sub-            Indirect                                         for Sub #1
Insert Name of Subcontractor                              Direct Labor       Fringe Benefits   Materials       Equipment       Travel             Misc.                                             G&A          Profit 1
                                                                                                                                                              contractors       Overhead


    1.0      Project Administration Activities

    A.1      Attend Kick-off Meeting                                                                                                                                                                                                        0

    A.2      CPR Meetings                                                                                                                                                                                                                   0

    A.3      Final Meeting                                                                                                                                                                                                                  0

    A.4      Monthly Progress Reports                                                                                                                                                                                                       0

             Test Plans, Technical Reports and Interim
    A.5
             Deliverables

    A.6      Final Report                                                0                 0               0               0            0                 0                 0               0                0              0               0

   A.6.1     Final Report Outline                                                                                                                                                                                                           0

   A.6.2     Final Report                                                                                                                                                                                                                   0

    A.7      Identify and Obtain Leverage Funds

    A.8      Identify and Obtain Required Permits

    A.9      Electronic File Format

   A.10      Establish the PAC (Optional)                                                                                                                                                                                                   0

   A.11      Conduct PAC Meetings (Optional)                                                                                                                                                                                                0

             Administration Activities Subtotals                         0                 0               0               0            0                 0                 0               0                0              0               0

             Project Technical Activities (Delete or add rows as necessary)

    1.0      Name of Project 1                                                                                                                                                                                                              0

    1.1      Name of Task 1.1                                                                                                                                                                                                               0

    1.2      Name of Task 1.2                                                                                                                                                                                                               0

    2.0      Name of Project 2                                                                                                                                                                                                              0

    2.1      Name of Task 2.1                                                                                                                                                                                                               0

    2.2      Name of Task 2.2                                                                                                                                                                                                               0

    2.3      Name of Task 2.3                                                                                                                                                                                                               0

                   Technical Activities Subtotals                        0                 0               0               0            0                 0                 0               0                0              0               0




                                                                                                              Page 27 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                                                                   Att B-2 - Sub ARRA
                                                                                                   Exhibit B
                                                                                              Att B-2 - Sub ARRA
     Budget for ARRA Reimbursement
                                                            Personal Services                                     Project Operating Expenses                                                  Indirect Costs
       to Major Subcontractor #1 (1)
                                                                                                                                                                                                                              ARRA Reimburs-
      DVBE Sub                                                                                                                                                                                                                ableTask Costs
                                                                                                                                                               Sub-            Indirect                                         for Sub #1
Insert Name of Subcontractor                           Direct Labor       Fringe Benefits   Materials       Equipment       Travel             Misc.                                              G&A          Profit 1
                                                                                                                                                            contractors       Overhead

                                                                                                                                                                                                                               Major Sub #1
                                                                                                                                                           Minor Subcon-       Indirect                                           ARRA
                      Major Subcontractor #1           Direct Labor       Fringe Benefits   Materials       Equipment       Travel             Misc.                                              G&A          Profit
                                                                                                                                                              tractors        Overhead                                          Reimburs-
                                                                                                                                                                                                                                able Cost
                    ARRA Reimbursable Totals                          0                 0               0               0             0                0                  0               0                0              0                   0
                        Percent of the Total             #DIV/0!             #DIV/0!        #DIV/0!          #DIV/0!        #DIV/0!        #DIV/0!            #DIV/0!          #DIV/0!           #DIV/0!       #DIV/0!           #DIV/0!
                                                                                                                               Total project expenses =                   0       Total overhead & profit =               0


             (1) Subcontractor profit is not allowed on Sub-subcontractor invoices and profit cannot exceed 10% of the ARRA funds allocated to the Task.




                                                                                                           Page 28 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                                                                Att B-2 - Sub ARRA
                                                                                  Exhibit B
                                                                         Att B-3 - Contractor Rates

Insert Name of Contractor Here
                                                                                       Projected Hourly Rates ($) *
                                             Dates:   From:              From:              From:               From:             From:              Projected Total
                                                       To:                To:                 To:                To:               To:
                                                                                                                                                     Hours Worked
Name                       Job Classification/Title   ($) Ceiling Rate   ($) Ceiling Rate   ($) Ceiling Rate   ($) Ceiling Rate   ($) Ceiling Rate
Employee Name #1 (or
"TBD")                     Employee Title #1




* Your actual billable rates cannot exceed the ceiling rates specified in this exhibit.
* As a reminder, this sheet lists unloaded (that is, before fringe benefits or any other overhead) rates.




                                                                                        Page 29 of 37
        f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                                 Att B-3 - Contractor Rates
                                                                                   Exhibit B
                                                                              Att B-3 - Sub Rates

Insert Name of Subcontractor
                                                                                    Projected Hourly Rates ($)
                                          Dates:   From:              From:              From:              From:              From:
                                                                                                                                                  Projected Total
                                                    To:                To:                To:                To:                To:
                                                                                                                                                  Hours Worked
Name                    Job Classification/Title   ($) Ceiling Rate   ($) Ceiling Rate   ($) Ceiling Rate   ($) Ceiling Rate   ($) Ceiling Rate
Sub#1 Employee Name
(or "TBD")          Sub#1 Employee Title




* Your actual billable rates cannot exceed the rates specified in this exhibit.
* As a reminder, this sheet lists unloaded (that is, before fringe benefits or any other overhead) rates.




                                                                                     Page 30 of 37
        f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                                  Att B-3 - Sub Rates
                                             Exhibit B
                                 Att B-4 - Contractor Costs Calc

 Insert Name of Contractor Here

                                                                            Percentage Rate

 Time intervals from the start of the project            Fringe     Indirect                      Profit (P)
 through the Contract Term End Date. (Use your Benefits Overhead                     General &      (10%
 organization's Fiscal Year start / end dates.)            (FB)       (OH)    Administrative (GA)   Max)
   From:        1/0/00         To:          1/0/00          %          %                %            0%
   From:                       To:                          %          %                %            0%
   From:                       To:                          %          %                %            0%
   From:                       To:                          %          %                %            0%
   From:                       To:                          %          %                %            0%
 Note: Use the categories that you typically use in your standard business practice.


                                          List the budget expense items to which the indirect costs or fees are
                                                        applied. Use the following abbreviations:
                                                 DL = Direct Labor, FB = Fringe Benefits, M = Materials,
     Expense Items in the Budget
                                          EQ = Equipment, T = Travel, MS = Miscellaneous, S = Subcontracts,
           Spreadsheets
                                                OH = Indirect Overhead, G&A = General & Administrative
                                           (For example, if the Fringe Benefits percentage is applied to Direct
                                              Labor expense, you would list DL in the Fringe Benefits line.)
 Fringe Benefits
 Indirect Overhead
 General & Administrative
 Profit*




 List items you include in each category (e.g., vacation, retirement plan, telephone, secretarial, rent/lease,
 insurance, etc.). If vacation, holidays, or sick leave are included, do not double count in your hourly rate
 calculations.

            Fringe Benefits                       Indirect Overhead                  General & Administrative




 * Prime Contractor profit not allowed on Subcontractor invoices.
                                               Page 31 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls B-4 - Contractor Costs Calc
                                       Att
                                               Exhibit B
                                       Att B-4 - Sub Costs Calc


  Insert Name of Subcontractor

                                                                            Percentage Rate

  Time intervals from the start of the project           Fringe     Indirect                      Profit (P)
  through the Contract Term End Date. (Use your Benefits Overhead                   General &       (10%
  organization's Fiscal Year start / end dates.)           (FB)       (OH)    Administrative (GA)   Max)
    From:        1/0/00         To:         1/0/00          %          %               %             0%
    From:                       To:                         %          %               %             0%
    From:                       To:                         %          %               %             0%
    From:                       To:                         %          %               %             0%
    From:                       To:                         %          %               %             0%
  Note: Use the categories that you typically use in your standard business practice.


                                          List the budget expense items to which the indirect costs or fees are
                                                        applied. Use the following abbreviations:
                                                 DL = Direct Labor, FB = Fringe Benefits, M = Materials,
                                          EQ = Equipment, T = Travel, MS = Miscellaneous, S = Subcontracts,
                                                OH = Indirect Overhead, G&A = General & Administrative
      Expense Items in the Budget          (For example, if the Fringe Benefits percentage is applied to Direct
             Spreadsheets                     Labor expense, you would list DL in the Fringe Benefits line.)
  Fringe Benefits
  Indirect Overhead
  General & Administrative
  Profit*




  List items you include in each category (e.g., vacation, retirement plan, telephone, secretarial, rent/lease,
  insurance, etc.). If vacation, holidays, or sick leave are included, do not double count in your hourly rate
  calculations.

             Fringe Benefits                       Indirect Overhead                 General & Administrative




  *Subcontractor profit is not allowed on Sub-subcontractor invoices.

                                               Page 32 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls Att B-4 - Sub Costs Calc
                                                                  Exhibit B
                                                           Att B-5 - Proj Oper Exp
                                                                  Pre-approved Travel List *
                                                                                                         Amount
                                                                                                             ARRA             Leverage
Task No.         Trip Number                     Trip Purpose                   Destination     Who          Funds             Funds
         2             2-1           Trip to Sacramento for Kickoff Meeting
                                         Four trips to Sacramento for PAC
         2       3-1 through 3-4
                                             Meetings @ $300 per trip




Total:                                                                                                               $0                  $0

* Travel is reimbursed at state rates.


                                                                            Equipment
                                                                                                                     Amount
              Contractor / Sub                                                                               ARRA             Leverage
Task No.           Name                         Name of Equip.                  Description    Purpose       Funds             Funds




Total:                                                                                                               $0                  $0



                                                                            Material(s)
                                                                                                                     Amount
              Contractor / Sub                                                                               ARRA             Leverage
Task No.           Name                                        Description of Material(s)                    Funds             Funds




Total:                                                                                                               $0                  $0



                                                                Miscellaneous Expenditures
                                                                                                                     Amount
              Contractor / Sub                                                                               ARRA             Leverage
Task No.           Name                                      Description of Expenditures                     Funds             Funds




Total:                                                                                                               $0                  $0



                                                                       Page 33 of 37
    f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                      Att B-5 - Proj Oper Exp
                                                                         Exhibit B
                                                               Att B-6 - Leverage Funding

                                                                                                       Other          Other          Other
                                                                    Insert Name of                   Leverage       Leverage       Leverage      Total Task
                                                                                   Insert Name of
                      Contractor / Subcontractor Name:                Contractor
                                                                                    Subcontractor
                                                                                                      Funding        Funding        Funding      Leverage
                                                                         Here                       Organization   Organization   Organization     Funds
                                                                                                       Name           Name           Name
                        Project Administration Activities

               A.1      Attend Kick-off Meeting                                                                                                               0

               A.2      CPR Meetings                                                                                                                          0

               A.3      Final Meeting                                                                                                                         0

               A.4      Monthly Progress Reports                                                                                                              0

                        Test Plans, Technical Reports and Interim
               A.5
                        Deliverables

               A.6      Final Report                                              0             0              0              0              0                0

                  A.6.1 Final Report Outline                                                                                                                  0

                  A.6.2 Final Report                                                                                                                          0

               A.7      Identify and Obtain Leverage Funds                                                                                                    0

               A.8      Identify and Obtain Required Permits                                                                                                  0

               A.9      Electronic File Format

               A.10     Establish the PAC (Optional)                                                                                                          0

               A.11     Conduct PAC Meetings (Optional)                                                                                                       0

                        Administration Activities Subtotals                       0             0              0              0              0                0

                        Project Technical Activities (Delete rows as necessary)

               1.0      Name of Project 1                                                                                                                     0

               1.1      Name of Task 1.1                                                                                                                      0

               1.2      Name of Task 1.2                                                                                                                      0



                                                                             Page 34 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                              Att B-6 - Leverage Funding
                                                                       Exhibit B
                                                             Att B-6 - Leverage Funding

                                                                                                  Other           Other           Other
                                                               Insert Name of                   Leverage        Leverage        Leverage       Total Task
                                                                              Insert Name of
                      Contractor / Subcontractor Name:           Contractor
                                                                               Subcontractor
                                                                                                 Funding         Funding         Funding       Leverage
                                                                    Here                       Organization    Organization    Organization      Funds
                                                                                                  Name            Name            Name

               2.0     Name of Project 2                                                                                                                    0

               2.1     Name of Task 2.1                                                                                                                     0

               2.2     Name of Task 2.2                                                                                                                     0

               2.3     Name of Task 2.3                                                                                                                     0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

              #REF!    #REF!                                                                                                                                0

                            Technical Activities Subtotals                  0              0               0               0               0                0
                               Leverage Funds Totals                        0              0               0               0               0                0
                                 Percent of the Total             #DIV/0!        #DIV/0!         #DIV/0!         #DIV/0!         #DIV/0!        #DIV/0!




                                                                        Page 35 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                         Att B-6 - Leverage Funding
                                                                Exhibit B
                                                       Att B-7 - Additional Notes


                       Exhibit / Attachment Name
                    (e.g., Exhibit B, Attachment B-3
                             Sub #2 Rates)                                          Note




                                                                 Page 36 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls                   Att B-7 - Additional Notes
                                                   Exhibit F
                                               List of Contacts
Commission Contract Manager:                               Contractor Contract Manager:

                                                           <name>
California Energy Commission                               <address line 1>
1516 Ninth Street, MS - 43                                 <address line 2>
Sacramento, CA 95814                                       <address line 3>
Phone:                                                     Phone:
Fax:                                                       Fax:
e-mail:                                                    e-mail:


Commission Contracts Officer:                              Contractor Contract Administrator:

                                                           <name>
California Energy Commission                               <address line 1>
1516 Ninth Street, MS - 18                                 <address line 2>
Sacramento, CA 95814                                       <address line 3>
Phone:                                                     Phone:
Fax:        (916) 654-4423                                 Fax:
e-mail:                                                    e-mail:
   Deliver confidential deliverables to this
                location only.

Invoices, Progress Reports and                             Contractor Accounting
Non-Confidential Deliverables to:                          Invoicing Contact:
Donna Green
Accounting Office                                          <name>
California Energy Commission                               <address line 1>
1516 Ninth Street, MS - 2                                  <address line 2>
Sacramento, CA 95814                                       <address line 3>
Phone:      (916) 654-3904                                 Phone:
Fax:        (916) 653-1435                                 Fax:
e-mail:     dgreen@energy.state.ca.us                      e-mail:


Commission Legal Notices:                                  Contractor Legal Notices:

Cheryl Raedel                                              <name>
Manager, Contracts Office                                  <address line 1>
California Energy Commission                               <address line 2>
1516 Ninth Street, MS -18                                  <address line 3>
Sacramento, CA 95814
Phone:      (916) 654-4392                                 Phone:
Fax:        (916) 654-4423                                 Fax:
e-mail:     craedel@energy.state.ca.us                     e-mail:




                                                   Page 37 of 37
f3efcc87-2d79-4fef-8740-fd0bed20fece.xls       Exh F List of Contacts

				
DOCUMENT INFO
Description: Sub Contractor Commission Based Agreement Policy document sample