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.
|
Articles on strategic management of apple
: Use the Internet or the Library to research articles on strategic management of Apple Inc. and Samsung Group. This assignment can be written on either Apple or Samsung or both if any question apply to either company.
|
|
Research and compare behavior assessment instruments availab
: Research and compare behavior assessment instruments available on the market today. Select and evaluate two behavior assessment tools by completing a complimentary assessment. Summarize your experiences, comparing the two instruments in relation to o..
|
|
Explain how the nomination and appointment of federal judges
: Explain how the nomination and appointment of federal judges differs from Supreme Court Justices. As well, explain how does the selection and length of terms differs between Supreme Court Justices and members of Congress.
|
|
Investment and portfolio management
: Starting with a notional AED 100,000 you will build up your portfolio by investing in securities in the Abu Dhabi Stock Exchange (ADX) and the Dubai Financial Market - Investment and Portfolio Management
|
|
Write a statement of work to present to wild wood management
: Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Write a statement of work to present to the Wild Wood management
|
|
Write a technical report for m-globals upper management
: Write a technical research report for M-GLOBAL's upper management. The topic you have been assigned is the wireless sensor network industry.
|
|
Cost of contracting and training a new supplier
: If you decide not to use all 20 suppliers, average cost of not buying from a supplier is $400 per supplier as the supplier has to be compensated for lost business. If you decide to get new suppliers, the cost of contracting and training a new supp..
|
|
Archiving cost and schedule data
: Determine one (1) mistake that project managers are most likely to make when archiving cost and schedule data for their projects. Next, propose one (1) strategy or best practice for limiting the mistake in question. Justify your response.
|
|
The federal reserve system to reform the national economy
: What are your thoughts on President Wilson instituting the Federal Reserve System to reform the national economy
|