30 Route Template - Excel

Document Sample
30 Route Template - Excel Powered By Docstoc
					     Pricing Submission Summary Sheet
Cluster Name:       Anytown                                             Operator Name: ACME Taxi Co.                                                                      Effective Date: 1/03/2008
                                                 (Note: all cost values are exclusive of GST)

                                        No.                                  Student                                              Variable                                     Total Daily Total Daily
          Vehicle    Subcontracted                Distance     Days Run                   Total km Fixed Daily       Variable                  Variable Daily    Total Daily                             Total Weekly
Route                                Students                                Trips per                                           Daily Cost                                     Cost Per    Cost Per
           Type        (Yes/No)                    in km       per week                   per week    Cost          Daily Cost                  Cost Per km        Cost                                     Cost
                                      Carried                                  week                                              Per Capita                                      Capita       km

1         Van                Yes            24         86.0       3.0                72      258.0       $340.00       $520.00        $21.67            $6.05        $860.00       $35.83      $10.00       $2,580.00
1a        TMV                No             12         44.0       5.0                60      220.0       $133.00       $344.00        $28.67            $7.82        $477.00       $39.75      $10.84       $2,385.00
2         Bus                No             18         14.8       4.0                72       59.2       $240.00       $700.00        $38.89           $47.30        $940.00       $52.22      $63.51       $3,760.00
3         Other              Yes            10         25.0       5.0                50      125.0       $180.00       $290.00        $29.00           $11.60        $470.00       $47.00      $18.80       $2,350.00




      4             Totals                  64          662 km/week                254       662.2                                                                                                         $11,075.00
                                                        132 km/day                                                                                              Total Cluster Daily Price:                  $2,215.00
                                                                                                                                                                (= Grand Total Weekly Costs / 5)


Service Agent Use Only
Contract No. Students in Cluster:           50                          % of Routes Subcontracted: 50%             40% Threshold Exceeded                            Signed:
Variance No. Students:                      14
Reported No. Students correct?:        No                     Note: Overcost Routes (ie: Total Daily Cost Per Capita > $50.00) are highlighted                        Name:
     Pricing Submission Summary Sheet
Cluster Name:     Anytown                                           Operator Name: ACME Taxi Co.                                                               Effective Date: 1/03/2008
                                              (Note: all cost values are exclusive of GST)

                                      No.                               Student                                          Variable                                    Total Daily Total Daily
        Vehicle    Subcontracted               Distance    Days Run                 Total km Fixed Daily    Variable                  Variable Daily   Total Daily                             Total Weekly
Route                              Students                             Trips per                                       Daily Cost                                    Cost Per    Cost Per
         Type        (Yes/No)                   in km      per week                 per week    Cost       Daily Cost                  Cost Per km       Cost                                     Cost
                                    Carried                               week                                          Per Capita                                     Capita       km

1       Van            Yes               24         86.0      3.0              72      258.0     $340.00      $520.00        $21.67            $6.05      $860.00        $35.83      $10.00       $2,580.00
1a      TMV            No                12         44.0      5.0              60      220.0     $133.00      $344.00        $28.67            $7.82      $477.00        $39.75      $10.84       $2,385.00
2       Bus            No                18         14.8      4.0              72       59.2     $240.00      $700.00        $38.89           $47.30      $940.00        $52.22      $63.51       $3,760.00
3       Other          Yes               10         25.0      5.0              50      125.0     $180.00      $290.00        $29.00           $11.60      $470.00        $47.00      $18.80       $2,350.00
                                        No.                              Student                                            Variable                                     Total Daily Total Daily
          Vehicle    Subcontracted               Distance    Days Run                 Total km Fixed Daily     Variable                  Variable Daily    Total Daily                             Total Weekly
Route                                Students                            Trips per                                         Daily Cost                                     Cost Per    Cost Per
           Type        (Yes/No)                   in km      per week                 per week    Cost        Daily Cost                  Cost Per km        Cost                                     Cost
                                      Carried                              week                                            Per Capita                                      Capita       km




      4             Totals                  64        662 km/week               254      662.2                                                                                                       $11,075.00
                                                      132 km/day                                                                                          Total Cluster Daily Price:                  $2,215.00
                                                                                                                                                          (= Grand Total Weekly Costs / 5)


Service Agent Use Only
Contract No. Students in Cluster:           50                     % of Routes Subcontracted: 50%            40% Threshold Exceeded                            Signed:
Variance No. Students:                      14
Reported No. Students correct?:        No                   Note: Overcost Routes (ie: Total Daily Cost Per Capita > $50.00) are highlighted                    Name:
     Pricing Submission Summary Sheet
Cluster Name:     Anytown                                           Operator Name: ACME Taxi Co.                                                               Effective Date: 1/03/2008
                                              (Note: all cost values are exclusive of GST)

                                      No.                               Student                                          Variable                                    Total Daily Total Daily
        Vehicle    Subcontracted               Distance    Days Run                 Total km Fixed Daily    Variable                  Variable Daily   Total Daily                             Total Weekly
Route                              Students                             Trips per                                       Daily Cost                                    Cost Per    Cost Per
         Type        (Yes/No)                   in km      per week                 per week    Cost       Daily Cost                  Cost Per km       Cost                                     Cost
                                    Carried                               week                                          Per Capita                                     Capita       km

1       Van            Yes               24         86.0      3.0              72      258.0     $340.00      $520.00        $21.67            $6.05      $860.00        $35.83      $10.00       $2,580.00
1a      TMV            No                12         44.0      5.0              60      220.0     $133.00      $344.00        $28.67            $7.82      $477.00        $39.75      $10.84       $2,385.00
2       Bus            No                18         14.8      4.0              72       59.2     $240.00      $700.00        $38.89           $47.30      $940.00        $52.22      $63.51       $3,760.00
3       Other          Yes               10         25.0      5.0              50      125.0     $180.00      $290.00        $29.00           $11.60      $470.00        $47.00      $18.80       $2,350.00
                                     No.                           Student                                          Variable                                   Total Daily Total Daily
        Vehicle   Subcontracted              Distance   Days Run               Total km Fixed Daily    Variable                 Variable Daily   Total Daily                             Total Weekly
Route                             Students                         Trips per                                       Daily Cost                                   Cost Per    Cost Per
         Type       (Yes/No)                  in km     per week               per week    Cost       Daily Cost                 Cost Per km       Cost                                     Cost
                                   Carried                           week                                          Per Capita                                    Capita       km
                                        No.                              Student                                            Variable                                     Total Daily Total Daily
          Vehicle    Subcontracted               Distance    Days Run                 Total km Fixed Daily     Variable                  Variable Daily    Total Daily                             Total Weekly
Route                                Students                            Trips per                                         Daily Cost                                     Cost Per    Cost Per
           Type        (Yes/No)                   in km      per week                 per week    Cost        Daily Cost                  Cost Per km        Cost                                     Cost
                                      Carried                              week                                            Per Capita                                      Capita       km




      4             Totals                  64        662 km/week               254      662.2                                                                                                       $11,075.00
                                                      132 km/day                                                                                          Total Cluster Daily Price:                  $2,215.00
                                                                                                                                                          (= Grand Total Weekly Costs / 5)


Service Agent Use Only
Contract No. Students in Cluster:           50                     % of Routes Subcontracted: 50%            40% Threshold Exceeded                            Signed:
Variance No. Students:                      14
Reported No. Students correct?:        No                   Note: Overcost Routes (ie: Total Daily Cost Per Capita > $50.00) are highlighted                    Name:
                                                                                                   Page 7




     Pricing Submission Summary Sheet
Cluster Name:     Anytown                                           Operator Name: ACME Taxi Co.                                                               Effective Date: 1/03/2008
                                              (Note: all cost values are exclusive of GST)

                                      No.                               Student                                          Variable                                    Total Daily Total Daily
        Vehicle    Subcontracted               Distance    Days Run                 Total km Fixed Daily    Variable                  Variable Daily   Total Daily                             Total Weekly
Route                              Students                             Trips per                                       Daily Cost                                    Cost Per    Cost Per
         Type        (Yes/No)                   in km      per week                 per week    Cost       Daily Cost                  Cost Per km       Cost                                     Cost
                                    Carried                               week                                          Per Capita                                     Capita       km

1       Van            Yes               24         86.0      3.0              72      258.0     $340.00      $520.00        $21.67            $6.05      $860.00        $35.83      $10.00       $2,580.00
1a      TMV            No                12         44.0      5.0              60      220.0     $133.00      $344.00        $28.67            $7.82      $477.00        $39.75      $10.84       $2,385.00
2       Bus            No                18         14.8      4.0              72       59.2     $240.00      $700.00        $38.89           $47.30      $940.00        $52.22      $63.51       $3,760.00
3       Other          Yes               10         25.0      5.0              50      125.0     $180.00      $290.00        $29.00           $11.60      $470.00        $47.00      $18.80       $2,350.00
                                                                                             Page 8




                                     No.                           Student                                          Variable                                   Total Daily Total Daily
        Vehicle   Subcontracted              Distance   Days Run               Total km Fixed Daily    Variable                 Variable Daily   Total Daily                             Total Weekly
Route                             Students                         Trips per                                       Daily Cost                                   Cost Per    Cost Per
         Type       (Yes/No)                  in km     per week               per week    Cost       Daily Cost                 Cost Per km       Cost                                     Cost
                                   Carried                           week                                          Per Capita                                    Capita       km
                                                                                             Page 9




                                     No.                           Student                                          Variable                                   Total Daily Total Daily
        Vehicle   Subcontracted              Distance   Days Run               Total km Fixed Daily    Variable                 Variable Daily   Total Daily                             Total Weekly
Route                             Students                         Trips per                                       Daily Cost                                   Cost Per    Cost Per
         Type       (Yes/No)                  in km     per week               per week    Cost       Daily Cost                 Cost Per km       Cost                                     Cost
                                   Carried                           week                                          Per Capita                                    Capita       km
                                                                                             Page 10




                                     No.                           Student                                          Variable                                   Total Daily Total Daily
        Vehicle   Subcontracted              Distance   Days Run               Total km Fixed Daily    Variable                 Variable Daily   Total Daily                             Total Weekly
Route                             Students                         Trips per                                       Daily Cost                                   Cost Per    Cost Per
         Type       (Yes/No)                  in km     per week               per week    Cost       Daily Cost                 Cost Per km       Cost                                     Cost
                                   Carried                           week                                          Per Capita                                    Capita       km
                                                                                             Page 11




                                     No.                           Student                                          Variable                                   Total Daily Total Daily
        Vehicle   Subcontracted              Distance   Days Run               Total km Fixed Daily    Variable                 Variable Daily   Total Daily                             Total Weekly
Route                             Students                         Trips per                                       Daily Cost                                   Cost Per    Cost Per
         Type       (Yes/No)                  in km     per week               per week    Cost       Daily Cost                 Cost Per km       Cost                                     Cost
                                   Carried                           week                                          Per Capita                                    Capita       km
                                                                                                    Page 12




                                        No.                              Student                                            Variable                                     Total Daily Total Daily
          Vehicle    Subcontracted               Distance    Days Run                 Total km Fixed Daily     Variable                  Variable Daily    Total Daily                             Total Weekly
Route                                Students                            Trips per                                         Daily Cost                                     Cost Per    Cost Per
           Type        (Yes/No)                   in km      per week                 per week    Cost        Daily Cost                  Cost Per km        Cost                                     Cost
                                      Carried                              week                                            Per Capita                                      Capita       km




      4             Totals                  64        662 km/week               254      662.2                                                                                                       $11,075.00
                                                      132 km/day                                                                                          Total Cluster Daily Price:                  $2,215.00
                                                                                                                                                          (= Grand Total Weekly Costs / 5)


Service Agent Use Only
Contract No. Students in Cluster:           50                     % of Routes Subcontracted: 50%            40% Threshold Exceeded                            Signed:
Variance No. Students:                      14
Reported No. Students correct?:        No                   Note: Overcost Routes (ie: Total Daily Cost Per Capita > $50.00) are highlighted                    Name:

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:105
posted:11/16/2008
language:English
pages:12