Show all calculations and formulas within your excel formulas, state all assumptions.

Failure to follow instructions will result in deductions

Question $1$

Roadway, Inc, is a highway contractor that has been awarded a contract to mill and pave a $37$ mile section of Interstate $10$ in the Phoenix metro area.

The government has requested a cost analysis of two alternatives:

The cost to perform the work under straight$-$time normal working conditions

The cost to perform the work under a combination of straight$-$time and a second shift In preparing your analysis you arrived at the following numbers:

Under straight$-$time hours the highway crew with equipment works at a rate of $0\mathrm{.}032$ labor$-$hour$/$tons$.$

The highway is $3$ lanes each direction, has a $10$ foot shoulder on all sides $(4$ shoulders total$),$ and has $3$ layers of $4$ inches, $3$ inches and $2$ inches respectively. Each lane is $13$ feet wide and asphalt has a density of $145lb\frac{s}{c}f.$

The crew consists of two working foreman, eight laborers, and three equipment operators $($equipment includes a paver, a tandem roller, and a pneumatic roller$).$ The average base cost for the crew is $$37\mathrm{.}15$ per labor$-$hour

Shift work rates are $7\mathrm{.}5$ hours at $8$ and a $20\%$ differential

$5.$ Assume no productivity drop

$6.$ The second shift requires an extra cost of $$2400/$day for lighting

$7.$ The government estimates an opportunity cost of $$3200/$day for every day the highway is under construction.