UDT is a consulting firm that develops e-commerce project, systems and websites for its clients. It...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
UDT is a consulting firm that develops e-commerce project, systems and websites for its clients. It has six available consultants and eight clients project is under contract. The consultants have different technical abilities and experience, and as a result, the company charges different hourly rates for its services. Also, the consultant's skill are more suited for some projects than others, and clients sometimes prefer some consultants over others. The suitability of a consultant for a project is rated according to a 5-point scale, in which 1 is the worst and 5 is the best. The following table shows the rating for each consultant for each project, as well as the hours available for each consultant and the contracted hours and maximum budget for each project: Project 4 Consultant Hourly 1 7 Available hours wage $155 A 3. 5 5 3 450 $140 3 3 5 5 3 3 600 C $165 2 1 3 1 3 500 D $300 1 3 1 1 1 300 E $270 3 1 1 1 3 710 F $150 4 5 3. 2 3 5 4 3 860 Project Hours 500 240 400 475 350 460 290 200 Contract 100 80 120 90 65 85 50 55 budget (x1000 USD) The company wants to know how many hours to assign each consultant to each project in order to best utilize their skill while meeting clients needs a. Formulate a linear programming model and write down the mathematical model for this problem. b. Solve this problem using QM and SOLVER c. If the company want to maximize revenue while ignoring client preferences and consultant compatibility, will this change the solution in b. ? d. Create a sensitivity report. What is the shadow price in this case ? e. If consultant A and E change their hourly wage from $155 to $200 (A) and from $270 to $200, will the solution change ? f. By exprerience, consultant B and E is getting better at their ability, which mean their capacity for every project now minimum start from 3 instead of 1 or 2, will the shadow UDT is a consulting firm that develops e-commerce project, systems and websites for its clients. It has six available consultants and eight clients project is under contract. The consultants have different technical abilities and experience, and as a result, the company charges different hourly rates for its services. Also, the consultant's skill are more suited for some projects than others, and clients sometimes prefer some consultants over others. The suitability of a consultant for a project is rated according to a 5-point scale, in which 1 is the worst and 5 is the best. The following table shows the rating for each consultant for each project, as well as the hours available for each consultant and the contracted hours and maximum budget for each project: Project 4 Consultant Hourly 1 7 Available hours wage $155 A 3. 5 5 3 450 $140 3 3 5 5 3 3 600 C $165 2 1 3 1 3 500 D $300 1 3 1 1 1 300 E $270 3 1 1 1 3 710 F $150 4 5 3. 2 3 5 4 3 860 Project Hours 500 240 400 475 350 460 290 200 Contract 100 80 120 90 65 85 50 55 budget (x1000 USD) The company wants to know how many hours to assign each consultant to each project in order to best utilize their skill while meeting clients needs a. Formulate a linear programming model and write down the mathematical model for this problem. b. Solve this problem using QM and SOLVER c. If the company want to maximize revenue while ignoring client preferences and consultant compatibility, will this change the solution in b. ? d. Create a sensitivity report. What is the shadow price in this case ? e. If consultant A and E change their hourly wage from $155 to $200 (A) and from $270 to $200, will the solution change ? f. By exprerience, consultant B and E is getting better at their ability, which mean their capacity for every project now minimum start from 3 instead of 1 or 2, will the shadow
Expert Answer:
Answer rating: 100% (QA)
The company wants to know how many hours to assign ... View the full answer
Related Book For
Operations Management Creating Value Along the Supply Chain
ISBN: 978-0470525906
7th Edition
Authors: Roberta S. Russell, Bernard W. Taylor
Posted Date:
Students also viewed these accounting questions
-
Vantage Systems is a consulting firm that develops e-commerce systems and Web sites for its clients. It has six available consultants and eight client projects under contract. The consultants have...
-
A friend owns and operates a consulting firm that works for a single client under one consulting agreement. The consulting firm bills the client monthly for charges incurred. She asks you whether you...
-
Finley and Associates is a consulting firm that spends $60,000 per year advertising the companys brand names and trademarks. Gross margin on sales after taxes is up $66,000 each year because of these...
-
The following data represent the concentration of dissolved organic carbon (mg/L) collected from 20 samples of organic soil. Assume that the population is normally distributed. Complete parts (a)...
-
Refer to the financial statement footnotes or financial review section of the annual report of Zipcar, Inc. Read the significant accounting policies footnote disclosures and answer the following...
-
Calculate the standard deviation of the U.S. Treasury bills, long-term government bonds, and large company stocks for 1990 to 1999 from Table 8.1. Which had the highest variance? Which had the lowest...
-
Revise cash collections budget (Learning Objective 4) Turn to the original Whitewater Sporting Goods Data Set item 4. Suppose \(70 \%\) of sales are cash and \(30 \%\) are credit. Revise Whitewater's...
-
1 Carry out a five forces analysis of the advertising industry in 2015. What is the strength of the five forces and what underlying factors drive them? What is the industry attractiveness? 2 What are...
-
Flay Foods has always used the FIFO inventory costing method for both financial reporting and tax purposes. At the beginning of 2 0 2 4 , Flay decided to change to the LIFO method. As a result of the...
-
Jones Company Edward Jones started the Jones Company Limited (JCL) as a sole proprietorship. It was later incor-- porated; ownership is now 50 percent controlled by Mr. Jones, who is 71 years old,...
-
. February March April Sources of cash Collections on current sales $ 110 $ 120 $ 100 Collections on amounts receivable 100 X 110 120 Total sources of cash $ 210 EA 230 220 Uses of cash Payments ...
-
In the fall of2009, Kraft Foods attempted to buy Cadbury plc. Data for each of the two companies are given in the table. Both companies are all equity financed. The CEO of Kraft Foods estimated that...
-
Hello. tutors. I need to make a file reader that reads in the xml files and reports any errors. And we also need to use the stack and queue. Can you help me out to make the code? I will add all the...
-
What is working Capital ? Explain Types of Working Capital Explain Needs of Working Capital Explain short term and Long Term sources of working capital financing Compare working capital Practices in...
-
a. Imagine that you are working in the marketing department of ABC Hotels Corp. and the board of directors asked you to provide a report about CRM. They are going to come up with a new hotel brand...
-
a.Transfer pricing is the method used to sell a product from one subsidiary to another within a company. It impacts the purchasing behaviour of the subsidiaries, and may have income tax implications...
-
Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply of isolinear chips. The trip will take Data about one day. Before he leaves, he c
-
Find the image of x = k = const under w = 1/z. Use formulas similar to those in Example 1. y| y = 0 -21 -2 -1 -1, /1 12 T -1 -1 y= -2 x =0
-
Bioway, Inc., a manufacturer of medical supplies, uses aggregate planning to set labor and inventory levels for the year. While a variety of items are produced, a standard kit composed of basic...
-
Identify three service businesses in your community and describe their supply chains.
-
Spiffy Dry Cleaners has recently changed management, and the new owners want to revise the current layout. The store performs six main services: (1) Laundry, (2) Dry cleaning, (3) Pressing, (4)...
-
On December 31, 20x7, the stockholders equity section of Tsang Companys balance sheet appeared as follows: The following are selected transactions involving stockholders equity in 20x8: On January 4,...
-
Recording Purchase and Sales Transactions} Raymond Company and Geeslin Company both use a perpetual inventory system. The following transactions occurred during the month of January: Jan. 1 Raymond...
-
Inventory Costing Methods} Refer to the information for Tyler Company above and assume the company uses a perpetual inventory system. \section*{Required:} Calculate ending inventory and cost of goods...
Study smarter with the SolutionInn App