Daily Exam Volume as a Management Tool
Some management techniques take advantage of basic receivables-system information to monitor charge capture and forecast future exam caseloads. The models shown here use real data; a complex hospital-based practice was purposely chosen, with a trend line of January 2008 through August 2009. To understand the power of today’s receivables systems, consider that it took approximately two minutes to write the extraction query for these models, and the compilation took 30 seconds. This covers individual days spanning 19 months. A larger date range would, theoretically, build a more normalized population, but this practice made a significant change in coverage that affected hospital volumes after January 1, 2008.
No strong math background is needed to follow basic statistical techniques. The database extraction was exported to a standard spreadsheet program for modification to produce tables. The receivables-database program can produce statistics; however, in the absence of this feature, the raw data can be exported either to a spreadsheet or to a database program that has statistical functions to produce the same results.
The exam patterns seen for different days of the week can be used by the practice or its receivables vendor to monitor exam capture quickly. The same data can be used in forecasting.
Data Capture
Table 1 illustrates what the total extraction looks like. A month with a national holiday was chosen to meet a requirement of the analysis.
Table 1: Extraction Example: July 2009 | ||
DOS | WEEKDAY | EXAMS |
7/1/09 | WED | 877 |
7/2/09 | THU | 891 |
7/3/09 | HOL | 447 |
7/4/09 | SAT | 351 |
7/5/09 | SUN | 420 |
7/6/09 | MON | 876 |
7/7/09 | TUE | 837 |
7/8/09 | WED | 813 |
7/9/09 | THU | 864 |
7/10/09 | FRI | 962 |
7/11/09 | SAT | 364 |
7/12/09 | SUN | 366 |
7/13/09 | MON | 804 |
7/14/09 | TUE | 901 |
7/15/09 | WED | 847 |
7/16/09 | THU | 867 |
7/17/09 | FRI | 960 |
7/18/09 | SAT | 341 |
7/19/09 | SUN | 409 |
7/20/09 | MON | 879 |
7/21/09 | TUE | 940 |
7/22/09 | WED | 814 |
7/23/09 | THU | 787 |
7/24/09 | FRI | 842 |
7/25/09 | SAT | 355 |
7/26/09 | SUN | 394 |
7/27/09 | MON | 831 |
7/28/09 | TUE | 844 |
7/29/09 | WED | 818 |
7/30/09 | THU | 832 |
7/31/09 | FRI | 848 |
TOTALS | 22,381 |
Fridays are highlighted because Independence Day for 2009 fell on a Saturday, but was observed on the preceding Friday. Note how different the volume can be on a day that is a national or regional holiday. It more closely mirrors weekend volumes, which principally come from emergency-department patients. July 2009 was also chosen because it is outside the population reflected in the monitoring statistics (January 2008 through June 2009). There is an important reason for this, stemming from the inherent delay between the date of service for an exam and the date that it is posted to the receivables system. It can take up to 90 days to capture all exams fully for a given day. Therefore, July 2009 will offer a good opportunity to test actual capture against prior averages. Table 2 illustrates the statistics pertaining to July 2009 matched against those for the full range of dates.
Table 2: Basic statistics on Table 1 data, versus entire population | ||||||||
UNIVERSE: 1/2008 TO 6/2009 | ||||||||
STANDARD | STANDARD | |||||||
WEEKDAY | COUNT | AVERAGE | DEVIATION | VARIANCE | PROOF | AVERAGE | DEVIATION | VARIANCE |
SUN | 4 | 397.25 | 23.40 | 547.58 | 1,589 | 385.76 | 31.77 | 1,009.17 |
MON | 4 | 847.50 | 36.37 | 1,323.00 | 3,390 | 876.46 | 51.60 | 2,662.34 |
TUE | 4 | 880.50 | 48.94 | 2,395.00 | 3,522 | 912.73 | 47.66 | 2,271.73 |
WED | 5 | 833.80 | 27.91 | 778.70 | 4,169 | 888.03 | 62.41 | 3,895.32 |
THU | 5 | 848.20 | 40.13 | 1,610.70 | 4,241 | 873.16 | 80.96 | 6,555.31 |
FRI | 4 | 903.00 | 67.02 | 4,492.00 | 3,612 | 889.75 | 48.82 | 2,383.82 |
SAT | 4 | 352.75 | 9.54 | 90.92 | 1,411 | 394.01 | 32.54 | 1,058.97 |
HOL | 1 | 447.00 | 0.00 | 0.00 | 447 | 397.42 | 63.61 | 4,046.63 |
31 | TOTAL | 22,381 |
The 31 days of July 2009 are organized by day of the week, with a special designation for a holiday falling on a weekday. The average is obtained by summing the exams per day, and then dividing by the number of days. The SD, or standard deviation, is the square root of the variance, and the variance is a measure of the database spread; it is the average of the distances from the mean, squared. These dispersion values help test the credibility of future results.
The three columns at the far right depict the universe of January 2008 through June 2009. The difference between the SD of July 2009 versus the SD of the prior 18 months suggests an important point about these data: seasonal variations. The Tuesday and Friday SDs of the July 2009 universe are the only ones higher than those of the prior universe, suggesting that the volumes for a day of the week, for a given month, might be better matched against those of the same month in different year.
Table 3: July 2008 statistics, versus entire population | ||||||||
UNIVERSE: 1/2008 TO 6/2009 | ||||||||
STANDARD | STANDARD | |||||||
WEEKDAY | COUNT | AVERAGE | DEVIATION | VARIANCE | PROOF | AVERAGE | DEVIATION | VARIANCE |
SUN | 4 | 365.00 | 39.30 | 1,544.67 | 1,460 | 385.76 | 31.77 | 1,009.17 |
MON | 4 | 832.00 | 23.73 | 563.33 | 3,328 | 876.46 | 51.60 | 2,662.34 |
TUE | 5 | 872.80 | 16.63 | 276.70 | 4,364 | 912.73 | 47.66 | 2,271.73 |
WED | 5 | 870.00 | 31.09 | 966.50 | 4,350 | 888.03 | 62.41 | 3,895.32 |
THU | 5 | 821.40 | 26.97 | 727.30 | 4,107 | 873.16 | 80.96 | 6,555.31 |
FRI | 3 | 862.33 | 34.03 | 1,158.33 | 2,587 | 889.75 | 48.82 | 2,383.82 |
SAT | 4 | 387.25 | 37.47 | 1,404.25 | 1,549 | 394.01 | 32.54 | 1,058.97 |
HOL | 1 | 340.00 | 0.00 | 0.00 | 340 | 397.42 | 63.61 | 4,046.63 |
31 | TOTAL | 22,085 |
In Table 3, in some cases, shows even smaller SDs. Statistically speaking, the smaller the SD, the more reliable the population universe used as a benchmark (Tables 4 and 5).
Table 4: Use of the "Z" statistic with the universe: 1/2008 to 6/2009 | ||||||
A | B | C | D | E | ||
UNIVERSE | UNIVERSE | "Z" | ||||
DOS | WEEKDAY | EXAMS | AVERAGE | STD. DEV. | STATISTIC | PROBABILITY |
7/1/09 | WED | 877 | 888.03 | 62.41 | -0.18 | 0.4286 |
7/2/09 | THU | 891 | 873.16 | 80.96 | 0.22 | 0.5871 |
7/3/09 | HOL | 447 | 397.42 | 63.61 | 0.78 | 0.7823 |
7/4/09 | SAT | 351 | 394.01 | 32.54 | -1.32 | 0.0934 |
7/5/09 | SUN | 420 | 385.76 | 31.77 | 1.08 | 0.8599 |
7/6/09 | MON | 876 | 876.46 | 51.60 | -0.01 | 0.4960 |
7/7/09 | TUE | 837 | 912.73 | 47.66 | -1.59 | 0.0559 |
7/8/09 | WED | 813 | 888.03 | 62.41 | -1.20 | 0.1131 |
7/9/09 | THU | 864 | 873.16 | 80.96 | -0.11 | 0.4562 |
7/10/09 | FRI | 962 | 889.75 | 48.82 | 1.48 | 0.9306 |
7/11/09 | SAT | 364 | 394.01 | 32.54 | -0.92 | 0.1788 |
7/12/09 | SUN | 366 | 385.76 | 31.77 | -0.62 | 0.2676 |
7/13/09 | MON | 804 | 876.46 | 51.60 | -1.40 | 0.0808 |
7/14/09 | TUE | 901 | 912.73 | 47.66 | -0.25 | 0.4013 |
7/15/09 | WED | 847 | 888.03 | 62.41 | -0.66 | 0.2546 |
7/16/09 | THU | 867 | 873.16 | 80.96 | -0.08 | 0.4681 |
7/17/09 | FRI | 960 | 889.75 | 48.82 | 1.44 | 0.9306 |
7/18/09 | SAT | 341 | 394.01 | 32.54 | -1.63 | 0.9484 |
7/19/09 | SUN | 409 | 385.76 | 31.77 | 0.73 | 0.7673 |
7/20/09 | MON | 879 | 876.46 | 51.60 | 0.05 | 0.4801 |
7/21/09 | TUE | 940 | 912.73 | 47.66 | 0.57 | 0.7157 |
7/22/09 | WED | 814 | 888.03 | 62.41 | -1.19 | 0.1170 |
7/23/09 | THU | 787 | 873.16 | 80.96 | -1.06 | 0.1446 |
7/24/09 | FRI | 842 | 889.75 | 48.82 | -0.98 | 0.1635 |
7/25/09 | SAT | 355 | 394.01 | 32.54 | -1.20 | 0.1151 |
7/26/09 | SUN | 394 | 385.76 | 31.77 | 0.26 | 0.6026 |
7/27/09 | MON | 831 | 876.46 | 51.60 | -0.88 | 0.1894 |
7/28/09 | TUE | 844 | 912.73 | 47.66 | -1.44 | 0.0749 |
7/29/09 | WED | 818 | 888.03 | 62.41 | -1.12 | 0.1314 |
7/30/09 | THU | 832 | 873.16 | 80.96 | -0.51 | 0.3050 |
7/31/09 | FRI | 848 | 889.75 | 48.82 | -0.86 | 0.1949 |
Consider whether the daily volumes per day of the week are random enough to infer a normalized population. Nearly everyone has heard the term bell-shaped curve. It is derived from a perfectly symmetrical graph, with the mean at the center and 49.99% of the actual data points on either side of it (the exact mean makes up the rest of the area under the curve). Thanks to the mathematical prowess of our predecessors, the cumulative area under the curve has been reduced to a table of standard normal probabilities.
The first step in use of the table is computation of a z score (standard score), which is determined by subtracting the population mean from the observation and then dividing the result by the SD. Negative values naturally pertain to observations below the mean. These are the ones that should be of most concern; however, just because an observation is above the mean, even by a large amount, that does not imply that all exams were captured for that date of service. Note the column E values in red. This model is set to isolate all observed volumes that are less than one SD below the mean. The advantage of a symmetrical population is its uniformity. Of the observations for each day of the week, 68% fall within one SD of the mean and 95% are within two SDs. This implies that 34% of the observations are within one SD below the mean. Therefore, we would be concerned with any column E value below 0.5 minus 0.34, which is 0.16. These dates should be more thoroughly examined for missing exams.
Table 5: Use of the "Z" statistic with the universe: July 2008 | ||||||
A | B | C | D | E | ||
UNIVERSE | UNIVERSE | "Z" | ||||
DOS | WEEKDAY | EXAMS | AVERAGE | STD. DEV. | STATISTIC | PROBABILITY |
7/1/09 | WED | 877 | 870.00 | 31.09 | 0.23 | 0.5910 |
7/2/09 | THU | 891 | 821.40 | 26.97 | 2.58 | 0.9951 |
7/3/09 | HOL | 447 | 340.00 | 0.00 | NA | NA |
7/4/09 | SAT | 351 | 387.25 | 37.47 | -0.97 | 0.1660 |
7/5/09 | SUN | 420 | 365.00 | 39.30 | 1.40 | 0.9192 |
7/6/09 | MON | 876 | 832.00 | 23.73 | 1.85 | 0.9678 |
7/7/09 | TUE | 837 | 872.80 | 16.63 | -2.15 | 0.0158 |
7/8/09 | WED | 813 | 870.00 | 31.09 | -1.83 | 0.0336 |
7/9/09 | THU | 864 | 821.40 | 26.97 | 1.58 | 0.9428 |
7/10/09 | FRI | 962 | 862.33 | 34.03 | 2.93 | 0.9983 |
7/11/09 | SAT | 364 | 387.25 | 37.47 | -0.62 | 0.2676 |
7/12/09 | SUN | 366 | 365.00 | 39.30 | 0.03 | 0.5120 |
7/13/09 | MON | 804 | 832.00 | 23.73 | -1.18 | 0.1190 |
7/14/09 | TUE | 901 | 872.80 | 16.63 | 1.70 | 0.9554 |
7/15/09 | WED | 847 | 870.00 | 31.09 | -0.74 | 0.2296 |
7/16/09 | THU | 867 | 821.40 | 26.97 | 1.69 | 0.9545 |
7/17/09 | FRI | 960 | 862.33 | 34.03 | 2.87 | 0.9979 |
7/18/09 | SAT | 341 | 387.25 | 37.47 | -1.23 | 0.1093 |
7/19/09 | SUN | 409 | 365.00 | 39.30 | 1.12 | 0.8686 |
7/20/09 | MON | 879 | 832.00 | 23.73 | 1.98 | 0.9761 |
7/21/09 | TUE | 940 | 872.80 | 16.63 | 4.04 | 1.0000 |
7/22/09 | WED | 814 | 870.00 | 31.09 | -1.80 | 0.0359 |
7/23/09 | THU | 787 | 821.40 | 26.97 | -1.28 | 0.1003 |
7/24/09 | FRI | 842 | 862.33 | 34.03 | -0.60 | 0.2743 |
7/25/09 | SAT | 355 | 387.25 | 37.47 | -0.86 | 0.1949 |
7/26/09 | SUN | 394 | 365.00 | 39.30 | 0.74 | 0.7704 |
7/27/09 | MON | 831 | 832.00 | 23.73 | -0.04 | 0.4840 |
7/28/09 | TUE | 844 | 872.80 | 16.63 | -1.73 | 0.0418 |
7/29/09 | WED | 818 | 870.00 | 31.09 | -1.67 | 0.0475 |
7/30/09 | THU | 832 | 821.40 | 26.97 | 0.39 | 0.6517 |
7/31/09 | FRI | 848 | 862.33 | 34.03 | -0.42 | 0.3372 |
In Table 5, both databases isolate the same days of the week, but this one further isolates some Saturdays. This is likely to be a false positive because emergency-department visits are very random. The analysis suggests that using the statistics from the largest population is just as accurate a gauge as using a peer month. This practice, however, is located in a very large metropolitan area where there is not likely to be significant seasonal variation. If a practice has clear evidence that some periods in a year are universally busier than others, then multiple universes should be built to measure future capture.
Why use this monitoring technique? In terms of transaction detail, radiology receivables dwarf the next-largest type of receivables represented in a hospital system . There is a great deal of work necessary to merge demographic and clinical information to create a patient account. Mistakes can happen, especially with systems that still use a paper version of the interpretation and employ manual checking of these documents against a department log. This statistical technique is a relatively quick way to identify potential dates where there might be a capture problem that needs more attention.
If a practice feels that one SD is too rigorous a benchmark, resulting in false alarms, then it should move out further from the mean. I would suggest that two SDs is excessive. Tables 4 and 5 show, especially using the peer month, that there were specific dates that should have set off alarms because some volumes were outside two SDs, and others were well past one SD.
The use of statistics to monitor charge capture will eventually be supplanted by a technique already in the marketplace. It takes advanced IT capability to build the monitoring system, but it will enable a practice to gain real-time confirmation that all exams have been accounted for, whether for a day or for a month. It requires the capture of the accession number that is assigned in the RIS for all exam orders.
Forecasting
One might assume that production of averages by day of the week provides a basis for estimating future volumes. Table 6 provides the evidence.
Table 6: Forecast of 2009, using 2008 averages | ||||||||
WEEKDAY | STATISTICS | Jan-09 | Feb-09 | Mar-09 | Apr-09 | May-09 | Jun-09 | Jul-09 |
SUN | 381.21 | 4 | 4 | 5 | 4 | 5 | 4 | 4 |
MON | 868.06 | 3 | 3 | 5 | 4 | 3 | 5 | 4 |
TUE | 895.27 | 4 | 4 | 5 | 4 | 4 | 5 | 4 |
WED | 881.28 | 4 | 4 | 4 | 5 | 4 | 4 | 5 |
THU | 855.10 | 4 | 4 | 4 | 5 | 4 | 4 | 5 |
FRI | 879.59 | 5 | 4 | 4 | 4 | 5 | 4 | 4 |
SAT | 388.88 | 5 | 4 | 4 | 4 | 5 | 4 | 4 |
HOL | 381.75 | 2 | 1 | 0 | 0 | 1 | 0 | 1 |
VOLUMES PER MONTH | ||||||||
SUN | 1,525 | 1,525 | 1,906 | 1,525 | 1,906 | 1,525 | 1,525 | |
MON | 2,604 | 2,604 | 4,340 | 3,472 | 2,604 | 4,340 | 3,472 | |
TUE | 3,581 | 3,581 | 4,476 | 3,581 | 3,581 | 4,476 | 3,581 | |
WED | 3,525 | 3,525 | 3,525 | 4,406 | 3,525 | 3,525 | 4,406 | |
THU | 3,420 | 3,420 | 3,420 | 4,276 | 3,420 | 3,420 | 4,276 | |
FRI | 4,398 | 3,518 | 3,518 | 3,518 | 4,398 | 3,518 | 3,518 | |
SAT | 1,944 | 1,556 | 1,556 | 1,556 | 1,944 | 1,556 | 1,556 | |
HOL | 764 | 382 | 0 | 0 | 382 | 0 | 382 | |
Predicted totals | 21,761 | 20,111 | 22,741 | 22,334 | 21,760 | 22,360 | 22,716 | |
Footnote: using 2009 avgs. | 22,555 | 20,816 | 23,492 | 23,062 | 22,517 | 23,097 | 23,494 | |
Footnote: Actual | 22,470 | 21,241 | 23,409 | 23,517 | 22,730 | 23,277 | 22,381 | |
Variance %: 2008 avgs. | -3.00% | -5.00% | -3.00% | -5.00% | -4.00% | -4.00% | 1.00% | |
Variance %: 2009 avgs. | 0.00% | -2.00% | 0.00% | -2.00% | -1.00% | -1.00% | 5.00% |
The advantage of testing this assumption is available if the 2008 averages are used to predict 2009 averages, and then these monthly predictions are measured against actual volumes. The predictions cover seven months; August was omitted because the extraction was performed at the close of the August billing cycle, and significant August volume was not yet posted. Every month is short. This suggests growth in averages by day of the week.
Table 7: Comparison of 2008 with 2009 averages. | ||||
Variance | ||||
WEEKDAY | 2008 | 2009 | Jan-09 | 09 vs. 08 |
SUN | 381.21 | 395.17 | 378.00 | 4.00% |
MON | 868.06 | 886.78 | 913.67 | 2.00% |
TUE | 895.27 | 938.70 | 959.25 | 5.00% |
WED | 881.28 | 890.90 | 837.50 | 1.00% |
THU | 855.10 | 899.70 | 890.50 | 5.00% |
FRI | 879.59 | 908.80 | 925.00 | 3.00% |
SAT | 388.88 | 397.40 | 391.40 | 2.00% |
HOL | 381.75 | 432.40 | 435.50 | 13.00% |
Table 7 shows a definite increase for every day of the week. The increases are generally linked to the variance between the predicted and actual volumes. The 2009 averages were also used to map the result against the actual volume. There is a close fit, except for July. Therefore, production of the averages per day, combined with an educated guess concerning next year’s growth (or decline), provides a useful way to begin preparing a budget.
I must emphasize that the forecast of volumes by month of service is the first step. There can be a delay of up to 10 days between the date of service and the date of posting for any date, with additional delays caused by unexpected complications. The prediction model then has to simulate what is actually posted to the receivables system each month by distributing the exams over two or three billing cycles.
Over time, there are definite patterns of exam volumes, by day of the week, that generally stay consistent for very busy practices. Today’s receivables systems can rapidly compile exam statistics by date of service to enable a practice to establish expected trends; these can then be used as benchmarks to test exam capture and predict future revenue streams.
Be careful not to run tests too early; allow sufficient time for the receivables system to post the exams. If the testing tool does not result in capture of missing exams (because there are none), then loosen the test by going out beyond one SD. We are only concerned with volumes below the mean, not above it. Falling one SD below the mean for a given day of the week has a 16% probability of happening. This, in my view, is sufficient to warrant specific examination of all documentation for that date of service. If you disagree, then use a less aggressive test.
Those practices in areas with known seasonal referral patterns can account for this by building peer-to-peer monthly comparisons. The z score, however, accounts for variability by using the SD, making it only marginally useful to bother with peer-to-peer timeframes.
James A. Kieffer, MBA is president of Proforma Financial Group Inc, Nashua, New Hampshire; James.Kieffer@comcast.net.