WC Spec Sheet (Additional Payers)
Updated
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
- line item billing multiplier
- primary payer billing multiplier
- system billing multiplier
Bill = Retail * BillingMultiplier
Discount to calculate Cost from Retail = first find of
