Option #1: Rock Quarry

The operator of a rock quarry is invited to bid on furnishing 42,000 cubic yards (cy) of crushed aggregate for a job. The aggregate will be delivered to the job, which is 27 miles from the quarry. The aggregate will be loaded into trucks by a loader that can load at a rate of 75 cy per hour. The trucks will haul 18 cy per load at an average speed of 50 miles per hour loaded and 55 miles per hour when empty. The estimated time to dump a load is 5 minutes. Assume a 45-minute effective hour for the loading and hauling operation.

The cost information for the job is included in the attachment

What should be the bid price per cubic yard?

Deliverable:

You will deliver BOTH:

1 – An Excel spreadsheet to include:

Tables of all information (data) given in the problem, formulas that reference cells thus creating dynamic formulas that will change if information in the tables change, and the final answer highlighted in YELLOW.

Show all of your work (at each step).

2 – A two-page narrative to describe your findings and interpret your results:

Follow APA format

Include a cover page and reference page.

Support your work with at least two peer-reviewed, credible, and current scholarly articles.