WC Spec Sheet (Additional Payers)

Updated 11 months ago by Dawn Garand

  • DiscountOffStdFee
  • Profit Margin by Allow (TotalAllowable - TotalCost) / TotalAllowable
  • Profit Total (TotalAllowable - TotalCost)
    • Qty
    • Item Number
    • Manufacturer
    • Model
    • Description
    • Primary Code
    • Secondary Code
    • Tertiary Code
    • Primay Reimb. (Primary Allow * Qty)
    • Secondary Reimb. (Secondary Allow * Qty)
    • Tertiary Reimb. (Tertiary Allow * Qty)
    • Retail (Retail * Qty)
    • Cost (Cost * Qty)
    • Bill (((Bill * (100 - DiscountOffStdFee)) / 100 * Qty)
    • Profit Margin ( (AllowableTimesQty - (Cost * QuantityOrdered)) / AllowableTimesQty ) Where AllowableTimesQty = (Primay Reimb + Secondary Reimb + Tertiary Reimb) * Qty

Notes: Billing Multiplier = first find of billing multiplier looking in order for 

  1. line item billing multiplier
  2. primary payer billing multiplier
  3. system billing multiplier

Bill = Retail * BillingMultiplier

Discount to calculate Cost from Retail = first find of


How did we do?