Need to evaluate the best possible supplier in the attached case study below.

kor is sourcing Facilities Management Services for one of our clients, with over stores operating in US and Canada  kor wants to help the client with supply base rationalization and volume leveraging for creating cost efficiencies in US and Canada  Services in scope include Janitorial Services, Landscaping, Snow Removal, Pest Control, and other Maintenance Services (HVAC, Electrical / Lighting, Plumbing)   The "Plumbing Bids" tab here contains data / response received from various suppliers on Plumbing Services   Can you please develop an "Evaluation Model", which could help the Sourcing Manager take informed decisions? You are free to create any number of additional sheets to perform the analysis.

However, there should be a "Summary Sheet" which summarizes the analysis performed.

              City Information   Supplier1 Supplier2 Supplier3 State / Prov City No of Facilities Total Facility Area (in ' sq feet)   Hourly Rate for Straight Time  (USD) Hourly Rate for Overtime  (USD) Hourly Rate for Holidays and Sundays  (USD) Hourly Rate for Straight Time  (USD) Hourly Rate for Overtime  (USD) Hourly Rate for Holidays and Sundays  (USD) Hourly Rate for Straight Time  (USD) Hourly Rate for Overtime  (USD) Hourly Rate for Holidays and Sundays  (USD) CA Chino 2 .1    $ .  $ .  $ .        $ .  $ .  $ . CA Dinuba 1    $ .  $ .  $ .        $ .  $ .  $ . CA Livermore 2    $ .  $ .  $ .        $ .  $ .  $ . CO Aurora 2    $ .  $ .  $ .        $ .  $ .  $ . FL Davenport 2    $  -    $  -    $  -          $ .  $ .  $ . GA Dublin 1    $  -    $  -    $  -          $ .  $ .  $ . GA Suwanee 2    $  -    $  -    $  -          $ .  $ .  $ . IL Woodridge 2 .6    $  -    $  -    $  -          $ .  $ .  $ . IN Franklin 1    $  -    $  -    $  -          $ .  $ .  $ . KY Shepherdsville 1    $  -    $  -    $  -          $ .  $ .  $ . MD Elkridge 2    $  -    $  -    $  -          $ .  $ .  $ . MN Bloomington 3    $  -    $  -    $  -          $ .  $ .  $ . MO Earth City 2    $  -    $  -    $  -          $ .  $ .  $ . NJ Perth Amboy 2    $  -    $  -    $  -          $ .  $ .  $ . NY Nichols 1    $  -    $  -    $  -          $ .  $ .  $ . OH Findlay 1    $  -    $  -    $  -          $ .  $ .  $ . OH Solon 2    $  -    $  -    $  -          $ .  $ .  $ . OK Ardmore 1    $  -    $  -    $  -          $ .  $ .  $ . TX Flower Mound 2    $  -    $  -    $  -          $ .  $ .  $ . VA Staunton 1    $  -    $  -    $  -          $ .  $ .  $ . WA Kent 2    $ .  $ .  $ .        $ .  $ .  $ . MA Bellingham 2    $ .  $ .  $ .        $ .  $ .  $ .