Docstoc

2010-2011apabd_3_7 - ALA-APA

Document Sample
2010-2011apabd_3_7 - ALA-APA Powered By Docstoc
					de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                         ALA-APA BUDGET REQUEST                                                                                   2010-11 APABD #3.7




                         Rev./     60-800                         ALA-APA            ADM.             Certification     Consulting &     Library      Support Staff
                                                                                                                         Statistical     Worklife     Certification
                                                                                                                         Reporting                                    FY 2012 Budget
                         Exp.                                                       Project #           Project #         Project #      Project #      Project #       REQUESTS
                         Acct. #   Description                                        0000                8060              8061           8062           8065            TOTAL


                                   Beginning Remaining Available from Loan /
                                   (Loan Overdrawn)                                                                                                                            92,743

                                   Subtotal-Dues                                             0                    0                 0             0              0                  0
                                   Subtotal-Sales-Net                                        0                    0            11,660             0              0             11,660
                                   Subtotal-Other Sales                                      0                    0                 0             0              0                  0
                                   Subtotal-Subscriptions                                    0                    0                 0       105,320              0            105,320
                                   Subtotal-Advertising                                      0                    0                 0             0              0                  0
                                   Subtotal-Meetings & Conf.                                 0               11,065                 0             0         35,600             46,665
                                   Subtotal-Grants & Awards                                  0                    0                 0             0              0                  0
                                   Subtotal-Misc.                                        6,000                    0               500             0              0              6,500

                                   Total Revenues                                        6,000               11,065            12,160       105,320         35,600            170,145

                                   Payroll & Related Exp.                               15,431               15,154            10,664        15,154            868             57,271
                                   Outside Services                                        700                  350            11,000         6,640            -               18,690
                                   Travel and Related Expenses                           7,500                5,000               -             -              -               12,500
                                   Meetings & Conferences                                1,000                  -                 -             -              -                1,000
                                   Publication Related Expenses                          5,015                  400            (3,165)          -              -                2,250
                                   Operating Expenses                                   15,120                1,922           (21,030)       20,810         15,181             32,003
                                   Total IUTs                                              -                    -                 -             -              -                    0

                                   Total Direct Expenses                                44,766               22,826            (2,531)       42,604         16,049            123,714

                                   Contribution Margin                                 (38,766)              (11,761)          14,691        62,716         19,551             46,431

                                   IUT-General Overhead                                     -                    -                -             -               -                      0

                                   Total Expenses Excl. Alloc                           44,766               22,826            (2,531)       42,604         16,049            123,714

                                   IUT-Allocations                                          -                    -                -             -               -                      0

                                   Total Exp. Incl. OH & Alloc.                         44,766               22,826            (2,531)       42,604         16,049            123,714

                                   Net Rev/(Exp) Before Taxes                          (38,766)              (11,761)          14,691        62,716         19,551             46,431

                                   Taxes/Income                                             -                    -                -             -               -                      0

                                   Total Expenses Incl. Taxes                           44,766               22,826            (2,531)       42,604         16,049            123,714

                                   Net Rev/(Exp) After Taxes                           (38,766)              (11,761)          14,691        62,716         19,551             46,431


                                   Ending Remaining Available from Loan / (Loan
                                   Overdrawn)                                                                                                                                 139,174



de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                                         1                                                                                        5/12/2013 10:27 AM
de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                  ALA-APA BUDGET REQUEST                                                                        2010-11 APABD #3.7




                         Rev./     60-800        ALA-APA      ADM.           Certification   Consulting &   Library     Support Staff
                                                                                              Statistical   Worklife    Certification
                                                                                              Reporting                                 FY 2012 Budget
                         Exp.                                Project #         Project #       Project #    Project #     Project #       REQUESTS
                         Acct. #   Description                 0000              8060            8061         8062          8065            TOTAL




de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                2                                                                               5/12/2013 10:27 AM
de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                             ALA-APA BUDGET REQUEST                                                                                            2010-11 APABD #3.7



                           Rev./          60-800                          ALA-APA        ADM.               Certification       Consulting &     Library         Support Staff
                                                                                                                                 Statistical     Worklife        Certification
                                                                                                                                 Reporting                                         FY 2012 Budget
                           Exp.                                                         Project #             Project #           Project #      Project #         Project #         REQUESTS
                           Acct. #        Description                                     0000                  8060                8061           8062              8065              TOTAL
                                          Beginning Remaining Available from Loan /
                                          (Loan Overdrawn)                                                                                                                                  92,743

                       1           4000   Dues/Personal                                             0                       0               0                0                 0                    0
                       2           4001   Dues/Organizational                                       0                       0               0                0                 0                    0
                       3           4002   Dues-Special                                              0                       0               0                0                 0                    0
                       4           4003   Dues Life Members-Current                                 0                       0               0                0                 0                    0
                       5           4004   Dues-Cont. Members & Div Trfr                             0                       0               0                0                 0                    0
                       6
                       7                  Subtotal-Dues                                             0                       0               0                0                 0                    0
                       8
                       9           4100   Sales/Books                                               0                       0          12,200                0                 0            12,200
                      10           4600   Assets Released From Restriction                          0                       0               0                0                 0                    0
                      11           4601   Returns/Credits                                           0                       0            (540)               0                 0              (540)
                      12           4620   Contra/Fulfillment Charges                                0                       0               0                0                 0                    0
                      13
                      14                  Subtotal-Sales-Net                                        0                       0          11,660                0                 0            11,660
                      15
                      16           4101   Sales/Pamphets                                            0                       0               0                0                 0                    0
                      17           4102   Sales Audiovisual                                         0                       0               0                0                 0                    0
                      18           4103   Sales/On-line                                             0                       0               0                0                 0                    0
                      19           4104   Sales/Rental-Mail Lists                                   0                       0               0                0                 0                    0
                      20           4105   Sales/Webinars, Webcasts. Web CE                          0                       0               0                0                 0                    0
                      21           4108   Sales/ALA Store                                           0                       0               0                0                 0                    0
                      22           4109   Sales/Miscellaneous                                       0                       0               0                0                 0                    0
                      23
                      24                  Subtotal-Other Sales                                      0                       0               0                0                 0                    0
                      25
                      26           4110 Subscriptions                                               0                       0               0       105,320                    0           105,320
                      27
                      28                  Subtotal-Subscriptions                                    0                       0               0       105,320                    0           105,320
                      29
                      30           4140   Advertising/Gross                                         0                       0               0                0                 0                    0
                      31           4142   Advertising/Classified                                    0                       0               0                0                 0                    0
                      32           4143   Advertising/Online                                        0                       0               0                0                 0                    0
                      33           4610   Comm/Online Advertising                                   0                       0               0                0                 0                    0
                      34           4611   Comm/Sales Rep                                            0                       0               0                0                 0                    0
                      35           4612   Comm/Adv. Agency                                          0                       0               0                0                 0                    0
                      36
                      37                  Subtotal-Advertising                                      0                       0               0                0                 0                    0
                      38
                      39           4200 Registration Fees                                           0              11,065                   0                0         35,600               46,665
                      40           4210 Exhibit Space Rentals                                       0                       0               0                0                 0                    0
                      41           4220 Meal Functions                                              0                       0               0                0                 0                    0


de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                                               3                                                                                               5/12/2013 10:27 AM
de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                            ALA-APA BUDGET REQUEST                                                                                           2010-11 APABD #3.7




                           Rev./          60-800                           ALA-APA      ADM.               Certification       Consulting &    Library         Support Staff
                                                                                                                                Statistical    Worklife        Certification
                                                                                                                                Reporting                                        FY 2012 Budget
                           Exp.                                                        Project #             Project #           Project #     Project #         Project #         REQUESTS
                           Acct. #        Description                                    0000                  8060                8061          8062              8065              TOTAL
                      42
                      43                  Subtotal-Meetings & Conf.                                0              11,065                  0                0         35,600               46,665
                      44
                      45           4300 Grants & Awards-Exchange                                   0                       0              0                0                 0                    0
                      46           4301 Grants & Awards-Temporary Restricted                       0                       0              0                0                 0                    0
                      47
                      48                  Subtotal-Grants & Awards                                 0                       0              0                0                 0                    0
                      49
                      50           4400   Donations/Honoraria                               6,000                          0              0                0                 0             6,000
                      51           4420   Interest/Dividends                                       0                       0              0                0                 0                    0
                      52           4421   Royalties-Exempt                                         0                       0              0                0                 0                    0
                      53           4422   L-T Invest. Gain/Loss-Realized                           0                       0              0                0                 0                    0
                      54           4423   L-T Invest. Gain/Loss-Unrealized                         0                       0              0                0                 0                    0
                      55           4429   Overhd-exempt Rev./Division                              0                       0              0                0                 0                    0
                      56           4430   Royalties-Non-Exempt                                     0                       0              0                0                 0                    0
                      57           4490   Misc. Fees/Revenues                                      0                       0            500                0                 0               500
                      58
                      59                  Subtotal-Misc.                                    6,000                          0            500                0                 0             6,500
                      60
                      61                  Total Revenues                                    6,000                 11,065              12,160      105,320            35,600              170,145
                      62
                      63           5000   Salaries & Wages                                 11,657                 11,657               8,203       11,657               668               43,842
                      64           5001   Temp Employees-In-House                                  0                       0              0                0                 0                    0
                      65           5002   Overtime/Wages                                           0                       0              0                0                 0                    0
                      66           5005   Attrition Factor                                         0                       0              0                0                 0                    0
                      67           5009   Accrued Vacation                                         0                       0              0                0                 0                    0
                      68           5010   Employee Benefits                                 3,264                   3,497              2,461        3,497               200               12,919
                      69           5015   Tuition Reimbursement                                    0                       0              0                0                 0                    0
                      70           5016   Prof Memberships                                     510                         0              0                0                 0               510
                      71
                      72                  Payroll & Related Exp.                           15,431                 15,154              10,664       15,154               868               57,271
                      73
                      74           5100   Temp Employee/Outside                                    0                       0              0                0                 0                    0
                      75           5110   Professional Services                                500                         0          11,000        6,600                    0            18,100
                      76           5120   Legal Fees                                               0                       0              0                0                 0                    0
                      77           5121   Audit/Tax Fees                                           0                       0              0                0                 0                    0
                      78           5122   Bank Service Fees                                    200                   350                  0               40                 0               590
                      79           5140   Repairs/Maintenance                                      0                       0              0                0                 0                    0
                      80           5150   Messenger Service                                        0                       0              0                0                 0                    0
                      81           5151   Duplication/Outside                                      0                       0              0                0                 0                    0
                      82
                      83                  Outside Services                                     700                   350              11,000        6,640                    0            18,690
                      84


de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                                              4                                                                                              5/12/2013 10:27 AM
de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                          ALA-APA BUDGET REQUEST                                                                                            2010-11 APABD #3.7




                           Rev./          60-800                         ALA-APA      ADM.               Certification       Consulting &     Library         Support Staff
                                                                                                                              Statistical     Worklife        Certification
                                                                                                                              Reporting                                         FY 2012 Budget
                           Exp.                                                      Project #             Project #           Project #      Project #         Project #         REQUESTS
                           Acct. #        Description                                  0000                  8060                8061           8062              8065              TOTAL
                      85           5210   Transportation                                  4,000                   2,500                  0                0                 0             6,500
                      86           5212   Lodging & Meals                                 3,000                   2,500                  0                0                 0             5,500
                      87           5214   Entertainment                                          0                       0               0                0                 0                    0
                      88           5216   Business Meetings                                  500                         0               0                0                 0               500
                      89
                      90                  Travel and Related Expenses                     7,500                   5,000                  0                0                 0            12,500
                      91
                      92           5300   Facilities Rent                                        0                       0               0                0                 0                    0
                      93           5301   Conference Equipment Rental                     1,000                          0               0                0                 0             1,000
                      94           5302   Meal Functions                                         0                       0               0                0                 0                    0
                      95           5303   Exhibits                                               0                       0               0                0                 0                    0
                      96           5304   Speaker/Guest Expenses                                 0                       0               0                0                 0                    0
                      97           5305   Speaker/Guest Honorarium                               0                       0               0                0                 0                    0
                      98           5306   Awards                                                 0                       0               0                0                 0                    0
                      99           5307   Security Services                                      0                       0               0                0                 0                    0
                     100           5308   Special Transportation                                 0                       0               0                0                 0                    0
                     101           5309   Audio/Visual Equip Rental & Labor                      0                       0               0                0                 0                    0
                     102           5310   Computer Rental/Internet Connection                    0                       0               0                0                 0                    0
                     103           5350   Program Allocation                                     0                       0               0                0                 0                    0
                     104
                     105                  Meetings & Conferences                          1,000                          0               0                0                 0             1,000
                     106
                     107           5400   Editl/Proofreading-O/S                                 0                       0               0                0                 0                    0
                     108           5401   Typesetting/Comptn-O/S                                 0                       0               0                0                 0                    0
                     109           5402   Printing-O/S                                    2,000                    400               1,000                0                 0             3,400
                     110           5403   Binding-O/S                                            0                       0               0                0                 0                    0
                     111           5404   Design Service-O/S                                 500                         0           1,000                0                 0             1,500
                     112           5406   Review Service                                         0                       0               0                0                 0                    0
                     113           5410   Mail Service-O/S                                       0                       0               0                0                 0                    0
                     114           5411   Advertising/Space                               1,000                          0               0                0                 0             1,000
                     115           5412   Advertising/Direct                                     0                       0               0                0                 0                    0
                     116           5413   Mail List Rental                                       0                       0               0                0                 0                    0
                     117           5414   Supplies/Production                                    0                       0               0                0                 0                    0
                     118           5415   Pre-Press/Photo Services                               0                       0               0                0                 0                    0
                     119           5416   Adv Production Cost                                    0                       0               0                0                 0                    0
                     120           5420   Copyright Fees                                         0                       0               0                0                 0                    0
                     121           5430   Web Operating Expenses                          1,515                          0               0                0                 0             1,515
                     122           5431   Webminars/Webcasts/Web CE Exp                          0                       0               0                0                 0                    0
                     123           5432   Purchased Inventory                                    0                       0               0                0                 0                    0
                     124           5433   Order Processing/Fulfillment                           0                       0            585                 0                 0               585
                     125           5480   Cost of Sales                                          0                       0           7,250                0                 0             7,250
                     126           5490   Inventory Adjustment                                   0                       0         (13,000)               0                 0           (13,000)
                     127           5499   Inventory Reserve Adjustment                           0                       0               0                0                 0                    0


de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                                            5                                                                                               5/12/2013 10:27 AM
de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                           ALA-APA BUDGET REQUEST                                                                                            2010-11 APABD #3.7




                           Rev./          60-800                          ALA-APA      ADM.               Certification       Consulting &     Library         Support Staff
                                                                                                                               Statistical     Worklife        Certification
                                                                                                                               Reporting                                         FY 2012 Budget
                           Exp.                                                       Project #             Project #           Project #      Project #         Project #         REQUESTS
                           Acct. #        Description                                   0000                  8060                8061           8062              8065              TOTAL
                     128
                     129                  Publication Related Expenses                     5,015                    400              (3,165)               0                 0             2,250
                     130
                     131           5030   Staff Recruitment/Relocation                            0                       0               0                0                 0                    0
                     132           5031   Staff Development                                   233                         0               0                0                 0               233
                     133           5500   Supplies/Operating                                  500                         0               0                0            400                  900
                     134           5501   Equipment/Software-Minor                                0                       0               0                0          9,814                9,814
                     135           5502   Ref Matls/Periodicals                                   0                       0               0                0                 0                    0
                     136           5510   Insurance                                               0                       0               0                0                 0                    0
                     137           5520   Equipment Rental/Lease                           1,200                          0               0                0                 0             1,200
                     138           5521   Space Rent                                              0                       0               0                0                 0                    0
                     139           5522   Telephone & Fax/O/S                                 300                         0               0                0                 0               300
                     140           5523   Postage & E-Mail/O/S                                400                         0               0                0                 0               400
                     141           5525   Utilities                                               0                       0               0                0                 0                    0
                     142           5530   Depr/Furn & Equipment                            2,077                          0               0                0                 0             2,077
                     143           5531   Depr/Building                                           0                       0               0                0                 0                    0
                     144           5532   Amortization/Equip Lease                                0                       0               0                0                 0                    0
                     145           5540   Royalty Expense                                         0                       0           1,800                0                 0             1,800
                     146           5543   Bad Debt Expense                                        0                       0               0                0                 0                    0
                     147           5544   Interest Expense                                 7,560                          0               0                0                 0             7,560
                     148           5545   Taxes/Property                                          0                       0               0                0                 0                    0
                     149           5550   Promotion                                        2,000                   1,000               500            500             2,000                6,000
                     150           5560   Organization Support/Contrib.                       350                         0         (24,503)               0                 0           (24,153)
                     151           5599   Misc. Expense                                       500                   922               1,173        20,310             2,967               25,872
                     152
                     153                  Operating Expenses                              15,120                   1,922            (21,030)       20,810            15,181               32,003
                     154
                     155           5900   IUT-Marketing                                           0                       0               0                0                 0                    0
                     156           5901   IUT-Prod. Serv./Adm. Fee                                0                       0               0                0                 0                    0
                     157           5902   IUT-ITTS                                                0                       0               0                0                 0                    0
                     158           5903   IUT-Subscription Processing                             0                       0               0                0                 0                    0
                     159           5904   Transfer to/from Endowment                              0                       0               0                0                 0                    0
                     160           5905   IUT-Telephone                                           0                       0               0                0                 0                    0
                     161           5906   IUT-Order Billing                                       0                       0               0                0                 0                    0
                     162           5908   IUT-Maint.                                              0                       0               0                0                 0                    0
                     163           5909   IUT-Dist. Center                                        0                       0               0                0                 0                    0
                     164           5910   IUT-Repro.                                              0                       0               0                0                 0                    0
                     165           5912   IUT-Copy Editing/Proofreading                           0                       0               0                0                 0                    0
                     166           5913   IUT-Composition/Alteration                              0                       0               0                0                 0                    0
                     167           5940   IUT-Registration Processing                             0                       0               0                0                 0                    0
                     168           5941   IUT-CHOICE                                              0                       0               0                0                 0                    0
                     169           5942   IUT-Advertising                                         0                       0               0                0                 0                    0
                     170           5999   IUT-Misc.                                               0                       0               0                0                 0                    0


de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                                             6                                                                                               5/12/2013 10:27 AM
de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                                ALA-APA BUDGET REQUEST                                                                                            2010-11 APABD #3.7




                            Rev./         60-800                           ALA-APA          ADM.               Certification       Consulting &     Library         Support Staff
                                                                                                                                    Statistical     Worklife        Certification
                                                                                                                                    Reporting                                         FY 2012 Budget
                            Exp.                                                           Project #             Project #           Project #      Project #         Project #         REQUESTS
                            Acct. #       Description                                        0000                  8060                8061           8062              8065              TOTAL
                     171
                     172                  Total IUTs                                                   0                       0               0                0                 0                    0
                     173
                     174                  Total Direct Expenses                                44,766                 22,826              (2,531)       42,604            16,049              123,714
                     175
                     176                  Contribution Margin                                 (38,766)                (11,761)            14,691        62,716            19,551               46,431
                     177
                     178            5911 IUT-General Overhead                                          0                       0               0                0                 0                    0
                     179
                     180                  Total Expenses Excl. Alloc                           44,766                 22,826              (2,531)       42,604            16,049              123,714
                     181
                     182            5998 IUT-Allocations                                               0                       0               0                0                 0                    0
                     183
                     184                  Total Exp. Incl. OH & Alloc.                         44,766                 22,826              (2,531)       42,604            16,049              123,714
                     185
                     186                  Net Rev/(Exp) Before Taxes                          (38,766)                (11,761)            14,691        62,716            19,551               46,431
                     187
                     188            5600 Taxes/Income                                                  0                       0               0                0                 0                    0
                     189
                     190                  Total Expenses Incl. Taxes                           44,766                 22,826              (2,531)       42,604            16,049              123,714
                     191
                     192                  Net Rev/(Exp) After Taxes                           (38,766)                (11,761)            14,691        62,716            19,551               46,431
                      193
                                          Ending Remaining Available from Loan / (Loan
                      194                 Overdrawn)                                                                                                                                          139,174
                      195
                      196                 Posted from Budget Notes                             -38766                  -11761              14691         62716              19551              46,431
                                          Variance (Notes Vs. worksheet)                           0                       0                  0             0                  0                    0

                                          Revenues from projects                                6,000                 11,065              12,160       105,320            35,600              170,145
                                          % of total revenues                                    0.04                   0.07                0.07          0.62              0.21                    1




de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                                                                  7                                                                                               5/12/2013 10:27 AM
                                                  Project # 0000
        Unit No.:              60-800
        Unit Name:             ALA-APA
        Project No.:           0000
        Project Name:          Administration

                                                                                                       FY 2012
                                                                                                        Budget
 Line# Line Item Description                         Explanation                          Memo Only    $ Amount

        REVENUE
4400    Donations/Honoraria    Contributions assumed from organizations and                      -           6,000
                               corporations

                               Contributions assumed at an average of $25 from 200             4,000
                               members (average gift 1/10-12/10 was $27.77 from 209
                               members)
                               Merchandise sales for NLWD                                      2,000
                               Total                                                           6,000
                               Total Revenue                                                                 6,000
        EXPENSES
5000    Salaries & Wages      Director at 27% of time of .5 FTE                                             11,657
5001    Temp Employees-In-House                                                                                 -
5002    Overtime/Wages                                                                                          -
5010    Employee Benefits                                                                                    3,264
5016    Prof Memberships      Association Forum ($245) and ASAE ($265)                                         510
5110    Professional Services Graphic designers                                                                500
5120    Legal Fees                                                                                              -
5122    Bank Service Fees                                                                                      200
5210    Transportation                                                                                       4,000
5212    Lodging & Meals       12 MW and AC hotel nights @ $200; 50 per diem                                  3,000
5216    Business Meetings                                                                                      500
5300    Facilities Rent       Conferences                                                                       -
5301                          Conferences
        Conference Equipment Rental                                                                          1,000
5303    Exhibits              Conferences                                                                       -
5304                          C
        Speaker/Guest Expenses onference speakers, includes honoraria                                           -
5402    Printing-O/S                                                                                         2,000
5404    Design Service-O/S                                                                                     500
5411    Advertising/Space                                                                                    1,000
5430    Web Operating ExpensesWebsite hosting with LISHost $1500/yr + $15 for                                1,515
                              FormStack Maintenance for CPLA and other
                              forms/applications; second annual capital payment on site
5031    Staff Development     development (9000/5)                                                             233
5500    Supplies/Operating                                                                                     500
5501    Equipment/Software-Minor                                                                                -
5502    Ref Matls/Periodicals                                                                                   -
5510    Insurance              Basic liability coverage for Directors and Officers                              -
5520    Equipment Rental/LeaseDesktop and laptop                                                             1,200
5522    Telephone & Fax/O/S                                                                                    300
5523    Postage & E-Mail/O/S                                                                                   400
5530    Depr/Furn & Equipment Website depr $9,000/5                                                          2,077
5544    Interest Expense       Based on loan outstanding of $240,000 @ .0315 (3.15%)                         7,560
                               11-591-5544-9140
5550    Promotion              Quarterly email updates to ALA members at 500 each                            2,000
                               4*500= 2000 +500=2500
                               Increase to $2,000 Summer Version
5560                           Sweatshop update
        Organization Support/Contrib.                                                                         350




de99330e-1ae4-4f66-8578-efb8758f75de.xlsx               8                                              5/12/2013
                                                  Project # 0000
        Unit No.:              60-800
        Unit Name:             ALA-APA
        Project No.:           0000
        Project Name:          Administration

                                                                                                         FY 2012
                                                                                                          Budget
 Line# Line Item Description                         Explanation                           Memo Only     $ Amount

5599    Misc. Expense          Overhead rate of .002536or 0.2536% is derived from                               500
                               .51845 FTE/204.418 FTE (.5 APA Director+.01845 FTE
                               Research Asst; 203.9 General Fund FTE plus (.51845)
                               APA FTE = 204.418FTE) therefore
                               (.51845/204.418=.002536). The 1.2 ALA FTE support
                               consists of .15 Executive Office, .35 Accounting &
                               Finance, .1 HR, .1 ITTS & .5 MPS-AED. The overhead
                               rate is calculated based on .73% of total expenses of the
                               following Units: 103-Exec Office, Units 550, 551 & 552-
                               Accounting & Finance, Unit 506-Human Resources, Unit
                               505- ITTS and Unit 200-MPS/AED. Overhead is paid to
                               ALA - 11-591-5599-9140.

                               Unit 103 Executive Office Budgeted Expenses                     723,629
                               Unit 506 HR Budgeted Expenses                                   649,882
                               Unit 200-MPS-AED Budgeted Expenses                              250,963
                               Unit 505 ITTS Budgeted Expenses                               2,491,135
                               Unit 550s Accounting & Finance Budgeted Expenses              1,476,192
                                  Total Budgeted Expenses                                    5,591,801
                               .2536% of total Budgeted Expenses                                14,181
                               To be allocated to proj 0000, 8060, 8061, 8062 & 8065

                               Total Expenses                                                                44,766
                               Net                                                                          (38,766)

                         Note: The FY 2012 budget assumes 23% of Director 1 FTE
                               salary to be allocated to IMLS Library Support Staff
                               Certification Program (LSSCP) and charged to 11-200-
                               5000-0000.
                               The FY 2012 budget assumes 27% of Director 1 FTE
                               salary to be allocated to HRDR and charged to 11-106-
                               5000-0000.
                               In FY 2012 budget, .9631 of .5 FTE of Research
                               Associate be charged to IMLS grant.




de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                9                                               5/12/2013
                                                        Project # 8060

         Unit No.:                   60-800
         Unit Name:                  ALA-APA
         Project No.:                8060
         Project Name:               Certification

                                                                                                                          FY 2012
                                                                                                                          Budget
 Line#      Line Item Description                                  Explanation                               Memo Only    $ Amount

         REVENUE
4200     Registration Fees           CPLA Applicants 30 ALA members @ $250. The average number of                7,500        11,065
                                     applicants each year has been 35 since 2006.
                                     CPLA Course provider fees 1 new course                                        100
                                     CPLA Course Completion reviews 70 ALA members @ $45. The                    3,150
                                     average number of Course Completion Forms submitted has been 96
                                     since 2007, but with applications decreasing, so will the CCFs.

                                     CPLA Final reviews 7 @ $45                                                   315
                                     Total Revenue                                                                            11,065
         EXPENSES
5000     Salaries & Wages            Director at 27% of time of .5 FTE                                                        11,657
5010     Employee Benefits                                                                                                     3,497
5122     Bank Service Fees                                                                                                       350
5210     Transportation                                                                                                        2,500
5212     Lodging & Meals                                                                                                       2,500
5402     Printing-O/S                                                                                                            400
5550     Promotion                   CPLA Product and service marketing and promotion advertisement              1,000         1,000
                                     related expenses. Public Libraries Editor agreed to promote in each
                                     issue.
5599     Misc. Expense               OH Allocation                                                                               922
                                     Total Expenses                                                                           22,826
                                     Net                                                                                     (11,761)

                               Note: The FY 2012 budget assumes 23% of Director 1 FTE salary to be
                                     allocated to IMLS Library Support Staff Certification Program (LSSCP)
                                     and charged to 11-200-5000-0000.
                                     The FY 2012 budget assumes 27% of Director 1 FTE salary to be
                                     allocated to HRDR and charged to 11-106-5000-0000.
                                     In FY 2012 budget, .9631 of .5 FTE of Research Associate be
                                     charged to IMLS grant.




de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                     10                                                         5/12/2013
                Unit No.:                      60-800       Project # 8061
                Unit Name:                     ALA-APA
                Project No.:                   8061
                Project Name:                  Consulting & Statistical Reporting


                                                                                                                FY 2012 Budget
        Line#      Line Item Description                            Explanation                        Memo       $ Amount
                                                                                                       Only
                REVENUE
       4100     Sales/Books                                                                                            12,200
                                               Print only 2012 Librarian Salary Survey 200 @ $100       9,000
                                               (member discount price $90) - anticipate 100 sales in
                                               FY12
                                                                                              9,000
                                               Database annual subscription now an institutional and    3,200
                                               corporate member benefit - 3200 as of December
                                               2010 @ $1 per subscription
       4601     Returns/Credits                6% of total print products                               9,000            (540)
       4490     Misc. Fees/Revenues            Consulting - mix of training & consulting                                  500

                                               Total Revenue                                                           12,160
                EXPENSES
       5000     Salaries & Wages               Director at 19% of time of .5 FTE                                        8,203
       5010     Employee Benefits                                                                                       2,461
       5110     Professional Services          Data/Research-Librarian Salary Survey piloted,          11,000          11,000
                                               administered, analyzed and synthesized by outside
                                               firm
       5402     Printing-O/S                   Printing for Librarian only                              1,000           1,000

       5404     Design Service-O/S             Design                                                   1,000           1,000

       5433     Order Processing/Fulfillment   6.5% of revenue                                                            585
       5480     Cost of Sales                  Print only 2012 Librarian Salary Survey 100 @ $72.50                     7,250

       5490     Inventory Adjustment           To transfer print only 2010 Librarian Salary Survey     13,000         (13,000)
                                               expenses to inventory
       5523     Postage & E-Mail/O/S           Postage for Surveys

       5540     Royalty Expense                10% royalties paid to ALA ORS on print version 109-                      1,800
                                               0700; 10% royalties paid to ALA Store for sales.

       5550     Promotion                     Salary Survey product and service marketing and                             500
                                              promotion advertisement related expenses. Includes
                                              listing in Standing Order Plan ($400).
       5560     Organization Support/Contrib. Contract with ALA Office for Research and Statistics -                  (24,503)
                                              covering subcontractor and analysis costs. (see unit
                                              109-0700)
       5599     Misc. Expense                  Email alerts 1x year @ 5 cents each                       160            1,173
                                               OH Allocation                                            1,013
                                               Total Expenses                                                          (2,531)
                                               Net                                                                     14,691

                                         Note: The FY 2012 budget assumes 23% of Director 1 FTE
                                               salary to be allocated to IMLS Library Support Staff
                                               Certification Program (LSSCP) and charged to 11-200-
                                               5000-0000.
                                               The FY 2012 budget assumes 27% of Director 1 FTE
                                               salary to be allocated to HRDR and charged to 11-
                                               106-5000-0000.
                                               In FY 2012 budget, .9631 of .5 FTE of Research
                                               Associate be charged to IMLS grant.




de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                           11                                                       5/12/2013
                                                       Project # 8062

         Unit No.:                     60-800
         Unit Name:                    ALA-APA
         Project No.:                  8062
         Project Name:                 Library Worklife

                                                                                                              FY 2012 Budget
 Line#      Line Item Description                                Explanation                         Memo        $ Amount
                                                                                                     Only
         REVENUE
4110     Subscriptions                 Library Worklife                                                              105,320
                                       ALA Personal members 57,660 @ $2 (FY 11 Dec Actual)           90,905
                                       $1.75 per subscription from GF
                                       and 25 cents from contingency fund. 11-591-5560-9140          14,415
                                       $90,000; 11-591-5599-9111 $18,001


                                       Total Revenue                                                                 105,320
         EXPENSES
5000     Salaries & Wages              Director at 27% of time of .5 FTE                                              11,657
5010     Employee Benefits                                                                                             3,497
5110     Professional Services         Honoraria for writers at $150-200 each article (Max 12 per     2,400            6,600
                                       year).
                                       Contract Editor @ $350/mo                                      4,200
5122     Bank Service Fees                                                                                                40
5550     Promotion                     Library Worklife promotion                                                        500
5599     Misc.                         LW is now an ALA individual member benefit, quarterly email   11,532           20,310
                                       alerts to all institional members @ 5 cents each
                                       OH Allocation                                                  8,778
                                       Total Expenses                                                                 42,604
                                       Net                                                                            62,716

                                 Note: The FY 2012 budget assumes 23% of Director 1 FTE salary
                                       to be allocated to IMLS Library Support Staff Certification
                                       Program (LSSCP) and charged to 11-200-5000-0000.

                                       The FY 2012 budget assumes 27% of Director 1 FTE salary
                                       to be allocated to HRDR and charged to 11-106-5000-0000.

                                       In FY 2012 budget, .9631 of .5 FTE of Research Associate
                                       be charged to IMLS grant.




de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                   12                                                   5/12/2013
                                                           Project # 8065

         Unit No.:                      60-800
         Unit Name:                     ALA-APA
         Project No.:                   8065
         Project Name:                  Support Staff Certification

                                                                                                                             FY 2012
                                                                                                                             Budget
 Line#      Line Item Description                                     Explanation                               Memo Only    $ Amount

         REVENUE
4200     Registration Fees              LSSC Applicants 100 ALA members @ $350                                     35,000        35,600
                                        LSSC Course provider fees, 3 @ $100, 6 @ $50                                  600
                                        Library Support Staff Certification Program (LSSC) began accepting
                                        candidates in January 2010.

                                        Total Revenue                                                                            35,600
         EXPENSES
5000     Salaries & Wages               Research Associate at 3.69% of .5 FTE                                                       668



5010     Employee Benefits                                                                                                          200
5100     Temp Employee/Outside
5110     Professional Services                                                                                                          -
5122     Bank Service Fees                                                                                                              -
5402     Printing-O/S                                                                                                                   -
5411     Advertising/Space
5500     Supplies/Operating             LSSC                                                                                        400
5501     Equipment/Software-Minor       LSSC Portfolio fees, 100 @ $98, paid to LiveText; Formstack payment                       9,814

5520     Equipment Rental/Lease
5522     Telephone & Fax/O/S
5523     Postage & E-Mail/O/S                                                                                                        -
5550     Promotion                      LSSC product and service marketing                                             -          2,000
5599     Misc. Expense                  OH Allocation                                                                             2,967
                                        Total Expenses                                                                           16,049
                                        Net                                                                                      19,551

                                  Note: The FY 2012 budget assumes 23% of Director 1 FTE salary to be
                                        allocated to IMLS Library Support Staff Certification Program (LSSCP)
                                        and charged to 11-200-5000-0000.
                                        The FY 2012 budget assumes 27% of Director 1 FTE salary to be
                                        allocated to HRDR and charged to 11-106-5000-0000.

                                        In FY 2012 budget, .9631 of .5 FTE of Research Associate be
                                        charged to IMLS grant.




de99330e-1ae4-4f66-8578-efb8758f75de.xlsx                        13                                                         5/12/2013
ALA Allied Professional Association                                                                         Business Plan
Financial Plan                                                                                                Summary
Summary                                                                                                   updated 5/12/2013




                                                                  ACTUAL         ACTUAL       ACTUAL        ACTUAL            ACTUAL       ACTUAL       ACTUAL       ACTUAL       BUDGET        BUDGET

                                                                 FY 2003 FY 2004 FY 2005 FY 2006 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 FY 2012
                                                                  Year 0         Year 1       Year 2         Year 3           Year 4       Year 5       Year 6       Year 7       Year 7        Year 8

                      Projected Beginning Net
                      Asset Balance                                              (1,409) (121,197) (195,509) (235,061) (229,345) (251,765) (267,009) (217,896) (149,032)
                      Revenue
                      Voluntary Contribution-individual &
                      Corporation
                                                                     5,992        26,702       14,725         24,419           33,254       22,779       14,203         6,576        6,000         6,000
                      Certification
                                                                           0           0        3,227         19,568           15,756       16,175       13,870       35,188       47,100        46,665
                      Consulting Services                                  0           0            0              0                0            0            0            0        1,000           500
                      Statistical Research Reports                         0           0       18,253         23,857           71,702       36,457       29,431       16,495       11,110        11,660
                      Monthly Electronic Newsletter                        0      63,255       64,906         96,455           91,906       93,779       90,469       96,330      109,800       105,320
                      Misc (sale of ads, video, buttons, etc.)
                                                                           0        1,500          564          5,340            3,649        2,280        6,730          581              0             0

                      Total Revenue                                5,992         91,457      101,675      169,639        216,267          171,470      154,703      155,170      175,010       170,145
                      Expenses
                      Payroll and Related Exp                            0        56,000       87,388         96,460          117,748       95,729       84,736       58,423       60,786        57,271
                      Travel/Related                                   680         7,500        3,757          7,556            6,769        6,280        5,790        5,251       12,500        12,500
                      Meetings and Conferences (incl.
                      awards)                                            0           145        9,642         10,781            9,598        9,797        5,543           569        1,000        1,000
                      Outside/Professional Services                  6,641        27,600        3,132         26,917           28,643       17,395       19,832         9,445        2,990       18,690
                      Publication Related                                0         3,000       11,399         13,444           (4,532)      26,054       10,056         8,580        6,590        2,250
                      Operating Expenses (incl. Overhead &
                      interest)                                            80     72,000       52,401         52,774           46,698       33,384       43,632       23,789       49,505        26,003
                      Marketing and Promotion                               0     45,000        8,268          1,259            5,627        5,251          357            0        6,000         6,000
                      Evaluation                                            0          0            0              0                0            0                                      0             0

                      Total Expenses                               7,401        211,245      175,987      209,191        210,551          193,890      169,946      106,057      139,371       123,714

                      Change in Net Assets                        (1,409) (119,788) (74,312) (39,552)                          5,716      (22,420) (15,244)          49,113       35,639        46,431
                      Projected Ending Net Assets Balance
                      After Interest payment                      (1,409) (121,197) (195,509) (235,061) (229,345) (251,765) (267,009) (217,896) (149,032) (102,601)

                      Beginning Remaining Available from
                      Loan                                        250,000        248,591      128,803         54,491           14,939       20,655        (1,765)       7,991      57,104        92,743
                      Funds used for operation / Funds
                      available for payment of loan
                                                                    (1,409)      (119,788)     (74,312)      (39,552)            5,716      (22,420)     (15,244)     49,113       35,639        46,431
                      Ending Remaining Available from Loan /
                      (Loan overdrawn)                           248,591        128,803       54,491       14,939             20,655       (1,765) (17,009)          57,104       92,743       139,174
                      Projected Cumulative Net Assets
                      Balance                                       (1,409)      (121,197)    (195,509)     (235,061)         (229,345)    (251,765)    (267,009)    (217,896)    (183,475)     (102,601)

                      Beginning Loan Balance                      250,000        250,000      250,000        250,000          250,000      250,000      250,000      275,000      265,000       240,000
                      Projected Loan Payment                                                                                                                  0       10,000       25,000        25,000
                      Ending Loan Balance                        250,000        250,000      250,000      250,000        250,000          250,000      250,000      265,000      240,000       215,000


14 5/12/2013 10:27 AM                                                                                            14
APA Repayment Schedule

Loan               250,000
Interest Rate        0.0315 (Current borrowing rate from JP Morgan Chase)
Repayment
                   FY 2004   FY 2005   FY 2006     FY 2007      FY 2008    FY 2009     FY 2010    FY 2011      FY 2012   FY 2013   FY 2014     FY 2015    FY 2016    FY 2017    FY 2018       FY 2019   FY 2017
        YEAR          1         2         3           4            5          6           7          8            9        10        11          12         13         14         15            16        14      Total
Projected
average loan
bal                  1,495   121,245   195,509       235,061    229,345    250,000     275,000    265,000      240,000   215,000    190,000    165,000    140,000    115,000      90,000       65,000    40,000
10 years                 0         0         0             0                     0      10,000     25,000       25,000    25,000     25,000     25,000     25,000     25,000      25,000       25,000    25,000   260,000

Interest



Interest                                                                                 7,875      8,348        7,560     6,773      5,985      5,198       4,410      3,623      2,835        2,048     1,260    55,913
Culmulative Int
Total Payment                                                                           17,875     33,348       32,560    31,773     30,985     30,198     29,410      28,623     27,835       27,048    26,260   315,913

Balance            250,000   250,000   250,000       250,000    250,000    250,000     265,000    240,000      215,000   190,000    165,000    140,000    115,000      90,000     65,000       40,000    15,000




Due the approval date of the loan payment, the transaction for payment was made in 2011 technically.
However the payment is for 2010 and therefore in affect there will be two recorded payments in 2011.
For budget purposes the loan balance on the worksheet should show $250,000. Another $25,000
payment should be budgeted for 2011 to bring the loan balance down to $225,000. Clear as mud?

glc

From: Sandra Lee
Sent: Tuesday, December 28, 2010 3:56 PM
To: Keith Brown; Jenifer Grady
Cc: Greg Calloway
Subject: RE: APA Loan amount

Keith & Jenifer,

Talked to Russ and he informed me that there is no loan payment made from APA to ALA in FY 2010 as
budgeted. Therefore, the loan balance is still $275,000.

Please use the attached budget workbook for FY 2012 budget. I have updated the loan balance figure
based on no loan payment in FY 2010. However, I kept the $25,000 budgeted loan payment for FY 2011.

Sandy
 Yep JG, you are correct. My bad memory on the finer more important detail of the action taken by the board.

From: Jenifer Grady
Sent: Tuesday, December 28, 2010 4:21 PM
To: Sandra Lee
Cc: Russ Swedowski; Greg Calloway
Subject: RE: APA Loan amount

I thought the payment for 2010 was $10,000 in cash plus the interest payment. Maybe that’s what you meant, or maybe it’s different. I couldn’t tell but I’m happy to use this one for 2012.

Jenifer Grady, MSLS, MBA, CAE + Director, ALA-APA + jgrady@ala.org + 312-280-2424
                    0000                   8060            8061               8062               8065                   Total
             %          $           %          $        %       $         %         $        %          $          %          $
Dir   43,174 0.27      11,657       0.27      11,657    0.19 8,203         0.27    11,657       0            0      1.00      43,174
         668
Research Asst.              0                      0              0                     0       1          668      1.00         668
           0                                                                                    0            0      0.00           0
Total 43,842 0.27      11,657       0.27      11,657     0.19   8,203      0.27    11,657    1.00       668.00                43,842
                                                                                                                              43,842
                                                                                Projected
                                                                                Sal Inc of           APA          APA
                                                                                  2%                portion      portion
800 Adm     Grady Jenifer       G          Director APA     1            84,655       1.02                0.5     43,174             0.5
800 Adm           Ian
            Lashbrook           D          Research Asst. 0.5            17,745       1.02            0.0369          668       0.01845

                                                        Total           102,400                                   43,842
                                                                                                                            FY 2012                                                    FY 2010
                                                                                                                            .5 of Grady's salary in APA                                .23 of Grady FTE IMLS/Contingency Fund
                                                                                                                                                                                       .
                                                                                                                            .23 of Grady's salary in unit 200 as matching for IMLS Grant27 of Grady FTE (CE project) Contingency Fund
                                                                                                                            .27 of Grady's salary in unit 106                          .5 FTE of Grady's salary in APA
                                                                                                                            FY 2012
                                                                                                                                                                                       FY 2010
                                                                                                                            .0369 of .5 FTE of Research Asst salary in APA (.72 of $19.5 hourly rate)
                                                                                                                                                                                         .5 for $19.5 hourly rate)
                                                                                                                            .9631 of .5 FTE of Research Asst.'s salary in IMLS Grant (18.78 ofHRDR-CEU project
                                                                                                                                                                                         .5 for IMLS Grant


                                                                                                                                                                                      FY 2011
                                                                                                                                                                                      .5 of Grady's salary in APA
                                                                                                                                                                                      .23 of Grady's salary in unit 200 as matching for IMLS Grant
                                                                                                                                                                                      .27 of Grady's salary in unit 106
                                                                                                                                                                                      FY 2011
                                                                                                                                                                                      .3 of .5 FTE of Jamie's salary in APA
                                                                                                                                                                                      .7 of .5 FTE of Jamie's salary in HRDR
                                                                                                                                                                                      .5 FTE of Jamie's salary in IMLS Grant

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/12/2013
language:Unknown
pages:16
yaofenji yaofenji
About