only letters D&E need to be answered. please answer these ASAP. i am so confused and need it to be submitted soon!
Family Planning in Azuay Province, Ecuador Dr. Zena Cordoba, deputy director of the Family Planning Research Center in Ecuador's Aruay province, was assigned the task of organizing and training five teams of field workers to perform educational and outreach activities as part of a large project to demonstrate acceptance of a new method of birth control. These workers already had training in family planning education but must receive specific training regarding the new method of contraception. Two types of materials must also be prepared: (1) those for use in training the workers and (2) those for distribution in the field. Training faculty must be brought in and arrangements must be made for transportation and accommodations for the participants Dr. Cordoba first called a meeting of her office staff. Together they identified the activities that must be carried out, their necessary sequences, and the time they would require. Their results are displayed in Table 1 Franco Pere, the chief clerk, noted that the project had to be completed in 60 days as mandated by the Health Ministry, Whipping out his solar powered calculator, he added up the time needed. It came to 94 days. "An Impossible task, then," he noted. "No," Dr Cordoba replied, "some of these tasks can 60 forward in parallel." "Be careful, though" warned Adriana Riveira, the chief nurse, "There aren't that many of us to go around. There are only 10 of us in this office." "I can check whether we have enough heads and hands once I have tentatively scheduled the activities." Dr Cordoba responded. If the schedule is too tight, I have permission from the Ministry to spend some funds to speed it up, just so long as I can prove that it can be done at the least cost necessary. Can you help me prove that? Here are the costs for the activities with the clapsed time that we planned and the costs and times if we shorten them to an absolute minimum. Those data are given in Table 2. All tables are provided in an Excel file called Project 1Doto wtex constraint of 10 persons? d. If the critical path is longer than 60 days, what is the least amount that Dr. Cordoba can spend and still achieve this schedule objective? After more discussion Dr. Cordoba realizes that their time estimates are "most likely estimates. But there is significant uncertainty on either side of these most likely estimates. Together they create Table 3 (see Project 3 Data.xlsx) with optimistic, most likely, and pessimistic times. e. Based on the new information in Table-3, redo the critical path calculations based on the expected time for each activity. What is the expected length of the project without crashing? fonthuth Molt? Table-2 Cost Data for Family Planning Research Center Activity A. Identify faculty and their schedules B. Arrange transport to base C. Identify and collect training materials D. Arrange accommodations E. Identify team F. Bring in team G. Transport faculty to base H. Print program material L.Have program material delivered J. Conduct training program K. Perform fieldwork training Table-3 Optimistic, Most Likely, and Pessimistic Times Normal Time (days) 5 7 5 3 7 2 3 10 7 15 30 Cost $400 $1,000 $400 $2,500 $400 $1,000 $1,500 $3,000 $200 $5,000 $10,000 Crash Time (days) Cost 2 $700 4 $1,450 3 $500 1 $3,000 4 $850 1 $2,000 2 $2,000 5 $4,000 2 $600 10 $7,000 20 $14,000 Immediate Predecessors a 4 Activity A. Identify faculty and their schedules B. Arrange transport to base C. Identify and collect training materials D. Arrange accommodations E. Identify team F. Bring in team G. Transport faculty to base H. Print program material 1. Have program material delivered J. Conduct training program K. Perform fieldwork training b 8 9 7 4 9 4 B, E AB C H D, F, G,1 Times (days) m 5 7 5 3 7 2 3 10 7 15 30 5 2 1 5 2 2 7 4 12 25 4 15 9 18 35 MacBook Pro Family Planning in Azuay Province, Ecuador Dr. Zena Cordoba, deputy director of the Family Planning Research Center in Ecuador's Aruay province, was assigned the task of organizing and training five teams of field workers to perform educational and outreach activities as part of a large project to demonstrate acceptance of a new method of birth control. These workers already had training in family planning education but must receive specific training regarding the new method of contraception. Two types of materials must also be prepared: (1) those for use in training the workers and (2) those for distribution in the field. Training faculty must be brought in and arrangements must be made for transportation and accommodations for the participants Dr. Cordoba first called a meeting of her office staff. Together they identified the activities that must be carried out, their necessary sequences, and the time they would require. Their results are displayed in Table 1 Franco Pere, the chief clerk, noted that the project had to be completed in 60 days as mandated by the Health Ministry, Whipping out his solar powered calculator, he added up the time needed. It came to 94 days. "An Impossible task, then," he noted. "No," Dr Cordoba replied, "some of these tasks can 60 forward in parallel." "Be careful, though" warned Adriana Riveira, the chief nurse, "There aren't that many of us to go around. There are only 10 of us in this office." "I can check whether we have enough heads and hands once I have tentatively scheduled the activities." Dr Cordoba responded. If the schedule is too tight, I have permission from the Ministry to spend some funds to speed it up, just so long as I can prove that it can be done at the least cost necessary. Can you help me prove that? Here are the costs for the activities with the clapsed time that we planned and the costs and times if we shorten them to an absolute minimum. Those data are given in Table 2. All tables are provided in an Excel file called Project 1Doto wtex constraint of 10 persons? d. If the critical path is longer than 60 days, what is the least amount that Dr. Cordoba can spend and still achieve this schedule objective? After more discussion Dr. Cordoba realizes that their time estimates are "most likely estimates. But there is significant uncertainty on either side of these most likely estimates. Together they create Table 3 (see Project 3 Data.xlsx) with optimistic, most likely, and pessimistic times. e. Based on the new information in Table-3, redo the critical path calculations based on the expected time for each activity. What is the expected length of the project without crashing? fonthuth Molt? Table-2 Cost Data for Family Planning Research Center Activity A. Identify faculty and their schedules B. Arrange transport to base C. Identify and collect training materials D. Arrange accommodations E. Identify team F. Bring in team G. Transport faculty to base H. Print program material L.Have program material delivered J. Conduct training program K. Perform fieldwork training Table-3 Optimistic, Most Likely, and Pessimistic Times Normal Time (days) 5 7 5 3 7 2 3 10 7 15 30 Cost $400 $1,000 $400 $2,500 $400 $1,000 $1,500 $3,000 $200 $5,000 $10,000 Crash Time (days) Cost 2 $700 4 $1,450 3 $500 1 $3,000 4 $850 1 $2,000 2 $2,000 5 $4,000 2 $600 10 $7,000 20 $14,000 Immediate Predecessors a 4 Activity A. Identify faculty and their schedules B. Arrange transport to base C. Identify and collect training materials D. Arrange accommodations E. Identify team F. Bring in team G. Transport faculty to base H. Print program material 1. Have program material delivered J. Conduct training program K. Perform fieldwork training b 8 9 7 4 9 4 B, E AB C H D, F, G,1 Times (days) m 5 7 5 3 7 2 3 10 7 15 30 5 2 1 5 2 2 7 4 12 25 4 15 9 18 35 MacBook Pro