"You are the owner of a refuse collection and disposal service, that is to say, a garbage$-$hauling company. You have been awarded the contracts for eight additional neighborhoods. The number of homes and average amount of trash collected from each home are available from a database. $($That data is available to you here as a table to the right of the work area.$)$ You will need to purchase additional trucks to handle the new contracts. There are four truck models from which to select, each with its own hauling capacity, operating costs, and purchase price. $($This data also is available to you as a table to the right of the work area.$)$ This spreadsheet model must be completed to help you decide how many of each of model of truck to buy, and how long it will take to pay off this capital expenditure.

The worksheet is labeled with letters to help guide you through the necessary calculations in the proper order. Each letter$-$label has a pop$-$up comment attached to it that will provide more instructions and specifications for completing that section. Start with section $\text{'}$A$\text{'}$ on the right$-$hand side of the worksheet.

NOTES:

A $""$tipping fee"" is what is charged by a refuse processing facillity for a truck to off$-$load its cargo. This fee is usually set per ton of refuse deposited.