31 May 2006

Real World Access (15)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.

Arvin Meyer's houses

Construction Database: Database creates, tracks, and awards bids for production homebuilding. It then tracks vendors and costs, loads the data into individual lots (at about 700 homes per year) and issues purchase orders, automatically emailing them to the vendors. Purchase orders are loaded into the individual house and into the accounting system and tracked until final payment is made. An audit trail and a history are kept of all price changes, and a comparison between costs of various models can be implemented. A backlog of homes to build is kept so that projections can be made of 6 to 9 months of activity.

On the sales side, the app creates and tracks contracts from initial buyer interest through closing. Housing prices are determinined by cost projections. Individual contracts are analyzed and accepted. Option costs and prices are tracked and options sold. On the planning side the housing starts are monitored from initial permiting through closing. Warranty service is tracked and quality control reports issued.

Tags:

Powered by Qumana

1 Comments:

At 15 January 2007 4:34 AM, Anonymous Anonymous said...

No screen shot of application.
No Sale :-(

 

Post a Comment

Links to this post:

Create a Link

<< Home