Determination of most economical scrapers fleet

Scrapers are valuable construction equipment for large earthmoving operations. Their production rates vary widely as they depend on the equipment performance, operation's travel time, and haul-road conditions. Determining the most economical selection of the size, model, and number of scrapers is a rather tedious process that involves repetitive calculations. A spreadsheet application was created in order to facilitate such calculations and select the most economical scraper from the list of available equipment for the job under consideration. The application is made of seven spreadsheets containing a scrapers' database, performance charts, soil properties, and other supporting worksheets. The application provides a user interface to solicit all data entries specific to a project. Once the user enters the required data the system compares the production rate, time required for the job, determines the estimated unit cost for each scraper in the database, and recommends the most economical selection.