API tools faq
paste
Advertisement
deathslayer999

yaleunion budgets

deathslayer999
Sep 25th, 2019
514
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.29 KB | None | 0 0
raw download clone embed print report
  1. YU - Operational Budget Summary
  2. January through December 2019
  3. January Jan - Actuals February Feb - Actuals March Mar - Actuals April April - Actual May June July August September October November December Total Budget Total Actual
  4. Programs Windows
  5. Sky
  6. Bernadette Matsuzawa STEINB BOOK
  7. HOMS Book Strike
  8. Dope Elf
  9. Small programs/Music Kolbowski Music Music Music Music Music Music
  10. Rentals HannahAnd BodV, Hann Barre3 Barre3 Pixie Barre3 PERCENTAGE
  11.  
  12. CHARITABLE CONTRIBUTIONS $247,655 $249,719 $26,892 $23,944 $9,155 $24,910 $9,859 $8,130 $9,155 $36,655 $13,655 $33,755 $10,155 $7,655 $13,155 $4,155 $421,901 $306,703 72%
  13. Total 4100 - Government Income $0 $0 $18,737 $17,736 $0 $0 $7,359 $1,000 $0 $15,000 $0 $17,000 $0 $0 $0 $0 $58,096 $18,736
  14. Total 4200 - Foundations $0 $1,000 $0 $0 $4,000 $15,000 $0 $0 $5,000 $15,000 $7,000 $10,000 $6,000 $0 $8,000 $0 $55,000 $16,000
  15. Total 4300 - Individual Donations $246,655 $246,019 $6,655 $6,200 $4,155 $8,160 $2,500 $7,130 $2,500 $2,500 $5,000 $2,500 $2,500 $5,000 $2,500 $2,500 $284,965 $267,509
  16. Total 4305 - Individual Donations -ProServ $1,655 $1,655 $1,655 $3,255 $1,655 $1,655 $1,655 $1,655 $14,840 $0
  17. Total 4400 - Corporate $1,000 $2,700 $1,500 $8 $1,000 $1,750 $0 $0 $0 $2,500 $0 $1,000 $0 $1,000 $1,000 $0 $9,000 $4,458
  18. $0
  19. PROGRAM SERVICE REVENUE (Neighbors +publication) $1,682 $3,987 $1,682 $1,839 $1,682 $1,724 $1,682 $2,135 $1,682 $1,682 $1,682 $0 $1,682 $1,682 $1,682 $1,682 $18,502 $9,685 3%
  20. $0
  21. OTHER REVENUE TYPES $14,452 $15,585 $7,902 $12,535 $21,452 $15,836 $13,452 $22,828 $7,882 $13,882 $9,882 $7,882 $7,882 $9,882 $13,882 $13,882 $142,314 $66,784 24%
  22. 4701 - Long Term Lease Rentals $7,452 $6,085 $7,452 $6,085 $7,452 $6,985 $7,452 $6,985 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $7,882 $92,864 $26,140
  23. 4702 - Short Term Facility Rentals $7,000 $9,500 $450 $6,450 $14,000 $7,400 $6,000 $15,500 $0 $6,000 $2,000 $0 $0 $2,000 $6,000 $6,000 $49,450 $38,850
  24. 4703 - Miscellaneous $0 $0 $0 $0 $0 $1,451 $0 $343 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,794
  25. $0
  26. TOTAL INCOME $263,789 $269,291 $36,476 $38,318 $32,289 $42,470 $24,993 $33,093 $18,719 $52,219 $25,219 $41,637 $19,719 $19,219 $28,719 $19,719 $582,717 $383,172 100%
  27. $0
  28. 5000 - PROGRAMS $8,300 $15,704 $22,800 $11,125 $55,300 $16,927 $16,500 $32,995 $51,250 $20,800 $60,300 $11,300 $24,500 $11,800 $18,800 $12,300 $313,950 $76,751 55%
  29. 5100 - Artist Fees $0 $1,250 $2,000 $1,500 $7,000 $0 $2,500 $1,002 $5,000 $1,000 $18,000 $1,000 $5,000 $1,000 $1,000 $1,000 $44,500 $3,752
  30. 5040 - 5080 - Exhibition Production Costs $0 $85 $2,500 $333 $32,700 $1,918 $1,500 $11,679 $16,700 $500 $22,300 $500 $0 $500 $500 $500 $78,200 $14,015
  31. 5300 - Artist and Curatorial Travel $0 $1,423 $500 $1,124 $4,000 $2,534 $1,000 $3,039 $7,550 $500 $9,500 $500 $7,000 $500 $500 $500 $32,050 $8,120
  32. 5400 - Documenation and Promotions $0 $0 $0 $0 $1,300 $0 $0 $0 $1,200 $0 $1,200 $0 $1,200 $0 $0 $0 $4,900 $0
  33. Publication Costs $0 $4,428 $10,000 $0 $1,500 $965 $0 $44 $12,000 $7,000 $500 $0 $0 $0 $8,000 $0 $39,000 $5,437
  34. 5040 - 5080 - Educational Programs $1,000 $0 $0 $0 $0 $0 $1,200 $0 $0 $1,500 $0 $1,000 $0 $1,000 $0 $1,500 $7,200 $0
  35. Artist in Residency $0 $0 $0 $0 $1,000 $0 $1,000 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $10,000 $0
  36. 5200 - Professional Services $0 $1,903 $500 $1,900 $500 $4,100 $2,000 $10,762 $500 $2,000 $500 $0 $3,000 $500 $500 $500 $10,500 $18,665
  37. 5010 - 5030 - Business and Communications $1,100 $415 $1,100 $68 $1,100 $1,210 $1,100 $269 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $13,200 $1,962
  38. 8200 - Program Staff $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $74,400 $24,800
  39. $0
  40. 6000 - GENERAL ADMIN $12,250 $11,977 $12,250 $13,704 $17,250 $11,310 $16,250 $15,225 $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $14,250 $14,950 $172,700 $52,216 30%
  41. 6010 - 6100 & 6500 - Faciilities and Equipment $5,000 $7,599 $5,000 $6,571 $5,000 $4,298 $7,000 $8,132 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $62,000 $26,600
  42. 6400 - Business and Communications $1,750 $0 $1,750 $0 $1,750 $0 $1,750 $0 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $21,000 $0
  43. 6300 - Travel, Accommodations, Meals $500 $0 $500 $226 $500 $85 $500 $0 $500 $500 $500 $500 $500 $500 $500 $1,200 $6,700 $311
  44. 6200 - Professional Services $1,000 $630 $1,000 $3,150 $6,000 $3,170 $1,000 $1,600 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $17,000 $8,550
  45. 8100 - Admin/Management Staff $4,000 $3,748 $4,000 $3,757 $4,000 $3,757 $6,000 $5,493 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $66,000 $16,755
  46. $0
  47. 7000 - DEVELOPMENT (FUNDRAISING) $18,855 $18,455 $2,200 $1,600 $2,200 $1,602 $11,427 $8,453 $2,200 $22,200 $3,000 $12,200 $3,000 $3,000 $2,200 $2,200 $84,682 $30,110 15%
  48. 7300 - Travel, Accommodations, Meals $250 $0 $250 $0 $250 $0 $250 $0 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $0
  49. 7010 - 7040 - Business and Communications $150 $0 $150 $0 $150 $2 $150 $0 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $2
  50. 7100 - 7200 - Special Events $0 $0 $200 $0 $200 $0 $1,000 $0 $200 $200 $1,000 $200 $1,000 $1,000 $200 $200 $5,400 $0
  51. 8200 - Development Staff $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $19,200 $6,400
  52. 1010 - Capital Projects $16,855 $16,855 $0 $0 $0 $0 $8,427 $6,853 $20,000 $0 $10,000 $0 $0 $0 $0 $55,282 $23,708
  53.  
  54. TOTAL EXPENSES $39,405 $46,136 $37,250 $26,429 $74,750 $29,839 $44,177 $56,673 $67,700 $57,250 $77,550 $37,750 $41,750 $29,050 $35,250 $29,450 $571,332 $159,077 100%
  55.  
  56. NET INCOME $224,384 $223,155 -$774 $11,889 -$42,461 $12,631 -$19,184 -$23,580 -$48,981 -$5,031 -$52,331 $3,887 -$22,031 -$9,831 -$6,531 -$9,731 $11,385 $224,095
  57. -31931
  58. Cash Balance 12/31/18: $40488 (US bank+paypal)* $264,872 $259,058 $264,098 $267,822 $221,637 $272,018 $202,453 246849 $153,472 $148,441 $96,110 $99,997 $77,966 $68,135 $61,604 $51,873
  59. *Variation in actual balance due to stock value change and loan principle payment 213401
  60. Assumptions
  61.  
  62. Outreach staff person starting April at $2,000
  63. Jenny's pay increased to $3,600 split between Admin and Development
  64. Hope's pay increased to $4,000, Mark to $1200
  65. Bonus/overtime pay for Jeff included in general admin professional services costs
  66. Artist in Residence starting in March ($1,000 a month cost)
  67. Outsource Bernadette book for $10,000 in February
  68. 14 windows confirmed to be restored in 2019, with 52,000 in gov grants supporting this.
  69. Program service revenue is Neighbors rent; John Jay donation is the individual giving prog serv
  70. Only including confirmed or almost confirmed short term rentals - no speculation
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!