Please screen shot the excel sheet, and all explanations.

Problem 6-05 Premier Consulting's two consultants, Avery and Baker, can be scheduled to work for clients up to a maximum of 160 hours each over the next four weeks. A third consultant, Campbell, has some administrative assignments already planned and is available for clients up to a maximum of 140 hours over the next four weeks. The company has four clients with projects in process. The estimated hourly requirements for each of the clients over the four-week period are as follows: Client Hours 180 B 75 C 100 D 85 Hourly rates vary for the consultant-client combination and are based on several factors, including project type and the consultant's experience. The rates (dollars per hour) for each consultant-client combination are as follows: Client Consultant A B D Avery 100 125 115 100 Baker 120 135 115 120 Campbell 155 150 140 130 a. Choose the correct network representation of the problem. (0) (ii) 100 180 180 A 1 120 100 125 155 160 Avery 1 Avery 1 160 115 100 125 75 75 B 3 135 120 135 150 160 Baker 2 115 Baker 2 160 115 120 100 100 C 115 155 150 140 140 Campbell 3 Campbell 140 120 130 85 85 D 4 130 (iv) 100 180 180 A 1 125 100 120 115 160 Avery 1 Avery 1 160 155 125 100 75 B 2 75 B 2 120 135 135 140 Baker 2 150 Baker 2 140 115 115 100 100 120 3 140 155 140 Campbell 100 Campbell 3 140 3 150 120 140 130 D 4 85 85 D 4 130 b. Formulate the problem as a linear program, with the optimal solution providing the hours each consultant should be scheduled for each client to maximize the consulting firm's billings. What is the schedule and what is the total billing? If the constant is "1" it must be entered in the box. If your answer is zero, enter "0". Let Xij = number of hours from consultant i assigned to client j. 100 125 115 100 120 135 115 Max X11 X12 X13 X14 X21 X22 X23 120 155 150 140 130 + X32 + X24 + X33 + |X31 X34 1 1 1 1 s.t. 160 X11 X12 X13 X14 1 1 1 1 + X22 160 X21 | X23 X24 1 1 1 1 s 140 X31 X32 X33 X34 1 1 1 = 180 | X11 X21 X31 1 1 1 75 X12 X22 X32 1 1 1 100 X13 X23 X33 1 1 1 85 X14 | X24 |x34 Xij 2 0 for all i, j Hours Assigned Billing Avery-Client A 0 Avery-Client B 40 5,000 Avery-Client C 100 11,500 Avery-Client D o o Baker-Client A 40 4,800 Baker-Client B 35 4,725 Baker-Client C 0 0 Baker-Client D 85 10,200 Campbell-Client A 140 21,700 Campbell-Client B 0 0 Campbell-Client C 0 o Campbell-Client D 0 o Total Billing $ 57,925 c. New information shows that Avery doesn't have the experience to be scheduled for client B. If this consulting assignment is not permitted, what impact does it have on total billings? What is the revised schedule? If your answer is zero, enter "0". Hours Assigned Billing, $ 4,800 X Avery-Client A 40 Avery-Client B o o Avery-Client C 100 11,500 Avery-Client D o o Baker-Client A 0 0 Baker-Client B B 75 10,125 Baker-Client C o 0 Baker-Client D 85 10,200 Campbell-Client A 140 21,700 Campbell-Client B o 0 Campbell-Client C o 0 Campbell-Client D 0 0 Total Billing 58,325 X