v2.cengagenow.com C + 88 My Home C CengageNOWv2 | Online teaching and learning resource from Cengage Learning Search Results | Course Hero Topic 5 - Linear Programming: Distril Problem 10-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 100 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 B Avery 100 125 115 100 Bake 120 135 115 120 Campbell 155 150 140 130 a. Choose the correct network representation of the problem. (ii) 100 180 180 120 100 160 Avery 125 Avery 1 160 100 125 75 120 135 135 Baker 160 Baker 2 115 2 160 115 120 100 100 115 155 Previous Next Assignment Score: 0.0% All work saved. Save and Exit Submit Assignment for GradingID v2.cengagenow.com C + 88 My Home C CengageNOWv2 | Online teaching and learning resource from Cengage Learning Search Results | Course Hero Topic 5 - Linear Programming: Distril 100 115 155 130 40 140 Campbell 140 3 Campbell 140 120 3 130 85 D 130 (iii) (iv ) 100 180 180 A 100 125 160 Avery 120 115 1 Avery 160 155 1 125 100 75 75 120 135 135 140 Baker 2 150 Baker 2 140 115 100 100 120 40 Campbell 100 140 3 Campbell 140 120 150 140 3 130 85 85 . U 130 Model (i) Model (ii) Model (iii) Previous Next Model (iv) Assignme.. All work saved. Save and Exit Submit Assignment for Gradingv2.cengagenow.com C + 88 My Home C CengageNOWv2 | Online teaching and learning resource from Cengage Learning Search Results | Course Hero Topic 5 - Linear Programming: Distril 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? Let xij = number of hours from consultant i assigned to client j. Max X11 + *12 + X13 + X14 + * 21 + * 22 + *23 * 24 + X31 + *32 + X33 + X34 + + s.t. x11 *12 + 13 + *21 + * 22 + *23 + X24 x31 + X32 + X33 + X34 *11 + X21 + X3 X12 + X22 + X32 *13 X23 + *33 X14 X24 + X34 = kij 2 0 for all i, j Hours Assigned Billing Avery-Client A $ Avery-Client B Avery-Client C Avery-Client D Baker-Client A Baker-Client B Baker-Client C Baker-Client D Campbell-Client A Campbell-Client B Campbell-Client C Campbell-Client D Total Billing Previous Next Assignment Score: 0.0% All work saved. Save and Exit Submit Assignment for Gradingv2.cengagenow.com C + 88 My Home C CengageNOWv2 | Online teaching and learning resource from Cengage Learning Search Results | Course Hero Topic 5 - Linear Programming: Distril Avery-Client C Avery-Client D Baker-Client A Baker-Client B Baker-Client Baker-Client D Campbell-Client A Campbell-Client B Campbell-Client C Campbell-Client D Total Billing $ 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? Hours Assigned Billing Avery-Client A $ Avery-Client B Avery-Client C Avery-Client D Baker-Client A Baker-Client B Baker-Client C Baker-Client D Campbell-Client A Campbell-Client B Campbell-Client C Campbell-Client D Total Billing Pre Assignment Score: 0.0% All work saved. Save and Exit Submit