Exp19_Excel_Ch06_ML1_Housing_Cost
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.
Create a data table listing various finished square footages and their effects on the base house cost and total cost.
