Use Advanced Costs in Laboratory Contracts
Copyright © 2019 EarthSoft, Inc • Modified: 12 Nov 2019
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.
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 desired. The type can be “MAG” or “analyte”.