Question $4$

This project is a large excavation project and we have just been awarded the contract. We desire to determine if the company owns enough D$-8$T Caterpillars $($CAT$)$ and also what our cash requirements are forecasted to be$.$ This same process would be used to manage and control any resource: labor, equipment, money, tools, etc.

Calculate the total cost per month $($thousands of dollars$).$

The owner does not want to go over $\backslash (\backslash$$ $135,000\backslash )$ per month. Do not use more than $10($ten$)$ CATs per month.

Create the following:

$1.$ Monthly cost and CAT loaded bar chart based on the standard project duration.

$2.$ Level for the constraints listed above.

Use Excel to do the work; it will make your life easier.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline Aclivily & Duration in months & IP & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Cost per month $($K$)\}$ & Number of D$-8$T CATs per menth $\backslash \backslash$

$\backslash$hline B & $3$ & $-$ & $5$ & $30$ & $2\backslash \backslash$

$\backslash$hline D & $3$ & B & $5$ & $40$ & $2\backslash \backslash$

$\backslash$hline K & $5$ & B & $5$ & $60$ & $5\backslash \backslash$

$\backslash$hline H & $4$ & B & $5$ & $30$ & $2\backslash \backslash$

$\backslash$hline I$\text{'}$ & $7$ & $1),$K$,$II & $5$ & $25$ & $2\backslash \backslash$

$\backslash$hline A & $4$ & K$,$I I & $5$ & $20$ & $2\backslash \backslash$

$\backslash$hline E & $6$ & H & S & $90$ & $6\backslash \backslash$

$\backslash$hline G & $2$ & $\backslash (\backslash$Gamma$\_\{$r$\}\backslash$mathrm$\{$~A$\}\backslash )$ & $5$ & $50$ & $2\backslash \backslash$

$\backslash$hline I & $3$ & A$,$ F & $5$ & $40$ & $2\backslash \backslash$

$\backslash$hline C & $6$ & G$,$ J & S & $30$ & $2\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$