أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
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 $ . $ . $ . $ . $ . $ .
