Create a scenario named Ideal Costs, using Base price per square foot and Lot fee $($use cell references$).$ Enter these values for the scenario: $80,102,675.$

Create a scenario named Increased Costs, using Base price per square foot and Lot fee $($use cell references$).$ Enter these values for the scenario: $100,110,000.$

Create a scenario named Low Costs, using Base price per square foot and Lot fee $($use cell references$).$ Enter these values for the scenario: $60,80,000.$

Generate a scenario summary report using the cell references for Price per square foot and Lot Fee. Add the appropriate formatting to the newly created report