Online Systems Development

 
Case Study - Safety Fencing (Estimating)
 

The Safety Fencing Estimating System is written in Microsoft Access to provide all the routines needed by a contractor to record enquiries, produce estimates, record measured work and generate Applications. The program is simple to use consisting of a switchboard (or menu) and a number of tailored forms and reports. Most safety fencing contractors now use this package  in its standard or a modified form.

(Click on any of the forms for a more detailed view)

Estimating Operation

 

Enter the Enquiry and Price the Work

The form opposite is completed and the system allocates a unique reference number. Information entered includes the title, the type of work, geographical area, due date and the client. This information with a price (if estimated) produces a set of reports to replace the conventional enquiry or quote register.

The program makes extensive use of a library of standard information e.g. Clients, Types of Work are pre-defined and are selected from lists to minimise errors and reduce typing.

Fields in yellow allow a "double click" to access the library directly and to add to an existing list new information without leaving the current form

   
   

Define the Bill Sections and add Items

If the enquiry is not priced a "We Regret" letter is automatically produced which may be posted, faxed or emailed to the Client.

If the enquiry is to be priced one or more bill sections are created using the form opposite and items of work are appended to create a bill of quantity.

As the items are reasonably standard in nature each is described in the library with the details of labour, plant and steel content.

This content is then re-priced when the item is used by applying a nominated steel price list and setting a number of discount factors affecting the labour, plant and steel content.

 
Enter settings which may be revised later Enter the items from the library

Once priced, a standard letter with a Bill of Quantities is produced which may be posted, faxed or emailed to the Client.

More >>

Copyright Online Systems Development Limited