Sh3Please help me. As the buyer for the city of Perrysburg, you are evaluating a supplier for garbage cans to be used in the city's parks. Three suppliersreturned acceptable bids within the allotted time frame.CategoryDesignDeliveryWarrantyPriceWeight13%27820%40%Supplier ASupplier BSupplier CSupplier ARating42Answer is complete but not entirely correct.Total WeightedScore21433.003.54PictureClick here for the Excel Data FileAll scores on a five-point scale with 1-poor, 5= excellent.a. Calculate the total weighted score for each supplier. (Round your answers to 2 decimal places.)Supplier BRating:2224Supplier CRating2524

The question is based on the concept of Financial Accounting. Weighted average is the sum of the…

As the buyer for the rrysburg, you are evaluating a supplier organ returned acceptable bids within the allotted time frame. Category Design Delivery Warranty Price Weight 138 27% 20% 40% Supplier A Rating 4 2 3 Supplier B Rating 2 2 2 4 Supplier C Rating 2 5 2 4 PictureClick here for the Excel Data File All scores on a five-point scale with 1-poor, 5= excellent. a. Calculate the total weighted score for each supplier. (Round your answers to 2 decimal places.)