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 howmany 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 'A' 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 setper ton of refuse deposited. A "markup percentage" is a comparison of profit to costs. A 100% mark-up implies that the price charged is double the cost of production: something that costs $1 to make is sold for $2. A "target net profit" percentage can be set for evaluating different pricing models. It is essentially the percentage of gross profits that a person or organization will retain after all associated costs are accounted for. Read over this entire worksheet before you begin. Read the instructions on the left and all of the pop-up instructions attached to the table letters. Work through each section in order: A, then B, then C, and so on. Hover the mouse cursor over the letter-labels for more information. Below are the tables you should use for look-ups. TIPPING FEE PER TON: VALUES TO BE USED IN YOUR CALCULATIONS MARKUP: TARGET NET PROFIT: TOTAL CAPITAL COSTS: $87.00 129% 23% H TOTAL GROSS PROFITS PER WEK: NET PROFITS PER WEEK: G WEEKS TO REPAY CAPITAL COSTS: SMALL MEDIUM LARGE SUPER TRUCK MODEL TYPES SMALL MEDIUM LARGE SUPER HAULING CAPACITY (TONS) OPERATING COST PER HOME HOW MANY OF EACH TYPE CAPITAL COSTS (PRICE SUM OF GROSS PURCHASE PRICE 7 $0.91 $27,839 11 $1.19 $37,293 19 $1.55 $46,016 25 $1.81 $55,533 ARE NEEDED QUANTITY WEEKLY PROFITS NEW CONTRACT NEIGHBORHOODS Bristol Springfield Salen Madison Arlington Milton Centerville Lexington HOMES: 287 339 305 256 362 348 240 315 neighborhood Greenville 315 70 11.1 ESTIMATED TOTAL WEIGHT: 12.4 12.9 5.4 12.2 9.8 23.5 6.6 13.6 Franklin 364 43 7.9 ESTIMATED TIPPING FEE: 1079 1123 470 1062 853 2045 575 1184 Bristol 287 86 12.4 A Clinton 327 39 6.4 CAPACITY OF EACH TYPE OF TRUCK - NEED OF EACH NEICHBORHOOD Springfield 339 76 12.9 C SMALL MEDIUM LARGE SUPER #REF! Fairview 294 53 7.8 Salam 305 35 5.4 Washington 251 100 12.6 Madison 256 95 12.2 Georgetown 341 93 15.9 Ashland 344 61 10.5 OPERATING COSTS PER NETCHBORHOOD CTE APPLICABLE) SMALL MEDIUM LARGE SUPER Oxford 236 84 10.0 Arlington 362 54 9.8 Jackson 279 109 15.3 Burlington 175 66 5.8 Manchester 362 67 12.2 Milton 348 135 23.5 TOTAL OPERATING COSTS PER HOME SMALL E MEDIUM LARGE SUPER Centerville 240 55 6.6 Clayton 304 100 15.2 Dayton 272 82 11.2 Lexington 315 86 13.6 Milford 286 81 11.6 Winchester 287 45 6.5 Bristol Springfield Salen Madison Arlington Milton | Centerville || Lexington MIN: Auburn 211 108 11.4 MATCH: Cleveland 325 74 12.1 F PRICE TO CUSTOMER: WEEKLY GROSS PROFITS: RANK: INDEX: Hudson 249 39 4.9 Kingston 253 126 16.0 Oakland 383 56 10.8 Riverside 285 83 11.9 Dover 311 61 9.5 Newport 341 93 15.9 Once in a while, the cells for one of the neighborhoods in Table-F will all turn to red, and the MATCH cell will show the "N/A" message. This does not necessarily mean there is a problem with your work! (And it is not something you need to address with an IFO function.) WHAT DOES IT MEAN in the context of this problem? Replace this text with your answer.