Home / Questions / Quality Consulting has two consultants Alfred and Barbara that can be scheduled to work fo...
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
Assuming a rate of 10% annually, find the FV of $1,000 after 5 years. What is the investment's FV at rates of 0%, 5%, and 20% after 0, 1, 2, 3, 4, and 5 years? Find the P...
Apr 15 2020The earnings before interest and tax of A Ltd is 37,20,000 when its investment in assets is 340,00,000. It has the capacity to raise debt at 12%. (a) If equity capitalisa...
Apr 11 2021Many freshwater animals cannot live for long in sea water and vice versa mainly because of the a) Change in N levels b) Change in the levels of thermal tolerance c) Va...
Jul 12 2021Internet Doctors: Hypothesis Test Use the survey results given in Exercise 1 and use a 0.05 significance level to test the claim that the majority of adults learn about m...
May 31 2021By examining first digits, Company XXX suspects fraud. You are asked to review the sample of invoicesshown on the previous page to see if they make sense. You are familia...
Aug 13 2021To supply side economists, the key to any economic stabilization is managing aggregate supply. What kinds of policy dothey advocate, and what outcomes do they expect to achieve?
Jun 08 2018Explain whether each of the following events increases or decreases the money supply.b. The Fed reduces the reserve requirement.
Jul 16 2021Viscosities of chlorine-air mixtures at low density. Predict the viscosities (in cp) of chlorine-air mixtures at 75oF and 1 atm, for the following mole fractions of chlo...
Jun 11 2020Which of the following applies to a price ceiling?A.A price ceiling is the maximum price that can be legally charged.B.A shortage results from a binding price ceiling.C.A...
May 11 2021I am resubmitting this as the guidance I received for question 3. A/B/C is incorrect. Mercer Asbestos Removal Company removes potentially toxic asbestos insulation and re...
Sep 11 2020