I need someone to help solve this question using Solver in Excel and show the steps $($visual$)$ in details via Excel.. Question$-$ Given the following project $($all times are in days$)$:

Activity

Predecessor

Normal

Time

Normal

Cost

Crash

Time

Crash

Cost

a $5$ $$503$ $$150$

b $4402200$

c b $7706160$

d a$,$ c $220150$

e a$,$ c $330$

f b $8805290$

g d $5504100$

h e$,$ f $6603180($a$)$ Draw the network $($AOA or AON$)$ and fi nd the

critical path, time, and cost for an all $-$ normal

level of project activity.

$($b$)$ Calculate the crash cost $-$ per $-$ day $($all activities

may be partially crashed$).$

$($c$)$ Find the optimal way of getting an $18-$ day delivery time. What is the project cost?

$($d$)$ Find the optimal way of getting a $16-$ day delivery time. What is the project cost?

$($e$)$ Calculate the shortest delivery time for the

project. What is the cost?

$($f$)$ Repeat questions $($c$),($d$),$ and $($e$)$ using Excel. A picture of the table that has been worked on nd a diagram showing the AON is also attached. $\backslash$table$[[$Activity$,\backslash$table$[[$Prede$-],[$cessors$]],\backslash$table$[[$Normal$],[$Duration$]],\backslash$table$[[$Crash$],[$Duration$]],$Normal Cost,Crash Cost,Cost per Day,Activity,$\backslash$table$[[$Actual$],[$Duration$]],$Actual Cost$],[$a$,-,5,3,$$$50,$$$150,$$$50,$a$,5,$$$50$