Reference no: EM13809277

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.