9. Referring to the hospital database management system installation example, Barbara has received word from her client that they need the new system com- pleted in 100 workdays. Looking at statistics from other jobs, she has determined the amount each task could be crashed and the cost (See Table 8.8). TABLE 8.8 Database Installation Crash Information TASK NORMAL CRASH NORMAL CRASH CODE PREDECESSORS TIME ( TIME / COSTIC) COST (CM) Assign Installation Team 7 5 3000 5000 Order Hardware B 11.5 10 5500 8500 Customize Software A 31 20 60000 120000 Install Hardware D B 16 10 15000 25000 Test Code E C D 24 16 50000 90000 Write Manual F D 20.5 15 15000 25000 Test System G E 15 12 50000 75000 Train Employees H F 15 10 40000 65000 Convert Current Database I D 10 15000 35000 Parallel User Test J G, H, I 20 20 50000 50000 Post Transition Assessment K J 25 15 25000 50000 a. Formulate a linear program to determine the minimum cost plan to complete the project in 100 days. b. Build a spreadsheet model of the project. Use solver to find the optimal solu- tion. Which activities should Barbara crash and by how much? What is the total cost