please use excel formulas and show the forumulas. if correct me and my friends will like!

4. CAM charges for retail leases in a shopping mall must be calculated. The retail mall consists of a total area of 2.8 million square feet, of which 800,000 square feet has been leased to anchor tenants that have agreed to pay $2 per Page 294 rentable square foot in CAM charges. In-line tenants occupy 1.3 million square feet, and the remainder is common arca, which the landlord believes will require $8 per square foot to maintain and operate each year If the owner is to cover total CAM charges, will in-line tenants have to pay per square foot for CAM charges