Navigation:  Rounding Issues > Target

Use Case

The Overhead workbook feeds in the selling prices to the Minutes and WBS. To make sure the grand total is the same in WBS and Overhead workbook in spite of the rounding in the Overhead Summary sheet, QDV7 tweaks a particular selling price.

One row among all the Minutes can be declared as the compensation line; it is the Minute whose selling price is adjusted for the WBS selling price to equal the Overhead Summary rounded selling price (target value).

This is not compatible with Forced Prices.

 

Procedure

Tool: bar Automation, group Formulas, icon Target values

1.In the Summary sheet of the Overhead, answer Yes to the question Must handle target value?; this shows the rounded value of the total selling price, which is the overall target; refer to How to Compute the Selling Prices

2.Select a row with a big enough selling price and a quantity of 1 in the Minutes'view; the quantity of the parent task in the WBS must also equal 1

3.Click Set Compensation Row; the row gets colored and hatched

4.Press Ctrl F5 to compute the selling price of the target; as a result, the line selling price of the target Minute and the selling price of the parent task are adjusted (but not the selling factor in the Minutes if it shows there).

Here, the full disk area is the target value (Overhead Summary rounded selling price). (We hypothesize that all the WBS quantities are 1.)

By default, the rounding formula in step 1 is =ROUND(F19,-2). Refer to ROUND function.

 

To revert to normal, click again Set Compensation Row.

If you repeat the steps with another row, the previous target gets regular.

To inhibit the function programmatically, use a verb; refer to Events Management.

 

NOTE  A warning prompts to select another row in place of the first one

- if the compensation exceeds 50%,

- if the quantity of the Minute, or of the parent in the WBS, is different than 1. There may be other occurrences of the Compensation Row in other tasks; then two rows will show in the Nomenclatures.

If you will deliver only a WBS report or document, you can bypass the warning by declaring an empty row in any task as the Compensation Row.

 

To retrieve a target in a long list of minutes, click Reach Compensation Row.

Using the native column Line target value, you can insert in the Minutes a column whose value is 1 in the target row.

The offset applied to the selling price can be read. Refer to Global Variables.