Premier consulting's two consultants

profilesulzer

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 adminstrative assignments already planned and is availble for clieents 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 requirments for each of the clients over the four-week period as follows:

 

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:

 

                                                                   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 experince to be scheduled for client B. If this consultingnassignment is not premitted, what impact does it have on total billings? What is the revised scheduled?

 

To solve problem using LINGO software. 

    • 6 years ago
    • 20
    Answer(6)

    Purchase the answer to view it

    NOT RATED
    • attachment
      lp-premier_consulting_soln.xlsx
    • attachment
      lp-premier_consulting_soln.docx

    Purchase the answer to view it

    NOT RATED
    • attachment
      lp-premier_consulting_soln.xlsx
    • attachment
      lp-premier_consulting_soln.docx

    Purchase the answer to view it

    NOT RATED
    • attachment
      premier_consulting.doc
    • attachment
      premier_consulting.xls
    • attachment
      premier_consultings.docx

    Purchase the answer to view it

    NOT RATED
    • attachment
      lp-network_consulatnat_apr_11.xlsm

    Purchase the answer to view it

    NOT RATED
    • attachment
      sol1.png
    • attachment
      sol2.png
    • attachment
      sol3.png
    • attachment
      sol4.png

    Purchase the answer to view it

    NOT RATED
    • attachment
      premier_consultings_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..docx