Recently, Santa Fe, New Mexico, was named one of the safest places to live in the United States. Sire then. housing development projects have been springing up all around Santa Fe. Six housing development projects are currently dominating the local market: Pinon Pine, ancho Hondo, Creek Side, Visa Del Monte, Forest View, and Santa Fe South. These six projects each started with 100 homes. hare sold all of them, and are currently developing phase two. As one of the three partners and real estate agents of Affordable Homes Real Estate, you are responsible for analyzing the information concerning the past 600 home sales and choosing which development project to focus on for selling homes in phase two. Because your real estate firm is so small, you and your partners have decided that the firm should focus on selling homes in only one of the development projects. From the New Mexico Real Estate Association, you have obtained a spreadsheet file that contains information concerning each of the sales for the first 600 homes. It contains the following fields: You do not know how many other real estate firms will also be competing for sales in each of the housing development projects. Phase two for each housing development project will develop homes similar in style, price, and square footage to their respective first phases. As you consider the information provided to you, think in terms of what information is important and what information is not important.

It is your responsibility to analyze the sales list and present a short analysis that details which housing development project your real estate firm should focus on.

Upon completion of your calculations using the attached "M1_AYK_Value of Info.xlsx" data file, please provide a concise analysis that justifies your decision.

1. Please note: Use 7% as the commission amount.

File Edit View Go Window Help M1 AYK 23 47 61 7B 92 97 AVERAGE ASK PRICE $82,844 AVERAGE SELL PRICE $80,374 AVERAGE COMMISSION $5.626 AVERAGE DAYS TO SALE 78 AVERAGE COMMISSION PER DAY $72 AYK 15 Value of Information Created Data Pivot Table FinalFile Edit View Go Window Help M1 AYK Value of Info 2.x PROJECT # Data 23 47 61 78 92 97 Grand Total Average of SELL PRICE $82 419.50 $80,373.60 $82, 182.80 $80,437.90 $82,302.60 $85,678.00 $82,232.40 Average of DAYS TO SALE 79 78 92 86 93 105 89.035 Average of ASK PRICE $83,916.70 $82,843.80 $83,519.50 $82 897.90 $84 709.60 $88, 101.80 $84,331.55 AYK 15 Value of Information Created Data Pivot Table