I need help for this question. I have completed task a and b , but in task c, I think it has some problems as my result and my classmates's are not the same. I really need assistance for task c and d,e,f, because I don't really understand about the shadow price mentioned. In task d, I can create a sensitivity report but I don't know how to define what is shadow price. I'm very graterful if you can help me. This is a extremely challenging subject for me. I has attached below the questions, result that I think is exact for task b. Thank you so much for assisting me.

1 le UDT is a consulting firm that develops e-commerce project, systems and websites for its clients. It has six available consultants and eight clients project is under contract. The consultants have different technical abilities and experience, and as a result, the company charges different hourly rates for its services. Also, the consultant's skill are more suited for some projects than others, and clients sometimes prefer some consultants over others. 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 following table shows the rating for each consultant for each project, as well as the hours available for each consultant and the contracted hours and maximum budget for each project: Project Consultant Hourly 2 3 4 5 6 7 8 Available wage hours A $155 3 3 5 5 3 3 3 3 450 B $140 3 3 2 5 5 5 3 600 $165 2 3 3 2 1 5 3 500 D $300 1 3 1 1 2 2 300 E $270 3 1 2 2 1 3 3 710 F $150 5 2 5 3 860 Project 500 240 400 475 350 460 290 200 Hours Contract 100 80 120 90 65 50 55 budget (x1000 USD) W . 3 MUA 1 5 1 1 4 w 3 3 4 85 The company wants to know how many hours to assign each consultant to each project in order to best utilize their skill while meeting clients needs a Formulate a linear programming model and write down the mathematical model for this problem b. Solve this problem using QM and SOLVER c. If the company want to maximize revenue while ignoring client preferences and consultant compatibility, will this change the solution in b.? d. Create a sensitivity report. What is the shadow price in this case ? e. If consultant A and E change their hourly wage from $155 to $200 (A) and from $270 to $200, will the solution change? f. By exprerience, consultant B and E is getting better at their ability, which mean their capacity for every project now minimum start from 3 instead of 1 or 2, will the shadow 1 DATA Project Hourly wege ($1 155 ! 4 8 Consultant B 1 140 165 3 3 2 2 3 4 C D E F 2 3 3 1 3 1 5 3 5 2 3 1 1 3 5 5 3 1 2 2 5 3 5 2 2 2 3 6 3 5 1 2 1 5 7 3 3 5 5 3 4 3 3 3 1 3 3 300 220 150 Project Total hours of Consultant Available hours 5 7 8 5 0 350 5 36 Consultant A B C D E F Total hours of each Project 1 ol 0 ol 208 2 0 0 96) 0 1441 3 189 0 211 0 o 4 261 214 0 0 0 0 Olodol 0 0 ol 0 200 0 289 1 0 450 600 500 97 408 860 3 5 s S s 450 600 500 300 710 860 0 0 0 0 292 424 $ 500 240 400 475 350 460 290 200 . Contract hours 500 240 400 475 350 450 290 200 Total budget of each Project 99960 5 50400 s 54110 s 70415 S 49000 s 58640 s 47985 s 54000 5 RESULT Max mix consultant skills with client's need 12853 Contract budoe/USD) 100000 80000 120000 90000 65000 85000 50000 55000 1 le UDT is a consulting firm that develops e-commerce project, systems and websites for its clients. It has six available consultants and eight clients project is under contract. The consultants have different technical abilities and experience, and as a result, the company charges different hourly rates for its services. Also, the consultant's skill are more suited for some projects than others, and clients sometimes prefer some consultants over others. 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 following table shows the rating for each consultant for each project, as well as the hours available for each consultant and the contracted hours and maximum budget for each project: Project Consultant Hourly 2 3 4 5 6 7 8 Available wage hours A $155 3 3 5 5 3 3 3 3 450 B $140 3 3 2 5 5 5 3 600 $165 2 3 3 2 1 5 3 500 D $300 1 3 1 1 2 2 300 E $270 3 1 2 2 1 3 3 710 F $150 5 2 5 3 860 Project 500 240 400 475 350 460 290 200 Hours Contract 100 80 120 90 65 50 55 budget (x1000 USD) W . 3 MUA 1 5 1 1 4 w 3 3 4 85 The company wants to know how many hours to assign each consultant to each project in order to best utilize their skill while meeting clients needs a Formulate a linear programming model and write down the mathematical model for this problem b. Solve this problem using QM and SOLVER c. If the company want to maximize revenue while ignoring client preferences and consultant compatibility, will this change the solution in b.? d. Create a sensitivity report. What is the shadow price in this case ? e. If consultant A and E change their hourly wage from $155 to $200 (A) and from $270 to $200, will the solution change? f. By exprerience, consultant B and E is getting better at their ability, which mean their capacity for every project now minimum start from 3 instead of 1 or 2, will the shadow 1 DATA Project Hourly wege ($1 155 ! 4 8 Consultant B 1 140 165 3 3 2 2 3 4 C D E F 2 3 3 1 3 1 5 3 5 2 3 1 1 3 5 5 3 1 2 2 5 3 5 2 2 2 3 6 3 5 1 2 1 5 7 3 3 5 5 3 4 3 3 3 1 3 3 300 220 150 Project Total hours of Consultant Available hours 5 7 8 5 0 350 5 36 Consultant A B C D E F Total hours of each Project 1 ol 0 ol 208 2 0 0 96) 0 1441 3 189 0 211 0 o 4 261 214 0 0 0 0 Olodol 0 0 ol 0 200 0 289 1 0 450 600 500 97 408 860 3 5 s S s 450 600 500 300 710 860 0 0 0 0 292 424 $ 500 240 400 475 350 460 290 200 . Contract hours 500 240 400 475 350 450 290 200 Total budget of each Project 99960 5 50400 s 54110 s 70415 S 49000 s 58640 s 47985 s 54000 5 RESULT Max mix consultant skills with client's need 12853 Contract budoe/USD) 100000 80000 120000 90000 65000 85000 50000 55000