Use Goal Seek to determine an estimate of the total finished square footage they can afford. Provide more flexibility in their decision-making, you will create a data table listing various finished square footages and their effects on the base house cost and total cost. Create another data table showing combinations of square footages and lot prices to identify total costs.

Housing Cost

 Project Description:

Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tentative costs, but they cannot afford the $414,717 estimated cost. You will use Goal Seek to determine an estimate of the total finished square footage they can afford. To help provide more flexibility in their decision-making, you will create a data table listing various finished square footages and their effects on the base house cost and total cost. Finally, you will create another data table showing combinations of square footages and lot prices to identify total costs.