6.3.5 Cost Reconciliation Report


The Cost Reconciliation Report lists the difference between
costs and charges by cost center, invoice category, or
charging element.  It allows management to determine the
effectiveness of the rate setting.  Figure 6-16 shows a
sample of the cost center version of the Cost Center
Reconciliation Report.  The report excludes all Cost Center
1s that are designated as NOBILL in the ACTCCA file.

The report heading contains the installation name and the
report name (for example, Cost Reconciliation Report).


REPORT OPTIONS

The available options for this report are:

o Data Center Costs

  Before running the report, you should enter data center
  costs in sharedprefix.MICS.PARMS(COSTREC).  You can specify
  them as total costs for the entire data center, by invoice
  category, or by computation code (charging element).

o Number of Input Cycles

  At the time of execution, the number of cycles of the
  Monthly Financial Recap File to be used as input is
  specified as SYSPARM=ACTn, where n is the number of cycles.
  The job is shipped with ACT12 to indicate that you are to
  use 12 cycles.  If you omit the ACTn parameter, the default
  is 1.


RUNNING THE REPORT

Run the report from the Cost Reconciliation Report option
from the IS Financial Management menu (MWF;4;2;4;3;5).  The
JCL for this report is in sharedprefix.MICS.CNTL(ACTCOSTR).


                                                   Y O U R   C O M P A N Y   N A M E                                                     COST RECONCILIATION REPORT                              ------------------------------------------------------------------------                              |                               |  CHARGES   |    COST    | DIFFERENCE |                              |                               |------------+-----------+-----------|                              |                               |    SUM     |    SUM     |    SUM     |                              |-------------------------------+-----------+-----------+-----------|                              |GRAND TOTAL                    |  1187477.33|  1499999.60|   312522.27|                              |-------------------------------+-----------+-----------+-----------|                              |COST CENTER NAME               |            |            |            |                              |-------------------------------|            |            |            |                              |NEW ENGLAND                    |   112459.46|   142056.76|    29597.30|                              |-------------------------------+-----------+-----------+-----------|                              |MIDDLE-ATLANTIC                |   167126.23|   211110.84|    43984.61|                              |-------------------------------+-----------+-----------+-----------|                              |SOUTHEAST                      |    46235.78|    58404.21|    12168.43|                              |-------------------------------+-----------+-----------+-----------|                              |NORTH CENTRAL                  |   276043.89|   348693.67|    72649.78|                              |-------------------------------+-----------+-----------+-----------|                              |MIDWEST                        |   249234.76|   314828.86|    65594.10|                              |-------------------------------+-----------+-----------+-----------|                              |SOUTHERN                       |    86589.41|   109378.18|    22788.77|                              |-------------------------------+-----------+-----------+-----------|                              |NORTHWEST                      |    24104.03|    30447.78|     6343.75|                              |-------------------------------+-----------+-----------+-----------|                              |PLAINS                         |    36919.21|    46635.68|     9716.47|                              |-------------------------------+-----------+-----------+-----------|                              |SOUTHWEST                      |   188764.56|   238443.99|    49679.43|                              |-------------------------------+-----------+-----------+-----------|


 Figure 6-16.  Cost Reconciliation Report