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.

I need a step by step explanation of how to do questions 1-13.

In cell B5, insert the appropriate database function to identify the lowest salary for programmers in Salt Lake City. 1 Aroposal for Dream Home Elijah and Valerie Foglesong 3 4 Base House Table 1: Square Footage Table 2: Square Footage \& Lot 5 Square footage: Main floor Total Sq Ft 6 Square footage: Basement 7 Total Square footage 8 Base price per square foot Base house price \begin{tabular}{rr} $ & 80.00 \\ $ & 288,000 \\ \hline \end{tabular} 11 Interior Upgrades 12 Granite countertops 13 Hardwood floors 14 Tile floors: main-floor bathrooms Total interior upgrades \begin{tabular}{|lr} $ & 3,000 \\ \hline$ & 7,500 \\ \hline$ & 3,200 \\ \hline$ & 13,700 \\ \hline \end{tabular} 17 Exterior Upgrades 18 Complete sprinkler system \begin{tabular}{rr} $ & 3,525 \\ \hline$ & 2,942 \\ \hline$ & 3,875 \\ \hline$ & 10,342 \\ \hline \end{tabular} 20 Energy efficient AC Total exterior upgrades $102,675 Total Estimated Cost