Nothing leaves your browser. The worksheet uses only the numbers you enter. There is nothing to submit, and the page does not store or send them.
Worksheets Worksheet
Bill-only request cost worksheet
Enter what your bill-only requests look like today: how many, how much, how late, and how far above contract price. You get what the late and off-contract ones cost a hospital in a year, worked out only from the numbers you enter, in your browser. Nothing is sent anywhere.
Every field starts empty. To see how the worksheet reads a month of requests, load a fictional one.
Illustrative hospital, synthetic numbers. A fictional hospital files 40 bill-only requests a month at an average of $6,000 each. A quarter arrive after the submission window, 10 days late on average. One request line in ten is billed above contract price, by 8% on average. Each request takes a person 20 minutes to re-key or chase, at $45 an hour.
These started as the illustrative example and have been edited. The figures use your changes.
Your four figures
Each is a different kind of cost, so they stay on separate lines and are never added together. They are arithmetic on your own numbers for a year at these rates, not a prediction.
Overcharge at stake per year
To see this figure, add the bill-only requests per month, the average request value, the share of lines above contract price and the average overcharge.
How this is calculated
- Requests a year: requests a month × 12.
- Value a year: requests a year × average request value.
- Lines above contract price: value a year × the share of lines above contract price.
- Overcharge: those lines × the average overcharge. Rounded to whole dollars.
Requests needing a person per year
To see this figure, add the bill-only requests per month, the share of requests arriving late and the share of lines above contract price.
How this is calculated
- Share needing a person: share late + share above contract price, capped at 100%.
- Requests a year × that share. Rounded to whole requests.
Hours of re-keying and chasing per year
To see this figure, add the bill-only requests per month and the minutes per request.
How this is calculated
- Minutes a year: requests a year × minutes per request.
- Hours: minutes a year ÷ 60, rounded to the whole hour.
- Cost: hours × the hourly cost, only when one is entered.
Late requests per year
To see this figure, add the bill-only requests per month and the share of requests arriving late.
How this is calculated
- Late requests: requests a year × the share arriving after the window. Rounded to whole requests.
- Days of delay: late requests × the average days late.
The figures are a year of requests at the rates you typed. They say what is at stake and how much handling the requests take, not what you would save. Implant Control checks each request against the contract price list and the surgical case while it is still pending, which is the point at which these numbers can still change.
What this worksheet leaves out
Enter what it can take. Your own process holds the rest.
- Device credits, returns and rebills after the purchase order. The worksheet stops where the request does.
- Invoice disputes after the purchase order, and the accounts payable time they take.
- Consignment stock, wasted and explanted items, and anything else that is not a line on the request.
- Requests that are both late and above contract price. The person count treats them as two until it is capped.
- What any of this would change: the figures are arithmetic on the numbers you enter, not a prediction of what you would save.
How Implant Control does it
In Implant Control the vendor rep picks contracted lines from your price list at your price, so a request arrives at contract price, and anything off contract is entered separately and flagged before approval. Every line is checked against the surgical case record, and the approver works only the differences. A late request needs a written reason, and a request that is too late is refused, at the day counts your policy sets.
Walk one request from submission to purchase order
Bring a month of bill-only requests, or just describe how they reach you today. We walk one through the product: submission, the contract and case checks, approval, and the hand-off to your ERP.