Home / Questions / Quality Consulting has two consultants Alfred and Barbara that can be scheduled to work ...
Quality Consulting has two consultants, Alfred and Barbara that can be scheduled to work for clients up to a maximum of 170 hours each over the next four weeks. A third consultant, Charlie, has some administrative assignments already planned and is available for clients up to a maximum of 150 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:
|
Client |
Hours |
|
A |
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 |
C |
D |
|
Alfred |
100 |
125 |
115 |
100 |
|
Barbara |
120 |
135 |
115 |
120 |
|
Charlie |
155 |
150 |
140 |
130 |
1) Develop a network representation of the problem. You may reference the Network Diagram Template .
2) 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?
?Would like to see each step using formula to this problem on excel setup. I saw other answers to this but didn't have the steps.
Jun 14 2020 View more View Less
Refer to the information provided in table below.Number of Cinema TicketsTotal UtilityMarginal UtilityPrice of a Cinema TicketMU/P forCinema Tickets1234561402403304004404...
Apr 19 2021Change in YTM is 75 basis points. YTM is 6%. Duration is 12 years. What is the percentage price change of the bond?
May 14 2021Suppose that there are three beachfront parcels of land available for sale in Huntington and six people who would each like to purchase one parcel. Assume that the parcel...
Mar 26 2020From your discussion experience describing a queue, diagram the queue you were in. This diagram should be created using shapes (as in page 440). Label the parts of the qu...
Aug 06 2020Define treasurer
Aug 26 2020never asked for help on this subject but this chapter confuses me, please helpAccording to Descartes' Rule and Norstrom's criterion, the number of possible i* va...
Dec 04 2019Discuss how the Fed raising the federal funds rate ripples through the different sectors of the economy.9) Explain the ripple effects of a sale of securities in an open m...
Dec 08 2019Which of the following molecules is(are) polar? For each polar molecule indicate the direction of polarity−that is, which is the negative end, and which is the positive e...
Jun 30 2021Propose a mechanism for this acid catalysed hydrolysis.
Jul 28 2021In the real business cycle model, suppose that government spending increases temporarily (i.e.,Gt increases but Gt+1 does not). Determine the equilibrium effects of this ...
Jul 12 2021