Price Proposal Spreadsheet by uqu13199

VIEWS: 15 PAGES: 5

									                                                                                                               Freeway Service Patrol RFP 2009
                                                                                                                                   Appendix B
                                                                                                                  Required Proposal Documents

FORM G. PRICE PROPOSAL SPREADSHEET
                                                        Contractor:                                    Beat:
Items                                                   Units                                          Costs
                                                                           No. of        Cost per
A. Vehicles & Equipment                                           Unit     Items          Unit           Total Cost         % of T Cost
1. Vehicles
a. Tow Trucks                                           trucks                      1             $1                  $1          100.00%
b. Pick-up Trucks                                       trucks                                                        $0            0.00%
2. Finance Charges                                      trucks                                                        $0            0.00%
3. Insurance & Vehicle Registration Fees                trucks                                                        $0            0.00%
4. Fuel
a. Tow Trucks                                           gallons                               $4.00                   $0             0.00%
b. Pick-up Trucks                                       gallons                                                       $0             0.00%
c. Motorist                                             gallons                                                       $0             0.00%
5. Vehicle Maintenace
a. Parts Replacement                                    trucks                                                        $0            0.00%
b. Labor                                                hours                                                         $0            0.00%
6. FSP Equipment/Supplies (Refer to Appendix D )        trucks                                                        $0            0.00%
Subtotal A (Vehicles & Equipment)                                                                                     $1          100.00%
                                                                           No. of        Cost per
B. Management & Drivers                                           Unit     Items          Unit           Total Cost         % of T Cost
7. FSP Management Costs                                 year                                                       $0              0.00%
8. FSP Driver Costs
 a. Wages (# of Drivers_______)                         hours                       1                                 $0             0.00%
 b. Workers Compensation                                driver                                                        $0             0.00%
 c. Taxes                                               driver                                                        $0             0.00%
9. FSP Driver Benefits
a. Vacation/Holidays/Sick Days                          driver                                                        $0            0.00%
b. Retirement                                           driver                                                        $0            0.00%
c. Medical, Dental, Vision                              driver                                                        $0            0.00%
10. Driver Admin (Pre-op Inspections, Training, etc.)   hours                                                         $0            0.00%
Subtotal B (Management & Drivers)                                                                                     $0            0.00%
                                                                           No. of        Cost per
C. Administration                                                 Unit     Items          Unit           Total Cost         % of T Cost
11. Administrative Costs - Office Operations            year                                                       $0              0.00%
12. Other (please specify)                                                                                         $0              0.00%
Subtotal C (Administration)                                                                                        $0              0.00%

D. Final Cost Calculation
13. Total Cost (Subtotal A + B + C)                                                                                $1
14. Subtract Equipment Salvage Value                                     Trucks         $ Value        Total Salvage Value
a. Tow Trucks                                                                1                                     $0
b. Pick-up                                                                   0                                     $0
15. Add Profit                                                                                                                       0.00%
16. Net Cost (item 13 - 14+ 15)                                                                                       $1
17. Total Contract Hours (Refer to Implemenation Plan in Appendix A )                                                  1
18. COST PER HOUR PER TRUCK (item 16/17)                                                                           $1.00
                                                                                                       Freeway Service Patrol RFP 2004
                                                                                                                           Appendix B
                                                                                                          Required Proposal Documents
                                                                                                                               Page 39
FORM G. PRICE PROPOSAL SPREADSHEET
                                                      Contractor:                                  Beat:
Items                                                 Units                                        Costs
                                                                          No. of        Cost per
A. Vehicles & Equipment                                         Unit      Items          Unit        Total Cost      % of T Cost
1. Vehicles
a. Tow Trucks                                         Trucks                                                   $0        #DIV/0!
b. Pick-up Trucks                                     Trucks                                                   $0        #DIV/0!
2. Finance Charges                                    Trucks                                                   $0        #DIV/0!
3. Insurance & Vehicle Registration Fees              Trucks                                                   $0        #DIV/0!
4. Fuel
a. Tow Trucks                                         gallons                                                  $0        #DIV/0!
b. Pick-up Trucks                                     gallons                                                  $0        #DIV/0!
c. Motorist                                           gallons                                                  $0        #DIV/0!
5. Vehicle Maintenace
a. Parts Replacement                                  trucks                                                   $0        #DIV/0!
b. Labor                                              trucks                                                   $0        #DIV/0!
6. FSP Equipment/Supplies (Refer to Appendix D )      trucks                                                   $0        #DIV/0!
Subtotal A (Vehicles & Equipment)                                                                              $0        #DIV/0!
                                                                          No. of        Cost per
B. Management & Drivers                                         Unit      Items          Unit        Total Cost      % of T Cost
7. FSP Management Costs                               year                                                     $0     #DIV/0!
8. FSP Driver Costs
 a. Wages (# of Drivers_______)                       hours                        0                           $0        #DIV/0!
 b. Workers Compensation                              driver                                                   $0        #DIV/0!
 c. Taxes                                             driver                                                   $0        #DIV/0!
9. FSP Driver Benefits
a. Vacation/Holidays/Sick Days                        driver                                                   $0        #DIV/0!
b. Retirement                                         driver                                                   $0        #DIV/0!
c. Medical, Dental, Vision                            driver                                                   $0        #DIV/0!
10. Training (Qtrly Refresher, Safety Mtgs., etc.)    driver                                                   $0        #DIV/0!
Subtotal B (Management & Drivers)                                                                              $0        #DIV/0!
                                                                          No. of        Cost per
C. Administration                                               Unit      Items          Unit        Total Cost      % of T Cost
11. Administrative Costs - Office Operations          year                                                     $0     #DIV/0!
12. Other (please specify)                                                                                     $0     #DIV/0!
Subtotal C (Administration)                                                                                    $0     #DIV/0!

D. Final Cost Calculation
13. Total Cost (Subtotal A + B + C)                                                                            $0
14. Subtract Equipment Salvage Value                                    Trucks         $ Value     Total Salvage Value
a. Tow Trucks                                                                0                                 $0
b. Pick-up                                                                   0                                 $0
15. Add Profit                                                                                                           #DIV/0!
16. Net Cost (item 13 - 14+ 15)                                                                                $0
17. Total Contract Hours (Refer to Implemenation Plan in Appendix A )
19. COST PER HOUR PER TRUCK (item 16/17)                                                                   #DIV/0!
FORM G. PRICE PROPOSAL SPREADSHEET
                                                      Contractor:                                  Beat:
Items                                                 Units                                        Costs
                                                                          No. of        Cost per
A. Vehicles & Equipment                                         Unit      Items          Unit        Total Cost      % of T Cost
1. Vehicles
a. Tow Trucks                                         Trucks                                                   $0        #DIV/0!
b. Pick-up Trucks                                     Trucks                                                   $0        #DIV/0!
2. Finance Charges                                    Trucks                                                   $0        #DIV/0!
3. Insurance & Vehicle Registration Fees              Trucks                                                   $0        #DIV/0!
4. Fuel
a. Tow Trucks                                         gallons                                                  $0        #DIV/0!
b. Pick-up Trucks                                     gallons                                                  $0        #DIV/0!
c. Motorist                                           gallons                                                  $0        #DIV/0!
5. Vehicle Maintenace
a. Parts Replacement                                  trucks                                                   $0        #DIV/0!
b. Labor                                              trucks                                                   $0        #DIV/0!
6. FSP Equipment/Supplies (Refer to Appendix D )      trucks                                                   $0        #DIV/0!
Subtotal A (Vehicles & Equipment)                                                                              $0        #DIV/0!
                                                                          No. of        Cost per
B. Management & Drivers                                         Unit      Items          Unit        Total Cost      % of T Cost
7. FSP Management Costs                               year                                                     $0     #DIV/0!
8. FSP Driver Costs
 a. Wages (# of Drivers_______)                       hours                        0                           $0        #DIV/0!
 b. Workers Compensation                              driver                                                   $0        #DIV/0!
 c. Taxes                                             driver                                                   $0        #DIV/0!
9. FSP Driver Benefits
a. Vacation/Holidays/Sick Days                        driver                                                   $0        #DIV/0!
b. Retirement                                         driver                                                   $0        #DIV/0!
c. Medical, Dental, Vision                            driver                                                   $0        #DIV/0!
10. Training (Qtrly Refresher, Safety Mtgs., etc.)    driver                                                   $0        #DIV/0!
Subtotal B (Management & Drivers)                                                                              $0        #DIV/0!
                                                                          No. of        Cost per
C. Administration                                               Unit      Items          Unit        Total Cost      % of T Cost
11. Administrative Costs - Office Operations          year                                                     $0     #DIV/0!
12. Other (please specify)                                                                                     $0     #DIV/0!
Subtotal C (Administration)                                                                                    $0     #DIV/0!

D. Final Cost Calculation
13. Total Cost (Subtotal A + B + C)                                                                            $0
14. Subtract Equipment Salvage Value                                    Trucks         $ Value     Total Salvage Value
a. Tow Trucks                                                                0                                 $0
b. Pick-up                                                                   0                                 $0
15. Add Profit                                                                                                           #DIV/0!
16. Net Cost (item 13 - 14+ 15)                                                                                $0
17. Total Contract Hours (Refer to Implemenation Plan in Appendix A )
19. COST PER HOUR PER TRUCK (item 16/17)                                                                   #DIV/0!
FORM G. PRICE PROPOSAL SPREADSHEET
                                                      Contractor:                                  Beat:
Items                                                 Units                                        Costs
                                                                          No. of        Cost per
A. Vehicles & Equipment                                         Unit      Items          Unit        Total Cost      % of T Cost
1. Vehicles
a. Tow Trucks                                         Trucks                                                   $0        #DIV/0!
b. Pick-up Trucks                                     Trucks                                                   $0        #DIV/0!
2. Finance Charges                                    Trucks                                                   $0        #DIV/0!
3. Insurance & Vehicle Registration Fees              Trucks                                                   $0        #DIV/0!
4. Fuel
a. Tow Trucks                                         gallons                                                  $0        #DIV/0!
b. Pick-up Trucks                                     gallons                                                  $0        #DIV/0!
c. Motorist                                           gallons                                                  $0        #DIV/0!
5. Vehicle Maintenace
a. Parts Replacement                                  trucks                                                   $0        #DIV/0!
b. Labor                                              trucks                                                   $0        #DIV/0!
6. FSP Equipment/Supplies (Refer to Appendix D )      trucks                                                   $0        #DIV/0!
Subtotal A (Vehicles & Equipment)                                                                              $0        #DIV/0!
                                                                          No. of        Cost per
B. Management & Drivers                                         Unit      Items          Unit        Total Cost      % of T Cost
7. FSP Management Costs                               year                                                     $0     #DIV/0!
8. FSP Driver Costs
 a. Wages (# of Drivers_______)                       hours                        0                           $0        #DIV/0!
 b. Workers Compensation                              driver                                                   $0        #DIV/0!
 c. Taxes                                             driver                                                   $0        #DIV/0!
9. FSP Driver Benefits
a. Vacation/Holidays/Sick Days                        driver                                                   $0        #DIV/0!
b. Retirement                                         driver                                                   $0        #DIV/0!
c. Medical, Dental, Vision                            driver                                                   $0        #DIV/0!
10. Training (Qtrly Refresher, Safety Mtgs., etc.)    driver                                                   $0        #DIV/0!
Subtotal B (Management & Drivers)                                                                              $0        #DIV/0!
                                                                          No. of        Cost per
C. Administration                                               Unit      Items          Unit        Total Cost      % of T Cost
11. Administrative Costs - Office Operations          year                                                     $0     #DIV/0!
12. Other (please specify)                                                                                     $0     #DIV/0!
Subtotal C (Administration)                                                                                    $0     #DIV/0!

D. Final Cost Calculation
13. Total Cost (Subtotal A + B + C)                                                                            $0
14. Subtract Equipment Salvage Value                                    Trucks         $ Value     Total Salvage Value
a. Tow Trucks                                                                0                                 $0
b. Pick-up                                                                   0                                 $0
15. Add Profit                                                                                                           #DIV/0!
16. Net Cost (item 13 - 14+ 15)                                                                                $0
17. Total Contract Hours (Refer to Implemenation Plan in Appendix A )
19. COST PER HOUR PER TRUCK (item 16/17)                                                                   #DIV/0!
                                                                                                       Freeway Service Patrol RFP 2004
                                                                                                                           Appendix B
                                                                                                          Required Proposal Documents
                                                                                                                               Page 39
FORM G. PRICE PROPOSAL SPREADSHEET
                                                      Contractor:                                  Beat:
Items                                                 Units                                        Costs
                                                                          No. of        Cost per
A. Vehicles & Equipment                                         Unit      Items          Unit        Total Cost      % of T Cost
1. Vehicles
a. Tow Trucks                                         Trucks                                                   $0        #DIV/0!
b. Pick-up Trucks                                     Trucks                                                   $0        #DIV/0!
2. Finance Charges                                    Trucks                                                   $0        #DIV/0!
3. Insurance & Vehicle Registration Fees              Trucks                                                   $0        #DIV/0!
4. Fuel
a. Tow Trucks                                         gallons                                                  $0        #DIV/0!
b. Pick-up Trucks                                     gallons                                                  $0        #DIV/0!
c. Motorist                                           gallons                                                  $0        #DIV/0!
5. Vehicle Maintenace
a. Parts Replacement                                  trucks                                                   $0        #DIV/0!
b. Labor                                              trucks                                                   $0        #DIV/0!
6. FSP Equipment/Supplies (Refer to Appendix D )      trucks                                                   $0        #DIV/0!
Subtotal A (Vehicles & Equipment)                                                                              $0        #DIV/0!
                                                                          No. of        Cost per
B. Management & Drivers                                         Unit      Items          Unit        Total Cost      % of T Cost
7. FSP Management Costs                               year                                                     $0     #DIV/0!
8. FSP Driver Costs
 a. Wages (# of Drivers_______)                       hours                        0                           $0        #DIV/0!
 b. Workers Compensation                              driver                                                   $0        #DIV/0!
 c. Taxes                                             driver                                                   $0        #DIV/0!
9. FSP Driver Benefits
a. Vacation/Holidays/Sick Days                        driver                                                   $0        #DIV/0!
b. Retirement                                         driver                                                   $0        #DIV/0!
c. Medical, Dental, Vision                            driver                                                   $0        #DIV/0!
10. Training (Qtrly Refresher, Safety Mtgs., etc.)    driver                                                   $0        #DIV/0!
Subtotal B (Management & Drivers)                                                                              $0        #DIV/0!
                                                                          No. of        Cost per
C. Administration                                               Unit      Items          Unit        Total Cost      % of T Cost
11. Administrative Costs - Office Operations          year                                                     $0     #DIV/0!
12. Other (please specify)                                                                                     $0     #DIV/0!
Subtotal C (Administration)                                                                                    $0     #DIV/0!

D. Final Cost Calculation
13. Total Cost (Subtotal A + B + C)                                                                            $0
14. Subtract Equipment Salvage Value                                    Trucks         $ Value     Total Salvage Value
a. Tow Trucks                                                                0                                 $0
b. Pick-up                                                                   0                                 $0
15. Add Profit                                                                                                           #DIV/0!
16. Net Cost (item 13 - 14+ 15)                                                                                $0
17. Total Contract Hours (Refer to Implemenation Plan in Appendix A )
19. COST PER HOUR PER TRUCK (item 16/17)                                                                   #DIV/0!

								
To top