Ask Your Mates Open Forum

Works Estimator

  • 1.  Works Estimator

    Posted 28 January 2020 23:14

    G'day everyone,

     

    We've recently renewed our annual supply contracts for civil works and are looking to create some sort of works estimator program. The program needs to be able to collate rates from all our contractors' for comparison purposes while referencing specific contract items.

     

    My main concern is the manual work involved at the beginning when inputting the rates into the program initially. This is especially concerning as we have rates for over 300 items and many of which include different rates to factor in economies of scale. Multiply that by 5 contractors and we're looking at a lot of work up front.

     

    Hoping for recommendations and advice.

     

    Regards,

     

    Samuel Beshai | Project Manager

    City of Whittlesea

     

    T: 03 9217 2553 | M: 0438 929 694 | TTY: 133 677 (ask for 9217 2553)

    Council Offices: 35 Ferres Blvd South Morang, Victoria 3752

    http://www.whittlesea.vic.gov.au

     

    ------------------------------------------------------------------------------------------------------------------------------------ Any personal or sensitive information contained in this e-mail and attachments must be handled in accordance with the Privacy and Data Protection Act 2014 (Victoria), the Health Records Act 2001 or the Privacy Act 1988 (Commonwealth), as applicable.   This e-mail, including all attachments, is confidential. If you are not the intended recipient, you must not disclose, distribute, copy or use the information contained in this e-mail or attachments.   Any confidentiality or privilege is not waived or lost because this e-mail has been sent to you in error. If you have received it in error, please let us know by reply e-mail, delete it from your system and destroy any copies.
    BlogPageSpacerBlank


  • 2.  RE: Works Estimator

    Posted 29 January 2020 20:38
    ​Hi Samuel,
    I'm not clear if you're talking about goods or plant hire, but we either way we share your pain.  Over the last couple of years we have improved our processes by requiring tenderers to return schedules with locked-down spreadsheets etc, however there is still a lot of manual review and assessment required to confirm rates and rankings.  We'd be happy to share what we have, but we'd be equally keen to hear of better ways of running these time consuming procurements.
    Feel free to contact me, Tim Mackney tmackney@tweed.nsw.gov.au, or our Contracts Coordinator, Charlotte Neilson cneilson@tweed.nsw.gov.au
    BlogPageSpacerBlank


  • 3.  RE: Works Estimator

    Posted 02 February 2020 16:53
    Hello Tim and Samuel,

    We are currently in the process of doing this for the City of Selkirk as well - we have found this to be a very manual process. We are at the beginning stages right now, so we have not yet gotten to the point of changing how our tenders are returned to us, but this is something that we would like to do. I an wondering if you would be able to share with me the schedules/spreadsheets that you require tenders to return to you?

    Looking forward to chatting - thank you,
    Megan
    BlogPageSpacerBlank


  • 4.  RE: Works Estimator

    Posted 02 February 2020 17:30
    At the old Great Lakes Council, for plant hire, we conducted our plant hire through a process where contractors had to log-in to a website and upload directly into our database all of their plant hire details.  This covered a large number of fields, and the process saved our internal staff a significant amount of time.  Just remember there is always more than one way to skin a cat.

    ------------------------------
    Stuart Small
    Team Leader Project Delivery
    MidCoast Council
    ------------------------------

    BlogPageSpacerBlank


  • 5.  RE: Works Estimator

    Posted 29 January 2020 20:38
    ​Hi Samuel,
    I'm not clear if you're talking about goods or plant hire, but we either way we share your pain.  Over the last couple of years we have improved our processes by requiring tenderers to return schedules with locked-down spreadsheets etc, however there is still a lot of manual review and assessment required to confirm rates and rankings.  We'd be happy to share what we have, but we'd be equally keen to hear of better ways of running these time consuming procurements.
    Feel free to contact me, Tim Mackney tmackney@tweed.nsw.gov.au, or our Contracts Coordinator, Charlotte Neilson cneilson@tweed.nsw.gov.au
    BlogPageSpacerBlank


  • 6.  RE: Works Estimator

    Posted 02 February 2020 16:52
    ​30 + years ago Public works NSW had a computer program (yes we had 2 computors in the office) that recorded every tendered rate for the previous 10 years you could look at the average rate for everthing that had been tendered. the program automatically corrected every rate for CPI and displayed the average rate, but you could drill down ito the data if you wanted.
    Smoking while using the computers had to be banned as the ash effected the keyboard function.
    We seem to have made progress in the smoking area but not so much in the estimating area.
    BlogPageSpacerBlank