Skip Navigation LinksHome > Sample ABC Reports
 
Skip Navigation Links

Sample ABC Reports

ABC Report 1

Provides a breakout of direct and indirect costs by function, partitioned by personnel, operating, and administrative categories.

  • This report presents costs for functional areas divided into Direct (Value-Added) Costs and Indirect (Non-Value Added) Costs. Each group of costs is further distributed into personnel, overhead and administrative/support types.
  • Important relationships are the proportion of direct personnel to indirect personnel and the proportion of direct to indirect costs.
Function: New Account Costs
  Direct Expense  
  Personnel $ 14,188  
  Operating $ 28,431  
  Total New Accounts Direct  
   $ 42,618  
   
  Indirect Expense  
  Personnel $ 11,497  
  Operating $ 47,636  
  Sup/Admin $ 24,312  
  Total New Accounts Indirect  
   $ 83,445  
   
  Total New Accounts Costs  
   $ 126,063  
Function: Teller Transactions
  Direct Expense  
  Personnel $ 44,233  
  Operating $ 388,856  
  Total Teller Direct  
   $ 433,089  
   
  Indirect Expense  
  Personnel $ 40,968  
  Operating $ 396,273  
  Sup/Admin $ 25,072  
  Total Teller Indirect  
   $ 462,313  
   
  Total Teller Transaction Costs  
   $ 895,402  

Function: Consumer Loans
  Direct Expense  
  Personnel $ 17,724  
  Operating $ 582,983  
  Total Consumer Loans Direct  
   $ 600,707  
   
  Indirect Expense  
  Personnel $ 36,140  
  Operating $ 174,664  
  Sup/Admin $ 25,832  
  Total Consumer Loans Indirect  
   $ 236,636  
   
  Total Consumer Loans Costs  
   $ 837,343  
Function: Mortgage Loans
  Direct Expense  
  Personnel $ 11686  
  Operating $ 177,948  
  Total Mortgage Loans Direct  
   $ 189,643  
   
  Indirect Expense  
  Personnel $ 2,975  
  Operating $ 71,799  
  Sup/Admin $ 15,955  
  Total Mortgage Loans Indirect  
   $ 90,728  
   
  Total Mortgage Loans Costs  
   $ 280,363  

Function: Comercial Loans
  Direct Expense  
  Personnel $ 91,171  
  Operating $ -  
  Total New Accounts Direct  
   $ 91,171  
   
  Indirect Expense  
  Personnel $ 270,582  
  Operating $ -  
  Sup/Admin $ 91,171  
  Total Commercial Loans Indirect  
   $ 361,753  
   
  Total Commercial Loans Costs  
   $ 452,924  
 

ABC Report 2

Provides a breakout of total costs particioned by function and direct vs. Indirect.

  • This report presents the direct costs in relation to the factors which cause activities and/or costs to be incurred.
  • Direct costs for each functional area are dividing by the different activity drivers to arrive at a per item cost.
  • Indirect costs for each functional area are dividing by the different activity drivers to arrive at a per item cost.
  • This report provides insight into the per item cost of delivering individual products and services.
  Function: New Accounts  
  Drivers Total Items Direct Indirect Total  
  New Accounts Opened 152 280 549 829  
  Members 7000 6.09 11.92 18.01  
   
  Function: Transactions  
  Drivers Total Items Direct Indirect Total  
  Total Deposit Accounts 4500 96.24 102.74 198.98  
  Total Deposit Transactions 15800 27.41 29.26 56.67  
  Members 7000 61.87 66.04 127.91  
   
  Function: Consumer Loans  
  Drivers Total Items Direct Indirect Total  
  Applications 215 2,793.99 1,100.63 3,894.62  
  Loans Opened 145 4,142.81 1,631.97 5,774.78  
  Loans in Portfolio 3120 192.53 75.84 268.38  
  Loan Members 2980 201.58 79.41 280.99  
   
  Function: Mortgage Loans  
  Drivers Total Items Direct Indirect Total  
  Applications 54 3,512 1,680 5,192  
  Loans Opened 51 3,718 1,779 5,497  
  Loans in Portfolio 145 1,308 626 1,934  
  Loan Members 140 1,355 648 2,003  

ABC Report 3

Provides a breakout of direct costs partitioned by function step.

  • In this report functional areas are divided into the individual activities engaged to delivery the product or service.
  • Direct costs for each functional area are partitioned into the various process steps to represent the cost of accomplishing each step.
  • This report provides a primary insight into credit union efficiency.
  Function: New Accounts       Function: Transactions  
  Steps Personnel Operating Total       Steps Personnel Operating Total  
  Collect Member Information 3,783 7,581 11,365       Deposit Transactions 8,531 74,994 83,524  
  Prepare Forms 4,256 8,529 12,785       Loan Transactions 4,265 37,497 41,762  
  Marketing 2,128 4,265 6,393       Marketing 2,844 24,998 27,841  
  Account Maint 1,419 2,843 4,262       Account Maint 17,693 155,542 173,236  
  Side Jobs 2,128 4,265 6,393       Side Jobs 10,900 95,825 106,725  
  Other 473 948 1,421       Other - - -  
  Total 14,188 28,431 42,618       Total 44,233 388,856 433,089  
 
  Function: Consumer Loans       Function: Mortgage Loans  
  Steps Personnel Operating Total       Steps Personnel Operating Total  
  Applications 3,633 119,512 123,145       Applications 2,532 38,555 41,087  
  Underwriting 2,221 73,067 75,289       Underwriting 2,945 44,843 47,788  
  Doc Prep 1,737 57,132 58,869       Doc Process 3,584 54,571 58,154  
  Closing 2,068 68,015 70,083       Doc/Closing 857 13,050 13,907  
  File Maint 744 24,485 25,230       File Maint 1,169 17,795 18,963  
  Collections 3,527 116,014 119,541       Collections - - -  
  Other 3,793 124,758 128,551       Other 584 8,897 9,482  
  Total 14,091 463,472 477,562       Total 9,139 139,155 148,294  

ABC Report 4

Provides a breakout of indirect overhead costs partitioned by function.

  Functions Personnel Operating Administrative Total  
  New Accounts 11,497 47,636 24,312 83,445  
  Transactions 40,968 396,273 25,072 462,313  
  Consumer Loans 36,140 174,664 25,832 236,636  
  Mortgage Loans 2,975 71,799 15,955 90,728  
  Commercial Loans 270,582 - 91,171 361,756  
 
  Functions Personnel Operating Administrative Total  
  New Accounts 13.78% 57.09% 29.14% 100.00%  
  Transactions 8.86% 85.72% 5.42% 100.00%  
  Consumer Loans 15.27% 73.81% 10.92% 100.00%  
  Mortgage Loans 3.28% 79.14% 17.59% 100.00%  
  Commercial Loans 74.80% 0.00% 25.20% 100.00%  
Copyright © 2007 - This website was created by Only Results, Inc.