Evaluating cost center productivity

The monthly and yearly productivity summaries were developed and applied to a computer spreadsheet to aid the nurse manager in better understanding and communicating budget issues for diverse ambulatory care departments. A computerized spreadsheet using a commercially available personal computer program, such as Lotus, Quattro Pro, or Excel, can be used to more quickly and accurately track and summarize monthly budget reports. The data can be entered into the spreadsheet either manually or imported by query from the financial mainframe system. Contact your agency's finance or information department for information on how to accomplish this. Periodically acuity and resources should be measured and compared with quality monitors to maintain standards. For the past 10 years, our facility has successfully used this tool to make more informed decisions by identifying trouble spots early, and taking corrective action to avoid crisis management.