A building company needs to move earth and level the terrain at three sites: site $1$has a surplus of $300$ truckloads of earth; site $2$ has a surplus of $1200$ truckloads ofearth and site $3$ has a deficit of $700$ truckloads of earth. Earth at surplus locations isloaded via bulldozers onto dumper trucks and then transported to site $3$ to rectifythe deficit, Any earth in excess of site $3\text{'}$s deficit must be disposed off at a dumpsite.The distances between the relevant sites are shown in the table below and runninga dumper truck cost $16$ per mile. You may assume that the company has sufficientdumper trucks available.

From site$1$ to site$3$ :$4$miles ; from site$1$ to dump site: $1$mile; from site $2$ to site$3$: $8$miles; from site $2$ to dump site: $6$miles

Bulldozers are required to load dumper trucks at the surplus locations $($sites $1$ &$2)$ as well as to level the earth at site $3.$ One bulldozer can load up to $50$ dumpertrucks per day; one bulldozer can also level the earth at site $3$ of up to $100$truckloads per day. Bulldozers are not required at the dump site. The companyhas $5$ bulldozers available, which are pre$-$positioned at different sites $($see below$).$

Bulldozers can be transported between sites $1,2$ and $3,$ but this will take a $2$ daylead time. When bulldozers are not needed anymore, they are transported to thecompany's depot, and this takes one full day. Operating a bulldozer at a site costs$2500$ per day per bulldozer; transporting a bulldozer between sites costs $700$per bulldozer $($lead time is $2$ days$)$; transporting $($and retiring$)$ a bulldozer to thedepot costs $300$ per bulldozer $($lead time $1$ day$).$ The company needs to completethe project within $10$ working days. This means that at the end of day $10($orearlier$)$ all $5$ bulldozers have to be back at the depot.

$1$ bulldozer is positioned at site $1$; $1$bulldozer is positioned at site $2$; and $3$ bulldozers are positioned at site $3.$

You may assume that allbulldozer transfers are initiated at the beginning of awork day. For example, if a bulldozer is transferred at the start of day t from site$1$ to site $3,$ then this bulldozer cannot be working during days t and t$+1,$ and willbe available to work on site $3$ at the start of day t$+2,$ When working at a site, the bulldozer cost is $2500$ per day, irrespective of whether the bulldozer is working$($or not$)$ at its maximum capacity $($i$.$e$.,$ loading at most $50$ trucks per day at sites$1$ & $2,$ or levelling earth at most at $100$ truck loads per day at site $3).$ solve this question in excel