meprs 2010 tma meprs program office management control and financial studies division
DESCRIPTION
MEPRS Early Warning and Control System (MEWACS) Online 2010 and the Consolidated Cost Report (CCR). MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division. MEWACS Online 2010. Overview. Highlights of the MEWACS upgrade include: - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/1.jpg)
MEPRS Early Warning and Control System
(MEWACS) Online 2010 and the
Consolidated Cost Report (CCR)
MEPRS 2010TMA MEPRS Program Office
Management Control and Financial Studies Division
![Page 2: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/2.jpg)
MEWACS Online2010
Overview
![Page 3: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/3.jpg)
Highlights of the MEWACS upgrade include:
* FTE and salary snapshots by Skill Type* Visibility of step-down expenses before allocation* Addition of Dental Weighted Procedures and OBD to MTF Data Profiles* Identification of data inconsistencies where workload is reported without expenses* Flexibility to see FTEs and salaries before or after cost pool purification* Expanded help features
![Page 4: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/4.jpg)
Two New metrics:Personnel Profiles
Workload-Expense Check
![Page 5: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/5.jpg)
Though the format is fresh, the basic concept of condition selection has not changed.
![Page 6: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/6.jpg)
Check for notes detailing issues
that affect all MTFs.
![Page 7: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/7.jpg)
For best results, Save first and
then Open.
![Page 8: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/8.jpg)
Two new data elements:Occupied Bed Days
Dental Weighted Procedures
![Page 9: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/9.jpg)
![Page 10: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/10.jpg)
Data are visible by Skill Type and by Pre- or Post-
purification.
Graphs can be copied for use in
documents.
![Page 11: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/11.jpg)
All of these instances are from the same
clinic BGAB.
For more help, consult the
Users Guide.
![Page 12: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/12.jpg)
MEWACS Online2010
Scenario
![Page 13: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/13.jpg)
Using your own MTF, check for data anomalies in:
* Data Load Status* Summary Outliers* MTF Data Profiles – Use multiple select on FY to see if data behavior is seasonal* WWR/EAS IV Outliers* Allocation Test/Detail* Personnel Profiles* Workload-Expense Check
![Page 14: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/14.jpg)
FY10 CCR
Overview
![Page 15: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/15.jpg)
FY10 Consol i dated Cost Report (CCR)
Executive Summary
External ResourcesData Sources Notes and
Documentation
Prepared by:TMA/ MEPRS Program Offi cePOC: Mr. Patri ck Wesl ey Patr i ck. Wesl ey@tma. osd. mi l
An i nteract i ve Servi ce- speci fi c monthl y MEPRS data snapshot by Mi l i tary Treatment Faci l ty, Fi scal Month, and 4th- Level Funct i onal Cost Code i ncorporat i ng automated var i ance detect i on to f aci l i tate data qual i ty
eval uat i on, expense and workl oad val i dat i on, and monthl y l ocal MEPRS data management .
Versi on:Prototype V7May 2010
Ai r Force
Cl i ck Here to Access CCR
![Page 16: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/16.jpg)
CCR Highlights include:
* Executive Summary * Detailed direct and Indirect expenses by Parent MTF, FM, and FCC4* Multi-stage outlier flagging methodology: - Negative Expenses - Expenses with no workload - Indirect expenses remaining after step-down - Application of Pareto principle (80 – 20 rule) to indicate which values to
evaluate for outliers.
![Page 17: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/17.jpg)
![Page 18: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/18.jpg)
Direct Expenses have been split into
two categories
Costpools are included in the Direct expense
![Page 19: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/19.jpg)
All FCCs are
available for review
![Page 20: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/20.jpg)
FY09 Data as baseline for FY10
FY09 data that drives FY10 flags
are highlighted
![Page 21: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/21.jpg)
Scenario
FY10 CCR
![Page 22: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/22.jpg)
Using your own MTF:
* Look for Total Expense anomalies in MEWACS. If your site has no anomalies, use 0043 Tyndall (AF) or 0056 Great Lakes (Navy)* Go to CCR in the appropriate month and 1st Level FCC* Evaluate instances of negative expenses* Evaluate instances of expenses with no workload* Evaluate instances of workload with no expenses* Evaluate other outliers
![Page 23: MEPRS 2010 TMA MEPRS Program Office Management Control and Financial Studies Division](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816790550346895ddcc25a/html5/thumbnails/23.jpg)
Questions?Deirdre Baker
MEPRS Early Warning and Control System
(MEWACS) Online 2010 and the
Consolidated Cost Report (CCR)