| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Revenue | 2014 Budget | January Projections | January Actual | February Projections | February Actual | March Projections | March Actual | April Projections | April Actual | May Projections | May Actual | 2014 YTD - Projections | 2014 YTD - Actual | Actual vs. Projections | Notes | |
2 | Corporate Membership (Foundation + Chapter) | $570,000.00 | $28,500.00 | $37,730.00 | $45,600.00 | $12,306.00 | $68,400.00 | $39,671.00 | $45,600.00 | $63,599.00 | $57,000.00 | $24,519.00 | $245,100.00 | $177,825.00 | -27.45% | ||
3 | Individual membership (Foundation + Chapter) | $137,500.00 | $6,875.00 | $9,564.00 | $8,250.00 | $6,015.00 | $11,000.00 | $7,181.00 | $13,750.00 | $6,444.00 | $16,500.00 | $4,187.00 | $56,375.00 | $33,391.00 | -40.77% | ||
4 | |||||||||||||||||
5 | Local Chapter Supporter/Local Meeting Supporter | $1,000.00 | $0.00 | $483.00 | $1,354.00 | $250.00 | $9,919.00 | $0.00 | $3,303.00 | $0.00 | $3,493.00 | $250.00 | $18,552.00 | 7320.80% | |||
6 | Donations | $40,000.00 | $0.00 | $505.00 | $220.00 | $5,000.00 | $2,183.00 | $0.00 | $5,810.00 | $0.00 | $3,605.00 | $5,000.00 | $12,323.00 | 146.46% | |||
7 | |||||||||||||||||
8 | AppSec USA | $700,000.00 | $0.00 | $0.00 | $15,000.00 | $19,890.00 | $25,000.00 | $29,195.00 | $55,000.00 | $134,332.00 | $98,000.00 | $32,621.00 | $193,000.00 | $216,038.00 | 11.94% | Profit Goal $240000 | |
9 | AppSec Europe | $195,801.00 | $5,000.00 | $19,176.00 | $10,000.00 | $0.00 | $34,000.00 | $10,091.00 | $57,000.00 | $67,560.00 | $59,675.00 | $45,251.00 | $165,675.00 | $142,078.00 | -14.24% | Profit Goal $75,000 | |
10 | AppSec APAC | $95,000.00 | $28,000.00 | $32,996.00 | $38,000.00 | $49,245.00 | $29,000.00 | $88,198.00 | $0.00 | -$640.00 | $0.00 | $0.00 | $95,000.00 | $169,799.00 | 78.74% | Profit Goal $5000, Projected Income $50,000 | |
11 | Latam Tour | $35,000.00 | $0.00 | $0.00 | $5,000.00 | $0.00 | $22,500.00 | $4,620.00 | $7,500.00 | $9,038.00 | $0.00 | $2,078.00 | $35,000.00 | $15,736.00 | -55.04% | Latam tour Profit Goal $5000, Projected Income $6,800 | |
12 | Local and Regional Events | $50,000.00 | $0.00 | $66,654.00 | -$109.00 | $12,500.00 | $4,091.00 | $0.00 | -$87.00 | $0.00 | $0.00 | $12,500.00 | $70,549.00 | 100.00% | Foundation Profit Goal $5000 | ||
13 | |||||||||||||||||
14 | Training | $20,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.00% | No training initiatives/events scheduled during Q1 | |||
15 | |||||||||||||||||
16 | UBI - Advertising & Merchandise Revenue | $30,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $5,000.00 | $0.00 | $0.00 | $1,213.00 | $0.00 | $0.00 | $5,000.00 | $1,213.00 | -75.74% | ||
17 | Interest and Investments | $400.00 | $0.00 | $12.00 | $0.00 | $33.00 | $100.00 | -$23.00 | $0.00 | $7.00 | $0.00 | -$21.00 | $100.00 | $8.00 | -92.00% | ||
18 | Grants & Sponsorship Programs | $50,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $12,500.00 | $0.00 | $0.00 | $8,514.00 | $0.00 | $0.00 | $12,500.00 | $8,514.00 | -31.89% | ||
19 | TOTAL Revenue: | $1,924,701.00 | $68,375.00 | $167,120.00 | $121,850.00 | $88,954.00 | $225,250.00 | $195,126.00 | $178,850.00 | $299,093.00 | $231,175.00 | $115,733.00 | $825,500.00 | $866,026.00 | 4.91% | ||
20 | |||||||||||||||||
21 | |||||||||||||||||
22 | EXPENSES | ||||||||||||||||
23 | Total Payroll and Benefits | $409,148.33 | $26,000.00 | $32,391.00 | $32,383.33 | $29,080.00 | $33,050.00 | $25,678.00 | $36,315.00 | $37,650.00 | $33,050.00 | $29,118.00 | $160,798.33 | $153,917.00 | -4.28% | ||
24 | Contractors | $46,500.00 | $1,000.00 | $1,538.00 | $1,500.00 | $1,400.00 | $17,875.00 | $10,516.00 | $1,500.00 | $1,640.00 | $1,500.00 | $2,693.00 | $23,375.00 | $17,787.00 | -23.91% | ||
25 | Staff Travel | $32,000.00 | $950.00 | $2,845.00 | $4,500.00 | $4,391.00 | $4,000.00 | $2,297.00 | $5,000.00 | $3,748.00 | $0.00 | $6,069.00 | $14,450.00 | $19,350.00 | 33.91% | ||
26 | Staff Professional Improvement | $20,000.00 | $4,000.00 | $2,027.00 | $1,000.00 | $395.00 | $1,000.00 | $2,341.00 | $2,000.00 | $1,218.00 | $2,000.00 | $2,449.00 | $10,000.00 | $8,430.00 | -15.70% | ||
27 | Employee Recognition | $500.00 | $0.00 | $0.00 | $100.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $100.00 | $0.00 | -100.00% | |||
28 | General & Administrative (Operational) | $110,233.00 | $40,000.00 | $29,604.00 | $22,000.00 | $3,193.00 | $17,800.00 | $5,177.00 | $3,233.00 | $37,429.00 | $9,700.00 | $9,538.00 | $92,733.00 | $84,941.00 | -8.40% | ||
29 | Chapter & Project Allocation & Expenses | $325,125.00 | $12,381.25 | $5,200.00 | $18,847.50 | $5,135.00 | $37,790.00 | $27,079.00 | $21,272.00 | $32,999.00 | $25,725.00 | $14,166.00 | $116,015.75 | $84,579.00 | -27.10% | ||
30 | BOARD | $27,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,500.00 | $0.00 | $2,500.00 | $0.00 | $0.00 | $4,220.00 | $4,000.00 | $4,220.00 | 5.50% | ||
31 | Projects | $46,000.00 | $3,000.00 | $0.00 | $3,000.00 | $0.00 | $3,000.00 | $2,895.00 | $3,000.00 | $367.00 | $3,000.00 | $247.00 | $15,000.00 | $3,509.00 | -76.61% | ||
32 | Grants | $50,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $12,500.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,210.00 | $12,500.00 | $1,210.00 | 0.00% | ||
33 | OWASP Outreach & Community Building | $60,000.00 | $5,000.00 | $0.00 | $5,000.00 | $497.00 | $5,000.00 | $7,556.00 | $5,000.00 | $1,537.00 | $5,000.00 | $3,380.00 | $25,000.00 | $12,970.00 | -48.12% | ||
34 | AppSec USA | $460,000.00 | $50,000.00 | $82,452.00 | $50,000.00 | $70.00 | $50,000.00 | $30,055.00 | $50,000.00 | $550.00 | $50,000.00 | $5,000.00 | $250,000.00 | $118,127.00 | -52.75% | ||
35 | AppSec Europe | $120,801.00 | $20,000.00 | $83,087.00 | $20,000.00 | $1,431.00 | $20,000.00 | $2,032.00 | $20,000.00 | $2,191.00 | $20,000.00 | $10,201.00 | $100,000.00 | $98,942.00 | -1.06% | ||
36 | AppSec AsiaPac | $90,000.00 | $20,000.00 | $582.00 | $25,000.00 | $33,379.00 | $45,000.00 | $27,711.00 | $0.00 | $32,879.00 | $0.00 | $32,631.00 | $90,000.00 | $127,182.00 | 41.31% | Expenses higher than projected, but income higher as well | |
37 | AppSec Latam | $30,000.00 | $0.00 | $0.00 | $5,000.00 | $10,000.00 | $0.00 | $10,000.00 | $0.00 | $5,000.00 | $7,953.00 | $30,000.00 | $7,953.00 | -73.49% | |||
38 | Local & Regional Events | N/A | $0.00 | $52,745.00 | $0.00 | $8,518.00 | $0.00 | $3,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $64,263.00 | 100.00% | Offset by Local and regional event income (Line 12 above) | |
39 | Extra Merchandise | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$4,253.00 | $0.00 | $3,150.00 | $0.00 | $15,084.00 | $0.00 | $13,981.00 | 0.00% | ||
40 | Deposit into Foundation Reserves | $98,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.00% | ||
41 | TOTAL EXPENSES | $1,925,307.33 | $182,331.25 | $292,471.00 | $188,330.83 | $87,489.00 | $258,515.00 | $142,084.00 | $159,820.00 | $155,358.00 | $154,975.00 | $143,959.00 | $943,972.08 | $821,361.00 | -12.99% | ||
42 | TOTAL INCOME: | $1,924,701.00 | $68,375.00 | $167,120.00 | $121,850.00 | $88,954.00 | $225,250.00 | $195,126.00 | $178,850.00 | $299,093.00 | $231,175.00 | $115,733.00 | $825,500.00 | $866,026.00 | 4.91% | ||
43 | NET | -$606.33 | -$113,956.25 | -$125,351.00 | -$66,480.83 | $1,465.00 | -$33,265.00 | $53,042.00 | $19,030.00 | $143,735.00 | $76,200.00 | -$28,226.00 | -$118,472.08 | $44,665.00 | -137.70% |