LINGO software - Academia Exp

LINGO software

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 (4) 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 (4) weeks. The company has four (4) clients with projects in process. The estimated hourly requirements for each of the clients over the four-week period as follows:

ORDER A PLAGIARISM-FREE PAPER HERE

CLIENT HOURS

A 180

B 75

C 100

D 85

Hourly rates vary form the consultant-client combinations and are based on several factors, including project type and consultants” experince. The rates( dollars per hour) for each consultants-client combination are as follows: LINGO software

CLIENT

CONSULTANTS A B C D

AVERY 100 125 115 100

BAKER 120 135 115 120

CAMPBELL 155 150 140 130

a) Develop a network representation of the problem.

b) formulate the problem as 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?

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 scheduled?

To solve problem using LINGO software.

Leave a Comment