find formulas for empty cells

TIPPING FEE PER TON: $81. 00 VALUES TO BE USED IN YOUR CALCULATIONS TRUCK MODEL TYPES MARKUP 130% SMALL MEDIUM LARGE SUPER TARGET NET PROFIT: HAULING CAPACITY (TONS) 19% 14 19 HOW MANY CAPITAL SUM OF OPERATING COST PER HOME $0.93 1. 34 OF EACH $1.55 $1. COSTS GROSS TYPE ARE (PRICE X WEEKLY PURCHASE PRICE $24, 129 $29, 246 $37, 717 $46, 038 NEEDED QUANTITY) TOTAL CAPITAL COSTS: PROFITS SMALL TOTAL GROSS PROFITS PER WEK: MEDIUM NET PROFITS PER WEEK: LARGE WEEKS TO REPAY CAPITAL COSTS SUPER average weight of trash number of homes in the estimated total weight of neighborhood trash, neighborhood NEW CONTRACT NEIGHBORHOODS Bristol Clinton Fairview Georgetown Oxford Burlington Clayton Lexington B HOMES : 379 338 neighborhood 198 239 280 247 382 366 ESTIMATED TOTAL WEIGHT : Greenville 18 13 14 276 13 10 1418 Franklin ESTIMATED TIPPING FEE: 1086 616 665 503 1102 401 1053 778 Bristol 379 D Clinton 338 CAPACITY OF EACH TYPE OF TRUCK - NEED OF EACH NEIGHBORHOOD MALL Springfield -11.5 -7.4 -1. 6 -2.2 0 . -7. 6 -7.0 -3. 61 Fairview MEDIUM -3.5 0. 6 6.4 5. 8 7.8 0.4 1.0 Salem LARGE 1. 5 5 .6 11.4 10.8 12 . 8 5.41 6.0 9. 4 SUPER 7.5 Washington 11. 6 17. 4 16.8 18 . 8 11. 4 12. 0 15 .4 Madison Georgetown OPERATING COSTS PER NEIGHBORHOOD (IF APPLICABLE) SMALL- Ashland MEDIUM Oxford $1, 537 $880 $984 $877 $1, 43 $1, 564 $1, 267 LARGE Arlington $2 , 005 $1, 609 $922 $1, 035 $936 $1, 48 $1, 645 $1, 345 Jackson SUPER $2, 152 $1, 740 $999 $1, 127 $1, 044 $1, 580 $1, 793 $1, 486 Burlington Manchester TOTAL OPERATING COSTS PER HOME SMALL- Milton Centerville MEDIUM $4.55 4.45 $4. 12 3. 13 $5.8 $4.09 LARGE $3.46 Clayton $5.29 $4.76 $4. 66 4.33 $3.3 $6. 01 $4. 31 $3. 67 Dayton SUPER $5. 68 $5.15 $5. 05 $4.72 $3.73 $6.40 $4.69 $4. 06 Lexington Milford Bristol Clinton Fairview Georgetown Oxford Burlington Clayton MIN: 5.29 Lexington Winchester 4.55 4. 4 4.12 3 . 13 5.80 4.09 . 46 Auburn MATCH 3. 00 2. 00 2. 00 2.00 2. 00 2. 00 2.00 .00 INDEX: LARGE Cleveland MEDIUM MEDIUM MEDIUM MEDIUM MEDIUM MEDIUM MEDIUM PRICE TO CUSTOMER Hudson WEEKLY GROSS PROFITS: tingston Oak land RANK Riverside Once in a while, the cells for one of the neighborhoods in Table-F will all turn to red, Dover and the MATCH cell will show the "#N/A" message. This does not necessarily mean there is Newport a problem with your work! (And it is not something you need to address with an IF() function. ) WHAT DOES IT MEAN in the context of this problem? Replace this text with your