Case Study
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
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