Use Advanced Costs in Laboratory Contracts

<< Click to Display Table of Contents >>

EQuIS 7  >>  SPM > SPM Desktop > Contracts >

Use Advanced Costs in Laboratory Contracts

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.

 

Setup

 

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

 

20081-LaboratoryContracts

 

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.

 

20081-MethodAnalyteGroups

 

4.Click Add to create a new MAG, or select an existing MAG from the list displayed and click Edit.

 

20081-MAGCosts

 

Refer to Advanced Costs Manager as needed for clarification of the following functions:

 

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”.

 

The Cost Summary Report includes advanced cost data when used in Scheduled tasks.