Quarterly Report and FY 2018 Financial Outlook

Quarterly Report and FY 2018 Financial Outlook

Bronx Community College 2017-2018 Mid-Year Financial Report January 2018 HR Current at $65 FTE as of 1/8 is 5562 or 71% HR has headcount at 911 Reduction Scheduled CUNY1ST mass auto step increments scheduled for January 1st includes most faculty and HEO series titles ECP and CM not yet processed All Funds Report Tax Levy Ledger 2 Resources Tax Levy Allocation (Per Allocation #4) Pending Allocations (subject to UBO approval) Revenue Collection Above/(Below) Target 93,810 966 483 Amounts in $000's Tax Levy Tax Levy Ledger 3: Tax Levy Ledger 3: Tax Levy Tech Ledger 3: ECC & Ledger 3: Fee EOC Misc ACE 1,995 219 4,061 619 273 157 BCC Inc Auxiliary Association Enterprises Auxiliary EOC Parking BCC Reserve: Restricted (GENERAL BCC ACE ACCOUNT) Foundation reserve ECC

503 BCC Total** 100,642 1,961 ACE 17.5% Fee Non Tax Levy Programs 507 547 115 0 824 80 115 0 824 80 93 2,166 93 403 105,655 Investment Income Scholarships, Grants & Contract Total Resources 95,259 Expenditures PS Regular, Retros & All Other PS Overtime Adjuncts Temporary Service Total PS Supplies Equipment & Furniture Books/Subscriptions/Memberships Fuel Maintenance Professional & Other Services Financial Aid Travel University-Wide Initiatives Additional OTPS to be allocated Total OTPS (Net of University Wide Initiatives) Total Expenditures* Beginning Fund Balance Net Surplus/(Deficit) Ending Fund Balance 68,728 1,303

10,344 5,479 85,854 1,490 1,579 361 76 1,484 1,534 1,583 127 780 1,211 10,225 96,079 1,910 (820) 1,090 2,214 4,680 430 503 507 547 2,999 157 31 69 1 184 52 267 9 45 3 69 26 2 26 1 36 1 1 0 13 14 106 47 0 13 0

0 3 4 3 56 222 489 20 14 34 105 174 1,028 333 1,361 54 55 2,269 492 2,761 75 552 627 45 606 190 184 3,183 144 56 867 781 557 157 5 273 10 1,764 2,391 750 (177) 573 1,497 4,680 0 0 0 273 430 0 0 0 403 403

447 0 447 21 10 1 0 0 0 28 43 152 75 43 43 7,706 37 7,743 152 152 1,384 251 1,635 75 75 1,362 18 1,380 3 27 27 178 88 266 0 0 278 0 278 63 510 1,938 314 2,252 72,432 1,303 10,787 6,083 90,605 1,784 2,257 587 76

2,321 3,695 1,583 150 780 1,267 14,500 105,105 18,823 550 19,373 Capital Request Focus on Critical Maintenance Revenue Target Increase The same amount is being added to the projection as increased revenue. Fall 2017 projected revenue collections are based on Fall 2016 billed amounts, adjusted by the tuition increase and enrollment changes. The spring billed amount is based on the two year average fall to spring ratio. The collection rates are based on two year averages. FY201 7 FY2018 $ Change Adjusted Revenue Target 43,820 44,047 227 Collections 43,407 45,644 2,238 (413) 1,598 2,011 Variance FY2018 YTD Community College and Central Expenditures Comparison ($000) BMC BCC GCC HOS KCC LAG QCC

CC Total Shared Services Central Administration University Programs University Total Stipends Rentals - Buildings Services-Other Student MetroCard Comp Software => $5K Books Periodicals/Subscriptions Maintenance-General Maint and Cleaning Supplies Services-Other Consulting Office Supplies Telephone Serv & Maintenance Scholarship Awards Services - Advertising Pub Rel Maintenance-HVAC Maintenance-Elevator Maintenance-Computer Equip Maintenance-Office Equipment Services-Info Technology 4,357 15 57 760 88 70 137 624 112 85 101 82 76 48 54 - 313 93 10 10 115 104 1 40 53 47 17 45 7 93 - 3,320 65 505

1 1 5 6 5 2 7 - 1,125 246 89 63 1 32 72 19 38 42 46 90 66 9 - 321 2 53 39 32 84 119 39 62 93 19 139 52 83 71 43 10 2,658 416 17 52 58 72 18 235 634 71 47 10 128 104 8 37 - 586 51 48 12 91 254 6 196 1

117 37 42 0 - 10 11,460 1,963 581 1,099 307 202 341 921 1,323 525 327 340 493 384 148 271 43 616 1,823 8,324 4,770 3,742 1,101 96 18 11 118 34 291 0 1,078 11 62 0 14 2 5 979 42 1 17 311 66 - 4,522 1 1,147 - 14,091 12,588 9,498 8,905 7,098 4,274 3,830 2,589 2,564 2,435 1,574

1,434 1,316 1,251 1,245 1,236 1,041 1,012 1,011 Total Top-20 YTD OTPS Expenditures 7,597 974 3,422 2,181 1,303 4,797 1,583 21,856 12,505 1,279 4,523 71,549 Remaining YTD OTPS Expenditures 2,739 827 593 642 758 836 1,090 7,485 10,713 1,074 1,151 28,516 10,336 1,801 4,015 2,823 2,060

5,633 2,673 29,341 23,218 2,353 5,674 100,065 Total YTD OTPS FY 2018 Projected Tuition Revenue Collections ($000s) Revenue Target Tuition Waiver Adjustment Other Adjustments Adjusted Revenue Target 43,820 0 227 44,047 Billed Fall 2017 Winter 2018 Spring 2018 Summer 2017 Other: Prior Year Receivables Collection Adjustment: Total Projection (1) (2) (3) (4) 7 8 9 6 22,871 0 22,315 2 1,619 1 3 % Collection 94.1% # 0.0% # 94.3% # 97.7% # 0 # 0 46,805 Projected Over/(Under) Assumes an Increase/(Decrease) in Enrollment

Estimate based on last year Fall/Spring billed amounts ratio: Collection rate estimates are based on average of past two years for same semester Estimate based on average of past two years Projected Revenue 21,525 0 21,047 1,583 0 1,262 4 227 45,644 1,598 # 0.7% 97.6% YTD Actual: $22,860 Current Year Balance Report Balance Report - Fall 2017 (Run Date: 1/8/2018) (Last Week's Date: 12/31/2017, Current Date: 01/07/2018) Balance Range 0.01 - 600 600.01 - 1200 1200.01 - 1800 1800.01 - 2400 2400.01 - 2600 2600+ Total Current Student Count FAFSA Filed Last Week Student Count Count Variance Last Week Balance Current Balance balance Variance 490 384 301 213 37 483 361 246 179 138 25

291 499 399 304 221 38 493 -9 -15 -3 -8 -1 -10 $126,221.18 $351,791.80 $450,808.74 $464,011.05 $93,203.02 $1,335,553.11 $125,578.85 $337,745.81 $445,063.75 $447,498.73 $90,710.94 $1,308,957.11 -$642.33 -$14,045.99 -$5,744.99 -$16,512.32 -$2,492.08 -$26,596.00 1908 1240 1954 -46 $2,821,588.90 $2,755,555.19 -$66,033.71 NOTE: Special programs have been included in the report. Students in these programs (ASAP, CD, Veterans, Excelsior Scholarship and CUNY Edge) are expected to get financial aid or other aid to pay their tuition and/or fees. The Balance is net of all student payment, waivers, other payment and anticipated Aid. Variance is the difference between current week and last week's data. BCC Annual Inventory Completed in Accordance with CUNY guidelines Tracking Improvements Required Additional work for depots requested FY2018 UWI Program Technology Items

Technology Fee Auto Student CISInsuranc Services UWI College Technology Library e Software Total Bronx $750,512 $67,702 $102,946 $6,900 $928,060 LIBRARY STEM Resources (112) Elsevier IEEE Nature Springer Wiley Total STEM Library Resources (FY2017 expenses) 108 Ethnic Newswatch LGBT (Ebsco) Emarketer NYTimes Digital Artstor Shared Shelf* JAMA ExLibris Primo Econlit Philosphers NEJM Foreign Policy Gale Serials Total Library 108 Total Library Resources 23,630 3,134 4,282 6,041 13,537 50,624 1,868 2,902 1,000 2,664 2,490 4,176 1,978 17,078 67,702 Blackboard Dell Microsoft HPC (High Powered Computing Center)* IBM - SPSS iParadigms (Turnitin) Maplesoft MathWorks ProQuest/Refworks SHI ADOBE SHI - Learning Object Texthelp - Browsealoud Access Data - FTK Standalone CollegeNet Gartner IBM - Filenet

Oracle Oracle Extended Mainttenance Proquest - Bowker Annese ISP Upgrade Level 3 Lightower 1 Nysernet Paetec - 111 8th Ave. Paetec - 32 A of AIT Training Strategic Technology Initiative Tax Levy Provision AMR Network Anue DDOS Dell - BeyondTrust Retina DynTek - McAfee EC America Inc. Proofpoint Enterprise Training Solutions Nexus Consortium PCM-G Spiron -Identity Finder SHI - Impact Core Security Vandis VMWARE Washington - FireEye Washington Computer FireEye TOTAL CIS TECHNOLOGY ITEMS 63,840 71,924 7,872 23,055 12,375 2,480 8,907 6,624 39,925 4,222 788 93 8,301 4,690 13,045 50,889 6,221 2,751 65,928 5,728 9,588 6,968 37,678 9,044 6,473 7,900 119,112 1,941 39,501 2,253 30589.51 40,582 4,564 4,291 559 420 2,650 6,650 382 19,709 750,512

STI Program In FY2018 community college technology fee funds totaling $1.5 million will be transferred to a University CIS Income Fund Reimbursable (IFR) account to cover the costs of the STI program purchases on behalf of the colleges. The colleges FMS Tech Fee deposits will be net the amounts shown below. Colleges that were awarded an STI Accessibility Project grant will have their STI contribution amount adjusted so that these funds can be allocated to the award recipient. Campus Services New Mission Being Established to improve support and services for the Campus Community and improve oversight of our Auxiliary operations. Training Scheduled for January Pending e-commerce Off Campus Outreach Facility Use Rates Facility Use Rates posted on the website New Office will be set up by February Streamlining Catering Orders and Support particularly with on-site catering FY18 Pouring Rights Allocation Queensborough Community Borough of Manhattan Community Campus Bronx Community College Q1 Case Volume Q2 Case Volume Q3 Case Volume Q4 Case Volume Total Percent of Total 2,362 2,053 1,989 1,877 8,281 3.05% FY 2018 Pouring Rights Allocation $50,668.76 Previous Year's Pouring Rights Allocation $ Variance % Variance $48,583.00 LaGuardia Community College Kingsborough Community College Hostos Community College Guttman Community College Bronx Community College

School of Professional Studies Law School Journalism School $2,085.76 4.29% Graduate School York College College of Staten Island Queens College New York City College of Medgar Evers College Lehman College John Jay College of Criminal Justice Hunter College City College Brooklyn College Baruch College 0 5000 10000 15000 20000 25000 30000 Faculty Workload Reduction 29 Employees in CM and ECP Pending COLA BCC Worksheet for EC and CM Increases Current for ECP and CM Minimum Maximum Proposed Payroll $4,300,370 $4,468,992 $4,697,391 Averages Variance $168,622 $397,021 $4,484,833 $184,463 Average > $100K Average < $100K $143,598 $86,805 $149,323 $89,063 $157,110 $94,284 $149,862 $89,063 President Has Opted for the Minimum except where required to preserve parity. Total impact will be $184,463

Public Safety Salary Description FY 2014 Allowance for Uniforms Full-time Classified Full-time Professional Holiday Pay Longevity Differential Overtime Actual FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Budget $29,573.00 $37,434.50 $37,455.50 $42,490.00 $2,142,708.24 $2,349,376.50 $2,660,509.08 $3,107,686.40 $153,481.56 $113,225.14 $80,943.97 $18,176.63 $21,206.70 $24,362.18 $6,930.82 $10,486.08 FY 2018 vs FY 2014 $45,000.00 (a) FY 2018 vs FY 2017 $15,427.00 52% $2,510.00

6% $3,292,876.00 $1,150,167.76 54% $185,189.60 6% $76,417.19 $77,121.00 ($76,360.56) -50% $703.81 1% $27,682.76 $20,000.00 $1,823.37 10% ($7,682.76) -28% $11,272.21 $9,124.43 $30,000.00 $23,069.18 333% $20,875.57 229% $514,925.85 $479,946.65 $490,831.82 $473,129.86 $206,000.00 ($308,925.85) -60% ($267,129.86) -56% Shift Differential

$55,365.18 $65,750.01 $68,918.19 $84,944.37 $70,000.00 $14,634.82 26% ($14,944.37) -18% Temporary Salaries $64,107.22 $208,276.94 $106,072.54 $111,317.94 $99,823.00 (a) $35,715.78 56% ($11,494.94) -10% $3,285,702.52 $3,480,365.49 $3,932,792.95 $1,379.23 Terminal Leave $0.00 Sub-total $2,985,268.50 Backpay $4,509.82 Bonus Payments Grand Total $2,989,778.32 $3,285,702.52 $3,481,744.72 0%

$0.00 0% 29% ($91,972.95) -2% $496,168.46 ($4,509.82) -100% ($496,168.46) -100% $73,122.27 $0.00 0% ($73,122.27) -100% $851,041.68 28% ($661,263.68) -15% $4,502,083.68 $3,840,820.00 Full-time Headcount FY 2014 - FY 2018 Budget Personnel Costs FY 2014 - FY 2018 Budget 85.0 90.0 $3,000,000 75.0 80.0 $1,500,000 $0 $0.00 $855,551.50 $3,840,820.00 70.0 y al al ti

Pa on n i e ay ss n er id fe l U ff o i o r e D H Pr fo y im e t e t c vi im llan l-t ge l Fu w n Fu llo Lo A FY 2014 Actual FY 2015 Actual FY 2017 Actual FY 2018 Budget s rm o if d fie i ss la C O ve r e

m ti Sh ift D iff e i nt e r al y ar r po m e T ri la a S es 63.0 67.0 70.0 60.0 50.0 40.0 30.0 20.0 10.0 FY 2016 Actual - 1 2 3 4 5 Alumni Gym Bridge Certificate to Proceed Issued for an amount not to exceed $309 thousand Areas of Impact of New Tax Bill

Unrelated Business Income UBI: changes in calculation method. New taxes on fringe benefits: value of providing employees with transportation fringe benefits, and on- premises gyms, and other athletic facilities. Funds used to pay for such benefits will be treated as UBI. Charitable deductions: The standard deduction would be increased to $24,000 for joint filers and $12,000 for individuals. The Joint Committee on Taxation has estimated that the Act will spur a dramatic drop in the amount of charitable giving in the U.S. with 32 million fewer people eligible to claim the deduction. This dramatic change, combined with the doubling of the estate tax exclusion from $5.49 million to $10.98 million could significantly affect donor behavior. The estate tax expansion expires after 2025. Athletic seating: The Act prohibits charitable treatment for payment to an institution of higher education in exchange for the right to purchase tickets or seating at an athletic event. International Students. Because the individual tax code will no longer allow personal exemptions, some international students may face new income tax liabilities. State and local tax (SALT) deduction. The Act limits itemized deduction for all state and local taxes (i.e., property taxes and income tax or sales tax in lieu of income tax) to $10,000. It is anticipated that increased pressure from this provision on state governments will result in even further funding cuts for public institutions. Funding cuts at the state level often lead to increased pressure on tuition revenue that only raise college costs and limit access. Issues Enrollment Projections Decline Budget Allocation Reduction Reporting and Transparency of Data Outstanding Balance Collection Efforts Payroll Interface Data Reconciliation Heating Systems, Fuel and Facility Issues Vehicle Reduction and Fuel Management MetroCard Distribution current and future processes Position Management and Vacancy Control Leveraging CUNYFirst Virtual Bookstore and Campus Service Center Glossary of Terms MAJOR PURPOSE Instruction and Departmental Research (I&DR): I&DR includes all faculty teaching and research activity and all nonteaching, fulltime academic staff from deans of divisions to departmental secretaries. Academic Support Services: Includes all expenditures associated with the library, organized activities, organized research, and extension and public services. Organized activitiesinclude audio visual services, museums, galleries, and various media operations. Student Services: Includes counseling, financial aid administration, registrar, athletics, international student services, admissions, and student health services, services to students with disabilities, and child care. Maintenance and Operations (M&O): Includes administrative, maintenance, and custodial activities associated with colleges physical plants. General Administration (GA): Includes presidential offices, legal services, fiscal operations, campus development, and grants offices. General Institutional Services (GIS): Includes information technology, security, mail and printing, institutional research, public relations, computer and telephone services. SEEK & College Discovery: Includes all expenditures from these college specific programs. MAJOR OBJECTS Personal Service Regular: Includes all fulltime employees at the college, from faculty, to security, to secretaries, to administrators. Personal Service Adjunct: Includes all teaching adjunct faculty. Personal Service Temp: Includes all temporary employees (including college assistants). Other than Personal Service (O.T.P.S.): Includes nonpersonnel related expenditures including supplies,

Recently Viewed Presentations

  • Title of Presentation Here

    Title of Presentation Here

    Repayers give because of what they have received in life, which could involve gratitude for medical or educational benefits that they have received. They insist on cost-effectiveness and want nonprofit organizations to focus on client needs. Dynasts see philanthropy as...
  • Chapter 1: Introduction to Statistics

    Chapter 1: Introduction to Statistics

    Chapter 1: Introduction to Statistics Variables A variable is a characteristic or condition that can change or take on different values. Most research begins with a general question about the relationship between two variables for a specific group of individuals.
  • Budget and Fiscal Management - NACM Core

    Budget and Fiscal Management - NACM Core

    Identify individual learning needs and objectives related to budget and fiscal management. List the basic differences between generally accepted accounting practices and governmental accounting practices as they pertain to adequate controls and audit compliance. Develop a plan to safeguard the...
  • The Value of Certification for in Supply Chain

    The Value of Certification for in Supply Chain

    Member discount. Yes. Yes. Yes. Yes. Program Overview. Provides candidates with the ability to understand and evaluate production and inventory activities within a company's global operations. Helps candidatesdemonstrate their knowledge andorganizational skills fordeveloping more streamlined operations across the extended supply...
  • Ch 3: Organizational structure and change

    Ch 3: Organizational structure and change

    Handy's structural view of culture. 1/Power culture. In which a single person or group tends to dominate. Decision making is centralized. Family businesses, 2 / Role culture. Work by logic and rationality. Activity is controlled more by rules and regulations...
  • Fruits and Vegetables - Weebly

    Fruits and Vegetables - Weebly

    PowerPoint Presentation PowerPoint Presentation PowerPoint Presentation PowerPoint Presentation 6.How many serving do you need? 6. Give examples for a serving of each food. 7. What does the color of the food indicate to the consumer? PowerPoint Presentation PowerPoint Presentation Veggie...
  • PROJECT TITLE - California State University, Northridge

    PROJECT TITLE - California State University, Northridge

    Shahnam Mirzaei, Ph.D. ECE Department. CECS. May 18, 2018. Introduction & Guiding Questions. The MPT (Math Placement Test) is used to determine eligibility for enrollment in Math 102, 103, 105, 150A, and 255A.
  • Using science fiction to teach science, fiction, and ...

    Using science fiction to teach science, fiction, and ...

    Arial Default Design Using science fiction to teach science, fiction, and communications skills Daniel W. Koon, Jonathan Gottschall St. Lawrence University, Canton, NY 13617, USA [email protected] Contents Acknowledgements The First Year in North American Colleges and Universities St. Lawrence University's...