Cost Markup

The Work program's Cost Markup feature enables users to apply additional charges or overhead costs to the use of a Work Order Resource. For example: The City is installing a new sewer main and has ordered 100 feet of 48" diameter concrete pipe. The pipe costs $5,000, along with a delivery charge of $10 per foot. The agency adds a $1,000 Cost Markup to the Material Resource record for the pipe to account for the delivery charge.

The Cost Markup grid for Work Order > Material Resource records lists cost markups that are applied as a group. Users can add records to this list individually or load items from the Cost Markup Library.

In the Work Orders > Tasks > Employees grid, click the to expand the Material Resource record to which you want to add a Cost Markup.
In the Cost Markup grid, click Add . The Cost Markup form opens.
Enter a number value for the type of adjustment you wish to apply*:
- Percentage - Applies a fraction of the Resource's Unit Cost as a markup. Enter a number. (The system converts the value to a percentage for calculations.)
- Flat Rate - Applies a set amount as a markup. Enter a dollar amount.
If you entered a Flat Rate in Step 3, use the Calculate On pick-list to select how the flat rate should be applied:
- 1|Units - Multiplies the Flat Rate by the Resource's Units value to determine the markup.
- 2|Subtotal - Adds the Flat Rate as a fixed value.
The system immediately displays the effects of the Markup in the New Unit Cost Add-on and Total Cost Markup fields.
Enter a Not To Exceed value, if desired. If Total Cost Markup > Not To Exceed, the Not To Exceed value will replace the Total Cost Markup.
Click Save . The new Cost Markup record now appears in the grid, and the total value of the Cost Markup appears on the Material Resource record.
*Note: Users may choose only one type of adjustment (Percentage or Flat Rate) per Cost Markup record. To apply a markup of another adjustment type, create additional Cost Markup records.

In the desired Work Order's Tasks > Resource grid (Employees, Materials, Fluids, Equipment or Contractors), click the Toolkit button and select Load Cost Markup List. The following pop-up appears:
Select a Cost Markup record from the list.
Click Select. The system copies the Cost Markup Detail records from the selected Cost Markup Library to the Cost Markup grid for the selected Work Order Resource.

Percentage	Applies a fraction of the Resource's cost to the Total Cost as a markup. Enter a number. The system will divide this number by 100 for all calculations.
Flat Rate	Applies a set amount as a markup.
Calculate On	Controls how the system applies the Flat Rate markup. 1\|Units - Multiplies the Flat Rate by the Resource's Units value to calculate the markup. 2\|Subtotal - Adds the Flat Rate as a fixed value.
New Unit Cost Add-on	Displays the amount added per Unit. If the Markup method was: Percentage = (Percentage/100) x Resource's Unit Cost Fixed Rate on Unit - Displays the Flat Rate. Fixed Rate on Subtotal - N/A.
Total Cost Markup	Indicates the amount that this Markup record will add to the Resource's Cost Markup value. If the Markup method was: Percentage = New Unit Cost Add-on x Resource's Units Fixed Rate on Unit = Flat Rate x Units Fixed Rate on Subtotal - Displays the Flat Rate. Note: When Total Cost Markup > Not To Exceed, the Not To Exceed value will replace the Total Cost Markup. This value is rolled into the Cost Markup value on the Work Order Resource record.
Not To Exceed	Identifies a limit at which this Cost Markup will be capped. When Total Cost Markup > Not To Exceed, the Not To Exceed value will replace the Total Cost Markup.