Using the allowed amounts, calculate the percent of reimbursement for each carrier Develop a weighted rate for each month based on the payer mix for that month Apply that weighted rate to the total revenue Subtract the assumed bad debt Develop a spread sheet with imbedded formulas so your provider can enter a payer mix and total revenue in future months and be able to calculate potential reimbursement. Include instructions and "what-if" scenarios in a Word memo