Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Each apartment complex contains anywhere from 10 to 60 separate apartments of varying sizes. All apartments are leased with a six-month or one-year lease.
It is the company's practice to hire one of the tenants to manage each apartment complex. As managers, they need to admit new tenants to the building, collect rents from existing tenants, and close out leases. The manager also needs to maintain the apartments, conducting any repairs, replacements, or renovations. These can be billed back to the parent company. For acting as manager, the tenant gets free rent and a stipend. The stipend varies depending on the size of the apartment building.
Each manager is expected to send a report to the Wild Wood Apartments company headquarters in San Francisco every quarter. This report summarizes the occupancy rate, the total revenues in rent, the total expenses in maintenance and repairs, etc. Currently managers fill out a paper form and mail it back to headquarters. Many apartment managers have complained that preparing this report is a very difficult and time-consuming process. Also, the managers at corporate headquarters have expressed concerns about the accuracy and verifiability of the reports.
To allay these concerns and to improve the ease and efficiency with which the apartment managers conduct their daily business, the company is proposing the development of a centralized database that the managers can use to track the daily business of their apartment building and to prepare their reports.
As a follow-up on your initial interview with the project coordinator, Wild Wood Apartments has agreed to show you some samples of various forms and reports they use.
Lease Form: Tracks leases of one apartment complex
|
Apt #
|
LeaseNumber
|
Lessee Name
|
StartDate
|
EndDate
|
Rent Amount
|
Deposit
|
Current
|
|
201
|
#201050109
|
Charles Summers
|
5/1/2009
|
5/1/2010
|
$1,500.00
|
$3,500.00
|
1
|
|
110
|
#110060109
|
Marilyn Newton
|
6/1/2009
|
12/1/2009
|
$1,200.00
|
$2,900.00
|
1
|
|
306
|
#306060109
|
Janice Lewis
|
6/1/2009
|
6/1/2010
|
$1,250.00
|
$3,000.00
|
1
|
|
102
|
#102060109
|
Larry Thomas
|
6/1/2009
|
6/1/2010
|
$1,250.00
|
$3,000.00
|
1
|
|
209
|
#209060109
|
Mark Patterson
|
6/1/2009
|
12/1/2009
|
$1,450.00
|
$3,400.00
|
1
|
Rent Payment Form: Tracks rent payment of one apartment complex
|
Date
|
Name
|
Apartment
|
Lease Number
|
Amount paid
|
Late
|
|
7/1/2009
|
Martin Scheller
|
203
|
#203011208
|
$1,200.00
|
|
|
7/1/2009
|
Roberta Louise
|
311
|
#311060108
|
$1,400.00
|
|
|
7/1/2009
|
Sue Tam
|
111
|
|
$1,400.00
|
|
|
7/1/2009
|
Laura Henderson
|
207
|
#207020209
|
$1,350.00
|
|
|
7/1/2009
|
Thomas Jones
|
110
|
#110010109
|
$1,200.00
|
|
|
7/2/2009
|
Shannon Hall
|
205
|
#205010109
|
$1,350.00
|
|
|
7/2/2009
|
Bob Newton
|
104
|
#104030209
|
$1,250.00
|
|
|
7/9/2009
|
Dennis Smith
|
209
|
|
$1,400.00
|
X
|
Maintenance Request Form: Tracks requests for maintenance and apartment manager's resolution
|
Apt
|
Date
|
Problem
|
Type
|
Resolution
|
Res Date
|
BExpense
|
Texpense
|
|
303
|
7/5/2009
|
Left burner out on range
|
electrical
|
Electrician rewired
|
7/10/2009
|
$150.00
|
$ -
|
|
201
|
7/5/2009
|
Water damage from overflowing bathtub
|
floor
|
Replaced flooring new tile
|
7/21/2009
|
$200.00
|
$350.00
|
|
101
|
7/6/2009
|
Dishwasher backing up
|
plumbing
|
filter clogged cleared it
|
7/6/2009
|
$35.00
|
$ -
|
|
207
|
7/15/2009
|
Hole in plaster
|
walls
|
Patched hole
|
7/17/2008
|
$ -
|
$250.00
|
|
113
|
7/15/2009
|
Refrigerator failed
|
utilities
|
new refrigerator
|
7/20/2009
|
$690.00
|
$ -
|
Sample Quarterly Report, which each manager must turn in to the main office
|
Quarterly Report
|
|
Building#
|
#12
|
|
|
|
|
Address
|
1321 East Lake, Seattle, WA 98123
|
|
|
|
|
Quarter
|
Spring
|
Year
|
2010
|
|
|
Total Apartments
|
Currently Occupied
|
Percent
|
No. Changing Tenants
|
|
45
|
40
|
89%
|
13
|
|
|
Revenues
|
|
Total Rent Revenue
|
175,500.00
|
|
|
|
|
Expenses
|
|
Utilities
|
2,450.00
|
|
|
|
|
Maintenance
|
11,298.00
|
|
|
|
|
Repairs
|
9,790.00
|
|
|
|
|
Insurance
|
5,340.00
|
|
|
|
|
New Tenant Cleaning
|
10,400.00
|
|
|
|
|
Wages
|
19,200.00
|
|
|
|
|
Total Expenses
|
58,478.00
|
|
|
|
|
|
|
Unrecovered Rents
|
3,200.00
|
|
|
|
|
|
|
Total Profit/Loss
|
113,822.00
|
|
|
|
Based on the scenario, complete the following tasks:
1. List the major topics for this database.
2. Write a statement of work to present to the Wild Wood management.