Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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. 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:

Hourly rates vary for the consultantclient combination and are based on several factors, including project type and the consultants experience. The rates (dollars per hour) for each consultantclient combination are as follows:

  1. Choose the correct network representation of the problem.

  1. 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 firms 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 + x12 + x13 + x14 + x21 + x22 + x23
    + x24 + x31 + x32 + x33 + x34
    s.t. x11 + x12 + x13 + x14 ___
    x21 + x22 + x23 + x24
    x31 + x32 + x33 + x34
    x11 + x21 + x31 =
    x12 + x22 + x32 =
    x13 + x23 + x33 =
    x14 + x24 + x34 =
    xij 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
  2. New information shows that Avery doesnt 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Institutions Management A Risk Management Approach

Authors: Anthony Saunders, Marcia Cornett

7th Edition

0073530751, 9780073530758

More Books

Students also viewed these Finance questions

Question

Discuss cross-cultural differences in perception

Answered: 1 week ago

Question

Compare and contrast families and family roles across cultures

Answered: 1 week ago

Question

Compare and contrast sex and gender roles across cultures

Answered: 1 week ago