Management Information Systems

• Cover page must have the following: 1) Course Name & Number, 2) Section, 3) Group Number 4) Group Member’s name & Student ID.
• Copy this assignment in a CD and make sure you CD cover have the following: 1) Course Name & Number, 2) Section, 3) Group Number 4) Group Member’s name & Student ID.
• Due date for this assignment is 1^st Oct, 2019 (before class).
• Extra point will be given for nice excel/report presentations.

You are the manager for a real estate company XYZ, which has been selling properties in seven neighborhood namely A to G for the past twenty years. At the most recent board of directors meeting, the manager was asked to identify and prioritize all seven neighborhoods based on “Ratio of Sale Price to Total Appraised Value” to help the board to make a policy for the company to target the three most lucrative neighborhoods in the near future.

Data available to calculate the “Ratio of Sale Price to Total Appraised Value” include 1) Appraised land value in each neighborhood, 2) Appraised value of improvement in each neighborhood and 3) final sale price of the property for all the 2405 sales for the last twenty years (provided as a spreadsheet under the WebCT). Your task now is to utilize the analytical and graphical capabilities of Excel to turn the data into managerial useful information.Project results should be supportedwith proper recommendation.

The data collected concerning the real estate sales includes;