Question

use excel to solve the problem

You and several friends are about to prepare a lasagna dinner. The tasks to be performed, their immediate predecessors, and their estimated durations are as follows: Tasks That Time Task Description (minutes) Must Precede 30 Buy the mozzarella cheese* Slice the mozzarella Beat 2 eggs Mix eggs and ricotta cheese Cut up onions and mushrooms Cook the tomato sauce 25 15 10 Boil large quantity of water Boil the lasagna noodles Drain the lasagna noodles Assemble al the ingredients Preheat the oven L, E, D, B 15 30 Bake the lasagna Thane is one in the refingetce Construct the project network. b. Find all the paths and path lengths through this project network. Which of these paths is a critical a. path? c. Find the earliest start time and earliest finish time for cach activity d. Find the slack for each activity. Which of the paths is a critical path? c. Find the latest start time and latest finish time for each activity f. Because of a phone cal, you were interrupted for 6 minutes when you should have been cutting the onions and mushrooms. By how much will the dinner be delayed? If you use your food processor, which reduces the cutting time from 7 to 2 minutes, will the dinner stl be delayed?

Answer 1

Answers a, b, c, d & e are provided in the image below

the formulae used in Network diagram are in the image below