Still Using Excel for Your Proposal Cost Estimates?

August 14, 2018

A Better Way: Quality Proposal Cost Estimates

 

Anyone who has lived through preparing a proposal in response to a government RFP knows it can be a difficult and painful process.  Often long days, bad food, and not much sleep.  It’s a vital part of business development, however.  Winning proposals means the company stays in business.  The proposal team’s mission is to ensure the company stands out from the competition and presents a compelling response. 

To quote others, preparing the proposal schedule and cost estimate often feels like herding cats.  You need to pull together other people’s assessments of what it will take to deliver what the customer is asking for.  Assumptions are made about the scope of work, how to accomplish it, and level of risk.  You frequently need to rely upon expert judgement from your company’s engineering, manufacturing, or technical people to put all the pieces together – and they need to agree the proposed approach makes sense.  You may or may not have previous historical data available to help you work through that process. 

There are a thousand and one questions you need to answer as you prepare your schedule and basis of estimate (BOE).  What is the approach you want to take to deliver what the customer is asking for?  What are tasks and sequence of those tasks?  What type of resources do you need and for how long?  Do you have them in-house or do you need help from other companies?  What materials do you need?  What’s the time frame to accomplish the work?  What are the risks?  Can they be mitigated to an acceptable level?  Are there unique requirements that mean you need special resources, tools, equipment, environment, or security? 

Time to Step Up from Excel

Perhaps you have found yourself in this situation.  You are collecting a mixture of inputs from your technical experts to create the cost estimate.  You are merging content from multiple spreadsheets into one, copying columns, adding columns, inserting this, deleting that.  Then you discover someone calculated something incorrectly, or they added something you didn’t expect.  Did you catch that in another submission?  Now do you have to redo some of your previous work?  What were the assumptions again?  It becomes a mind-numbing blur.  Then, try and align the cost estimate with the schedule – a whole different challenge to make sure they tell the same story.

The designers of BOEMax have been in your shoes and decided to do something about it.  The result?  A better, faster, and easier way to produce a reliable data-driven cost estimate. 

A Better Way

ProjStream’s BOEMax is designed to:

  • Provide a WBS and workflow framework to organize the data and the proposal team.  The first step is building the WBS in BOEMax or importing the structure from another source such as the schedule or historical data.  You can also import and parse the lengthy statement of work (SOW) documents that you can map to the WBS elements.  That means you can quickly produce a single, standard framework the proposal team or technical personnel can use to break the work effort down to the level they need determine resources and estimate the work.  

    The other benefit?  With the built-in workflow functions in BOEMax, you can route specific work elements to the person responsible for developing the basis of estimate (BOE) and track where things are in the proposal development process.  They can produce a data driven cost estimate, price it, and document their BOE assumptions and rationale in one place.  They can then route the cost estimate with the BOE to the next person for review or approval.  No need to copy and paste or reassemble content because everything is contained within a single database in BOEMax. 

  • Establish standardized methodologies for developing cost estimates.  Why reinvent the wheel for every proposal?  With BOEMax, you have the means to establish a common library of proposal components every proposal team can leverage.  For example, you can establish a library of complex rate structures for the different types of cost elements such as labor, material, subcontract, and other direct costs.  You can establish hierarchical bills of material (BOM) that make it easy to price components.  Or, create estimating templates to capture repeatable work processes with labor and BOM relationships built in.  This increases accuracy and consistency in approach – the proposal teams have a foundation to build their cost estimates using prior estimates or historical actuals.

  • Integrate bi-directionally with schedule tools That means which ever direction you start, the network schedule tasks with resource assignments and the time phased cost estimate data are in alignment.  You can trace the data from either direction and get the same result.  Need to change the proposed schedule tasks, duration, or resources?  No problem – you can quickly reprice the revised time phased cost estimate in BOEMax and you know the data matches. 

  • Make it easy to evaluate alternatives.  Need to do further analysis to determine the best approach to propose?  With BOEMax, you can create different versions to compare the cost estimate results.  Perhaps you need to compare different risk mitigation actions, select the best alternative for a purchased part, or determine whether to make or buy a component.  You can save the result of your analysis for future use – either for another proposal or the project team can use your documented analysis at contract award to develop the performance measurement baseline (PMB).

  • Produce standard cost summary or custom proposal reports.  You can leverage the BOEMax database to produce the required reports with ease.  All the reports are fully traceable from the top down or bottom up.  You can combine rich text data with the cost estimate details to demonstrate traceability between the WBS and WBS dictionary, related SOW, BOE assumptions and rationale, and schedule driven resource budget data.  The perfect basis for developing the PMB after contract award.

Why Make the Change to BOEMax?

BOEMax was designed with you in mind to improve the quality and traceability of the cost estimate data as well as eliminate the data “wrangling” that wastes time.  Producing the proposal response is stressful enough.  With BOEMax, your proposal team can focus on creating a comprehensive and compelling proposal the customer can’t resist.

Call us today to schedule a demo today to see how BOEMax can streamline and improve your cost estimating process.

 

Topics: Basis of Estimate, proposal cost estimate, cost estimate

Author: Jeff Lutton

Get Updates Straight To Your Inbox