Please answer the question by using solver in excel.

Problem 11 Zapperi Blitz is an e-commerce consultant company that develops website platforms that ties up with supply chain management. It has six available consultants and eight client projects under exclusive contract. Each consultant is distinct from one another in terms of technical abilities and experience. And because of this, each consultant has different hourly rates. Consultant's skills fit for some projects than others. Also, some clients express their own preferences and compatibility. The suitability of a consultant for a project is rated according to a 5 point scale in which 1 is the worst and 5 is the best. The table below shows the rating for each respective consultant for each project including the hours available for each consultant and the contracted hours and maximum budget for each project. Hourly Consultant Rate ($) 155 140 165 D 300 E 270 F 150 Contract Hours Contract Budget ($) Project 2 4 5 6 7 8 3 5 3 3 3 3 - 3 3 2 555 33 2 3 21 5 1 3 2 2 5 1 31 12 2 1 3 3 4 5 3 2 3 5 4 3 500 240400475350460290200 100000 80000 120000 90000 65000 85000 50000 55000 Available Hours 450 600 500 300 710 860 The company wants to know how many hours will be assigned to each consultant to each project in order to best utilize the consultants' skills while meeting the client's needs. Formulate and solve the above problem using LP of MS Excel (Solver)