Transcript MEPRS Early Warning and Control System (MEWACS) Online

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:
*
*
*
*
*
*
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
Two New metrics:
Personnel Profiles
Workload-Expense Check
Though the format is fresh, the basic concept of
condition selection has not changed.
Check for notes
detailing issues
that affect all
MTFs.
For best results,
Save first and
then Open.
Two new data elements:
Occupied Bed Days
Dental Weighted Procedures
Graphs can
be copied
for use in
documents.
Data are visible
by Skill Type and
by Pre- or Postpurification.
For more help,
consult the
Users Guide.
All of these
instances
are from
the same
clinic
BGAB.
MEWACS Online
2010
Scenario
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
FY10 CCR
Overview
FY10 Consolidated Cost Report
(CCR)
An interactive Service-specific monthly MEPRS data snapshot by Military Treatment Facilty, Fiscal Month,
and 4th-Level Functional Cost Code incorporating automated variance detection to facilitate data quality
evaluation, expense and workload validation, and monthly local MEPRS data management.
Click Here to Access CCR
Air
Force
Executive
Summary
Version:
Prototype V7
May 2010
Data Sources
Notes and
Documentation
External
Resources
Prepared by:
TMA/MEPRS Program Office
POC: Mr. Patrick Wesley
[email protected]
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.
Costpools are
included in the
Direct expense
Direct Expenses
have been split into
two categories
All FCCs
are
available
for review
FY09 Data as baseline for FY10
FY09 data
that drives
FY10 flags
are
highlighted
FY10 CCR
Scenario
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
MEPRS Early Warning and
Control System
(MEWACS) Online 2010
and the
Consolidated Cost Report (CCR)
Questions?
Deirdre Baker
[email protected]
210-832-5216