1. OVERVIEW › 1.1 Reporting and Inquiry Functions
1.1 Reporting and Inquiry Functions
CA MICS Accounting and Chargeback's Enterprise IS Financial
Reporting is grouped into five management impact areas:
o Invoicing
o Client Support
o IS Financial Management
o Enterprise IS Financial Management
o Accounting Administration
The information is presented as a mainframe report or in
graphic and tabular form at your workstation.
You can view additional information by running predefined
MICF inquiries. These inquiries are described at the end of
this section.
INVOICING
The Invoicing management impact area produces the following
reports:
-------------------------------------------------------------
Report Description
-------------------------------------------------------------
Consolidated Provides a summary of charges invoiced to a
Invoice cost center during the accounting period.
Report You can produce the report at three levels of
summarization: Computation Code line items,
Invoice Category line items, or Cost Center
(total) line items. The invoice shows the
charges incurred at the chosen level with
several options for additional information
including quantities consumed and rates
charged, and comparison to budget or
year-to-date charges. Installations with
multiple sites can produce a consolidated
multi-site invoice at the central site.
Zero Balance Shows the accounting month's charges for each
Report value of the highest-level cost center and
lists the adjustment amounts and revised
charges that result from calculating a zero
balance.
Repeat Invoice An invoice run from a prior accounting
period.
Month-to-Date An invoice run from the current month cycle
Invoice of the ledger, debit and credit files and the
active cycle of the budget file. Any
recurring debits and credits are included.
Year-to-date amounts through the previous
month can be shown.
Multi-site A consolidated multi-site invoice run from
Invoice the 01 (prior month) cycle of the Multi-site
Financial Recap file. The invoice is created
from the central and remote site Financial
Recap files.
Multi-site A multi-site invoice run from a prior
Repeat accounting period. You can reprint an
Invoice invoice from any existing Multi-site
Financial Recap file cycle.
Invoice Credit Provides a detailed listing of the credits
Supplement applied to a given cost center's bill. When
Report detailed information is required, this report
supplements the credit total printed on the
invoice.
Trial Balance Provides a trial balance invoice for the
Invoice previous month's cycle before all the monthly
closeout jobs (MONTHLY/MONTHACT and CLOSETBL)
are run.
CLIENT SUPPORT
The Client Support management impact area focuses on the
needs of the users of IS computer services and their
management in keeping track of how their IS expenses are
being consumed. It provides information in graphic and
tabular form at your workstation and in a mainframe report as
described below:
-------------------------------------------------------------
Report Description
-------------------------------------------------------------
User IS Presented at your workstation, this
Expense information focuses on monthly charges for
Analysis the current and prior year and, if you have
six or more month's data, projects charges
through the end of the current year. You can
view a subset of the information by
department, by application, or by invoice
category.
User Expense This is a report of charges for a specific
Summary Report user, or for all users at a specific cost
center level, in any defined invoice format.
IS FINANCIAL MANAGEMENT
The IS Financial Management impact area focuses on the needs
of IS management in providing computer services to the
enterprise. It provides information in graphic and
tabular form on a workstation and in a series of mainframe
reports as described below:
-------------------------------------------------------------
Report Description
-------------------------------------------------------------
IS Revenue Presented at your workstation, this
Analysis information provides IS management with
several views of the fiscal health of the IS
organization by looking at IS revenue. It
focuses on monthly revenue for the current and
prior year for up to twenty-six months of data
and, if you have six or more month's data,
projects revenue through the end of the
current year.
Budgetary Provides a summary of the charges invoiced to
Analysis cost centers within the accounting period
Report compared to their budgets for that period.
The report gives upper management a concise
method of determining which cost centers are
over or under budget and the amount of
discrepancy. It is also useful as an "early
warning" mechanism for clients whose charges
increase significantly during the course of a
billing cycle. You can also produce a
year-to-date version.
Revenue Area Lists, by invoice category, a summary of
Analysis charges incurred during the accounting period.
Report This report allows cost center management to
determine the dollar expenditure for each
resource and allows data center management to
determine if charges are distributed
appropriately. You can also produce a
year-to-date version.
User Revenue Shows the percentage of total revenue accrued
Distribution by each value of the highest level cost
Report center. This report gives management a
concise way of determining the relative
ranking of data processing charges. You can
also produce a year-to-date version.
Credit Area Shows, by individual credit category, a
Analysis summary of the charges credited during the
Report accounting period. This report allows data
center management to determine which resource
is being credited, and helps to determine
processing inefficiencies and the resulting
amount of lost revenue. You can also produce
a year-to-date version.
User Credit Provides a summary of the percentage of total
Distribution credits accounted for by each value of the
Report highest level cost center. This report gives
management a rapid method of determining
relative ranking of cost center credits. You
can also produce a year-to-date version.
Revenue/ Lists a one-year history of charges and
Credit Trend credits for a given cost center compared to
Analysis its budget. This report allows management to
Report analyze the credits applied to a cost center
in relation to its expenditures, which may
indicate cost center operational problems.
Surcharge Provides a summary of the surcharge amounts
Summary for each cost center invoiced. This report
Report gives management a concise view of surcharges
for tax reporting and other purposes. You can
also produce a year-to-date version.
Invoice Lists the total charges, credits, discounts,
Summary zero balance adjustments, surcharges, and a
Report grand total for each cost center invoiced.
This report provides management with a quick
overview of the invoices for tax reporting
and other purposes. You can also produce a
year-to-date version.
Budget Provides a listing of all budget amounts by
Summary cost center and type of budget.
Report
Cost Lists the difference between costs and
Reconciliation charges, in order by cost center, invoice
Report category, or computation code, to help
management determine the effectiveness of its
rate-setting structure.
IS Revenue Presented on the workstation, this information
Analysis and provides the accounting administrator, and
Rate other IS management, with an in-depth analysis
Projection of current utilization and revenue and
forecasts future trends. You can analyze the
effects of new rates and workloads on present
and future enterprise utilization and
revenues. It focuses on the data for the last
12 accounting periods and forecasts
utilization and revenue trends for the next 12
accounting periods.
ENTERPRISE IS FINANCIAL MANAGEMENT
The Enterprise IS Financial Management impact area focuses
on the needs of enterprise management in tracking how the
enterprise's IS expenses are being consumed. It provides
information in graphic and tabular form at your workstation
and a mainframe report as described below:
-------------------------------------------------------------
Report Description
-------------------------------------------------------------
Application Presented on a workstation, this information
IS Expense focuses on monthly charges for the top ten
Analysis business applications for the current and
prior year at the selected cost center level.
You can select an application and compare
actual and projected charges to budgeted
charges. You can also view charges by month,
by designated cost center level, and by
invoice category.
Application This is a report of charges, in any defined
Expense invoice format, for each application or
Summary Report other information contained in a specified
cost center level.
ACCOUNTING ADMINISTRATION
The Accounting Administration impact area focuses on the
needs of the accounting administrator in monitoring the
status of accounting processing and determining rates. It
provides information in graphic and tabular form at your
workstation and in a series of mainframe reports as described
below:
-------------------------------------------------------------
Report Description
-------------------------------------------------------------
Journal Run These logs retain information about the
Status Logs journal files created by daily processing,
such as the run time stamp when they were
created by the DAY199 step of the DAILY job,
or the external journal file update job, and
the charges for each computation code. They
are viewed online and provide a convenient way
for you to check on the daily update of
CA MICS Accounting and Chargeback files.
Daily IS Presented on the workstation, this information
Revenue focuses on daily charges for the past 35 days.
Analysis A breakdown is provided of the charges for the
top ten applications, at the selected cost
center level, with detail by invoice category
or charging element.
Daily Provides a daily and a month-to-date summary
Charges of the total charges incurred within each
Summary invoice category by each high level cost
center. This report provides an additional
way for the accounting administrator to check
on the daily update of CA MICS Accounting and
Chargeback files.
Audit Provides a detail listing of individual
Report charges, the date and time they were incurred,
and the specific work unit involved. You can
produce a complex-level report or a unit-level
report.
Cost Center Produces a listing of the special billing
Attributes attributes for each cost center. It includes
File Recap personalized addressing information, billable
status (billable/non-billable), budget print-
ing information, whether this user is entitled
to a lump sum or a flat percentage discount
and, if so, the amount involved.
Invoice Lists the serial number of the next invoice
Sequence that will be produced.
Number File
Recap
Credit File Lists individual standard and recurring credit
Recap entries for each cost center in a format
compatible with the data entry format used to
maintain the file.
Debit File Lists individual standard and recurring debit
Recap entries for each cost center in a format
compatible with the data entry format used to
maintain the file.
Budget File Lists individual budget entries for each cost
Recap center in a format compatible with the data
entry format used to maintain the file.
Effective/ Lists the percentage of difference between
Simulated currently effective rates and proposed rates
Rate for each computation code so that you can
Comparison compare the projected percentage of change in
Report revenue produced by other rate simulation
reports.
Rate Lists the amount of revenue that would have
Simulation been generated by each invoice category had
Revenue it been billed at the simulated rate. It
Area Effects shows the actual charges, the simulated
Report charges, the percentage of difference between
the charges, the original and simulated
percentage distribution of the charges, and
the percentage of change in the distribution.
Rate Shows the percentage of simulated total
Simulation revenue that would have been incurred by each
Cost Center cost center compared to that actually
Effects incurred, which helps you assess the effects
Report that a proposed rate change would have on
charges incurred by a cost center.
Rate Shows the percentage of simulated total
Simulation revenue that would have been incurred by each
Billing charging element compared to that actually
Element incurred. This report helps you to assess the
Effects effect that a proposed rate change would have
Report on the relationship between the charge for a
given resource and its actual cost.
Journal Provides a complete listing of the charging
Files Rate algorithms in effect for a portion of the
Report CA MICS database. For each journal file, it
lists the applicable rate for each charging
element in order by system identifier,
subsystem (such as CICS or TSO), subtype, and
cost center. It is produced automatically
when the CA MICS Algorithm Generator is run,
or you may generate it as a stand-alone
report.
Complex-Level Produces a complete listing of the
External complex-level external file charging
Files Rate algorithms. For each complex-level external
Report file, it lists the applicable rate for each
charging element, in order, by system
identifier, subsystem, subtype, and cost
center. It is produced automatically when the
External File Generation job is run, or you
may generate it as a standalone report.
MICF INQUIRIES
The following describes predefined MICF inquiries that are
delivered with the system. You can run these inquiries on an
as-needed basis. You can also use them as templates for
designing your own inquiries. They are located in MICF's
Finance Catalog Group.
------------------------------------------------------------
Inquiry Name Function
------------------------------------------------------------
Net Revenue by Produces a pie chart that depicts how
Cost Center revenue, less any cost center credits, is
distributed to the various high-level cost
centers. Each slice represents a cost
center's relative contribution to total
revenue.
Budgeted vs. Produces a vertical bar chart for selected
Actual high-level cost centers. Each bar represents
either the actual charges or the budgeted
amount for a cost center, which helps you to
see how well the cost centers are staying
within their budgets.
Monthly Produces a pie chart depicting how revenue,
Charges by less any credits, is distributed to the
Invoice various invoice categories, where the
Category categories are broadly defined along the
lines of CPU, DASD, Print, Tape, etc. Each
slice represents a category's relative
contribution to total revenue. You can
produce the graph for any or all high-level
cost centers.
Invoice Produces a stacked vertical bar chart that
Category shows each invoice category's charges for the
Charges by preceding month. Each bar is composed of the
Cost Center charges for each high-level cost center. You
can produce the chart for any or all
high-level cost centers.
Invoice Produces a pie chart depicting how credits
Credits by are distributed to the various high-level
Cost Center cost centers. Each slice represents a cost
center's relative share of the total credits.
Cost Center Produces a stacked vertical bar chart that
Charges by shows the preceding month's charges for
Invoice any or all high-level cost centers. Each bar
Category depicts charges applicable to the different
invoice categories.
Invoice Produces a pie chart that shows how discounts
Discounts by are distributed to the various high-level
Cost Center cost centers. Each slice represents a cost
center's relative share of the total
discounts issued during the preceding month.
Monthly Net Produces a vertical bar chart that represents
Revenue net revenue for a selected number of months
Summary for any or all high-level cost centers.
Monthly Produces a stacked vertical bar chart
Invoice depicting the credits and discounts provided
Credit/ each month over a specified period of months
Discount for any or all high-level cost centers. Each
Summary shows the relative share of credits and
discounts.
Weekly Produces a vertical bar chart showing the
Processing total charges processed during the preceding
Charges seven days for any or all high-level cost
Summary cost centers. Each bar represents one day's
charges.
Weekly Charges Produces a vertical bar chart showing the
by Invoice total charges processed during the preceding
Category seven days for any or all high-level cost
centers. Each bar represents one day's
charges.
Daily Revenue Produces three ranked lists that show
Ranking charging activity for the previous day for
specified high-level cost centers, invoice
categories, and computation codes (types of
charges within an invoice category). The
first list shows the top ten charges; the
second shows the top five charges in each
invoice category; the third shows the top
five charges in each high-level cost center.
Copyright © 2014 CA.
All rights reserved.
|
|