MBA Wild Wood Apartments - Assignment Example

MBA WILD WOOD APARTMENTS Index Page Chapter Chapter 2…………………………………………………………………………………. Chapter 3…………………………………………………………………………………. Chapter 4…………………………………………………………………………………. WILD WOOD, Chapter 1 Topics included sales and purchase of albums, employees of the company, Expenditures of the company, Terms and conditions of the company, Contracts or agreements, example lease, Assets acquired e.g. stationery among other tangible assets History Wild wood apartments have been a host to most of the occupants in New York City, Boston, Louisiana and California. The growth rate of the following town has seen the apartments booked and the contract is agreed upon with the tenant. The apartments are well furnished with the best quality products and latest fittings that meet the growing population needs. The wild wood company offers fair rates to employees who live and maintain the apartments. It is the tradition of the wild wood apartments to ensure that they meet to discuss on how to improve the standards of their apartments and plan to expand their business in real estate. Tenants fill questionnaires every end month to air out complaints or suggest on new ways to maintain the apartments. SCOPE The introduction of a database will be to meet the daily needs of the employees and the tenants who live within the Wild Wood apartments. It will also help in keeping of records of the apartments such as expenditure and the rents paid by the tenants. The database may also have records on the margin of profits and losses of the apartments. OBJECTIVES 1. Have the actual number of tenants in the apartments 2. Compare difference occupancy rate of all apartments 3. Have all grievances addressed to the letter to avoid vacation of the apartments 4. To ensure proper us of appliances in the apartments such that the tenant could repair damaged appliances’ before vacating 5. Have the actual figure of the rents and the possible values in case of any change so as to have a clear comparison during meetings 6. Have all sorts of receipts noted down example tenants receipts and purchased goods that may be purchased for any changes to be done 7. Note events such as robbery or fire cases in any of the apartments among other cases that may have happened within and how to prevent them. 8. Regulation of prices such that they may not be too high or too low TASKS AND TIMELINE 1. Gathering Data: The manager may gather information in different ways of data collection such as surveying, observation and filling of questionnaires. Time allotted 3 weeks. Deliverable: A list of schedule of interviews and observations by relevant employee, text of the questionnaires. 2. Analyzing Data: Data gathered can be analyzed to determine business rules and other preliminary data modeling. Time allotted 3 weeks. Deliverable: Rules of the business should be reviewed including the basic entities and attributes. 3. Normalization: The data model will be completed with entities and relationships normalized. Time allotted 1 week. Deliverables: Entity Relation Diagram for Review. 4. Building the physical database: The data model will be translated to the Relational Database Management system. Tables, Columns with specific data types and Relational and other constraints created. Time allotted 2 days. Deliverables: The Schema of the database for review. 5. Testing and security: Sample data will be entered and each of the business rules and requirements will be tested. General database security and security related to business rules will also be tested. Time allotted 3 weeks. Deliverables: Documented test results 6. Database completion and installation: Final changes and corrections are made. Sample data will be removed and the database installed on a server. Final testing for server access and connections. Time allotted 2 weeks. Deliverables: The working database total time between beginning of project and end: 11 weeks, 3 days. WILD WOOD, Chapter 2 Leases of California apartment Apt # Lease Number Lessee Name Start Date End Date Rent Amount Deposit Current 101 7017509 John’s Bates 6/1/2008 5/2/2008 $ 1,700.00 $ 3,500.00 1 320 16000109 Gibson Howard 9/1/2008 9/2/2008 $ ,2000.00 $ 2,700.00 1 301 786060104 Veronica Gibbins 25/1/2008 25/2/2008 $ 2,250.00 $ 3,500.00 1 148 201060106 Samantha Malone 14/1/2008 6/2/2008 $ 1,350.00 $ 3,000.00 1 13 21406019 Jeff Craig 15/1/2008 12/3/2008 $ 2,450.00 $ 4,000.00 1 Table 1 1. Would the database have all tenants included in it 2. Can there be any additional space for more tenants to move in 3. Tenants with apartments with executive option 4. Should there be warning signs and direction signs indicated Rent payment Date Name Apartment Lease Number Amount paid Late 12/1/2010 Martin Cliffs 5467 453011208 $ 1,100.00 12/1/2010 Louise kelvin 231 768060108 $ 1,300.00 12/1/2010 Susan Tales 16 x 12/1/2010 Anthony Hedges 78 9876020209 $1,350.00 12/1/2010 Clifford Jones 190 098710109 $1,200.00 12/2/2010 Anthony Hall 50 09875010109 $1,350.00 12/2/2010 Bobby Brown 198 434030209 $1,450.00 12/2/2010 Dennis sheath 200 875600.00 X Table 2 1. Does it show how the rents are to be collected and dates rents should be collected? 2. Does it ensure that the rents are filled in? 3. How do you identify the number of tenants who have paid rent on time? 4. Are their fines imposed for tenants who pay their rents on a later date? Quarterly report Building #12 Address 1321 Eastlake, Seattle, and WA.98123 Quarter spring year 2009 Total apartment currently occupied percent no. changing tenants 45 40 89% 13 Revenue Total rent revenue 275000 Expense Utility 1840 Maintenance 13298 Repair 8790 Insurance 6340 New tenant cleaning 11 400 Wages 20,200 Total expense 61,868 Unrecovered rent 4,200 Total profit 116,822 Table 4 1. What is the aim of following up with the tenants migration? 2. Do the records show the profit and loss margin? 3. Can one compare and combine all three quarters records to generate a report? 4. How does the manager deal with issues such as late payments and lack of payments? 5. Are there any computers that are used to store and retrieve data 2. Stakeholders of wild wood apartment: Manager Tenants Shareholders / owners /Landlords Employees And any other individuals who has an interest on the wild wood 3. An interview with one of the representative of the Tenants: Wild Wood Apartments Total time: 60 minutes Allow 10 minutes for introduction Questions For Time allotted How do you pay your Rent? Do you have a method of paying? Tenant (Joseph Hoddap) 8 minutes What are the reasons that led you to renting into the apartments Tenant (Joseph Hoddap) 10 minutes What are the improvements or suggestions would you share with the apartments manager or changes made Tenant (Joseph Hoddap) 10 minutes How is the management of the apartments Tenant (Joseph Hoddap) 5 minutes Do you feel the rent is too high or are you comfortable with it Tenant (Joseph Hoddap) 10 minutes Are you receipted after every payment? Tenant (Joseph Hoddap) 5 minutes Are you as a tenant have your complaints attended to? Tenant (Joseph Hoddap) 10 minutes 4. Questionnaire for the owners of the 20 apartment buildings. 1. How many apartments do you own? a) 8 b) 20 c) 34 d) 34 and more 2. How often do you need to have updates the progress of the rent per year? a) 1 time b) 2 times c) 3 times d) 4 times or more 3. How do you make sure that the investment is worth it? a) Giving good prices. b) Maintenance of the premises. c) Availability. d) Its Convenience 4. What is the first step you take to deal with the losses per year? a) Change the management b) Board meetings c) Have audits ERD diagram Read More