Show Original Cost of Quoted Field Plans

Q.  Field plans are usually created several weeks or months ahead of actual applications and billing. Since product costs can fluctuate over time, is there a way to display the original costs of the products from when the plan was first created?

A.  Go to the Planning / Setup / Location Preferences / Blend Setup tab and check the box, shown below, to Show Original Costs on Pricing Options when available. The Quoting Basis is used as the default for the Cost Type on the Pricing Options window of a Field Plan or Blend. In the example below, Replacement Cost will be used as the default Cost Type.

Start out with a Field Plan and mark the prices as quoted. Shown below is the quoted plan with the products used in that plan.

Directly below is the pricing option information that was saved on the plan at the time it was created.

Below are the costs of the products at the time the plan is saved (Hub / Utilities / Edit Product Pricing).

Now we’ll edit the Replacement Cost of each product to reflect what may happen over time. All products except Water were increased $50/ton.

Next, the plan is imported into a Blend Ticket. Remember to use the Plan selection drop down on the Blend Ticket (since the Import Blend button does not bring across the quoted prices) of the imported transaction.

On the Prices tab of the Blend Ticket, select the Pricing Options button. This will show the default Cost Type (set by the Quoting Basis), the Original Costs, Current Costs, Quote Costs, and the Difference.

Note that the Current Cost of this blend is $162.89/ton and the Quoted Cost was $119.84/ton. That’s a difference of $43.05/ton.