PAY PERIOD ENDING 06/29/2006 SUMMARY-REGULAR 0PS ALLOCATION   SUMMARY-RECLASS ALLOCATION
hours actual budget under(over) Av. Hourly Rates   hours actual budget under(over) Av. Hourly Rates
Acquisitions & Licensing                 4,361.75  $ 29,495.94  $ 30,500.00  $                   1,004.06  $                            6.76 Acquisitions & Licensing     1,529.50  $ 13,070.87  $  17,600.00  $     4,529.13  $             8.55
                       
Cataloging & Metadata                 3,611.25  $ 20,861.26  $ 23,500.00  $                   2,638.74  $                            5.78 Cataloging & Metadata         404.25  $   3,348.14  $     4,400.00  $     1,051.86  $             8.28
                       
Total Departments                 7,973.00  $ 50,357.19  $ 54,000.00  $                   3,642.81  $                            6.32 Total Departments     1,933.75  $ 16,419.01  $  22,000.00  $     5,580.99  $             8.49
A&L RECAP BY PAYROLL CLASS A&L RECLASS RECAP BY PAYROLL CLASS
  Hours Gross FICA Employer Exp Distribution   Hours Gross FICA Employer Exp Distribution
OPS/N                     648.25        4,706.45           360.04  $                   5,066.49 17.18% OPS/N     1,529.50     12,236.00            834.87       13,070.87 100.00%
OPS/S                 3,171.25     23,432.03                    -                       23,432.03 79.44% OPS/S                  -                      -                        -                        -   0.00%
Subtotal                 3,819.50     28,138.48           360.04                     28,498.52 96.62% Subtotal     1,529.50     12,236.00            834.87       13,070.87 100.00%
FWSP                     542.25           997.41                    -                            997.41 3.38% FWSP                  -                      -                        -                        -   0.00%
                       
YTD total                 4,361.75     29,135.89           360.04                     29,495.94 100% YTD total     1,529.50     12,236.00            834.87       13,070.87 100%
C&M RECAP BY PAYROLL CLASS C&M RECLASS RECAP BY PAYROLL CLASS
  Hours Gross FICA Employer Exp Distribution   Hours Gross FICA Employer Exp Distribution
OPS/N                     269.75        2,159.80           165.22  $                   2,325.02 11.15% OPS/N         232.25        2,038.58            155.95         2,194.53 65.54%
OPS/S                 2,314.50     16,663.25                       16,663.25 79.88% OPS/S         172.00        1,153.61                      -           1,153.61 34.46%
Subtotal                 2,584.25     18,823.05           165.22                     18,988.27 91.02% Subtotal         404.25        3,192.19            155.95         3,348.14 100.00%
CWSP                 1,027.00        1,872.99                         1,872.99 8.98% FWSP                  -                      -                        -                        -   0.00%
                       
YTD total                 3,611.25     20,696.03           165.22                     20,861.26 100% YTD total         404.25        3,192.19            155.95         3,348.14 100.00%
        ACQUISITIONS AND LICENSING DEPARTMENT 55080000               RECLASS      
06/29/06 Date Payroll Paid    Hours   Student      Unit     Department % of Sect'n Budgeted  Variance:        
#   Part    Equivalents  MONOGRAPH UNIT SERIALS PAYING UNIT G & E ADMIN Expenditure Allocation Expenditure Fav ,-Unfav Hours Expenditure Budgeted  Under (Over) Budget
1 07/14/05 1.0           192.50 4.81                            915.74                                           -    $              -             525.33                      -           1,441.06 4.7%        1,168.58 -23.3%             68.50                                              589.92  $       674.33               84.41
2 07/28/05 1.0           165.00 4.13                            580.28                                           -    $              -             677.17                      -           1,257.45 4.1%        1,168.58 -7.6%             75.50                                              650.21  $       674.33               24.12
3 08/11/05 1.0           135.75 3.39                            488.28                                           -    $              -             342.83                      -               831.11 2.7%        1,168.58 28.9%             74.50                                              641.59  $       674.33               32.74
4 08/25/05 1.0           157.00 3.93                            736.48                                           -    $       40.37           171.18                      -               948.03 3.1%        1,168.58 18.9%             72.75                                              626.52  $       674.33               47.81
5 09/08/05 1.0           214.50 5.36                            773.91                                           -    $       99.09           533.19                      -           1,406.19 4.6%        1,168.58 -20.3%             69.00                                              594.23  $       674.33               80.10
6 09/22/05 1.0           223.75 5.59                            747.40                                           -    $    106.43           554.41                      -           1,408.24 4.6%        1,168.58 -20.5%             77.00                                              663.12  $       674.33               11.21
7 10/06/05 1.0           244.75 6.12                            899.35                                           -    $       91.75           588.50                      -           1,579.59 5.2%        1,168.58 -35.2%             75.50                                              650.21  $       674.33               24.12
8 10/20/05 1.0           219.50 5.49                            849.50                                           -    $       84.41           482.75                      -           1,416.66 4.6%        1,168.58 -21.2%             65.00                                              559.78  $       674.33            114.55
9 11/03/05 1.0           186.50 4.66                            541.27                                           -    $    104.60           475.00                      -           1,120.87 3.7%        1,168.58 4.1%             65.00                                              559.78  $       674.33            114.55
10 11/17/05 1.0           222.00 5.55                            789.30                                           -    $       93.59           510.75                      -           1,393.63 4.6%        1,168.58 -19.3%             61.50                                              529.64  $       674.33            144.69
11 12/01/05 1.0           168.75 4.22                            631.51                                           -    $       58.72           345.05                      -           1,035.27 3.4%        1,168.58 11.4%             61.00                                              525.33  $       674.33            149.00
12 12/15/05 1.0           171.75 4.29                            642.99                                           -    $       93.59           420.31                      -           1,156.89 3.8%        1,168.58 1.0%             65.75                                              566.24  $       674.33            108.09
13 12/29/05 1.0             55.50 1.39                            346.20                                           -    $              -               54.38                      -               400.58 1.3%        1,168.58 65.7%             32.00                                              275.58  $       674.33            398.75
14 01/12/06 1.0             93.25 2.33                            515.90                                           -    $       39.85           106.88                      -               662.62 2.2%        1,168.58 43.3%             28.00                                              241.14  $       674.33            433.19
15 01/26/06 1.0           197.00 4.93                            689.15                                           -    $    106.26           589.50                      -           1,384.91 4.5%        1,168.58 -18.5%             62.00                                              503.19  $       674.33            171.14
16 02/09/06 1.0           217.00 5.43                            990.51                                           -    $              -             524.75                      -           1,515.26 5.0%        1,168.58 -29.7%             71.00                                              576.24  $       674.33               98.09
17 02/23/06 1.0           185.50 4.64                            707.09                                           -    $              -             570.00                      -           1,277.09 4.2%        1,168.58 -9.3%             71.00                                              576.24  $       674.33               98.09
18 03/09/06 1.0           145.75 3.64                            689.34                                           -    $              -             298.56                      -               987.90 3.2%        1,168.58 15.5%             29.00                                              249.75  $       674.33            424.58
19 03/23/06 1.0             69.75 1.74                            216.31                                           -    $              -             241.88                      -               458.19 1.5%        1,168.58 60.8%             77.00                                              663.12  $       674.33               11.21
20 04/06/06 1.0           207.00 5.18                            903.26                                           -    $              -             527.75                      -           1,431.01 4.7%        1,168.58 -22.5%             75.00                                              645.90  $       674.33               28.43
21 04/20/06 1.0           191.50 4.79                            692.17                                           -    $              -             629.00                      -           1,321.17 4.3%        1,168.58 -13.1%             61.00                                              525.33  $       674.33            149.00
22 05/04/06 1.0           194.75 4.87                            706.58                                           -    $              -             628.13                      -           1,334.70 4.4%        1,168.58 -14.2%             79.50                                              684.65  $       674.33             (10.32)
23 05/18/06 1.0           109.25 2.73                            681.37                                           -    $              -               89.50                      -               770.87 2.5%        1,168.58 34.0%             70.00                                              602.84  $       674.33               71.49
24 06/01/06 1.0             87.50 2.19                            407.99                                           -    $              -             132.00                      -               539.99 1.8%        1,168.58 53.8%                    -                                                          -        
25 06/15/06 1.0           185.00 4.63                            974.98                                           -    $              -             498.60                      -           1,473.58 4.8%        1,168.58 -26.1%             43.00                                              370.32  $       674.33            304.01
26 06/29/06 1.0           121.25 3.03                            415.62                                           -    $              -             527.48                      -               943.09 3.1%        1,168.58 19.3%                    -                                                          -        
TOTAL   26.0        4,361.75 4.19  $                  17,532.43  $                                      -    $    918.64  $ 11,044.86  $                 -    $   29,495.94 96.7%     30,383.14 2.9%        1,529.50  $                                    13,070.87  $ 16,183.91  $     3,113.04
  target % spent 99.62%   Unit Allocation  $                  17,770.36  $                                      -    $    918.64  $ 11,811.00  $                 -    $   30,500.00 Allocation  Balance 06/29/06        1,004.06   Initial allocation  $ 17,600.00  
  actual % spent 96.71%   Allocation  Bal.  $                        237.93  $                                      -    $       (0.00)  $       766.14  $                 -    $     1,004.06 remaining ppds: 0.1           113.45   Allocation  Bal.  $   4,529.13  
  CURRENT FTE                2.10   %  Expended 98.7%   100.0% 93.5%   96.7% Budget excess, (shortfall)  $       890.62   %  Expended 74.3%  
   AV. HR. RATE:   $           6.76   initial allocation 58.26% 0.00% 3.01% 38.72% 0.00% 100.00%         av. Hours per pay pd             58.83  
      minimum per ppe to spend out =   #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! maximum exp per pay period  $ 10,040.65  $ 45,291.30 minimum per ppe to spend out #DIV/0!  
  Payroll Classification Summary (includes reclass) TOTAL HOURS                         2,428.00                                           -           124.50        1,809.25                      -           4,361.75 expense per pay period  $   1,134.46  $       502.73 TOTAL HOURS        1,529.50  
         Budgeted YTD Expense   $                  17,702.27  $                                      -    $    915.12  $ 11,765.75  $                 -    $   30,383.14 excess capacity (overrun)  $   8,906.19  $ 44,788.57  Budgeted YTD Expense      17,532.57  
  Direct  Cost   Hours  Variance favorable, -unfav  $                        169.84  $                                      -    $       (0.00)  $       720.89  $                 -    $        890.73 maximum hours per pay period        1,484.77        5,299.80 Variance favorable, -unfav        4,461.70  
  OPS/Non-Student  $   5,066.49           648.25 Projected Annual Expenditure  $                  17,599.86  $                                      -    $    918.64  $ 11,087.34  $                 -    $   29,605.85 av hours per pay period           167.76             58.83 Projected Annual Expenditure     13,121.14  
  OPS/Student  $ 23,432.03        3,171.25 Projected Surplus,(Deficit)  $                        170.50  $                                      -    $       (0.00)  $       723.66  $                 -    $        894.15 additional (cut) hours        1,317.01        5,240.98 Projected Surplus,(Deficit)        4,478.86  
  SUBTOTAL OPS     28,498.52        3,819.50  Pay pd budget   $                    2,379.28  $                                      -    $       (0.03)  $   7,661.39  $                 -    $   10,040.65 maximum stud. Eq.             37.12           184.11  Pay pd budget      45,291.30  
  FWSP           997.41           542.25 Pay pd Average Exp.  $                        674.32  $                                      -    $       35.33  $       424.80  $                 -    $     1,134.46 student equivalents                4.19                1.47 Pay pd Average Exp.           502.73  
  Total     29,495.94        4,361.75  Av. Hourly rate   $                            7.22  NO HOURS   $         7.38  $           6.10  NO HOURS   $             6.76 under,(over)staffing             32.93           182.64  Av. Hourly rate                 8.55  
Acquisitions & Licensing Summary by Student     Payroll Paid 06/29/06                              32.95              (0.00)           125.50               148.48    
  Hours  Worked Gross Wages FICA Match  Expense         
Monographs            
             
OPS/Non-student            
Caicedo, Ana                         6.75             49.55                3.79                             53.34    
Ally, Usman                       63.50           409.58             31.33                          440.91    
Leino, David                      145.00        1,073.04             82.09                       1,155.13    
Davis-Vanness, Spencer                     121.00           877.50             67.13                          944.63    
Montas, Lucia                       39.00           300.30             22.97                          323.27    
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                     375.25        2,709.96           207.31                       2,917.27    
             
OPS/STUDENT            
Aggarwal, Amit                       14.50           121.22                    -                            121.22    
Leino, David                      585.00        4,372.80                    -                         4,372.80    
Montas, Lucia                     130.00           976.16                    -                            976.16    
Bruno, Jessica                     300.00        2,211.00                    -                         2,211.00    
DelValle, Jessica                     163.25        1,224.38                    -                         1,224.38    
Soykatristan, W                       27.00           193.59                    -                            193.59    
                               -                      -                      -                                      -      
Davis-Vanness, Spencer                     439.00        3,260.52                    -                         3,260.52    
Daue, Katharina                     158.50        1,152.90                    -                         1,152.90    
Sanchez, Melissa                     116.50           884.24                    -                            884.24    
                               -                      -                      -                                      -      
Total                 1,933.75     14,396.80                    -                       14,396.80    
             
Work Study Program            
Caicedo, Ana                     119.00           218.37                    -                            218.37    
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                     119.00           218.37                    -                            218.37    
Total Monographs                 2,428.00     17,325.12           207.31                     17,532.43    
             
             
             
SERIALS ACQUISITIONS            
OPS/Non-student            
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                              -                      -                      -                                      -      
             
OPS/Student            
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                              -                      -                      -                                      -      
             
Work Study Program            
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                              -                      -                      -                                      -      
Total SERIALS ACQUISITIONS                              -                      -                      -                                      -      
             
PAYING UNIT            
OPS/Non-student            
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                              -                      -                      -                                      -      
             
OPS Student            
Sanchez, Melisa                     124.50           918.64                    -                            918.64    
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                     124.50           918.64                    -                            918.64    
             
Work Study Program            
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                              -                      -                      -                                      -      
Total PAYING UNIT                     124.50           918.64                    -                            918.64    
             
             
GIFTS & EXCHANGE            
OPS/Non-student            
Pafundi, Brian                     160.50        1,175.13             89.90                       1,265.02    
Bree, Patrick                       10.00             72.50                5.55                             78.05    
Sepulveda, Migdalia                     102.50           748.87             57.29                          806.15    
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                     273.00        1,996.49           152.73                       2,149.22    
             
OPS/Student            
Matthews, Diana                      323.00        2,381.11                    -                         2,381.11    
Davis, Casey                       78.00           546.00                    -                            546.00    
Pafundi, Brian                     157.00        1,165.00                    -                         1,165.00    
Devier, Charlotte                     265.50        1,951.86                    -                         1,951.86    
Rivera, Delia                     289.50        2,072.63                    -                         2,072.63    
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                 1,113.00        8,116.59                    -                         8,116.59    
             
Work Study Program            
Sepulveda, Migdalia                     417.75           769.19                    -                            769.19    
Davis, Casey                         5.50                9.86                    -                                 9.86    
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                     423.25           779.05                    -                            779.05    
Total Gifts & Exchange                 1,809.25     10,892.13           152.73                     11,044.86    
ADMIN          
OPS/Non-student          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total                              -                      -                      -                                      -    
           
OPS/Student          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total                              -                      -                      -                                      -    
           
Work Study Program          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total FWSP                              -                      -                      -                                      -    
Total ADMIN                              -                      -                      -                                      -    
Total Acquisitions & Licensing                 5,891.25     41,371.89        1,194.91                     42,566.81  
OPS/Non-student                     648.25        4,706.45           360.04                       5,066.49    
OPS/Student                 3,171.25     23,432.03                    -                       23,432.03    
Work Study Program                     542.25           997.41                    -                            997.41    
Total Acquisitions & Licensing                 4,361.75     29,135.89           360.04                     29,495.94    
A&L RECLASS = DATABASE MANAGEMENT            
DATABASE MANAGEMENT            
OPS/Non-student            
Garcia, Josefina                 1,529.50     12,236.00           834.87                     13,070.87    
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                 1,529.50     12,236.00           834.87                     13,070.87    
             
OPS/Student            
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
Total                              -                      -                      -                                      -      
             
Work Study Program            
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -      
                               -                      -                      -                                      -   Total A & L RECLASS            
                               -                      -                      -                                      -   OPS/Non-student                              1,529.50   12,236.00           834.87       13,070.87    
                               -                      -                      -                                      -   OPS/Student                                           -                    -                      -                        -      
Total                              -                      -                      -                                      -   Work Study Program                                           -                    -                      -                        -      
Total Database Management                 1,529.50     12,236.00           834.87                     13,070.87 Total A & L RECLASS                              1,529.50   12,236.00           834.87       13,070.87    
   
06/29/06       CATALOGING AND METADATA DEPARTMENT 55160000                        
Pay Period             Unit           Budgeted Variance RECLASS      
# Ended Part  Hours   Student Equivalents  HUMANITIES & SPECIAL COLLECTIONS C&M CHAIR PRINCIPAL SERIAL CATALOGER AUTHORITY & METADATA QUALITY COPY CATALOGING SCIENCE & SOCIAL SCIIENCE DEPARTMENT EXPENDITURE % of Sect'n Allocation Expenditure Fav / (Unfav) Hours Expenditure Budgeted  Under (Over) Budget
1 07/14/05 1.0           146.50                               3.66                                     -                                             -                    -               82.24            629.51               90.43            802.18 3.4%           900.38 10.9%                                                 25.00           178.43  $        168.58                              (9.85)
2 07/28/05 1.0           154.50                               3.86                                     -                                             -                    -                      -              743.69                      -              743.69 3.2%           900.38 17.4%                                                 30.00           214.12  $        168.58                           (45.53)
3 08/11/05 1.0           118.00                               2.95                            229.20                                           -                    -                      -              406.87                      -              636.07 2.7%           900.38 29.4%                                                 57.25           510.18  $        168.58                         (341.60)
4 08/25/05 1.0             48.25                               1.21                                     -                                             -                    -                      -              129.38                      -              129.38 0.6%           900.38 85.6%                                                 62.00           576.46  $        168.58                         (407.88)
5 09/08/05 1.0           124.25                               3.11                                     -                                             -                    -                      -              747.33                      -              747.33 3.2%           900.38 17.0%                                                 53.00           516.79  $        168.58                         (348.21)
6 09/22/05 1.0           206.50                               5.16                                     -                                             -                    -                      -           1,061.51                      -           1,061.51 4.5%           900.38 -17.9%                                                 49.00           490.27  $        168.58                         (321.69)
7 10/06/05 1.0           226.50                               5.66                                     -                                             -                    -                      -           1,135.59                      -           1,135.59 4.8%           900.38 -26.1%                                                   7.00             46.41  $        168.58                           122.17
8 10/20/05 1.0           200.50                               5.01                                     -                                             -                    -                      -              985.43                      -              985.43 4.2%           900.38 -9.4%                                                 10.00             66.30  $        168.58                           102.28
9 11/03/05 1.0           205.50                               5.14                                     -                                             -                    -                      -           1,057.06                      -           1,057.06 4.5%           900.38 -17.4%                                                   8.00             53.04  $        168.58                           115.54
10 11/17/05 1.0           188.00                               4.70                                     -                                             -                    -                      -              808.78                      -              808.78 3.4%           900.38 10.2%                                                 10.00             66.30  $        168.58                           102.28
11 12/01/05 1.0           144.00                               3.60                                     -                                             -                    -                      -              711.78                      -              711.78 3.0%           900.38 20.9%                                                 10.00             66.30  $        168.58                           102.28
12 12/15/05 1.0           118.75                               2.97                                     -                                             -                    -                      -              560.94                      -              560.94 2.4%           900.38 37.7%                                                 10.00             66.30  $        168.58                           102.28
13 12/29/05 1.0                    -                                          -                                             -                    -                      -                        -                        -                        -               900.38 100.0%                                                 20.00           132.60  $        168.58                             35.98
14 01/12/06 1.0             32.50                               0.81                                     -                                             -                    -                      -              209.61                      -              209.61 0.9%           900.38 76.7%                                                   9.00             61.92  $        168.58                           106.66
15 01/26/06 1.0           171.00                               4.28                            234.00                                           -                    -                      -              763.15                      -              997.15 4.2%           900.38 -10.7%                                                   8.00             55.04  $        168.58                           113.54
16 02/09/06 1.0           192.75                               4.82                            270.00                                           -                    -                      -              897.26                      -           1,167.26 5.0%           900.38 -29.6%                                                 10.00             68.80  $        168.58                             99.78
17 02/23/06 1.0           184.75                               4.62                            202.50                                           -                    -                      -              862.30                      -           1,064.80 4.5%           900.38 -18.3%                                                   7.00             48.16  $        168.58                           120.42
18 03/09/06 1.0           160.00                               4.00                            252.00                                           -                    -                      -              800.52                      -           1,052.52 4.5%           900.38 -16.9%                                                   9.00             61.92  $        168.58                           106.66
19 03/23/06 1.0           119.00                               2.98                            209.25                                           -                    -                      -              612.32                      -              821.57 3.5%           900.38 8.8%                                                 10.00             68.80  $        168.58                             99.78
20 04/06/06 1.0           142.25                               3.56                                     -                                             -                    -                      -              856.54                      -              856.54 3.6%           900.38 4.9%                                                        -                      -        
21 04/20/06 1.0           147.50                               3.69                                     -                                             -                    -                      -              821.50               83.97            905.47 3.9%           900.38 -0.6%                                                        -                      -        
22 05/04/06 1.0           120.75                               3.02                                     -                                             -                    -                      -              812.27                      -              812.27 3.5%           900.38 9.8%                                                        -                      -        
23 05/18/06 1.0           126.25                               3.16                                     -                                             -                    -                      -              846.84             174.39         1,021.24 4.3%           900.38 -13.4%                                                        -                      -        
24 06/01/06 1.0             88.50                               2.21                                     -                                             -                    -                      -              667.53                      -              667.53 2.8%           900.38 25.9%                                                        -                      -        
25 06/15/06 1.0           116.00                               2.90                                     -                                             -                    -                      -              882.76                      -              882.76 3.8%           900.38 2.0%                                                        -                      -        
26 06/29/06 1.1           128.75                               2.93                                     -                                             -                    -                      -           1,022.82                      -           1,022.82 4.4%           990.42 -3.3%                                                        -                      -        
    26.1        3,611.25                               3.46  $                    1,396.95  $                                      -    $              -    $         82.24  $  19,033.28  $        348.79  $  20,861.26 88.8%     23,500.00 11.2%                                              404.25  $   3,348.14  $     3,203.07  $                     (145.07)
  target % spent 100.00%   Allocation  $                    1,396.95  $                                      -    $              -    $         82.24  $  21,930.38  $           90.43  $  23,500.00  Allocation Balance  06/29/2006  $   2,638.74   Allocation  $     4,400.00  
  actual % spent 88.77%   Allocation  Balance  $                                 -    $                                      -    $              -    $          (0.00)  $     2,897.10  $       (258.36)  $     2,638.74       Allocation  Balance  $     1,051.86  
  Current FTE           1.7295   Total Hours                            153.75                                           -                    -                  8.00         3,422.50               27.00  $     3,611.25 0.0 ppds expense                    -     Total Hours            404.25  
   AV. HR. RATE:   $           5.78   initial allocation 5.9% 0.0% 0.0% 0.3% 93.3% 0.4% 100% Budget excess, (shortfall)  $   2,638.74        
        Av. Hourly rate  $                            9.09  NO HOURS   NO HOURS   $         10.28  $             5.56  $           12.92  $             5.78         Av. Hourly rate  $             8.28  
        minimum per ppd to   $                                 -    $                                      -    $              -    $           0.05  $ (28,971.03)  $     2,583.56  $ (26,387.43) Maximum expense per pay period #DIV/0! #DIV/0! break-even per ppd  $ (10,518.61)  
  Payroll Classification Summary (includes Reclass)      spendout               current expense per pay period  $       799.28  $                                          128.28      
        YTD Budgeted Expense  $                    1,396.95  $                                      -    $              -    $         82.24  $  21,930.38  $           90.43  $  23,500.00 excess capacity (cost) #DIV/0! #DIV/0! YTD Budgeted Expense  $     4,400.00  
  Direct  Cost  Hours Variance 0.0% n/a n/a 0.0% 13.2% -285.7% 11.2% Maximum hours per pay period #DIV/0! #DIV/0! Variance 23.9%  
  OPS/Non-Student  $   2,325.02           269.75 Projected Annual Expense  $                    1,396.95  $                                      -    $              -    $         82.24  $  19,033.28  $        348.79  $  20,861.26 current hours per pay period           138.36                                                 15.49 Projected Annual Expense  $     3,348.14  
  OPS/Student     16,663.25        2,314.50 Projected Surplus,(deficit)  $                                 -    $                                      -    $              -    $          (0.00)  $     2,897.10  $       (258.36)  $     2,638.74 excess capacity (cutback)-hours #DIV/0! #DIV/0! Projected Surplus,(deficit)  $     1,051.86  
  SUBTOTAL OPS     18,988.27        2,584.25 Pay Pd Budgeted Exp  $                          53.52  $                                      -    $              -    $           3.15  $        840.24  $             3.46  $        900.38 max student Complement #DIV/0! #DIV/0! Pay Pd Budgeted Exp  $        168.58  
  FWSP        1,872.99        1,027.00 Pay Pd Average Exp  $                          53.52  $                                      -    $              -    $           3.15  $        729.24  $           13.36  $        799.28 current student complement                3.46                                                   0.39 Pay Pd Average Exp  $        128.28  
  Total     20,861.26        3,611.25 Av. Hourly rate  $                            9.09        $         10.28  $             5.56  $           12.92  $             5.78 excess capacity (cutback)-students #DIV/0! #DIV/0! Av. Hourly rate  $             8.28  
 
Cataloging & Metadata Summary by Student       PAY PERIOD ENDING  
        6/29/2006  
HUMANITIES & SPECIAL COLLECTIONS Hours  Worked Gross Wages fica/med  Expense   
           
OPS/Non-student          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total ops/n                              -                      -                      -                                      -    
           
OPS/Student          
Zhang, Yue                       24.00           229.20                    -                            229.20  
Zhang, Jian                     129.75        1,167.75                    -                         1,167.75  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total OPS/S                     153.75        1,396.95                    -                         1,396.95  
           
Work Study Program          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total FWSP                              -                      -                      -                                      -    
TOTAL HUM/SC                     153.75        1,396.95                    -                         1,396.95  
           
           
C&M CHAIR          
OPS/Non-student          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total ops/n                              -                      -                      -                                      -    
           
OPS/STUDENT          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total OPS/S                              -                      -                      -                                      -    
           
Work Study Program          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total FWSP                              -                      -                      -                                      -    
C&M CHAIR                              -                      -                      -                                      -    
PRINCIPAL SERIAL          
  CATALOGER           
           
OPS/Non-student          
Zhang, Jian                              -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total ops/n                              -                      -                      -                                      -    
           
OPS/STUDENT          
Zhang, Jian                              -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total OPS/S                              -                      -                      -                                      -    
           
Work Study Program          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total FWSP                              -                      -                      -                                      -    
TOTAL SERCAT                              -                      -                      -                                      -    
           
           
AMQ          
OPS/Non-student          
Lowry, Paul                         8.00             76.40                5.84                             82.24  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total ops/n                         8.00             76.40                5.84                             82.24  
           
OPS/STUDENT          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total OPS/S                              -                      -                      -                                      -    
           
Work Study Program          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total FWSP                              -                      -                      -                                      -    
TOTAL AMQ                         8.00             76.40                5.84                             82.24  
COPY CATALOGING          
OPS/Non-student          
Solano, Arlene                         7.00             50.19                3.84                             54.03  
Melnyk, Daria                       39.25           356.31             27.26                          383.57  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Lima, Andiara                        31.75           218.44             16.71                          235.15  
Sheridan, Philip                       85.00           658.75             50.39                          709.14  
Anderson, Tiara                       71.75           475.70             36.39                          512.09  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total ops/n                     234.75        1,759.40           134.59                       1,893.99  
OPS/STUDENT          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Sauleda, Andrea                     292.00        1,972.46                    -                         1,972.46  
                               -                      -                      -                                      -    
Amienyi, Shaina                     256.00        1,733.28                    -                         1,733.28  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Sheridan, Philip                     460.50        3,522.06                    -                         3,522.06  
Lima, Andiara                      188.00        1,274.19                    -                         1,274.19  
                               -                      -                      -                                      -    
Goodall, Gavin                     410.00        3,048.76                    -                         3,048.76  
Apena, Olusola                       62.00           411.06                    -                            411.06  
Yoo, Christina                       48.00           318.24                    -                            318.24  
Wong, Lianna                     254.75        1,715.56                    -                         1,715.56  
Boza, Dulce                     109.25           732.02                    -                            732.02  
Knight, Krystal                       80.25           538.68                    -                            538.68  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total OPS/S                 2,160.75     15,266.30                    -                       15,266.30  
Work Study Program          
Amienyi, Shaina                       18.00             29.84                    -                               29.84  
Johnson, Vamadria                     170.50           351.66                    -                            351.66  
Solano, Arlene                     204.00           372.08                    -                            372.08  
Ordonez, Ivis                     122.00           212.85                    -                            212.85  
Lucas, Santresse                     139.25           234.68                    -                            234.68  
Boza, Dulce                              -                      -                      -                                      -    
                               -                      -                      -                                      -    
Thomas, Catrice                       48.00             96.00                    -                               96.00  
                               -                      -                      -                                      -    
Sheridan, Philip                     149.75           280.78                    -                            280.78  
Bowes, Joycelyn                     175.50           295.11                    -                            295.11  
           
           
Total FWSP                 1,027.00        1,872.99                    -                         1,872.99  
Total COPY CATALOGING                 3,422.50     18,898.68           134.59                     19,033.28  
SCIENCE & SOCIAL SCIENCE          
OPS/Non-student          
Constantineau, Susan                       27.00           324.00             24.79                          348.79  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total ops/n                       27.00           324.00             24.79                          348.79  
           
OPS/STUDENT          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total student                              -                      -                      -                                      -    
           
Work Study Program          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total FWSP                              -                      -                      -                                      -    
Total SCI/SOC                       27.00           324.00             24.79                          348.79  
           
TOTAL C&M                 3,611.25     20,696.03           165.22                     20,861.26  
           
OPS/N                     269.75        2,159.80           165.22                       2,325.02  
           
OPS/S                 2,314.50     16,663.25                    -                       16,663.25  
SUBTOTAL OPS                 2,584.25     18,823.05           165.22                     18,988.27  
           
FWSP                 1,027.00        1,872.99                    -                         1,872.99  
           
TOTAL C&M                 3,611.25     20,696.03           165.22                     20,861.26  
           
CATMET RECLASS          
OPS/Non-student          
Garcia, Emilia                     148.00        1,480.00           113.22                       1,593.22  
Zhang, Jian                       84.25           558.58             42.73                          601.31  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total ops/n                     232.25        2,038.58           155.95                       2,194.53  
           
OPS/STUDENT          
Zhang, Jian                     172.00        1,153.61                    -                         1,153.61  
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
total student                     172.00        1,153.61                    -                         1,153.61  
           
Work Study Program          
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
                               -                      -                      -                                      -    
Total FWSP                              -                      -                      -                                      -                                       -    
Total RECLASS                     404.25        3,192.19           155.95                       3,348.14  
           
OPS/N                     232.25        2,038.58           155.95                       2,194.53  
           
OPS/S                     172.00        1,153.61                    -                         1,153.61  
SUBTOTAL OPS                     404.25        3,192.19           155.95                       3,348.14  
           
FWSP                              -                      -                      -                                      -    
           
Total RECLASS                     404.25        3,192.19           155.95                       3,348.14