Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 22 3 H5 A fx Proposal for Dream Home Elijah and Valerie Foglesong 1 pts B C D E F G H J
Question 22 3 H5 A fx Proposal for Dream Home Elijah and Valerie Foglesong 1 pts B C D E F G H J K 4 Base House 5 Square footage: Main floor 6 Square footage: Basement 1,800 1,800 Table 1: Square Footage Total Sq Ft Base Cost 1,800 $144,000 Table 2: Square Footage & Lot Total Cost 7 Total Square footage 3,600 8 Base price per square foot $ 80.00 9 Base house price 10 11 Interior Upgrades 12 Granite countertops $ 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 $ 288,000 3,000 2,000 $160,000 2,200 $176,000 $302,717 2,400 $ 192,000 $ 318,717 2,600 $208,000 $ 334,717 2,800 $ 224,000 $350,717 3,000 $240,000 $ 366,717 3,200 $256,000 $ 382,717 3,400 $272,000 $ 398,717 3,600 $288,000 $ 414,717 $270,717 $286,717 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 414,717 26 If you wanted to compare the total Estimated Cost using a two variable data table based on both the square footage and cost of the lot, what value should be placed in cell H5(upper left cell of Table 2) =$B$9 =$B$25 =$B$23 Total Sq Ft
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started