DAILY ACTIVITY REPORT This is a very useful report that can be used by any manager or administrator of a cancer treatment facility to gage things like daily patient activity and revenue (daily snapshot). It also projects activity based on history and can be very useful mid-month to predict month-end figures (i.e. admits and collections). There are separate TABS for each month in 2005 (Jan through Dec). Also there is a "roll-up" page (TAB) called 'Worksheet Totals'. This report is manual and will require someone to input the data daily from whatever system (i.e. IMPAC) reports you now use (may take more than one). COLUMN EXPLANATION: Opr. Day - Typical work days (Mon through Fri) Date - Calendar day Admits - New admits on that day Tech Procedures - Total number of technical procedures performed on that day Patients Treated - Actual patients treated (total) on that day Patients Scheduled - Total patients scheduled for treatment on that day Break - Break in treatment (total patients on break that day) No Show - Total patients that did not show up for treatment for any reason on that day Cancelled - Total patients that canceled their treatment for any reason on that day Machine Down - Machine(s) not working on that day Dx CT's - Total number of diagnostic CT's done on that day (if department has dedicated CT machine) Dx Xray - Total number of department x-rays performed on that day Dx Rev. - Total charges generated by all diagnostic procedures on that day Tx Rev. - Total charges generated by all radiation oncology technical procedures on that day 26 Rev. - Total charges generated by all professional (RadOnc) procedures on that day Total Revenue - Total technical and professional (global) charges on that day (calculation) Technical Collections - Amount of cash (payments) received on that day for technical billing Professional Collections - Amount of cash (payments) received on that day for professional billing Global Collections - Total technical and professional (global) payments received on that day (calculation) NOTE: This report is open and can be changed to fit the facility and circumstances - enjoy!