Bid Proposal Excel Template - Download as Excel

							                                                                                            Rates and Factors Calculation


                                      QUICK & DIRTY RATES AND FACTORS ESTIMATES FOR SMALL BUSINESS ACTIVITIES
                                                                                                      DISCLAIMER
                     NO WARRANTY. Praxis Inc. (Praxis) provides this Excel template solely as a service for small one-person businesses, Consultants, and/or Independent Consultants
                     contemplating submission of a cost proposal to Praxis. Because of this, we do not promise that the templates will work for any other purpose. We also do not promise that
                     they are free from viruses, bugs, or other defects, nor do we promise that they will comply with any guidelines promulgated by the Federal Acquisition Regulation (FAR), the
                     Defense Contract Audit Agency (DCAA), or any other agency of the U.S. Government. The template(s) are provided "as is" and without warranty of any kind. You bear the
                     risk of using them. Praxis gives no express warranties, guarantees and conditions with regard to the templates. To the extent permitted under law, Praxis excludes the implied
                     warranties and conditions of merchantability, fitness for a particular purpose, workmanlike effort, title and non-infringement.
                     NO REMEDIES OR DAMAGES: By using this template, you agree that you cannot recover direct or other damages, including consequential, lost profits, special, indirect or
                     incidental damages from Praxis. This limitation applies to: (i) Anything related to this templates and/or the website containing this template; (ii) Claims for breach of contract,
                     breach of warranty, guarantee or condition, strict liability, negligence, or other tort to the extent permitted by applicable law. It also applies even if Praxis knew or should have
                     known about the possibility of the damages.



                                                          CALCULATE WORKING HRS PER YEAR
                                          COMPENSATION PARAMETERS                                                                INPUT VALUE                UNITS
                     a) Compensated Work Day (w/o Overtime)                                                                                 8                Hrs
                     b) Compensated Work Days Per Week                                                                                      5                Day
                     c) Compensated Weeks Per Year                                                                                         52                Wks
                     d) Compensated Holidays (Gvmt/Other)                                                                                  10               Days
                     e) Compensated Vacation and Personal Leave Days                                                                       20               Days
                     h) Total, Compensated Non-Work Days per Year                                                                         30                Days

                     i) Number of Compensated Work Hrs Per Year (a*b*c)                                                                       2080            Hrs
                       Less:
                     j) Compensated Non-Work Hours Per Year (a*h)                                                                              240            Hrs
                     k) Other Compensated Time                                                                                                   0
                     Total, Direct Productive Person-Hrs (DPPH) (i-(j+k))                                                                     1840            Hrs

                                 CALCULATE 'RATES AND FACTORS' WITH COMBINED FRINGE/OVERHEAD RATE
                                                       Category                                                                       $ or Hrs               Rate               %            Total $'s
                     Base Hourly Rate                                                                                                                  $         50.00
                     Compensated Hours Per Year                                                                                                                  2,080
                     Annual Salary (based on Number of Working Hrs Per Year)                                                                           $    104,000.00

                     Direct Productive Person-Hours (DPPH)                                                                                                        1,840
                                                                           Direct Labor Base (DPPH * Hrly Rate)                                        $     92,000.00                   $ 92,000.00

                     Vacation and Personal Leave:
                     Vacation and Personal Leave (Hrs)                                                                                  160            $      8,000.00
                     Federal and Other Holiday Hrs                                                                                      80             $      4,000.00
                     Other Leave (Hrs)                                                                                                   0             $           -
                                                              Subtotal, Vacation and Personal Leave                                     240            $     12,000.00                   $ 12,000.00
                     Health & Welfare:
                     Health Insurance Premium - Monthly (Medical / Dental / Eye)                      $    1,200.00                                    $     14,400.00
                     Other Insurance Premiums - Monthly                                               $      100.00                                    $      1,200.00
                     Short - Term Disability (<90 Days) Insurance Premium Per Month                   $      150.00                                    $      1,800.00
                     Long - Term Disability (>90 Days) Insurance Premium Per Month                    $      300.00                                    $      3,600.00
                                                                                       Subtotal, Health and Welfare                                    $     21,000.00                   $ 21,000.00
                     Combined Fringes and Overhead Burdens:
                     401K/SEP (Corporate Match)                                                           5.0%                                         $       5,200.00
                     Employer's FICA Match (CY07 - 6.2%; Max Wage/Tax is $97,500; $6045)                 6.20%                                         $       6,045.00
                     Employer's Medicaid Match (1.45% with No Limit on Tax)                              1.45%                                         $       1,508.00
                     FUTA (Fed Unemployment is 6.2% to $7,000 Max)                                       6.20%                                         $       6,448.00
                     SUTA (State Unemployment in VA is 2.6% - 6.2% to 8000)                              2.60%                                         $       2,704.00
                     General Office Space                                                             $         -                                      $            -
                     Computer Hardware (Annual)                                                       $    1,500.00                                    $       1,500.00
                     Computer SW (Annual License Expense)                                             $    1,000.00                                    $       1,000.00
                     Other                                                                            $         -                                      $            -
                     Cell Phone (Business Use)                                                        $      125.00                                    $       1,500.00
                     Office and Misc. Business Supplies                                               $       75.00                                    $         900.00
                     Other                                                                            $         -                                      $            -
                     Other                                                                            $         -                                      $            -
                     Depreciation, Various Assets                                                                                 $            -       $              -
                                                                                                                                  Subtotal $    26,805.00         $ 26,805.00
                                                                                                            Subtotal, All Fringe Benefits, Overheads, and Burdens $ 59,805.00

                                                                                                                        Subtotal, Direct/Indirect Costs $ 151,805.00
                                                                                     Combined Fringes and Overhead/Burden Rate on Direct Costs 65.01%

                     General & Administration G&A Expenses:
                     Accounting/Legal Fees (State/Federal Taxes, and Incurred Cost Submissions)                                  $   1,500.00          $       1,500.00
                     Business and Professional Occupation Licenses (BPOL) and Taxes                                              $       0.30          $         312.00
                     Administrative Hours Per Month (Non-Billable Expenses)                                                               2.0          $         100.00
                     Payroll expenses (checking/Invoicing)                                                                      $      100.00          $       1,200.00
                     Other                                                                                                      $         -            $            -
                     Bid & Proposal (B&P) Hours Per Year (Non-Billable Expenses)                                                          8.0          $         400.00
                     Other                                                                                                      $         -            $            -
                     Other                                                                                                      $         -            $            -
                                                                                                                             Total, G&A Costs          $       3,512.00                  $     3,512.00

                                                                                                                                                    Subtotal, Cost Thru G&A $ 155,317.00
                                                                                                                                                     G&A (Per Cent) 2.31%

                                                                                                                                                                      Fee     6.90% $ 10,716.87

                                                                                                                 Annualized Cost to the Client (Billing Rate * DPPH) $ 166,033.87
                                                                                                                                           Hourly Billing (Sell) Rate $     90.24
                                                                                                                                                           Multiplier        180%



Rates and Factors Estimator
Version 1.0 - 4/29/07                                                                                      Page 1                                                               53ef2f8c-0d8e-456f-849e-c9075289afbf.xls