iPE Help

How to Perform a Sweep Analysis (Scan for new source documents since costing which might impact the cost)

Updated on

Explains how to review proposal costs and pricing at a summary level, as well as how to input independent assessment data

To review your proposal pricing open a proposal and click on the PRICING tab as highlighted below. Here you will see and can edit:

  1. Whether the proposal pricing is primarily market-based ("what are other's charging?"), benefits driven ("what is the value to the client i.e. how much can they afford to pay?") or cost-based ("what is my target margin on top of my estimated costs?")
    • Often pricing is a mixture of all three however one strategy tends to dominate
    • With cost-based or cost-plus pricing the line item prices can be set calculated as cost + margin, vs. with market-based and benefits-driven pricing the margin is calculated as price - cost
  2. You can upload a business case for this bid, as a file attachment
  3. Select whether you know who your competitors are, or not. If you have done some offline competitor research, then upload it here - for example a comparison of each competitor's strengths and weaknesses in Excel would allow you to determine what price is competitive enough to win
  4. If the total estimated cost exceeds $10,000,000 then mark this as a major quote
  5. Enter the total target "price to win" (PTW) here. This is maintained for the entire proposal, and is normally derived from a competitor analysis (uploaded in item #3)
  6. The total "design to cost" (DTC), rolled up from design to cost targets maintained in your WBS, is displayed here. You can edit the total DTC for the proposal resulting in a variance compared to the rolled-up DTC in the WBS tab
    • Click on the "Quotation P&L" link to see the proposal cost, price and margin laid out more like a profit & loss financial statement
  7. The total price of the proposal is calculated by summing up net price (unit x qty + freight/discount/tax etc.) for each line item. The total cost of the proposal is calculated by summing up the costs estimated on each WBS
  8. Three margins are displayed:
    • Target margin is the desired margin for this proposal. It is calculated as price-to-win less design-to-cost. All margins can be displayed as a monetary amount in the internal company currency, a monetary amount in the external company currency or as a %
    • The quotation margin is the difference between the total price of the proposal less the estimated cost
    • The forecast margin is the difference between the total price of the  proposal and the risk and investment adjusted cost
  9. The sum of weighted risks and weighted opportunities is displayed for all risks and opportunities in your proposal risk register
  10. Enter a figure for any strategic internal investment in this box. The risk and investment adjusted cost is calculated as the estimated total cost + sum of weighted risks - sum of weighted opportunities - strategic investment. This is in turn used to calculate the forecast margin
  11. If you do enter a strategic investment enter an explanation or justification for this investment below
  12. If authorized, you can update your proposal status by clicking on the status menu and selecting a new status from the menu.

If you scroll down you can edit Independent Assessment and indirect cost attributes, as well as win/loss criteria, as shown below:

  1. The costing sheet is used to calculate indirect costs. It defaults based on your leading company  or business unit in the SETUP tab however you can select a different indirect costing sheet to invoke different indirect rates
  2. If you perform an independent assessment of the proposal cost enter the minimum (best-case), most likely and maximum or worst-case cost estimate for your entire proposal.  This information is used to score or rate your proposal and to compare to the risk adjusted cost from the detailed bottom-up cost estimates
  3. The performance risk factor is a factor applied to the weighted risk impact to account for the effect of the proposal's risk and opportunities on performance. It can be used to determine the independently assessed difference between unfactored and factor risk or opportunity impact
  4. The G&A absorption factor accounts for the fact that most general and administrative costs will be incurred by the business regardless of whether this proposal is won or lost, and probably won't vary that much if this proposa is won. While the true cost estimated for this proposal includes indirect costs such as G&A, it is reasonable to calculate the:
    • Gross margin or price - direct cost
    • Net margin or price - total direct+indirect cost
    • Contribution margin or price - fringe, overhead and a portion of the G&A cost i.e. total G&A x adsorption %
  5. You can edit the anticipated probability of closure resulting in the factored value of this proposal calculated as total price x probability of closure
  6. Check this box if / when you win this proposal. If you lose this bid select a reason for loss from the list below
  7. ...and provide a detailed explanation for your loss in the text box
  8. Finally you can select who won the bid and provide a shorter explanation of why your or another company won the bid in the text box

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article How to Define a Strategic Investment for a Proposal or Capital Project
Next Article Net Present Value Proposals or Project Estimates vs.Escalation to Future-date costs