The URL can be used to link to this page

Home My WebLink About2018-05-23 - Agenda Packet - Community & Arts Foundation RANCF-O CUCAMONGA `'' COMMUNITY &ARTS FOUNDATION AGENDA COMMUNITY & ARTS FOUNDATION WEDNESDAY, MAY 23, 2018 EXECUTIVEIFINANCE COMMITTEE MEETING LOCATION: Serrano Conference Room City of Rancho Cucamonga 10500 Civic Center Drive Rancho Cucamonga, CA 91703 MEMBERS: CHAIR Paula Pachon VICE CHAIR Tina Chen, Esq. TREASURER/SECRETARY Mark Rivera Mission Statement ♦ Enriching lives through support of the arts at the Victoria Gardens Cultural Center and supporting efforts that benefit the community. ® If you need special assistance or accommodations to participate in this meeting,please contact the Community Services at(909)477-2760. Notification of 48 hours prior to the meeting will enable the City to make reasonable arrangements to ensure accessibility. Listening devices are available for the hearing impaired. RANCHO CUCAMONGA COMMUNITY &4RTSFOUNDATION MAY 23, 2018 COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE A. 4:30 P.M. -CALL TO ORDER Al. Roll Call: Paula Pachon Tina Chen Mark Rivera B. COMMUNICATIONS FROM THE PUBLIC This is the time and place for the general public to address the Committee. State law prohibits the Committee from addressing any issue not previously included on the Agenda. The Committee may receive testimony and set the matter for a subsequent meeting. Comments are to be limited to five minutes per individual. C. CONSENT CALENDAR The following Consent Calendar items are expected to be routine and non-controversial. They will be acted upon by the Community and Arts Foundation Executive/Finance Committee at one time without discussion. Any item may be removed by a Member or member of the audience for discussion. Cl. Request for approval of the minutes of the Community &Arts Foundation Executive/Finance 1 Committee meeting held on March 28, 2018. C2. Receive and file Treasurer Report. 4 D. ITEMS FOR DISCUSSION The following items are not public hearing items, although the Chair may open the meeting for public input: D1. Update on Scope of Work for Attorney. D2. Discussion on Payroll Company Bids and Review of Employment Contract for Executive Director. D3. Update on Fundraising Committees. • Golf Tournament • Quince de Bunco • Monte Carlo Night • High School Program/Scholarship • Fritz Coleman — Benefit Performance—March 23, 2019 • Quakes Night D4. Update on Transfer of Animal Center and Affiliate Funds. 37 Page 1 of 2 RANCHO CUCAMONGA COMMUNITY QA RTS FOUNDATION MAY 235 2018 COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE D5. Review of Investment Funds and Development of FY 18/19 Budget. 37 D6. Discussion regarding Upcoming Board Elections. E. IDENTIFICATION OF ITEMS FOR THE NEXT MEETING This is the time for the Executive Committee to identify the items they wish to discuss at the next meeting. These items will not be discussed at this meeting, only identified for the next meeting. F. ADJOURNMENT I, Valerie Smith, Administrative Secretary of the City of Rancho Cucamonga, or my designee, hereby certify that a true, accurate copy of the foregoing agenda was posted on Thursday, May 17, 2018, seventy-two (72) hours prior to the meeting per Government Code 54954.2 at 10500 Civic Center Drive. /s/ Valerie Smith Valerie Smith Administrative Secretary City of Rancho Cucamonga Page 2 of 2 RANCHO CUCAMONGA COMMUNITY &4RTS FOUNDATION MARCH 28, 2018 COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE MEETING MINUTES A. CALL TO ORDER Al. A meeting of the Rancho Cucamonga Community & Arts Foundation Executive/Finance Committee was held on Wednesday, March 28, 2018 at the Rancho Cucamonga Civic Center, located at 10500 Civic Center Dr., Rancho Cucamonga, California. The meeting was called to order at 4:35 p.m. by Chair Pachon. A2. Present were Committee Members: Paula Pachon, Tina Chen, and Jim Harrington. Absent: Mark Rivera. Also present were: Jennifer Hunt Gracia, Community Services Director; Susan Sluka-Kelly, Cultural Arts Manager; Catherine Allen, Account Technician; Christen Mitchell, Management Analyst II, and Valerie Smith, Administrative Secretary. B. COMMUNICATIONS FROM THE PUBLIC 61. None. C. CONSENT CALENDAR Cl. Request for approval of the minutes of the Community & Arts Foundation Executive Finance Committee meeting held on January 31, 2018 and February 6, 2018. C2. Receive and file Treasurer Report. MOTION: Moved by Vice Chair Chen, seconded by Member Harrington to receive and file the Consent Calendar as presented. Motion carried: 3-0-1. Absent: Rivera. D. ITEMS FOR DISCUSSION D1. Update on 2017 Taxes provided by Analyst Mitchell. Analyst Mitchell updated the Committee on the 990 that was sent to LSL. Due to the busy tax season, LSL indicated that they will not be able to provide the taxes for the Committee to review; therefore, the taxes will be presented at the April full board meeting. If the taxes are received after the agenda packets are mailed out then staff will email the taxes so all members have an opportunity to review prior to the meeting. The board has until May 15'h to file the taxes. No further discussion was held. Page 1 of 3 RANCHO CUCAMONGA COMMUNITY &ARTS FOUNDATION MARCH 28, 2018 COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE MEETING MINUTES D2. Verbal Update on Attorney. Vice Chair Chen stated that the next step is to develop the scope of work. She indicated that the items identified during the financial review would likely be part of the scope of work. She and Secretary/Treasurer will discuss. Cultural Arts Manager stated she will list items that the non-profit attorney would evaluate. No further discussion was held. D3. Update on Fundraising Committees. Chair Pachon stated that work for the golf tournament will likely begin soon. She shared that Quince de Bunco was a success and thanked all who participated. Vice Chair Chen provided an update on Monte Carlo Night. The committee discussed the tax-deductible note that participants receive after the event. Vice Chair Chen requested clarification whether a certain amount triggers the need to send a letter of the tax-deductible amount. Cultural Arts Manager also discussed raffle items that are donated and following all State regulations regarding raffles. The committee also received an update on the High School Program/Scholarship. Chair Pachon shared that the information on the website has not been updated. No further discussion was held. D4. Discussion of Executive Director Proposal and Employee Requirements. Vice Chair Chen shared that she will contact Cloud Payroll to request a quote. Employment contract needs to be in place by the June meeting for the board to approve. The items will be brought to the Executive/Finance Committee to review in May, prior to submitting to the full board for review in June. Chair Pachon will create an employment contract based on various samples and Vice Chair Chen will review. No further discussion was held. D5. Update on Transfer of Animal Center Funds and Discussion of Investment Funds. Analyst Mitchell shared that the funds for the Animal Center have not been transferred. The Foundation has not taken in or expended any funds from the Animal Center since Feb 28, 2018. The balance due to them is $290,107.58. The recommendation to the Committee was to transfer$150,000 from the LAIF account to the checking account to ensure sufficient funds are available for the remaining budgeted expenses and any miscellaneous pending expenses, not yet included. Member Harrington stated that the Animal Center funds were kept separate in checking or LAW and were never invested. The committee had questions regarding the Kohl's Cares donations that are coming for City programs. Each member stated that the Foundation needs more oversight over money coming in and out. Member Harrington shared that the Foundation investments are guaranteed so the fluctuations in the stock market do not affect it. Member Harrington will provide an update on investments in May for the Executive/Finance Committee meeting and during the June meeting. No further discussion was held. Page 2 of 3 RANCHO CUCAN.ONGA COMMUNITY &ARTS FOUNDATION MARCH 28, 2018 COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE MEETING MINUTES MOTION: Moved by Vice Chair Chen, seconded by Member Harrington to approve the transfer of $150,000 from the LAIF account to the checking account. Motion carried: 3-0-1. Absent: Rivera D6. Budget Update. Discussed under item D5. E. IDENTIFICATION OF ITEMS FOR THE NEXT MEETING The following items were identified for the next meeting: Update on scope of work for attorney; Discuss payroll and employment contract; Update on transfer of Animal Center and affiliate funds; Development of budget; Update on fundraising committees. F. ADJOURNMENT The Community & Arts Foundation Executive/Finance Committee meeting was adjourned at 5:49 p.m. Respectfully submitted, /s/Valerie Smith Valerie Smith Administrative Secretary City of Rancho Cucamonga Page 3 of 3 i,tRANCHO CUCAMONGA COMMUNITY A RTS FOUNDATION 00 STAFF REPORT DATE: May 23, 2018 TO: Rancho Cucamonga Community &Arts Foundation FROM: Jennifer Hunt Gracia, Community Services Director INITIATED BY: Catherine Allen, Account Technician Christen Mitchell, Management Analyst II SUBJECT: Treasurer Report RECOMMENDATION: Staff recommends the Foundation receive and file this informational report. BACKGROUND: Updated treasurer reports are provided to Full and Executive Board members at bimonthly meetings. ANALYSIS: Highlights from the attached reports. P&L Detail —Operating Budget: • 04/13/2018— LAIF interest income forthe quarterwas earned and deposited into the LAIF account in the amount of$1,623.53. • 04/16/2018—There was an adjustment for the Foundation's state tax filing, for year ending June 2014 (FY 2013-2104). A reimbursement check was received in the amount of $10,07. According to the Tax Board, there was an "overpayment due to duplicate or additional payments." • 04/02/2018 — The $27.99 charge is the PAL checking account service fee. This fee is typically credited by the City. However, bank staff is currently behind in making the credit adjustments. Staff reflected this charge in the Financial Compliance line item of the Operating Budget in April, but should be able to adjust for the credit in May. P&L Detail — Grants: • Grant funds received in April 2018 = $0.00 • Grant funds disbursed in April 2018 = $2,289.00 P&L Fundraising Events: • Monte Carlo Night: Accounts receivable (outstanding donor invoices) as of April 30, 2018 is $3,200.00. Page 1 of 2 AIR Aging Detail • 03/21/2018 — Per Gary Ablard, the Buquets will reimburse the Foundation for $535.00, which is for their bronze casting Shakespeare plaque. Their$19.00 brick and the$154.59 cost of reordering the star for the Donor Wall will be paid for by the City of Rancho Cucamonga's Victoria Gardens Cultural Center's account. Animal Care Foundation: • 04/30/2018—A donation of$50.00 from PetSmart Charities was electronically deposited into the PAL account. Historically, deposits like this have been received by the Foundation on behalf of the Animal Center. Staff has notified the Rancho Cucamonga Animal Care Foundation about these donations and has requested that they advise PetSmart Charities accordingly. Per Foundation approval at the March 28th Board Meeting, staff has issued a reimbursement check for$50.00 to the Animal Care Foundation. The remaining balance in the Animal Care Foundation account is now zero. PAL Checking Account: • 4/25/2018 — General donation received from Doug Morris (Morgan Stanley) through Benevity in the amount of$1,000.00. • Uncleared Transactions — 12.07.2017 — City staff is in contact with the staff person at Euclid Elementary regarding the uncashed check#11431 for$152.00. The staff person is inquiring with the District Office regarding the status of the check. FISCAL IMPACT: • Total FY 2017/2018 Operating Budget Income for April 2018 = $7,812.53 • Total FY 2017/2018 Operating Budget Expenses for April 2018 = $4,217.52 EXHIBITS: Exhibit 1 - Foundation financial reports and operating budgets for April 2018 Page 2 of 2 Foundation Financial Reports ' FY 2017/2018 'I Foundation Operating Budget Budget Summary and Profit & Loss Detail April 1 - 30, 2018 Rancho Cucamonga Community & Arts Foundation Operating Budget- 17/18 Budget 17/18 17/19 17/18 YTD Description Approved Actuals Jan 1-31 Feb 1-28 Mar 1-31 Apr 1-30 May 1-31 June 1-30 Actuals Fundraising/Investments $ 38,900 $ 31,345 $ 5,223 $ 322 $ 200 $ 2,074 $ - $ - $ 31,345 PAL Compalgn/Spotilght Donors $ _ 3,400 $ - $ Major Gift Campaign 1 $ $ RC Quakes Strike Outs $ 5,000 $ 6,570 $ 6,570 VG Bricks/Plaques. $ Soo $ 1,050 $ 300 $ 450 $ 1,050 Investment Income $ 28,000 $ 17,804 $ 3,375 $ 17,804 Misc/Interest $ 2,000 $ 5,920 $ 1,848 $ 21 $ 200 $ 1,524 $ 5,920 Activities&Events GoIJToQuakes N(October 2017) $ 65,000 $ 5g,ggg $ - $ _ - $ - $110,800 $ 83,142 $ _-_ $ 3,025 $ 3,740 5,739 uokesNight(Sept20J7) $ 1,500 $ 1,700 $ 68,898 Monte Carlo Night(April 2018) $ 32,000 1 $ 10,139 $ 3,025 $ 1,375 $ 5,739 $ 10,139 Cinco de Bunco(May 2018) $ 2,300 $ 2,405 $ 2,365 T $ 2,405 Tour de Fork(June 2018) $ 10,000 $ _ $ - Total Revenue $149,700 r$114,487 $ 5,M ( $3,347T$ 3,940 $ 7,813 $ - $ $114,487 Rancho Cucamonga Community & Arts Foundation Operating Budget- 17/18 Budget Expenditures Description 17/18 17/18 Jan 1-31 Feb 1-28 Mar 1-31 Apr 1-30 May 1-31 June 1-30 17/18 YTD Approved Actuals Actuals Administration $ 34,100 $ 12,035 $ 8,224 $ 228 $ 174 $ 18 $ $ $ 12,035 personnel $ 20,0001 $ 6,908 $ 6,174 - - $- 6,908 Office Supplies $ 1,000 _$ 317 317 2,251 Financial Compliance $ 10,000 $ 2,251 $ 1 5 28 $ 174 $ 18 $ Insurance $ _2,100 $ 2,049 5 2,049 2,049 Travel&Meetings $ 1,000 $ 510 $ 201 $ 510 Marketing&Community Outreach $ 1,700 $ - $ - $ - $ - $ $ - $ $ - 201612017 Foundation Report $ 1,200 $ - _ _ _ _ _ $ Foundation Brochure $- $ $ Websitellosting/Maintenance $ $ $ Miscellaneous Marketing Exp $ 500 $ $ Donor Development&Retention $ 2,200 ' $ 2,145 $ 1,991$ - $ $ - $ 2,145 Donor Recognition �$ 600 $ 420 $ 1,420 $ 1,420 Donor Plaques/Bricks $ 155 _ __ Fundraising Activities&Events -_ $ 39,200 $ 27,864 $ 334 $ - $ - S 4,109 _$ _ $ - S 27,864 Golf Tournament(2017) $ 25,000 $ 23,755 $ 334 $ 23,755 Monte Carlo Night(2018)_$ 14,200 $ 4,109 $ 4,109 _ --- � $ 4,109 Other $ $ - $ Foundation Sponsored City Programs $ 67,500 $ 15,650 $ 500 _ $ 7,169_$ 575 $ $ _ $ - $ 15,650 Lewis Family Playhouse $ 10000 $ _ _ - $ - RCCommunityTheatre/BATG $ 15,000 $ 575 $ 575 $ 575 World Music Series(3 Shows) $ 9,000 $ - $ - TicketsJorUnderservedStudents/Families $ 6,000 $ 1,741 $ 500 $ 503 $ 1,741 Foundation Family Wknds/Flex Pack MSTC $ 10,000 $ 33,334 $ 6,666 $ 13,334J MainStreet Theatre Company_$ 7,500 $ tY g HSPerforming Arts Program Support $ 3,000 _$ 3,000 $ 3,000 $ - $ $ $ 3,000 Community Pro rams $ 12,000 $ 7,000 $ $ $ 3,000 _ $ 3,000 Student Scholarship Program $ 5,000 $ - - SeptemberArt Association Art Show $ 4,000 $ 4,000 _ - $ 4,000 $Total Expenditures $157,700 $ 64,694 $11,049 $ 7,397 3,749 $ 4,127-I $ L$ - 5_64,694 Budgeted Net Total $ (8,000) $ 49,793 Rancho Cucamonga Community &Arts Foundation Operating Budget- 17/18 Budget Description 17/18 17/18 Approved Actuals July 1-31 Aug 1-31 Sept 1-30 Oct 1-31 Nov 1-30 Dec 1-31 Fundraising/Inyestments $ 38,900 $ 31,345 $ 4,383 $ 15 $ 5 $ 8,058 $ 6,690 $ 4,375 PAL Campaign/Spotlight Donors $ 3,400 $ - - _ Major Gift Campaign $ - i $ - RC Quakes Strike Outs $ 5,000 $ 6,570 S 6,570 _ VG Bricks/Plaques $ 500 $ 1,050 $ 300 Investment Income $ 28, $ 17,000 804 75$ 3,375 -$ 6,679 $ 4,3 Misc/Interest $ 2,000 $ 5,920 '' $ 1,008 $ 15 S 5 $ 1,188 $ 11 Activities&Events $110,800 $ 83,142 $ 3,950 $ 36,400 $ 12,140 48 FYi6/17 Revenue Quakes Night(Sept 2017) $ 1,500 $ 1,700 5 450 �500__.S. 6D0 $ 150 Golf Tournament(October 2017) $ 65,000 $ 68,898 $ 3,500 $ 35,900 $ 11,500 Fy16/17 Revenue (- Monte Carlo Might(May 2018) $ 32,000 $ 10,139 1 _ Once,de Bunco(May 2018) $ 2,300 $ 2,405 $ 40 -T Tour de For (June 2018) $ 30,000 $ Total Revenue 1 $149,700 $114,487 1 $ 8,333 S 36,415 $ 12,145 $ 26,206 $ 6,690 $ 4,375 Rancho Cucamonga Community & Arts Foundation Operating Budget - 17/18 Budget Expenditures Description 17/18 17/18 July 1-31 Aug 1-31 Sept 1-30 Oct - - -31 Approved Actuals FIWII Reimbursement Administration _ $ 341 _12,035 $ - $ 2,776 558 $ 10 $ 47 $ Personnel $ 20000 $ 6,908 $ 734 Business Cards/Office Supplies $ 1,000 $ 317_ $ 32 $ 285 Financial Compliance $ 10,000 $ 2,251 $ 2,010 $ 20 Insurance $ 2,100 $ 2,049 Travel&Meetings $ 1,000 $ 510 $ 253 $ 10 $ 47 Marketing&Community Outreach _$ 1,700 $ - $ - $ _ _$__ - $ _ - $ - $ 201612017 Foundation Report $ 1,200 FoundoUon Brochure $ - . $ _ Website Hosting/Mointenance $ - Miscellaneous Marketing Exp $ 500 $ Board Development&Training $ 1,000 $ $ Donor Development&Retention $ 2,200 $ 2,145 $ - $ - $ - $ 155 $ - . $ - DonorRecognitionEvent $ 1,400 $ 1,570 Donor Awards $ 500 $ 420 Donor Ploques/Bricks $ 200 $ 155 $ 155 Fundraising Activities&Events $ 39,200 $ 27,864 $ $ 361 $ 861$ 5,901 $ 17,073 $ Golf Tournament(2017)1 $ 25,000 $ 23,755 $ 361 $ 86 $ 5,901 $__3.7,07_3 Monte Carlo Night(2018) $ 14,200 . _ Other' $ - $ Foundation Sponsored City Programs $ 67,500 $ 15,650 $ - $ - $ - $ - I $ 6,668 $ 738 Lewis Family Playhouse $ 10,000 $ I ! RC Community Theatre/BATG $ 15,000 j $ 575 World Music Series(3 Shows)j$ 9,000 $ - _ Transportationfor Underserved5tudents $ 6,000 $ 1,741 _ $ 738 Foundation Family Wknds/Flex Pack MSTC $ 20,000 $ 13,334 $ 6,668 MainStreet Theatre Company $ 7,500 $ - Community Programs $ 12,000 $ 7,000 $ - $ - $ - ,$ - $ _ - $ 4,000 H S Performing Arts Program Support $ 3,000 $ 3,000 Student Scholarship Program $ 5,000 $ - September Art Associotion Art Show $ 4,000 $ 4,000 Total Expenditures $157,700 $ 64,694 $ - $ 3,137 $ 644__$_. 6,065 $ 23,788 $ 4,738_ Budgeted Net Total $ (8,000) $ 49,793 Accrual Basis Rancho Cucamonga Community &Arts Foundation Profit & Loss Detail - Operating Budget Fiscal Year 2017 - 2018 April 1 -30,2018 Type Date Name Memo Amount Ordinary Income/Expense Income 3150'-Banking Income 3160.2-Interest Income Deposit 04/13/2018 Interest 1,623.53 Total 3150.2-Interest Income 1,623.53 Total 3150-Banking Income 1.623.53 3010•Donations 3010.11 -Brick Donation Sales eipt 04/09/2018 Morris,Doug&Dee Brick Purchase:"Doug&Dee Morris-2017" 150.00 Re Seceeipt 04/09/2018 Morris,Doug&Dee Brick Purchase:"Doug&Dee Morris-2018" 150.00 Sales 04/18/2018 Hicks,George and Iris Engraved Brick Purchase-Donor Walkway(Hicks 150.00 Receipt Family-George&Iris,Sean,Ashley&Ian) Total 3010.11 -Brick Donation 450.00 Total 3010-Donations 450.00 3020 Event Income-Fundraising 3020.11 -Event Sponsorship Invoice 04/11/2018 The Skye Group Inc 2018 Monte Carlo Casino Night-Entertainment 400.00 Sponsorship (Medical Center)IInvoice 04/18/2018 Goldman, en ter)Scott 2018 Monte Carlo Casino Night-Table Sponsorship 400.00 Invoice 04/25/2018 Chen,Abraham 2018 Monte Carlo Casino Night-Casino Table 650.00 Sponsorship Invoice 04/25/2018 Chen,Tina, 2018 Monte Carlo Casino Night-Bar Sponsorship 1,200.00 Secretaryfrreasurer Invoice 04/25/2018 Barag,Taro,Board 2018 Monte Carlo Casino Night-Entertainment 300.00 Member Sponsorship Total 3020.11 •Event Sponsorship 2,950.00 3020.13-Event Donation Sales 04/23/2018 Michael,L.Dennis 2018 Monte Carlo Casino Night-Donation 100.00 Receipt Sales 04/23/2018 Spagnolo,Salvatore& 2018 Monte Carlo Casino Night-Donation 85.00 Receipt Viola Total 3020.13-Event Donation 185.00 3020.16•Event Silent Auction Sales 2018 Monte Carlo Casino Night-Silent Auction- Receipt 04/28/2018 Gomez,Paul Mercedes Benz of Ontario Golf Bag 170.00 Sales 2018 Monte Carlo Casino Night-Silent Auction- 40.00 Receipt 04/28/2018 Lee,Dianna Personal Training with Tania's Fitness Sales 2018 Monte Carlo Casino Night-Silent Auction- Receipt 04/28/2018 Morris,Doug&Dee Elway Wine Basket 85.00 Sales 2018 Monte Carlo Casino Night-Silent Auction- Receipt 04/28/2018 Morris,Doug&Dee Chefs Tasting Dinner at Brio Tuscan Grille 625.00 Sales 2018 Monte Carlo Casino Night-Silent Auction-Dine Receipt 04/28/2018 Morris,Doug&Dee Victoria Gardens 90.00 Accrual Basis Rancho Cucamonga Community &Arts Foundation Profit & Loss Detail - Operating Budget Fiscal Year 2017 - 2018 April 1 -309 2018 Type Date Name Memo Amount Sa! 04/28/2018 Chen,Tina, 2018 Monte Carlo Casino Night-Silent Auction 40.00 - Receipt Secretary/Treasurer Blaze Pizza Dinner for 4 Sales 04/28/2018 Chen,Tina, 2018 Monte Carlo Casino Night-Silent Auction-Dine 95.00 Receipt Secretary/Treasurer Inland Empire Sales 04/28/2018 Chen,Tina, 2018 Monte Carlo Casino Night-Silent Auction- 50.00 Receipt Secretary/Treasurer Botox with Dr.Aswan Sales 04/28/2018 Chen,Tina, 2018 Monte Carlo Casino Night-Silent Auction- 280.00 Receipt Secretaryfrreasurer Quake's Suite for July 3rd Game Sales 04/28/2018 Chen,Tina, 2018 Monte Carlo Casino Night-Silent Auction- 80.00 Receipt Secretary/Treasurer Meet&Greet with Deja and Dare K9s Sales 04/28/2018 Chen,Tina, 2018 Monte Carlo Casino Night-Silent Auction-Spa 90.00 Receipt Secretary/Treasurer Package from the Refresh Bar Sales 04/28/2018 Chen,Tina, 2018 Monte Carlo Casino Night-Silent Auction-My 40.00 Receipt Secretary/Treasurer Addiction Gift Certificate Sales 04/28/2018 Sluka-Kelly,Susan 2018 Monte Carlo Casino Night-Silent Auction- 55.00 Receipt Charming Charlie Gift Set Sales 04/28/2018 Kelly,Sean 2018 Monte Carlo Casino Night-Silent Auction- 275.00 Receipt Helicopter Tour&Ride-Along Sales 04/28/2018 Henderson,Dezzarae 2018 Monte Carlo Casino Night-Silent Auction- 50.00 Receipt Laser Hair Removal from Inland Cosmetic Sales 2018 Monte Carlo Casino Night-Silent Auction- Receipt 04/28/2018 Henderson,Dezzarae Nikki B Photography Session 60.00 Sales 2018 Monte Carlo Casino Night-Silent Auction-LFP 30.00 Receipt 04/28/2018 Henderson,Dezzarae "It's Magic"Gift Basket Sales 04/28/2018 Henderson,Dezzarae 2018 Monte Carlo Casino Night-Silent Auction- 100.00 Receipt Harmony Deluxe Wine Case Sales 2018 Monte Carlo Casino Night-Silent Auction- Receipt 04/28/2018 Wu,Faye Chick-Fil-A Dinner for 6 40.00 Sales 04/28/2018 Freeman,Keith&Angela 2018 Monte Carlo Casino Night-Silent Auction-Skin 95.00 Receipt Perfect Medical Gift Basket Sales 04/28/2018 Freeman,Keith&Angela 2018 Monte Carlo Casino Night-Silent Auction-Last 40.00 Receipt Name Brewing Gift Basket Sales 04/28/2018 Freeman,Keith&Angela 2018 Monte Carlo Casino Night-Silent Auction- 70.00 Receipt Ultrasonic Facial from Ahava Medspa Total 3020.16•Event Silent Auction 2,500.00 3020.2-Event Income-Misc Sales 04/28/2018 Monte Carlo Donor 2018 Monte Carlo Casino Night-Drink ticket money 64.00 Receipt Sales Corbett,Fatima,Board Receipt 04/28/2018 Member 2018 Monte Carlo Casino Night-Drink tickets 30.00 Saes 04/28/2018 Gibbs,Joshua 2018 Monte Carlo Casino Night-Drink tickets 10.00 Receipt Total 3020.2-Event Income-Misc 104.00 Total 3020-Event Income-Fundraising 5,739.00 Total Income 7,812.53 Gross Profit 7,812.53 Expense 5020 Event Expense-Fundraising 5020.13•Event Entertainment Check 04/02/2018 Casino Parties& 2018 Monte Carlo Casino Night(Job ID: 180225-18- 1,375.00 Entertainment xx) Check 04/23/2018 Luxe Pix Photo Booth 2018 Monte Carlo Casino Night-Photo booth rental 300.00 Accrual Basis Rancho Cucamonga Community &Arts Foundation Profit & Loss Detail - Operating Budget Fiscal Year 2017 - 2018 April 1 -30,2018 Type Date Name Memo Amount Check 04/26/2018 On The Go DJ Pro 2018 Monte Carlo-DJ Services for Monte Carlo 300.00 Casino Night Total 5020.13-Event Entertainment 1,975.00 6020.12-Event Food/Beverage Credit Card 04/24/2018 Brio Tuscan Grille 2018 Monte Carlo Casino Night-Dinner 1,700.00 Charge Total 5020.12•Event Food/Beverage 1,700.00 6020.22-Event Staffing Impressions Gourmet Invoice#13850-2018 Monte Carlo Casino Night- Check 04/23/2018 Catering Beverage server,ice,cups 433.69 Total 5020.22-Event Staffing 433.69 Total 6020-Event Expense-Fundraising 4,108.69 504011 Board Travel&Meetings 504q.1 •Board Hospitality (Credit Card 04/25/2018 Stonefire Grill Dinner for board meeting-April 25,2018 90.91 Charge Total 5040.1 -Board Hospitality 90.91 Total 5040-Board Travel&Meetings 90.91 5140-Taxes 6140.2-RCCAAF Federal and State Filing Deposit 04/16/2018 Refund adjustment for tax year ending June 2014(FY -10.07 2013-2014) Total 5140.2-RCCAAF Federal and State Filing -10.07 Total 5140•Taxes -10.07 5150 j Bank Charges 5150.1 -Merchant Service Fee Check 04/02/2018 Service Charge 27.99 Total 5150.1 •Merchant Service Fee 27.99 Total 6150-Bank Charges 27.99 Total Expense 4,217.52 Net Ordinary Income 3,595.01 Net Income 3,695.01 Foundation Financial Reports i FY 2017/2018 Grants Operating Budget Budget Summary and Profit & Loss Detail April 1 - 30, 2018 2 of Rancho Cucamonga Community&Arts Foundation Operating Budget GRANTS-17/18 Budget Description Jan 1.31 Feb 1-28 Mar 1-31 Apr 1.30 May 1-31 June 1.30 17/18 YM Actuals Grant Support $ - $ Soo $ - $ - $ - $ - S 65,750 Bank ofAmerloo Grand(Bank) $ 10,000I Bank of Americo Sponsor(Foundation) I $ 10,D00 Kohl's Cares AIA $ 500 _ _ _ $ 1,500 Macy's District Grant � ',$ 5,000 Ralph Lewis Properties $ US Bancorp Foundation $ 25,000 Edison International _ _ $ - MoinStreet Program 5upport $ 14.250 Total Reven e S $ 500 f $ - $ - . $ _=$ Expenditures Description Jan 1.31 Feb 1.28 Mari-31 Apr 1-30 May 1.31 June 1-30 17/18 yi0 Aatuals Grant Supported Giving $ $ 8,538 $ $ 2,289 $_ - $ - $__ 36,300 Bank of America Grant(Bank) _ _ $ _ Bank of America Sponsor(Foundation) $ 304 $ 1,411 $ 5,775 Kohl's Cares AIA $ Soo $� 1,500 _ Mary'District Grant - - S - 2,528 _. ... Ralph Lewis Properties _ —_$ - _ US Bancorp Foundation $ 7,542 $ 2.1,931 Edison International $ 391 $ 878 $ 4,566 MoinStreetProgrom5upport _ $ Total Expenditures 1$ - $ 8,538 $ $ 2,269 1 $ - $ - S 36,300 Rancho Cucamonga Community &Arts Foundation Operating Budget GRANTS- 17/18 Budget Description 17/18 Proposed 17/18 Actuals July 1-31 Aug 1-31 Sept 1-30 Oct I-31 Nov 1-30 Dec 1-31 Grant Support $ 90,000 $ 87,M9 $ - $ - $ 20,000 $ 30,000 $ 500 $ 14,750 Bank o/Amedco Grant(Bank) $ 10,000 $ 11,314. 5 10,000 Bank aJAmedca Sponsor(Foundation) $ 10,000 $ _ 50,000 Kohl's Cares AIA $ 5,000 $ 1,500 5 500 5 Soo Macy's District Grant $ 5,000 $ 5,DD0 $ 5,0001 Ralph Lewis Properties,$ 30,000 $ 10,000 _ US Bancorp Foundation $ 25,000 $ 30,785 $ 25,000 (Carryover)Edison International $ 5,000 $ 5,000 MolnStreet Proarom Support $ 14,250 $ 14,250 Total Revenue $ 90,000 _$ 87,849 $ 20,000 $ 30,000 $ 500 $ 34,750 Expenditures Description 17/18 July 1-31 Aug 1-31 Sept 130 Oct 1-31 Nov 1-30 Dec 1-31 Proposed 17/18 Balance Grant Supported Giving $ 87,099 $ 50,799 $ - $ 3" $ - $ 5,620 $ AW $ 3652 Bank of America Grant(Bonk) $ 11,314 $ 11,314 Bank of America Sponsor(Foundation) $ 10,000 $ 4,225 $ 4,060 Kohl's Cares AIA $ 5,000 $ _ 3,500 _ $ 500 $ Soo Mary's District Grant $ 5,000 '$ 2,472 �$ Z528 Ralph Lewis Properties $ 10,000 $ 2D,000 _ US Bancorp Foundation$ 30,785 $ 8,854 _ _ $ 1,560 $ 32,829 (Carryover)Edison International $ 5,000 $ 434 _$_ 344 _ $ 3,152 MainStreet Program Support $ Total Expenditures I$ 87,099 $ ____50,799 $ __ $___ 344 $ _ _$ 5,620 $ 15,857 Accrual Basis Rancho Cucamonga Community & Arts Foundation Profit & Loss Detail - Operating Budget / Grants Fiscal Year 2017 - 2018 April 1 -30,2018 Type Date Num Name Memo Amount Ordinary Income/Expense Expense 6800;Grant Disbursements 5827-Edison International Grant Check 04/04/2018 11466 City of Rancho Edison-Sponsored Tickets-"Stunt Dog 558.00 Cucamonga-V Experience"(Invoice#S0331-1718) City of Rancho Invoice#SO414-1718-LFP Sponsored Tickets- Check 04/23/2018 11469 Cucamonga-V "Choo Choo Soul" 320.00 Total 5827-Edison International Grant 878.00 5812-BofA Sponsorship(Foundation) 5812.1 -BofA Spons.-CC(Foundation) Check 04/04/2018 11465 City of Rancho BofA Foundation-Sponsored Tickets-"In the 1050.00 Cucamonga-V Heights"(Invoice#BW01 B-1718) ' Check 04/23/2018 11470 City of Rancho Invoice#SO414-1718-LFP Sponsored Tickets- 361.00 Cucamonga-V "Choo Choo Soul" Total 5812.1 -BofA Spons.-CC(Foundation) 1,411.00 Total 5812-BofA Sponsorship(Foundation) 1,411.00 Total 5800-Grant Disbursements 2,289.00 Total Expense 2,289.00 Net Ordinary Income -2,289.00 Net Income -2,289.00 Foundation Financial Reports FY 2017/2018 Fundraising Events All transactions for events held during fiscal year Accrual Basis Rancho Cucamonga Community & Arts Foundation Profit & Loss by Class Fundraising Events All Transactions through April 30,2018 Quince de Bunco Monte Carlo Night Golf Tourney Quakes Night March 16,2018 April 28,2018 October 23,2017 Sept 2,2017 TOTAL Ordinary Income/Expense Income 3020-Event Income-Fundraising $ 2,365.00 $ 10,139.00 $ 65,398.01 $ 1,700.00 $ 79,602.01 Total Income $ 2,365.00 $ 10,139.00 $ 65,398.01 $ 1,700.00 $ 79,602.01 Gross Profit $ 2,365.00 $ 10,139.00 $ 65,398.01 $ 1,700.00 $ 79,602.01 Expense 5020-Event Expense-Fundraising $ - $ 4,108.69 $ 23,593.87 $ - $ 27,702.56 6150-Bank Charges $ - $ - $ 161.25 $ - $ 161.25 Total Expense $ - $ 4,108.69 $ 23,755.12 $ - $ 27,863.81 Net Ordinary Income $ 2,365.00 $ 6,030.31 $ 41,642.89 $ 1,700.00 $ 51,738.20 Net Income $ 2,365.00 $ 6,030.31 $ 41,642.89 $ 1,700.00 $ 51,738.20 Foundation Financial Reports FY 2017/2018 Foundation Balance Sheet i Standard Report As of April 30, 2018 Accrual Basis Rancho Cucamonga Community & Arts Foundation Balance Sheet Fiscal Year 2017 - 2018 As of April 30,2018 April 30,2018 ASSETS Current Assets Checking/Savings 1010-PAL Checking Account 126,711.87 1030-LAW Account 292,986.86 Total Checking/Savings 419.698.73 Accounts Receivable 11000•Accounts Receivable 3,735.00 Total Accounts Receivable 3,735.00 Other Current Assets 1040-Investment-UnionBanc-WBB-022293 1049•American Express BK FSB CD 250,000.00 1048-Capital One Bank USA NA CD 250,000.00 1043-American Express Centrn 250,000.00 1046-Fed Natl Mtg Assn-3136GOK93 700,868.00 1047-Fed Natl Mtg Assn-3135GOL68 900,000.00 Total 1040-Investment-UnionBanc-WBB-022293 2,350,868.00 12000-Undeposited Funds 2,339.00 Total Other Current Assets 2,353,207.00 Total Current Assets 2,776,640.73 TOTAL ASSETS 2,776,640.73 LIABILITIES&EQUITY Liabilities Current Liabilities Credit Cards 2001 -US Bank Credit Cards 2001.1 -US Bank Credit Card- 9817 1,790.91 Total 2001 -US Bank Credit Cards 1,790.91 Total Credit Cards 1,790.91 Total Current Liabilities 1.790.91 Total Liabilities 1,790.91 Equity 30000-Opening Balance Equity 2,906,774.24 32000-Unrestricted Net Assets 156,095.98 Net Income -288,020.40 Total Equity 2,774,849.82 TOTAL LIABILITIES&EQUITY 2,776,640.73 Foundation Financial Reports FY 2017/2018 A/R Aging Detail I As of April 30, 2018 Rancho Cucamonga Community & Arts Foundation AIR Aging Detail Fiscal Year 2017 - 2018 As of April 30,2018 Type Date Num Name Due Date Class Aging Open Balance Current Total Current 1-30 100 Operating/Program Fund:Fund raising Invoice 04/11/2018 MC2018-SG01 The Skye Group Inc 04/11/2018 Activities:Fundraising 2017/2018:2018 Monte Carlo 19 400.00 Night-April 28th 100 Operating/Program Fund:Fund raising Invoice 04/25/2018 MC2018-AC01 Chen,Abraham 04/25/2018 Activities:Fundraising 2017/2018:2018 Monte Carlo 5 650.00 Night-April 28th Chen,Tina, 100 Operating/Program Fund:Fund raising Invoice 04/25/2018 MC2018-TC01 Secretary/Treasurer 04/25/2018 Activities:Fundraising 2017/2018:2018 Monte Carlo 5 1,200.00 Night-April 28th Barag,Taro,Board 100 Operating/Program Fund:Fund raising Invoice 04/25/2018 MC2018-TB01 Member 04/25/2018 Activities:Fundraising 2017/2018:2018 Monte Carlo 5 300.00 Night-April 28th Total 1 -30 2,550.00 31-60 Invoice 03/21/2018 CS131 -2018 Buquet,Charles J 03/21/2018 100 Operating/Program Fund:Donor Development& 40 535.00 Retention:Donor Recognition Total 31-60 535.00 61 -90 100 Operating/Program Fund:Fundraising Invoice 02/27/2018 MC2018-OW04 Manuel Madrid 02/27/2018 Activities:Fundraising 2017/2018:2018 Monte Carlo 62 650.00 Night-April 28th Total 61 -90 650.00 >90 Total>90 TOTAL 3,735.00 Foundation Financial Reports FY 2017/2018 Foundation Financials Summary Report i As of April 30, 2018 Rancho Cucamonga Community & Arts Foundation Financial Summary as of as of as of as of April 30, 2018 June 30, 2017 June 30, 2016 June 30, 2015 ILAIF Balance $ 292,986.86 $ 437,831.40 $ 1,333,765.45 $ 432,390.90 Investments Total 2,350,868.00 2,350,868.00 1,450,868.00 2,348,425.00 Checking Balance 126,711.87 271,037.44 206,062.67 141,973.30 Affiliate's Balance 0.00 -357,580.15 -305,312.95 -267,034.84 Total $ 2,770,566.73 $ 2,702,156.69 $ 2,685,383.17 1 $ 21655,754.36 Affiliate Financial Reports FY 2017/2018 � Animal Care Foundation Profit & Loss Summary and Detail April 1 - 30, 2018 Accrual Basis Rancho Cucamonga Community & Arts Foundation Profit & Loss Summary - Animal Care Foundation All Transactions through April 30, 2018 April 30,2018 Ordinary Income/Expense Income 3015-Restricted Income-Affiliates 3016.14-Animal Center Donation 290,289.66 Total 3016-Restricted Income-Affiliates 290,289.66 3020•Event Income-Fundraising 3020.12-Event Ticket Sale 3,577.41 3020.13•Event Donation 2,077.22 Total 3020-Event Income-Fundraising 5,654.63 3990-Fund Transfer Income 122,062.27 Total Income 418,006.56 Gross Profit 418,006.56 Expense 6016-Affiliate Disbursements 5015.14-Animal Center Disbursements 417,785.51 6015-Affiliate Disbursements-Other 101.05 Total 5015-Affiliate Disbursements 417,886.56 5150-Bank Charges 6150.3-NSF Charges 120.00 Total 6160-Bank Charges 120.00 Total Expense 418,006.56 Net Ordinary Income 0.00 Net Income 0.00 Accrual Basis Rancho Cucamonga Community &Arts Foundation Profit & Loss Detail - Animal Care Foundation Fiscal Year 2017 - 2018 April 1 -30,2018 Type Date Name Memo Amount Ordinary' Income/Expense Income 3015-Restricted Income-Affiliates 3016.14-Animal Center Donation Check 04/30/2018 Rancho Cucamonga Animal Care Reimbursement to Animal Center for -50.00 Foundation Petsmart donation Total 3015.14-Animal Center Donation -50.00 Total 3015-Restricted Income-Affiliates -50.00 Total Income -50.00 Gross Profit -50.00 Net Ordinary Income -50.00 Net Income -60.00 Foundation Financial Reports FY 2017/2018 PAL Checking Account Reconciliation Summary and Detail I April 1 - 30, 2018 Rancho Cucamonga Community &Arts Foundation Reconciliation Summary - PAL Checking Account Fiscal Year 2017 - 2018 Period Ending April 30,2018 April 30,2018 Beginning Balance $ 136,253.56 Cleared Transactions Checks and Payments-10 items $ (11,366.07) Deposits and Credits-3 items $ 3,050.00 Total Cleared Transactions $ (8,316.07) Cleared Balance $ 127,937.49 Uncleared Transactions Checks and Payments-5 items $ (1,235.69) Deposits and Credits-1 item $ 10.07 Total Uncleared Transactions $ (1,225.62) Register Balance as of 04/30/2018 $ 126,711.87 New Transactions Checks and Payments-5 items $ (1,783.93) Deposits and Credits-4 items $ 2,935.00 Total New Transactions $ 1,151.07 Ending Balance $ 127,862.94 Rancho Cucamonga Community & Arts Foundation Reconciliation Detail - PAL Checking Account Fiscal Year 2017 - 2018 Period Ending April 30,2018 Type Date Num Name Memo Clr Amount Balance Beginning Balance 136,253.56 Cleared Transactions Checks and Payments-10 items City of Rancho Reimbursement for RCCAAF Check 01/31/2018 11444 Cucamonga-V Account Technician-Catherine 4 -6,174.08 -6,174.08 Allen(07.01.2017-01.18.2018) City of Rancho Kohl's Cares disbursement- Check 02/21/2018 11456 Cucamonga-V Senior Center 2017 Thanksgiving 4 -500.00 -6,674.08 Luncheon Check 03/01/2018 11462 Rancho Cucamonga 2017/18 Sponsorship Award 4 -500.00 -7,174.08 High School Check 03/01/2018 11461 Los Osos High School 2017/18 Sponsorship Award 4 -500.00 -7,674.08 Check 04/02/2018 11464 Casino Parties& 2018 Monte Carlo Casino Night 4 -1,375.00 -9,049.08 Entertainment (Job ID:180225-18-xx) Check 04/02/2018 Service Charge 4 -27.99 -9,077.07 City of Rancho BofA Foundation-Sponsored Check 04/04/2018 11465 Cucamonga-V Tickets-"In the Heights"(Invoice 4 -1,050.00 -10,127.07 #BW01 B-1718) City of Rancho ,Edison-Sponsored Tickets- Check 04/04/2018 11466 Cucamonga-V Stunt Dog Experience (Invoice J -558.00 -10,685.07 #S0331-1718) Invoice#SO414-1718-LFP Check 04/23/2018 11470 City of Rancho Sponsored Tickets-"Choo Choo 4 -361.00 -11,046.07 Cucamonga-V Soul" Invoice#S0414-1718-LFP Check 04/23/2018 11469 City of Rancho Sponsored Tickets-"Choo Choo 4 -320.00 -11,366.07 Cucamonga-V Soul" Total Checks and Payments -11,366.07 -11,366.07 Deposits and Credits-3 items -- - Deposit 04/04/2018 - -- 2018 Monte Carlo Casino Night 1,000.00 1,000.00 Deposit 04/16/2018 (2018 Monte Carlo Night), 4 1,050.00 2,050.00 (Bricks) Rancho Cucamonga Community &Arts Foundation Reconciliation Detail - PAL Checking Account Fiscal Year 2017 - 2018 Period Ending April 30, 2018 Type Date Num Name Memo Clr Amount Balance Deposit 04/25/2018 Morgan Stanley-General Cause 4 1,000.00 3,050.00 Project Total Deposits and Credits 3,050.00 3,050.00 Total Cleared Transactions -8,316.07 -8,316.07 Cleared Balance -8,316.07 127,937.49 Uncleared Transactions Checks and Payments-5 items Trip ID#16649,16650,16651 - Check 12/07/2017 11431 Euclid Elementary Bus reimbursement for Euclid -152.00 -152.00 Elementary to see`The Witches" Impressions Gourmet Invoice#13850-2018 Monte Check 04/23/2018 11467 -433.69 -585.69 Catering Carlo Night-Beverage Server Check 04/23/2018 11468 Luxe Pix Photo Booth 2018 Monte Carlo Casino Night- -300.00 -885.69 Photo booth rental Check 04/26/2018 11471 On The Go DJ Pro DJ Services for Monte Carlo -300.00 -1,185.69 Rancho Cucamonga Reimbursement to Animal Center Check 04/30/2018 11472 Animal Care for Petsmart donation -50.00 -1,235.69 Foundation Total Checks and Payments -1,235.69 -1,235.69 Deposits and Credits-1 item Deposit 04/16/2018 Franchise Tax Board 10.07 10.07 Total Deposits and Credits 10.07 10.07 Total Uncleared Transactions -1,225.62 -1,225.62 Register Balance as of 04/30/2018 -9,541.69 126,711.87 New Transactions Checks and Payments-5 items LFP Bus Reimbursement-Bear - - Check - -05/01/2018 11473 Central-School District Gulch-Mainstreet's-"Oh =462.92 462.92 Freedom" Rancho Cucamonga Community &Arts Foundation Reconciliation Detail - PAL Checking Account Fiscal Year 2017 - 2018 Period Ending April 30, 2018 Type Date Num Name Memo Clr Amount Balance LFP-Bus Reimbursement-EJ Check 05/01/2018 11474 CVUSD Marshall-Mainstreers"Oh -219.01 -681.93 Freedom" Check 05/01/2018 11475 City of Rancho Donor Brick Walk-Invoice# -171.00 -852.93 Cucamonga-V 2018CORCU3 Victor Elementary LFP Bus Reimbursement- Check 05/03/2018 11476 School District Liberty Elementary-Mainstreets -500.00 -1,352.93 "Oh Freedom" Invoice#10188:2018 Monte Check 05/07/2018 11477 Carol's Secret Garden Carlo Casino Night- -431.00 -1,783.93 Centerpieces Total Checks and Payments -1,783.93 -1,783.93 Deposits and Credits-4 items Deposit 05/01/2018 Theatre Seat Plaques 500.00 500.00 Deposit 05/01/2018 (2018 Monte Carlo Casino Night), 735.00 1,235.00 (Engraved Brick) Deposit 05/03/2018 2018 Monte Carlo Casino Nlght 170.00 1,405.00 Deposit 05/03/2018 2018 Monte Carlo Casino Night 1,530.00 2,935.00 Total Deposits and Credits 2,935.00 2,935.00 Total New Transactions 1,151.07 1,151.07 Ending Balance -8 390.62 127,862.94 Foundation Financial Reports FY 2017/2018 LAIF Account Reconciliation Summary and Detail I, April 1 - 30, 2018 Rancho Cucamonga Community & Arts Foundation Reconciliation Summary - LAW Account Fiscal Year 2017 - 2018 Period Ending May 3,2018 May 3,2018 Beginning Balance $ 291,363.33 Cleared Transactions Deposits and Credits-1 item $ 1,623.53 Total Cleared Transactions $ 1,623.53 Cleared Balance $ 292,986.86 Register Balance as of 06/03/2018 $ 292,986.86 Ending Balance $ 292,986.86 Rancho Cucamonga Community &Arts Foundation Reconciliation Detail - LAW Account Fiscal Year 2017 - 2018 Period Ending May 3,2018 Type Date Memo Cir Amount Balance Beginning Balance $ 291,363.33 Cleared Transactions Deposits and Credits-1 item Deposit 04/13/2018 Interest $ 1.623.53 $ 1,623.53 Total Deposits and Credits $ 1,623.53 $ 1,623.53 Total Cleared Transactions $ 1,623.53 $ 1,623.53 Cleared Balance $ 1,623.53 $ 292,986.86 Register Balance as of 05/03/2018 $ 1,623.53 $ 292,986.86 Ending Balance $ 1,623.63 $ 292,986.86 RANCHO CUCAMONGA COMMUNITY A RTS FOUNDATION 00 STAFF REPORT DATE: May 23, 2018 TO: Rancho Cucamonga Community &Arts Foundation Executive/Finance Committee FROM: Jennifer Hunt Gracia, Community Services Director INITIATED BY: Christen Mitchell, Management Analyst II SUBJECT: Financial Update RECOMMENDATION: Staff recommends the Executive/Finance Committee review the current fiscal year's annual operating budget, the Draft 2018/2019 Fiscal Year Operating Budget and therefore recommend the 2018/2019 budget to the Full Board for adoption. An update on the Animal Center Affiliate and the 2016/2017 Fiscal Year taxes has been provided. In addition, staff recommends the Executive/Finance Committee discuss proposed bookkeeping changes in QuickBooks and give staff approval to move forward. BACKGROUND: The Operating Budget includes all events, programs and operation expenses and revenues. ANALYSIS: The attached budget includes one column of numbers showing the current approved 2017/2018 Fiscal Year Budget, a second column showing the actual, including some expected, revenues and expenses through the end of the fiscal year and a third column with the 18/19 Proposed Budget. A Fritz Coleman Performance and a new program grant are new line items to be considered for the upcoming fiscal year. Animal Center staff is currently working with PetSmart Charities to update their information. Staff hopes to have this resolved within a month. Tina Chen, Vice Chair, signed the taxes of May 14, 2018. LSL CPAs and Advisors electronically filed the Form 990 and California Form 199 return. Staff mailed the California Form RRF-1, with a $75.00 check made payable to the Attorney General Registry of Charitable Trusts, on May 15, 2018. Taxes were to be postmarked on or before May 15, 2018. Staff met with Secretary/Treasurer Mark Rivera to discuss some ideas on how to better streamline the Foundation's financials in QuickBooks. This would require staff to make changes to current account numbers, classes, update the equity accounts to ensure a more accurate Balance Sheet and to better track donors and grants in QuickBooks. Staff will be prepared to present these ideas to the Executive/Finance Committee in the meeting. Page 1 of 2 FISCAL IMPACT: 17/18 Fiscal Year Budgeted Net Total as of 05/14/2018: ($5,116.00) 18/19 Draft Fiscal Year Budgeted Net Total: $25.00 Exhibits: Exhibit A—Proposed Operating Budget Draft worksheet Page 2of2 Rancho Cucamonga Community &Arts Foundation Draft Operating Budget- 18/19 Budget 17/18 17/18 18/19 Description Notes: Approved Actuals Proposed Fundraising/Investments i $ 38,900 $ 32,845 $ 68,825 PAL Campaign/Spotlight Donors 1 $ 3,400 $ - $ 17,000 New/Renewing Donors(Premier/Lewis/Morris) RCQuakes5trike Outs l $ 5,000 $ 6,570 $_ _6,000 VG Bricks/Plaques $ 500 $ 1,550 $ 1,200 HeartsforArts Compaign(Feb.2019) Investment Income $ 28,000 $ 17,804 $ 36,625 _ Misc/Interest $ 2,000 $ 6,920 $ 8,000 Add Monthly Campaign/Restaurant Fundraisers Activities&Events $110,800 $ 83,142 $ 96,700 _ g p -_.�-� 1,500 quakes Night(Se t1017 $ 1,700 �'. $ 1,600 September 1,2018 Golf Tournament(October2D17) $ 65,000 $ 68,898 $ 65,000 October2018 Fritz Coleman Performance(TBD) $ 9,800 (350 tx @$28ovg.) Monte Carlo Night(Moy 2018) $ 32,000 $ 10.139 $ 18,000 May2019 Gnco de Bunco(May 2018) $ 2,300 $ 2,405 $ 2,300 TBD Tour de Fork(June 2018)'. $ 10,000 $ $149,700 $115,987 ( $165,525 Rancho Cucamonga Community &Arts Foundation Draft Operating Budget- 18/19 Budget Expenclitures Description 17/18 17/18 18/19 Notes: .Approved Actuals Proposed Administration $ 34,100 $ 12,035 $ 44,100 Personnel $ 20,000 $ 6,ka 1 $ 30,000 _ Business Cords/Ofke Supplies $ 1,000 $_ 317 $ 1,0 O Financial Compliance $ 10000 $ 2,251 $ 10,000 Insurance $ 2 100 $ 2,049 5 2,100 Travel&Meetings $ 1,000 $ 510 ( $ 1,000 p 201712018Fountloo Brochure $ 1,200 $_ $ 1200 Marketin &_Commum Outreach $ 1,700 $ 157 $ 3, 700 - Website Hoski9 n /Mmntenonce $ $ $ 1,5001 paidfor3years renewalln FY202012021 Miscellaneous Marketing Exp $ 500 $ 157 ;$ 1,000 Board Development&Training $ 1,000 $ - $ 11000 Donor Development&Retention $ 2,200 $ 2,316 $ 2,200 Donor Recognition Event $ 1,400 : $$ 1,570 $ _ 1400111 Donor Awards $ 600 $ 420 $ 6061 Donor Plaques/Bricks $ 200 $ 326 $ 2001 Fundraising Activities&Events 5 39,200 $ 28,595 $ 33,500 Golf Tournoment(2017), $ 25,000 $ 23,7551 $ 25,000 October2018 Monte Carlo Night(2018)'. $ 14200 _$ 4,8401 $ 7500 April/May 2039 rtz Coleman Performance $ ;$. I $ 1,000 Other $ $ Foundation Sponsored CityPrograms $ 67,500 $ 66,000 $ 64,000 Lewis Famil Pla house_ p y gy '� 10000 $ 10,000 $__7,500 RC Community Theatre/BATG $ 15,000 $ 15,000I $ 15,OGO World Music Series(3 Shows) $ 9,000 ',. $ 7,500 1 $ 8,000 _ Bussing far Underserved Students $ 6,000 $ 6,000 $ 6,000 Foundation Family Wknds/Flex Pack MSTC $ 20,000 '.. $ 20,000. $ 20,000 MoinStreet Theatre Company $ 7,500 $ 7,500 $ 7500 Community Programs $ 12,000 $ 12,000 $ 17,000 H S Performing Arts Program Support $ 3,000 _$_3,660 $ 3,0007. Student Scholarship Program $ 5,000 $ 5,000 $ 5,000 -- - - New Program Grant $ Is 5,000 - SeptemberArt Association Art Show $ 4,000 $ 4,000' $ 4000- Total Expenditures _j$157,700 $121,103 1 $165,500 1 Budgeted Net Total' : $ (8,000). $ (5,116). $ 25.: