Use Advanced Costs in Laboratory Contracts
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
The Advanced Costs option in the lab contract allows for estimating cost-per-tasks by method analyte group (MAG) or at the analyte level. MAG rates are grouped by COST_CALC_CODE. For example, Lab1 may have a cost rate per MAG based on the number of samples, reporting levels, and turnaround times (TAT). The table RT_SPM_COST_CALC stores the different COST_CALC_CODES while RT_SPM_COST_CALC_MAG will store the details of each code.
Cost data can be uploaded to SPM tables in two ways:
1.Using the SPM_REF.xsd EDD format as explained in Upload Reference Values with SPM_REF EDD Format. This format is installed by default in the \Program Files\EarthSoft\SPM\Format\SPM\ directory. An example EDD named "SPM_Example_EDD.xlsx" is also supplied in the same folder and houses some example cost calculation data.
2.Using the Advanced Costs form as explained in Advanced Costs Manager.
Assigning advanced costs to contracts
1.Click Contracts on the Plan ribbon
2.From the Contracts column on the left side of the screen, select the relevant contract.
3.Select the Method Analyte Groups tab in the Contract Items section to the right.
4.Click Add to create a new MAG, or select an existing MAG from the list displayed and click Edit.
5.In the Cost group area, select Advanced.
6.Select the Cost Calc Code, Cost Type and Report Level as you see fit. The type can be “MAG” or “analyte”.