Previous Topic: 6.3.3 Budget Summary ReportNext Topic: 6.4 Enterprise IS Financial Management


6.3.4 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