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
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
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
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,
New Design Option Passively remove heat from modules, without using forced convection Transfer the heat from the modules to collection points, where the energy is removed by convection Circulated fluid could be either single or two phase, but presently assumed...
Typically 95% of all lead time is non-value-added. Principles for Implementing Lean Manufacturing. Complexity. The waste of doing things the hard way! Excessive paperwork. Excessive approvals. Redundancy. Poor communications. Causes of complexity:
Cost-Volume-Profit (CVP) Analysis. CVP analysis is an analysis of the relationships among activity level, revenue, costs and profit. Classification of cost items into fixed and variable is paramount in CVP analysis.
Sport Popular sports in England: football ( = soccer ) rugby cricket golf tennis horse racing betting money on the winning horse Cricket Cricket a similar game was played in England 700 years ago competitions are held in summer matches...
Culture--Basics. Evolved from Anthropology to mean allhuman phenomena that are not genetically determined.It is the way humans represent their lives in symbols, values and behaviors—language, dress, food, religion, commerce--the totality of our "way of life.". How tradition, values and social...
Dr. Khan. Houston has faults! Two things going on: 1.) Sedimentation in the gulf causes loading on crust and the gulf coast subsides. Most of the faults here are down thrown towards the gulf. 2.) Salt domes - plastic material,...
Ontario College Fair October 24th and 25th. Student Life Expo . at the Enercare Centre Oct 28th and 29th (We have Tickets) US-COLLEGE EXPO . Oct. 24th-YorkMills Collegiate Institute. Oct. 25th-Oakville Trafalgar High School . Postsecondary Fair . at FMSS...
Ready to download the document? Go ahead and hit continue!