Quantitative methods for business 13th ed. HELP! HW Chapter 10#517& 18 Solve the
ID: 359669 • Letter: Q
Question
Quantitative methods for business 13th ed. HELP!
HW Chapter 10#517& 18 Solve the HW problems from Chapter 10- attach 3 file types only (two) lg4 files, (one) excel (with two worksheets), (one) word. 1. Develop the network representation (draw the network nodes, etc.) (attach in MS Word or in your Excel file) 2. Formulate the problem as an LP (write out the objective function and constraints) 3. Solve using LINGO and attach your Ig4 file and solution & range report (paste solution report to the same MS Word or Excel file) 4. Solve in MS Excel and attach your Excel file and sensitivity report (paste solution report to the same MS Word or Excel file) #17 about Scott and Associates Inc. S&A; is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on the different backgrounds and experiences of the leaders, the various leader-client assignments differ in terms of projected completion times. The possible assignments and the estimated completion times in days are as follows. What is the total time required? Client 2 10 22 34 3 Project Leader Jackson Ellis Smith 40 24 #18 about the CarpetPlus company. Carpet Plus sells and installs floor covering for commercial buildings. Brad Sweeney, a Carpet Plus account executive, was just awarded teh contract for five jobs. Brad must now assign a CarpetPlus installation crew to each of the five jobs. Because the commission Brad will earn depends on the profit CarpetPlus makes, Brad would like to determine an assignment that will minimize total installation costs. Currently, five installation crews are available for assignment. Eacvh crew is identified by a color code, which aids in tacking of job progress on a large white board. The following table shows the costs (in hundreds of dollars) for each crew to complete each of the five jobs. Determine the minimum cost assignment. Job 1 2 3 4 5 30 44 38 47 31 25 32 45 44 25 23 40 37 39 29 26 38 37 45 28 Red White Crew Blue Green Brown 26 34 44 43 28Explanation / Answer
Based to minimize the total number of Days Its better to assign all the clients to Jakson
But if only one project Leader would need to assign
Jackson – Client 1
Ellis – Client 2
Smith – Client 3
Total Days: 66 Days
Other combinations result in higher number to days.
From Below table first, we calculate the sum of number of days taken by each crew to complete the task,
The will find which crew is taking lesser number of days to reduce the cost.
The best Solution is $162,000
Clients Project Leader 1 2 3 Total Jackson 10 16 32 58 Ellis 14 22 40 76 Smith 22 24 34 80 Minimum 10 16 32