Answered step by step
Verified Expert Solution
Link Copied!

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 1has 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'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 site1 to site3 :4miles ; from site1 to dump site: 1mile; from site 2 to site3: 8miles; from site 2 to dump site: 6miles
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 100truckloads 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 costs2500 per day per bulldozer; transporting a bulldozer between sites costs 700per 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; 1bulldozer 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 site1 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 sites1 & 2, or levelling earth at most at 100 truck loads per day at site 3). solve this question in excel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Project Management

Authors: Dr. Obi Obata

1st Edition

9798849596822

More Books

Students also viewed these General Management questions

Question

What is its position?

Answered: 1 week ago

Question

What are the organizations relationship goals on this issue?

Answered: 1 week ago