Write a statement of work to present to wild wood management

Assignment Help Database Management System
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.

Reference no: EM13809277

Questions Cloud

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

Reviews

Write a Review

 

Database Management System Questions & Answers

  What must a user guarantee with respect to a transaction and

What must a user guarantee with respect to a transaction and database consis-tency? What should a DBMS guarantee with respect toconcurrent execution of several transactions and database consistency?

  Find all employees in the database

Find the names and cities of residence of all employees who work for ABC Corporation

  Database design for the solution of new database

You have completed the database design for the solution of new database you selected in week 1 in Microsoft Access; the final step is to submit the database for implementation. After you have created the remaining pieces needed for the application..

  Explaining uses for views

Views are integral part of virtual private databases, yet views are utilized for many other reasons. Find out many other uses for views.

  Briefly explain the aries recovery algorithm

Briefly explain the ARIES recovery algorithm, including the main phases, main principles and key ideas behind the algorithm such as WAL protocol and checkpointing etc.

  Create and input the design of the table

When building a database, you should first create and input the design of the table and reports at the same time. determine the input and then design the tables

  Write a memorandum to sam jones

Write a memorandum to Sam Jones (CIO) and present your research findings. Your memorandum should be no longer than 500 words.

  Design a database - what is the purpose of your database

Design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database and how it will be organized.

  Describe how you created the conceptual and process

Describe how you created the conceptual and process view for all four (4) diagrams. In the description, be sure to provide a justification for each key decision in the design.

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Describes the movement of inventory

Create a decision table that describes the movement of inventory and draw a decision tree that describes the merchandise inventory management process.

  Use data mining technique

The software MUST use DATA MINING TECHNIQUES (at least one like classification or association rule mining etc). The work involves analysing loads of the Hospitals data to search for the desired patterns.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd