Case Study

Only available on StudyMode
  • Download(s) : 489
  • Published : January 6, 2013
Open Document
Text Preview
Case Study Title

Analyzing the Value of Information

Affordable Homes Real Estate

Executive Summary

Real Estate Name:

Wisconsin Real Estate Association

Industry:

Housing Development

Six Dominating Housing Development Projects:

Woodland Hills

Granite Mound

Creek Side Huntington

East River Community

Forest Green

Eau Claire South

*each projects started and have sold with 100 homes, and is currently developing

Phase 2.

Recommendations and Solutions

Business Challenge

Focus selling in only one of the development projects
From which of these housing development should the partners / agents should focus on. Business Solutions
Data Processing Method (Pivot Table - Excel) to generate information significant to the agent(s). Result
“With the information generated, discussed and analyzed from the spreadsheet, we’ve come up that the partners and the agents should focus on the project name entitled Eau Claire South. The spreadsheet shows that most of the customers want to live a this place base on the total square footage for the home. Some of the customers of the real estate does not regards the number of bathrooms and bedrooms although some required to have it. But then, if will analyze the figures, Eau Claire South is the best for the customers from the price they bought the house up to the area of the house. On the succeeding housing development (Phase 2), the agents / partners should focus both on all the area(area, style, number of bathrooms and bedrooms) that the customer wish to have as they want the new house. ”

Table 1a Data Analysis Using Pivot Table of Microsoft Excel
|PROJECT # |Sum of ASK PRICE |Sum of SELL PRICE |Sum of SQ. FT. |Sum of # BATH. |Sum of #BDRMS | |Creek Side Huntington |8,351,950 |8,218,280 |155,660 |220.5 |345 | |East River Community |8,289,790 |8,043,790 |150,952 |217.75 |366 | |Eau Claire South |8,810,180 |8,567,800 |161,220 |214.5 |355 | |Forest Green |8,470,960 |8,230,260 |155,510 |215 |348 | |Granite mound |8,284,380 |8,037,360 |150,700 |223 |369 | |Woodland Hills |8,391,670 |8,241,950 |155,850 |226 |358 | |Grand Total |50,598,930 |49,339,440 |929,892 |1316.75 |2141 |

Table 1a Breakdown
|23 |Woodland Hills |
|  |Data |  |  |  |  | |  |Sum of ASK PRICE |Sum of SELL PRICE |Sum of SQ. FT. |Sum of # BATH. |Sum of #BDRMS | |Total |8,391,670 |8,241,950 |155,850 |226 |358 |

47 Granite mound

|  |Data |  |  |  |  | |  |Sum of ASK PRICE |Sum of SELL PRICE |Sum of SQ. FT. |Sum of # BATH. |Sum of #BDRMS | |Total |8,284,380 |8,037,360 |150,700 |223 |369 |

61 Creek Side Huntington

|  |Data |  |  |  |  | |  |Sum of ASK PRICE |Sum of...
tracking img