Can I get help with this problem.

4. Sylva Manufacturing purchase one of its essential raw materials from four suppliers (Acme, Berg, Card, and Delta) . The current policy is to give each supplier an equal amount of raw material orders. However, Ann Bird, proposes that these suppliers be rated (high numbers indicate good performance) on six performance criteria weighted as shown in the table. She wants a score hurdle of 6.0 to screen suppliers. Suppliers whose overall ratings fall below 0.60 would not be considered. Purchasing policy would be revised to order raw materials whose scores are greater than the hurdle score in proportion to their performance rating scores (e.g. If three suppliers had scores of 9.5,8.2, and 7.3 - the supplier with the 8.2 score would get (8.2/(9.5+8.2+7.3))32.8% of the orders.) Answer the following questions: - Determine the overall rating for each supplier and the percentage of the raw material orders each supplier should receive based on the hurdle score. Place this information in the above table. Show 1 decimal point for the overall rating and the proportion of orders should be formatted as percentages showing one decimal place (e.g., 12.3% not 0.123 or 12% ) - What are the advantages of using a policy that divides the orders up among suppliers as above rather than giving an equal proportion of orders to each supplier