Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A building company needs to move earth and level the terrain at three sites: site 1 has a surplus of 3 0 0 truckloads of
A building company needs to move earth and level the terrain at three sites: site has a surplus of truckloads of earth; site has a surplus of truckloads ofearth and site has a deficit of truckloads of earth. Earth at surplus locations isloaded via bulldozers onto dumper trucks and then transported to site to rectifythe deficit, Any earth in excess of site 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 per mile. You may assume that the company has sufficientdumper trucks available.
From site to site :miles ; from site to dump site: mile; from site to site: miles; from site to dump site: miles
Bulldozers are required to load dumper trucks at the surplus locations sites & as well as to level the earth at site One bulldozer can load up to dumpertrucks per day; one bulldozer can also level the earth at site of up to truckloads per day. Bulldozers are not required at the dump site. The companyhas bulldozers available, which are prepositioned at different sites see below
Bulldozers can be transported between sites and but this will take a 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 per day per bulldozer; transporting a bulldozer between sites costs per bulldozer lead time is days; transporting and retiring a bulldozer to thedepot costs per bulldozer lead time day The company needs to completethe project within working days. This means that at the end of day orearlier all bulldozers have to be back at the depot.
bulldozer is positioned at site ; bulldozer is positioned at site ; and bulldozers are positioned at site
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 to site then this bulldozer cannot be working during days t and t and willbe available to work on site at the start of day t When working at a site, the bulldozer cost is per day, irrespective of whether the bulldozer is workingor not at its maximum capacity ie loading at most trucks per day at sites & or levelling earth at most at truck loads per day at site solve this question in excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started