Problem II 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

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).

Problem II 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 ($) A 155 B 140 165 D 300 E 270 F 150 Contract Hours Contract Budget ($) 1 3 3 2 1 3 4 500 100000 2 3 3 1 3 1 5 240 80000 Project 3 4 5 5 5 3 2 5 5 3 3 2 1 1 2 1 2 2 3 2 3 400 475 350 120000 90000 65000 6 3 5 1 2 7 3 3 5 5 3 4 290 50000 8 3 3 3 1 3 3 200 55000 Available Hours 450 600 500 300 710 860 1 5 460 85000 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)