230 likes | 345 Views
2012 Navy Medicine Audit Readiness Training Symposium Summarized Management Analysis Resource Tool (SMART) Workshop Track: Resources National Conference Center (NCC), Lansdowne, VA 04 - 06 June 2012. Purpose and Objectives. Purpose:
E N D
2012 Navy Medicine Audit Readiness Training Symposium Summarized Management Analysis Resource Tool (SMART) Workshop Track: Resources National Conference Center (NCC), Lansdowne, VA 04 - 06 June 2012
Purpose and Objectives • Purpose: • Present Summarized Management Analysis Resource Tool (SMART) overview and discuss application capabilities, functionality, and system enhancements. • Objectives: • Increase SMART awareness. User forum to share methods on how SMART is being utilized and discuss system development. FOR OFFICIAL USE ONLY
Session Overview This session will cover the following topics: • SMART Overview & Capabilities • About SMART • SMART Information • Key Benefits • Data Sources • SMART Functionality • UIC Structure by Fiscal Year • Omitting Data – Remove or Suppress • Update Time Stamp • Shared Views • SMART System Enhancements • FTEs & Civ Man Hours • 365 Daily • Workload • BJONs • Direct Cost Detail – PoR, OCO, WII, TBI/PH FOR OFFICIAL USE ONLY
SMART Overview • About SMART: • SMART is a web-based analytical application used to plan and monitor the cost, expense, and workload of operating Naval hospitals, dental centers, and clinics. • Created as a one-stop option for providing detailed and summarized information on the status of any medical health care facility in the BSO. • Consolidates data from multiple applications into a single, centrally available, and easy to use interface. • Information in SMART is based on the Financial Guidance supplied by Code M84. FOR OFFICIAL USE ONLY
Key Analytical Capabilities • Summary executive and detailed managerial information provided in the following key areas: • Financial Performance Monitoring • Unit Cost Measurement • Commodity Trending • Workload Analysis • Peer Group Comparisons • Data Quality / Integrity Analysis • Budget Execution FOR OFFICIAL USE ONLY
Key Analytical Benefits • SMART provides benefit with a higher quality and quantity of data. This results in improved timeliness, cost savings, improved operations and higher rates of return. Key analytical benefits include: • Verifiable Data • Accuracy in analytical data measures • Speed • Consistent data view • Simplicity • Daily process supporting data quality and integrity FOR OFFICIAL USE ONLY
Data Files Database SMART EV Web Pages Data Export STARS Daily , Cert Monthly, & Deltas Ad Hoc Query reporting SGL C&O Summary Report Excel PDF Email Microsoft XPS Doc Writer CHCS & MEPRS/EAS Ancillary Workload SMART EV Cube DMHRSi / STARS / Military Pay & Hrs Annual Planning Figure (BAPF) Monthly M2 / WWR Workload DENCAS Actual & Targets Dental Workload SMART Data Sources FOR OFFICIAL USE ONLY
UIC Structure by Fiscal Year • SMART maintains and preserves data associated with past structures. • Budget Submitting Office (BSO) reorganizations, including now closed activities continue to be reflected in SMART to maintain historical reporting and data integrity. FOR OFFICIAL USE ONLY
Example: Org Structure FOR OFFICIAL USE ONLY
Omit Data Options • Complex reports can be ‘cleaned up’ or simplified by omitting column or row data that is missing or zero. • Permanently remove by ‘right-clicking’ on-grid. • Suppress missing or zero via the Options dialog box. • Which option do you use? FOR OFFICIAL USE ONLY
Example: Omit Data Options Note: These two differing methods can create different results FOR OFFICIAL USE ONLY
System Update Time Stamp Has today’s update been completed? You can audit. The System Data Dates table is loaded with info. FOR OFFICIAL USE ONLY
Shared Views • SMART users can collaborate by utilizing Shared Folders. • Shared Folders can save you time. • Use other’s hard work as templates for your reporting needs. • You have access to all of the reports in your Group’s folder(s). • Do you use SMART’s Shared Folders? FOR OFFICIAL USE ONLY
FTEs & Civilian Man Hours New SMART Data: Streamlined FTE Calculation Key Benefits: • Streamlined processes for procuring and modeling large bi-weekly datasets • Enhanced CIVPERS FTE transparency across Navy Medicine • Stakeholders can now conduct multi-dimensional analysis of CIVPERS FTE data • Streamlined processes for reconciliation of FTE data between the various financial and manpower systems FOR OFFICIAL USE ONLY
Example: New Man Hours Data NH Camp Lejeune – Civilian Man Hours by Pay Plan Code (Object Class Dimension) and Work Code (Expense Element Dimension) FOR OFFICIAL USE ONLY
SMART Daily Reporting • DAILY REPORTING EXAMPLE • NMSC requested enhancement. • Expansion of data in Fiscal Months Dimension. • Day by Day nested within Cumulative MP1. • Once 365+ days of data have been retained, year over year daily comparisons will be available. FOR OFFICIAL USE ONLY
Workload Data Returns • WORKLOAD REPORT EXAMPLE • Resumption of data feed previously available. • Provides ready availability of productivity metrics (counts/$s). • Narrowed focus resulting in reduced number of available members. FOR OFFICIAL USE ONLY
Base/ Basic JON • Added to help identify costs associated with a specific type of service or function within an operating budget • Base or Basic JON is a subset of data within the JON and JOSN. • BJON = positions 7-10 of the JON • Currently 7000+ BJONs FOR OFFICIAL USE ONLY
Example: BJON report NMSC and reporting activities – BJONs filtered by those with negative values only. Report also filtered by suppress missing rows. FOR OFFICIAL USE ONLY
Direct Cost Detail • Expansion of the Cost Dimension • Nested within the Direct Cost member • FY09- current • Money for specific programs (OCO, WII, TBI/PH) can be projected, analyzed, and tracked in a simplified manner via these new members FOR OFFICIAL USE ONLY
Example: OCO, WII, TBI/PH FOR OFFICIAL USE ONLY
Questions & Answers FOR OFFICIAL USE ONLY
Points of Contact SMART Program Administration: Cheryl Hawkins (202) 685-1849 cheryl.hawkins@med.navy.mil Data Sources and Data Related Questions: Christopher Villalba (M84) (703) 681-9462 christopher.villalba@med.navy.mil Technical & Functional Support Contact: SMART Helpdesk (202) 685-1259 smart.helpdesk@med.navy.mil FOR OFFICIAL USE ONLY