Question

PROBLEM 00 tons of fill with a density of 100 lbs/cf is to be transported to a job site located at 6 miles away using a 12-cy dump truck. The speed of the dump truck with load is 25 MPH and while returrn empty is 30 MPH. It takes 3 min to dump the load. Two laborers and a driver each load the truck at a rate of 2cy/hour. The cost of the truck is $30/hr, the driver is $20/hr and the laborers is $15/hr. The average working time (productivity factor) is 45 minutes in an hour. Create a spreadsheet that calculates the cost of transporting the fill per ton with adjustable variables for all inputs. NOTE: Organization, Labeling and Neatness will account for 25% of the 20 points you can earn

Answer 1

at first we will calculate the total trip time. Then we have to calculate the time required for loading. Then we will Calculate the total cost.

600000 pusa 6000pp -- 222 су

12 25 0,24 ke ty h hme needed e eldy on 30

Toral time meeded in 1 htǐ (0.24 +0.1)hon esn To unloading Tohl unloading time:9x192 5t min. = 0.45 hr bohoe the labourer and driver齒load a , a Ad 2 - 222

Totul tブtu ck unlrading "Them, us,ing time -rr;P time + ne -e, 36+0.95) h 8,36+0.95+3국 46-21 hr labourer"9 Lending time: 37 hoUL ~'

Achuol tnue using ime tot .1X133 12-38 hr actual. drtiver3s 46, 3 1 =6159hr timez, -33 2 13315146.3

"Totae eost -33-1, 4ナ12.3), 8 + 1476-3 Laspotn $10,265 þeてtonne