Previous Topic: 6.6.4 Invoice Category Charges by Cost Center (Color)Next Topic: 6.6.16 Invoice Category Charges by Cost Center


6.6.5 Invoice Credits by Cost Center (Color)


 
 
The Invoice Credits by Cost Center inquiry (Color) produces a
pie chart depicting how credits are distributed to the
various high-level cost centers.

INTENDED USE:

In the bar chart, each slice represents a cost center's
relative share of the total credits.


 DATA SOURCE (file):
 
      ACTRCP   - Financial Recap File
 
 DATA ELEMENTS USED:
 
      COSTCTRn - User-Defined Cost Center Codes
      INVCCAT  - Invoice Categories
      RCPTYPE  - Financial Recap Type
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTCM5, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 
 

 +----------------------------------------------------------------------------------+  |  -------------------------  Execution-Time Parameters  ------------------------- |  |  Command ===>                                                  Scroll ===> PAGE  |  |                                                                                  |  |  Executing CA MICS Inquiry:  ACTCM5 - Invoice Credits by Cost Center             |  |                                                                                  |  |  ------------------------------------------------------------------------------  |  |    Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.          |  |  01                                    - _____________________________________   |  |                                                                                  |  |    Specify the Cost Centers to be reported or leave blank to report all.         |  |  _____________________________________ - _____________________________________   |  +----------------------------------------------------------------------------------+

 
 NOTE:  Because this is a color graphics chart, no sample of
        the chart is provided.

6.6.6 Cost Center Charges by Invoice Category (Color)


 
 
The Cost Center Charges by Invoice Category (Color) inquiry
produces a stacked vertical bar chart that shows the
preceding month's charges for any or all high-level cost
centers.

INTENDED USE:

In the chart, each bar depicts charges applicable to the
different invoice categories.


 DATA SOURCE (file):
 
       ACTRCP  - Financial Recap File
 
 DATA ELEMENTS USED:
 
      COSTCTRn - User-Defined Cost Center Codes
      INVCCAT  - Invoice Categories
      RCPTYPE  - Financial Recap Type
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTCM6, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 
 

 +----------------------------------------------------------------------------------+  |  -------------------------  Execution-Time Parameters  ------------------------- |  |  Command ===>                                                  Scroll ===> PAGE  |  |                                                                                  |  |  Executing CA MICS Inquiry:  ACTCM6 - Cost Center Charges by Invoice Category    |  |                                                                                  |  |  ------------------------------------------------------------------------------  |  |    Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.          |  |  01                                    - _____________________________________   |  |                                                                                  |  |    Specify the Cost Centers to be reported or leave blank to report all.         |  |  _____________________________________ - _____________________________________   |  +----------------------------------------------------------------------------------+  

 
 NOTE:  Because this is a color graphics chart, no sample of
        the chart is provided.

6.6.7 Invoice Discounts by Cost Center (Color)


 
 

The Invoice Discounts by Cost Center (Color) inquiry produces
a pie chart depicting how credits are distributed to the
various high-level cost centers.

INTENDED USE:

In the chart, each slice represents a cost center's relative
share of the total credits.


 DATA SOURCE (file):
 
       ACTRCP  - Financial Recap File
 
 DATA ELEMENTS USED:
 
      COSTCTRn - User-Defined Cost Center Codes
      RCPTYPE  - Financial Recap Type
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTCM7, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 

   +----------------------------------------------------------------------------------+  |                                                                                  |  | -------------------------  Execution-Time Parameters  -------------------------  |  | Command ===>                                                  Scroll ===> PAGE   |  |                                                                                  |  | Executing CA MICS Inquiry:  ACTCM7 - Invoice discounts by Cost Center            |  |                                                                                  |  | ------------------------------------------------------------------------------   |  |   Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.           |  | 01                                    - _____________________________________    |  |                                                                                  |  |   Specify the Cost Centers to be reported or leave blank to report all.          |  | _____________________________________ - _____________________________________    |  |                                                                                  |  +----------------------------------------------------------------------------------+  

  NOTE:  Because this is a color graphics chart, no sample of
         the chart is provided.

6.6.8 Monthly Net Revenue Summary (Color)


 
 
The Monthly Net Revenue Summary (Color) inquiry produces a
vertical bar chart that represents net revenue for a selected
number of months for any or all high-level cost centers.

INTENDED USE:

The bar chart shows monthly revenue for each month at
high-level cost centers.

 DATA SOURCE (file):
 
       ACTRCP  - Financial Recap File
 
 DATA ELEMENTS USED:
 
      COSTCTRn - User-Defined Cost Center Codes
      RCPTYPE  - Financial Recap Type
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTCM8, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 

   +----------------------------------------------------------------------------------+  | -------------------------  Execution-Time Parameters  -------------------------  |  | Command ===>                                                  Scroll ===> PAGE   |  |                                                                                  |  | Executing CA MICS Inquiry:  ACTCM8 - Monthly Net Revenue Summary                 |  |                                                                                  |  | ------------------------------------------------------------------------------   |  |   Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.           |  | 12                                    - 01                                       |  |                                                                                  |  |   Specify the Cost Centers to be reported or leave blank to report all.          |  | _____________________________________ - _____________________________________    |  +----------------------------------------------------------------------------------+

 
 
 NOTE:  Because this is a color graphics chart, no sample of
        the chart is provided.

6.6.9 Monthly Invoice Credit/ Discount Summary (Color)


 
 
The Monthly Invoice Credit/ Discount Summary (Color) inquiry
produces a stacked vertical bar chart depicting the credits
and discounts provided each month over a specified period of
months for any or all high-level cost centers.

INTENDED USE:

The bar chart shows the relative share of credits and
discounts for each month at any level of cost center.


 DATA SOURCE (file/timespan):
 
      ACTLGR   - Ledger File at the MONTHS timespan.
 
 DATA ELEMENTS USED:
 
      COSTCTRn - User-Defined Cost Center Codes
      INVCCAT  - Invoice Categories
      LGRCHG   - Amount Billed
      RCPTYPE  - Financial Recap Type
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTCM9, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 

 +----------------------------------------------------------------------------------+  | -------------------------  Execution-Time Parameters  -------------------------  |  | Command ===>                                                  Scroll ===> PAGE   |  |                                                                                  |  | Executing CA MICS Inquiry:  ACTCM9 - Monthly Invoice Credit/Discount Summary     |  |                                                                                  |  | ------------------------------------------------------------------------------   |  |   Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.           |  | 12                                    - 01                                       |  |                                                                                  |  |   Specify the Cost Centers to be reported or leave blank to report all.          |  | _____________________________________ - _____________________________________    |  +----------------------------------------------------------------------------------+  

 NOTE:  Because this is a color graphics chart, no sample of
        the chart is provided.

6.6.10 Weekly Processing Charges Summary (Color)


 
 
The Weekly Processing Charges by Summary (Color) inquiry
produces a vertical bar chart showing the total charges
processed during the preceding seven days for any or all
high-level cost cost centers.

INTENDED USE:

The bar chart shows each day charges for any high-level cost
centers.


 DATA SOURCE (file/timespan):
 
      ACTLGR   - Ledger File at the DAYS timespan.
 
 DATA ELEMENTS USED:
 
      COSTCTRn - User-Defined Cost Center Codes
      INVCCAT  - Invoice Categories
      LGRCHG   - Amount Billed
      RCPTYPE  - Financial Recap Type
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTCW1, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 

 +----------------------------------------------------------------------------------+  |   -------------------------  Execution-Time Parameters  ------------------------ |  |   Command ===>                                                  Scroll ===> CSR  |  |                                                                                  |  |   Executing CA MICS Inquiry:  ACTCW1 - Weekly Processing Charges Summary         |  |                                                                                  |  |   ------------------------------------------------------------------------------ |  |     Enter the Data Base ID. (1 character) for the Data Base to be processed.     |  |   _____________________________________ - _____________________________________  |  |                                                                                  |  |     Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.         |  |   07                                    - 01                                     |  |                                                                                  |  |     Specify the Cost Centers to be reported or leave blank to report all.        |  |   _____________________________________ - _____________________________________  |  +----------------------------------------------------------------------------------+  

 NOTE:  Because this is a color graphics chart, no sample of
       the chart is provided.

6.6.11 - Weekly Processing Charges by Invoice Category (Color)


 
 
The Weekly Processing Charges by Invoice Category (Color)
inquiry produces a vertical bar chart showing the total
charges processed during the preceding seven days for any or
all high-level cost centers.

INTENDED USE:

The bar chart shows each day's charges for any high-level
cost centers by Invoice Category.


 DATA SOURCE (file/timespan):
 
      ACTLGR   - Ledger File at the DAYS timespan.
 
 DATA ELEMENTS USED:
 
      COSTCTRn - User-Defined Cost Center Codes
      INVCCAT  - Invoice Categories
      LGRCHG   - Amount Billed
      RCPTYPE  - Financial Recap Type
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTCW2, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 

   +-----------------------------------------------------------------------------------+  |                                                                                   |  |   -------------------------  Execution-Time Parameters  ------------------------- |  |   Command ===>                                                  Scroll ===> CSR   |  |                                                                                   |  |   Executing CA MICS Inquiry:  ACTCW2 - Weekly Charges by Invoice Category         |  |                                                                                   |  |   ------------------------------------------------------------------------------  |  |     Enter the Data Base ID. (1 character) for the Data Base to be processed.      |  |   _____________________________________ - _____________________________________   |  |                                                                                   |  |     Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.          |  |   07                                    - 01                                      |  |                                                                                   |  |     Specify the Cost Centers to be reported or leave blank to report all.         |  |   _____________________________________ - _____________________________________   |  |                                                                                   |  |     Specify the invoice categories to be reported or blank to report all.         |  |   _____________________________________ - _____________________________________   |  |                                                                                   |  +-----------------------------------------------------------------------------------+  

 NOTE:  Because this is a color graphics chart, no sample of
        the chart is provided.

6.6.12 Daily Revenue Ranking


 
 
The Daily Revenue Ranking inquiry produces three ranked lists
that show charging activity for the previous day for
specified high-level cost centers, invoice categories, and
computation codes (types of charges within an invoice
category).  Figure 6-34 is a sample of the reports.

INTENDED USE:

The report shows the top ten charges, the top five charges in
each invoice category and the top five charges in each
high-level cost center.
 DATA SOURCE (file):
 
      ACTLGR   - Ledger File at DAYS timespan
 
 DATA ELEMENTS USED:
 
      COSTCTRn - User-Defined Cost Center Codes
      INVCCAT  - Invoice Category
      LGRCPC   - Ledger Computation Code
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTLD1, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 

 +----------------------------------------------------------------------------------+  |  -------------------------  Execution-Time Parameters  ------------------------- |  |  Command ===>                                                  Scroll ===> CSR   |  |                                                                                  |  |  Executing CA MICS Inquiry:  ACTLD1 - Daily Revenue Ranking                      |  |                                                                                  |  |  ------------------------------------------------------------------------------  |  |    Enter the Data Base ID. (1 character) for the Data Base to be processed.      |  |  _____________________________________ - _____________________________________   |  |                                                                                  |  |    Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.          |  |  01                                    - _____________________________________   |  |                                                                                  |  |    Specify the Cost Centers to be reported or blank to report all.               |  |  _____________________________________ - _____________________________________   |  |                                                                                  |  |    Specify the invoice categories to be reported or blank to report all.         |  |  _____________________________________ - _____________________________________   |  |                                                                                  |  |    Specify the computation codes to be reported or blank to report all.          |  |  _____________________________________ - _____________________________________   |  |                                                                                  |  |                                                                                  |  +----------------------------------------------------------------------------------+  


                                                  Daily Revenue Ranking - Top 10 Charges                                                                  CA                                                         FOR:  December 7, yyyy   INQUIRY:  ACTLD1                                                                                           RUN DATE:  08DECyy                                    Amount      Comp.             No.    Billing            Inv.     Cost                                  Billed      Code            Items     Rate      Hour    Cat.    Center                                  $18,023.00    0097             3605    $5.0000      1     1200     UNK                                $16,769.00    0097             3354    $5.0000     15     1200     STO                                $13,312.00    0097             2662    $5.0000     16     1200     STO                                $12,360.00    0097             2472    $5.0000     15     1200     UNK                                $11,711.00    0097             2342    $5.0000     16     1200     UNK                                 $9,453.00    0023             3151    $3.0000      9     1100     EJM                                 $9,004.00    0097             1801    $5.0000      5     1200     IIS                                 $8,896.00    0097             1779    $5.0000     16     1200     STO                                 $8,412.00    0252             1402    $6.0000     15     1100     MFB                                 $7,871.00    0097             1574    $5.0000      0     1200     IIS  

 Figure 6-34. Daily Revenue Ranking (Part 1 of 6)

                                      Daily Revenue Ranking - Top 5 Charges by Invoice Category                                                                  CA                                                         FOR:  December 7, yyyy   INQUIRY:  ACTLD1                                                                                           RUN DATE:  08DECyy    ---------------------------------------------- Invoice Category=CENTRAL PROCESSOR(S) -----------------------------------------------                                        Amount      Comp.             No.    Billing             Cost                                      Billed      Code            Items     Rate      Hour    Center                                       $9,453.00    0023             3151    $3.0000      9      EJM                                     $8,412.00    0252             1402    $6.0000     15      MFB                                     $7,360.00    0023             2453    $3.0000     16      UNK                                     $6,954.00    0023             2318    $3.0000     15      UNK                                     $6,402.00    0252             1067    $6.0000     15      MFB      ---------------------------------------------------- Invoice Category=CHANNELS -----------------------------------------------------                                        Amount      Comp.             No.    Billing             Cost                                      Billed      Code            Items     Rate      Hour    Center                                      $18,023.00    0097             3605    $5.0000      1      UNK                                    $16,769.00    0097             3354    $5.0000     15      STO                                    $13,312.00    0097             2662    $5.0000     16      STO                                    $12,360.00    0097             2472    $5.0000     15      UNK                                    $11,711.00    0097             2342    $5.0000     16      UNK  

 Figure 6-34. Daily Revenue Ranking (Part 2 of 6)

                                         Daily Revenue Ranking - Top 5 Charges by Cost Center                                                                  CA                                                         FOR:  December 7, yyyy   INQUIRY:  ACTLD1                                                                                           RUN DATE:  08DECyy    --------------------------------------------------------- Cost Center=ALF ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                        $1,236.00    0252              206    $6.0000     15     1100                                        $455.00    0097               91    $5.0000     14     1200                                        $450.00    0252               75    $6.0000     13     1100                                        $396.00    0252               66    $6.0000     18     1100                                        $342.00    0252               57    $6.0000     15     1100      --------------------------------------------------------- Cost Center=CPT ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                          $726.00    0252              121    $6.0000     19     1100                                        $164.00    0097               33    $5.0000     19     1200                                         $78.00    0252               13    $6.0000     18     1100                                         $32.00    0023               11    $3.0000     19     1100                                         $30.00    0252                5    $6.0000     23     1100      --------------------------------------------------------- Cost Center=CTO ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                        $4,830.00    0252              805    $6.0000     15     1100                                      $1,026.00    0097              205    $5.0000     15     1200                                        $504.00    0252               84    $6.0000     14     1100                                        $204.00    0097               41    $5.0000     14     1200                                        $157.00    0023               52    $3.0000     15     1100      --------------------------------------------------------- Cost Center=CTS ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                           $36.00    0252                6    $6.0000     17     1100                                         $24.00    0252                4    $6.0000     20     1100                                         $24.00    0252                4    $6.0000      7     1100                                         $18.00    0252                3    $6.0000      1     1100                                         $18.00    0097                4    $5.0000     20     1200    

 Figure 6-34. Daily Revenue Ranking (Part 3 of 6)

                                         Daily Revenue Ranking - Top 5 Charges by Cost Center                                                                  CA                                                         FOR:  December 7, yyyy   INQUIRY:  ACTLD1                                                                                           RUN DATE:  08DECyy    --------------------------------------------------------- Cost Center=EJM ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                        $9,453.00    0023             3151    $3.0000      9     1100                                      $1,254.00    0252              209    $6.0000     12     1100                                        $852.00    0252              142    $6.0000     10     1100                                        $714.00    0252              119    $6.0000     12     1100                                        $458.00    0097               92    $5.0000     10     1200      --------------------------------------------------------- Cost Center=FIN ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                           $55.00    0097               11    $5.0000      2     1200                                          $7.00    0023                2    $3.0000      2     1100                                          $6.00    0252                1    $6.0000      2     1100                                          $6.00    0252                1    $6.0000      2     1100                                          $6.00    0252                1    $6.0000      2     1100      --------------------------------------------------------- Cost Center=GIS ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                           $18.00    0252                3    $6.0000     23     1100                                         $18.00    0252                3    $6.0000     23     1100                                         $18.00    0252                3    $6.0000     23     1100                                          $2.00    0097                0    $5.0000     23     1200                                          $1.00    0097                0    $5.0000     23     1200      --------------------------------------------------------- Cost Center=IIS ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                        $9,004.00    0097             1801    $5.0000      5     1200                                      $7,871.00    0097             1574    $5.0000      0     1200                                      $6,614.00    0097             1323    $5.0000      7     1200                                      $3,072.00    0097              614    $5.0000      4     1200                                      $3,032.00    0097              606    $5.0000      7     1200  

 Figure 6-34. Daily Revenue Ranking (Part 4 of 6)

                                         Daily Revenue Ranking - Top 5 Charges by Cost Center                                                                  CA                                                         FOR:  December 7, yyyy   INQUIRY:  ACTLD1                                                                                           RUN DATE:  08DECyy    --------------------------------------------------------- Cost Center=MFB ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                        $8,412.00    0252             1402    $6.0000     15     1100                                      $6,402.00    0252             1067    $6.0000     15     1100                                      $2,298.00    0252              383    $6.0000     13     1100                                      $1,822.00    0097              364    $5.0000      0     1200                                      $1,500.00    0252              250    $6.0000     11     1100      --------------------------------------------------------- Cost Center=OSY ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                        $6,383.00    0097             1277    $5.0000     23     1200                                      $5,641.00    0097             1128    $5.0000     17     1200                                      $5,615.00    0097             1123    $5.0000     18     1200                                      $2,031.00    0097              406    $5.0000     23     1200                                        $947.00    0097              189    $5.0000     17     1200      --------------------------------------------------------- Cost Center=SPT ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                        $1,196.00    0097              239    $5.0000     20     1200                                        $992.00    0097              198    $5.0000     13     1200                                        $930.00    0252              155    $6.0000      9     1100                                        $715.00    0097              143    $5.0000      9     1200                                        $714.00    0252              119    $6.0000      1     1100      --------------------------------------------------------- Cost Center=STO ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                       $16,769.00    0097             3354    $5.0000     15     1200                                     $13,312.00    0097             2662    $5.0000     16     1200                                      $8,896.00    0097             1779    $5.0000     16     1200                                      $4,854.00    0097              971    $5.0000     11     1200                                      $2,820.00    0252              470    $6.0000     21     1100  

 
 Figure 6-34. Daily Revenue Ranking (Part 5 of 6)

                                         Daily Revenue Ranking - Top 5 Charges by Cost Center                                                                  CA                                                         FOR:  December 7, yyyy   INQUIRY:  ACTLD1                                                                                           RUN DATE:  08DECyy    --------------------------------------------------------- Cost Center=TST ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                           $72.00    0252               12    $6.0000     16     1100                                         $54.00    0252                9    $6.0000     15     1100                                         $54.00    0252                9    $6.0000     17     1100                                         $48.00    0252                8    $6.0000      8     1100                                         $45.00    0097                9    $5.0000     14     1200      --------------------------------------------------------- Cost Center=UNC ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                        $4,668.00    0023             1556    $3.0000      3     1100                                      $3,672.00    0097              734    $5.0000      1     1200                                      $3,299.00    0023             1099    $3.0000      9     1100                                      $2,377.00    0097              475    $5.0000      5     1200                                      $2,324.00    0097              465    $5.0000      4     1200      --------------------------------------------------------- Cost Center=UNK ----------------------------------------------------------                                         Amount      Comp.             No.    Billing            Inv.                                       Billed      Code            Items     Rate      Hour    Cat.                                       $18,023.00    0097             3605    $5.0000      1     1200                                     $12,360.00    0097             2472    $5.0000     15     1200                                     $11,711.00    0097             2342    $5.0000     16     1200                                      $7,360.00    0023             2453    $3.0000     16     1100                                      $6,954.00    0023             2318    $3.0000     15     1100  

 Figure 6-34. Daily Revenue Ranking (Part 6 of 6)

6.6.13 Net Revenue by Cost Center


 
 
The Net Revenue by Cost Center inquiry produces a pie chart
that depicts how 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. Figure 6-35 shows a sample Net Revenue by Cost
Center.

INTENDED USE:

The pie chart shows the Financial Recap Charge for various
high-level cost centers.


 DATA SOURCE (file):
 
      ACTRCP   - Financial Recap File
 
 DATA ELEMENTS USED:
 
      RCPTYPE  - Financial Recap Type BUDGET
      COSTCTRn - User-Defined Cost Center Codes
      RCPCHG   - Amount Billed (format MONEY is used for this
                 chart. If RCPCHG value is large you can
                 modify the format to meet your need (e.g.;
                 format BEST.)
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTPM1, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 

   +----------------------------------------------------------------------------------+  |                                                                                  |  | -------------------------  Execution-Time Parameters  -------------------------  |  | Command ===>                                                  Scroll ===> PAGE   |  |                                                                                  |  | Executing CA MICS Inquiry:  ACTPM1 - Net Revenue by Cost Center                  |  |                                                                                  |  | ------------------------------------------------------------------------------   |  |   Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.           |  | 01                                    - _____________________________________    |  +----------------------------------------------------------------------------------+


                                                      Net Revenue by Cost Center                                                          HERNDON DEVELOPMENT                                                           FOR NOVEMBER, yyyy   INQUIRY:  ACTPM1                                                                                           RUN DATE:  21DECyy                                                         Sum of RCPCHG by COSTCTR1                                                            ALF ***************                                                      ******               ******                                                  ****                           ****                                               ***                                   ***                                             **                                         **                                           **                                             **                                         **                                                 **                                        *                                                     *                                      **                                                       **                                     **                                                         **                                    **                     637430.0                              **                                   **                       56.96%                                **                                  *                                                                 *                                 **                                                                 **                                 *                                                                   *                                *                                                                     *                                *                                                                     *                               *                                                                       *                               *                                                                       *                               *                                                                       *                              *                                                                         *                              *                                                                         *                              *                                    +  . . .. . .. . .. . .. . .. . .. . *                              *                               . .                                       *                              *                            . .                                          *                               *                       .. .                                            *                               *                    ..                                                 *                               *                 ..                                                    *                                *           . ..                                                      *                                *        . .                                                          *                                 *   .. .                                                            *                                 **.                                                                **                                  *                                                                 *                                   **                              481579.7                       **                                    **                              43.04%                       **                                     **                                                         **                                      **                                                       **                                        *                                                     *                                         **                                                 **                                           **                                             **                                             **                                         **                                               ***                                   ***                                                  ****                           ****                                                      ******               ******                                                            *************** DEP  

 Figure 6-35. Net Revenue by Cost Center

6.6.14 Budgeted and Actual Charges


 
 
The Budgeted and Actual Charges inquiry produces a vertical
bar chart for selected high-level cost centers.  Each bar
represents either the actual charges or the budgeted amount
for a cost center. Figure 6-36 is a sample of the chart.

INTENDED USE:

This report can be used to see how well the cost centers are
staying within their budgets.


 DATA SOURCE (file):
 
      ACTRCP   - Financial Recap File
 
 DATA ELEMENTS USED:
 
      RCPTYPE  - Financial Recap Type BUDGET
      COSTCTRn - User-Defined Cost Center Codes
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTPM2, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 
 

   +----------------------------------------------------------------------------------+  |                                                                                  |  |  Command ===>                                                  Scroll ===> PAGE  |  |                                                                                  |  |  Executing CA MICS Inquiry:  ACTPM2 - Budgeted and Actual Charges                |  |                                                                                  |  |  ------------------------------------------------------------------------------  |  |    Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.          |  |  01                                    - _____________________________________   |  |                                                                                  |  |    Specify the Cost Centers to be reported or leave blank to report all.         |  |  _____________________________________ - _____________________________________   |  |                                                                                  |  +----------------------------------------------------------------------------------+


                                                     Budgeted and Actual Charges                                                          HERNDON DEVELOPMENT                                                           FOR NOVEMBER, yyyy   INQUIRY:  ACTPM2                                                                                         RUN DATE:  15DECyy                               Net Charges Sum                               600000 +                                                BBBBB                                    |                                                BBBBB                                    |                                                BBBBB                                    |                                                BBBBB                                    |                                    AAAAA       BBBBB                             500000 +                   BBBBB            AAAAA       BBBBB                                    |                   BBBBB            AAAAA       BBBBB                                    |                   BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                             400000 +       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                             300000 +       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                             200000 +       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                             100000 +       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    |       AAAAA       BBBBB            AAAAA       BBBBB                                    ----------------------------------------------------------------------                                              A           B                A           B          GROUP                                              |----- ALF -----|            |----- DEP -----|        COSTCTR1                                                        Symbol TYPE       Symbol TYPE                                                         A   Actual        B   Budget  


 Figure 6-36. Budgeted and Actual Charges

6.6.15 Monthly Charges by Invoice Category


 
 
 The Monthly Charges by Invoice Category inquiry produces a
pie chart depicting how revenue, less than any credits, is
distributed to the various invoice categories, where the
categories are broadly defined along the lines of CPU, DASD,
Print, Tape, etc.  Each slice represents a category's
relative contribution to total revenue. Figure 6-37 is a
sample of the chart.

INTENDED USE:

The pie chart shows the Financial Recap Charge for various
high-level cost centers by Invoice Category.


 DATA SOURCE (file):
 
      ACTRCP   - Financial Recap File
 
 DATA ELEMENTS USED:
      RCPTYPE  - Financial Recap Type
      RCPCHG   - Amount Billed (format MONEY is used for this
                 chart. If RCPCHG value is large you can
                 modify the format to meet your need (e.g.;
                 format BEST.)
      COSTCTRn - User-Defined Cost Center Codes
 
 HOW TO PRODUCE THE REPORT:
 
   o Enter the CA MICS Workstation Facility (MWF).
 
   o Choose option 2, CA MICS Information Center Facility
     (MICF).
 
   o Choose option 2, Database Inquiries.
 
   o Select ACTPM3, whose Catalog Group is FINANCE.
 
   o Complete the Execution-Time Parameters panel illustrated
     below. (If you are not familiar with MICF, see the
     CA MICS MICF Reference Guide.)
 

 +----------------------------------------------------------------------------------+  |                                                                                  |  |   Command ===>                                                  Scroll ===> PAGE |  |                                                                                  |  |   Executing CA MICS Inquiry:  ACTPM3 - Monthly Charges by Invoice Category       |  |                                                                                  |  |   ------------------------------------------------------------------------------ |  |     Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed.         |  |   01                                    - _____________________________________  |  |                                                                                  |  |     Specify the Cost Centers to be reported or leave blank to report all.        |  |   _____________________________________ - _____________________________________  |  +----------------------------------------------------------------------------------+


                                                 Monthly Charges by Invoice Category                                                          HERNDON DEVELOPMENT                                                           FOR NOVEMBER, yyyy   INQUIRY:  ACTPM3                                                                                RUN DATE:  14DECyy                                                          Sum of RCPCHG by INVCCAT                                                                ***************                                                      ******               ******                                                  ****                           ****                                               ***                                   ***                                             **                                         **                                           **                                             **                                         **                                                 **                                        *                                                     *                                      **                                                       **                                     **                                                         **                                    **                                                           **                 CENTRAL PROCESSOR **                                                             **                                  *                                                                 *                                 **                                                                 **                                 *                                                                   *                                *                                                                     *                                *             443032.9                                                *                               *               84.26%                                                  *                               *                                                                       *                               *                                                                       *                              *                                                                         *                              *                                                                         *                              *                                    +  . . .. . .. . .. . .. . .. . .. . *                              *                                       .                                 *                              *                                      . .                                *                               *                                      ....                             *                               *                                        .  ..         57124.37         *                               *                                         .   .         10.86%          *                                *                                        .     ..                     *                                *                                         .      .                    *                                 *                                         ..      ..                *  TERMINALS                                 **                                          .       ..             **                                  *                                           .25642.91 .           *                                   **                                          . 4.88%   ..       **                                    **                                          .           .    **                                     **                                          ..          .. **                                      **                                           .           **                                        *                                           .         *                                         **                                         .       **                                           **                                        .    **  CHANNELS                                             **                                       . **                                               ***                                   ***                                                  ****                           ****                                                      ******               ******                                                            ***************

 Figure 6-37. Monthly Charges by Invoice Category