please provide steps$/$answers to these four questions. I think most of if not all of it has to be done within excel $1.$ Develop a network diagram $($AKA precedence diagram$).$

$2.$ Calculate the expected duration for each activity. Determine the ES$,$ EF$,$ LS$,$ LF$,$ and slack for each activity.

$3.$ Using your calculations determine the critical path and highlight it on your diagram.

$4.$ Calculate the variance and standard deviation of the project's total duration. What is the probability that the project will be finished within $270$ days $($that is $270$ days or less$)?$ Case Study

Southwestern University Stadium Construction

After six months of study, much political arm wrestling, and

some serious financial analysis, Dr$.$ Martin Starr, president of

Southwestern University, had reached a decision. To the delight

of its students and to the disappointment of its athletic boosters,

SWU would not be relocating to a new football site but would

expand the capacity at its on$-$campus stadium.

Adding $21,000$ seats, including dozens of luxury skyboxes,

would not please everyone. The influential football coach, Billy

Bob Taylor, had long argued the need for a first$-$class stadium,

one with built$-$in dormitory rooms for his players and a palatial

office appropriate for the coach of a future NCAA champion

team. But the decision was made, and everyone, including the

coach, would learn to live with it$.$

The job now was to get construction going immediately af$-$

ter the current season ended. This would allow exactly $270$ days

until the upcoming season opening game. The contractor, Hill

Construction $($Bob Hill being an alumnus, of course$),$ signed the

contract. Bob Hill looked at the tasks his engineers had outlined

and looked President Starr in the eye. "I guarantee the team will

be able to take the field on schedule next year," he said with a

sense of confidence. "I sure hope so$,"$ replied Starr. "The con$-$

tract penalty of $$10,000$ per day for running late is nothing

compared to what Coach Billy Bob Taylor will do to you if our

opening game with Penn State is delayed or cancelled." Hill,

sweating slightly, did not respond. In football$-$crazy Texas, Hill

Construction's name would be mud if the $270-$day target were

missed.

Back in his office, Hill again reviewed the data. $($See Table

$11\mathrm{.}11,$ and note that optimistic time estimates can be used as

crash times.$)$ He then gathered his foremen. "People, if we're

not $75\%$ sure we'll finish this stadium in less than $270$ days, I

want this project crashed! Give me the cost figures for a target

date of $250$ days$-$also for $240$ days. I want to be early, not just

on time