Question: answer number three below from the case file. thanks Lance Petroleum Company Lance Petroleum Company's Potomac, Pennsylvania, manufacturing complex comprises several operating units. These units
answer number three below from the case file. thanks

Lance Petroleum Company Lance Petroleum Company's Potomac, Pennsylvania, manufacturing complex comprises several operating units. These units process the crude oil that is pumped through and transform it into a multitude of hydrocarbon products. The units run 24 hours a day, 7 days a week, and must be shut down for maintenance on a predetermined schedule. One such unit is Distillation Unit No. 5, or DU5. Studies have shown that DUS can operate only 3 years without major equipment breakdowns, and excessive loss of efficiency. Therefore, DU5 is shut down every 3 years for cleaning, inspection, and repairs. DU5 is the only distillation unit for crude oil in the Potomac complex, and its shutdown severely affects all other operating units. Some of the production can be compensated for by Lance refineries in other locations, but the rest must be processed and stored before the shutdown. Without proper planning, a nationwide shortage of Lance gasoline could occur. The time of DUS's shutdown is critical, and the length of time the unit is down must be kept to a minimum to limit production loss. Lance uses PERT as a planning and controlling tool to minimize shutdown time. The first phase of a shutdown is to open and clean the equipment. Inspectors can then enter the unit and examine the damage. Once damages are determined, the needed repairs can be carried out. Repair times can vary considerably, depending on what damage the inspection reveals. Based on previous inspection records, some repair work is known ahead of time. Thorough cleaning of the equipment is also known to improve the unit's operating efficiency. The attached table lists the many maintenance activities, their precedences, and their estimated completion times. Discussion Questions (Note: You must provide formulas, tables, and/or figures in your case report to show your work.) 1. Based on the data provided, determine the critical path activities, the expected completion time, and the probability that the project can be completed 7 days earlier than expected. 2. What are the probabilities that Lance finishes the maintenance project 1, 2, 3, 4, 5, or 6 days earlier ? 3. If the optimistic time is the crash time for each activity and the cost of crashing each activity is irrelevant, use Excel to crash the maintenance project so that it is completed 7 days earlier than expected. Explain which activities should be crashed and how many days they should be crashed. Lance Petroleum Company Lance Petroleum Company's Potomac, Pennsylvania, manufacturing complex comprises several operating units. These units process the crude oil that is pumped through and transform it into a multitude of hydrocarbon products. The units run 24 hours a day, 7 days a week, and must be shut down for maintenance on a predetermined schedule. One such unit is Distillation Unit No. 5, or DU5. Studies have shown that DUS can operate only 3 years without major equipment breakdowns, and excessive loss of efficiency. Therefore, DU5 is shut down every 3 years for cleaning, inspection, and repairs. DU5 is the only distillation unit for crude oil in the Potomac complex, and its shutdown severely affects all other operating units. Some of the production can be compensated for by Lance refineries in other locations, but the rest must be processed and stored before the shutdown. Without proper planning, a nationwide shortage of Lance gasoline could occur. The time of DUS's shutdown is critical, and the length of time the unit is down must be kept to a minimum to limit production loss. Lance uses PERT as a planning and controlling tool to minimize shutdown time. The first phase of a shutdown is to open and clean the equipment. Inspectors can then enter the unit and examine the damage. Once damages are determined, the needed repairs can be carried out. Repair times can vary considerably, depending on what damage the inspection reveals. Based on previous inspection records, some repair work is known ahead of time. Thorough cleaning of the equipment is also known to improve the unit's operating efficiency. The attached table lists the many maintenance activities, their precedences, and their estimated completion times. Discussion Questions (Note: You must provide formulas, tables, and/or figures in your case report to show your work.) 1. Based on the data provided, determine the critical path activities, the expected completion time, and the probability that the project can be completed 7 days earlier than expected. 2. What are the probabilities that Lance finishes the maintenance project 1, 2, 3, 4, 5, or 6 days earlier ? 3. If the optimistic time is the crash time for each activity and the cost of crashing each activity is irrelevant, use Excel to crash the maintenance project so that it is completed 7 days earlier than expected. Explain which activities should be crashed and how many days they should be crashed