Instructions

Full instructions on this assignment are available bydownloading this Word file. You will also need todownload this Excel file, which is a Network Diagram Template.

MGMT 430 Network Modeling Assignment - Week 3 - Dropbox 4 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 180 75 C 100 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 110 135 115 110 Charlie 155 140 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?MGMT430_Week3_NetworkDiagram_Template [Protected View] - Excel X Sign in FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing R11 S T U A B C D E F G H K L M N O P Q R 1 This template may be used to draw a network diagram AWN Node 1 CO 10 12 14 15 16 18 20 22 23 24 25 26 27 28 Sheet1 Sheet2 Sheet3 + + 100% READY