Recently Santa Fe, New Mexico, was named one of the safest places to live in the United States. Since then, housing development projects have been springing up all around Santa Fe. Six housing development projects are currently dominating the local market—Pinon Pine, Rancho Hondo, Creek Side, Vista Del Monte, Forest View, and Santa Fe South. These six projects each started with 100 homes, have 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, it is your responsibility to analyze the information concerning the past 600 home sales and choose 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:

The following numbers have been assigned to each of the housing development projects:

It is your responsibility to analyze the sales list and prepare a report that details which housing development project your real estate firm should focus on. Your analysis should be from as many angles as possible.

1. You do not know how many other real estate firms will also be competing for sales in each of the housing development projects.

2. Phase two for each housing development project will develop homes similar in style, price, and square footage to their respective first phases.

3. As you consider the information provided to you, think in terms of what information is important and what information is not important. Be prepared to justify how you went about your analysis.

4. Upon completing your analysis, please provide concise, yet detailed and thorough, documentation (in narrative, numeric, and graphic forms) that justifies your decision.

 

 

 

Project Number Project Name Project Type Page Number Plug-In Focus Area Project Lovel Skill Set Financial Excel T2 Personal Introductory Formulas AYKA Destiny Budget Cash Flow Excel T2 Cash Flow Introductory Formulas AYK4 TI, T2 Hardware and Software 3. Technology Budget Excel Introductory Formulas AYKA Excel Formulas AYKA Tracking Donations T2 Employee Relationships Introductory Global Commerce 5 Convert Excel T2 Introductory Formulas AYK.5 Currency Excel Total Cost of Introductory Ownership Cost T2 Formulas AYK.5 Comparison Time Excel or Project T12 Project Management Introductory Gantt Charts AYK.6 Management Maximize Excel T2, T4 Strategic Analysis Intermediate Formulas or AYK.6 Profit Solver Security Analysis Excel T3 Filtering Data Intermediate Conditional AYK.7 Formatting, Autofilter, Subtotal 10 Gathering Data Excel T3 Data Intermediate Conditional AYK8 Analysis Formatting 11 Scanner Excel T2 Strategic Intermediate Formulas AYK.8 System Analysis 12 Profit Intermediate Formulas Competitive Pricing Excel T2 AYK.9 Maximization 13 Adequate Acquisitions Excel T2 Break-Even Intermediate Formulas AYK.9 Analysis 14 xcel CRM Customer Relations T3 Intermediate PivotTable AYK.9 15 Assessing Excel T3 Data Intermediate PivotTable AYK. 10 the Value of Information Analysis 16 Growth, Trends, and Forecasts Excel T2, 13 Data Advanced Average, Trend, Growth AYK.11 Forecasting 17 Shipping Costs Excel T4 SCM Advanced Solver AYK.12 18 Formatting Grades If, LookUp Excel T3 Data Advanced AYK.12 Analysis