Creative Media

2017 - 2018

Charts
-8.76% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
Income 18,948 25,648 15,948 25,648 15,948

Expenses
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
General Assistance / Benefits 226,647 252,403 258,817 258,817 258,817
Administrative / Programmatic -54,146 -61,463 -63,090 -62,745 -62,745
Total Expense 172,501 190,940 195,727 196,072 196,072

Reconciliation
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
Subsidy 153,553 165,292 179,779 170,424 180,124
Transfers To/From Reserve 0 0 0 0 0
Charts
-37.82% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Income
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
11000 Promotional Videos & Services (Aggie Studios)

0 6,500 0 6,500 0
12000 ---

0 0 0 0 0
13000 Graphics Income

3,000 3,000 3,000 3,000 3,000
14000 External Projects

MOU with CSI

3,000 3,000 0 3,000 0
15000 Sponsorships

0 0 0 0 0
17000 Web Rental/Services

CSI Contract

12,948 12,948 12,948 12,948 12,948
18000 Bad Checks

0 0 0 0 0
19000 Over and Short

0 0 0 0 0
2000 Youtube Monetization (Aggie Studios)

0 200 0 200 0
Total Income 18,948 25,648 15,948 25,648 15,948
Charts
2.65% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
21000 Common Goods Assessment

0 5,277 3,640 3,640 3,640
30000 Copying & Printing

0 0 0 0 0
31000 Mail

0 0 0 0 0
32000 Office Supplies

0 0 0 0 0
33000 Transportation

0 0 0 0 0
34000 Telephone Equipment

0 0 0 0 0
35000 Telephone Long Distance

0 0 0 0 0
36000 Equipment Purchase

6,000 7,500 7,500 7,500 7,500
37000 Repair & Maintenance

0 1,500 1,500 1,500 1,500
40000 Equipment Rental

0 0 0 0 0
50000 Merchandise for Resale

0 0 0 0 0
51000 Services Rendered

0 0 0 0 0
52000 Publicity

1,550 800 800 800 800
54000 ---

0 0 0 0 0
55000 Software & Licensing

3,000 3,000 3,000 3,000 3,000
70000 Allowance for Uncollectables

0 0 0 0 0
71000 Replacement Reserve

0 0 0 0 0
72000 University Recharge

0 0 0 0 0
79000 OP Tax

36 91 101 125 125
90000 Admin Recharge

9,180 9,369 9,369 9,690 9,690
90500 Network Recharge

-62,888 0 0 0 0
90600 Creative Media Recharge

-10,374 -89,000 -89,000 -89,000 -89,000
90700 ---

0 0 0 0 0
91000 ASUCD

0 0 0 0 0
92000 ASUCD

0 0 0 0 0
92700 Creative Media Marketing Recharge

-650 0 0 0 0
93000 ASUCD

0 0 0 0 0
94000 Network Recharge

0 0 0 0 0
Total Expenses -54,146 -61,463 -63,090 -62,745 -62,745
Charts
-2.54% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
a Aggie Studios Executive Producer

0 1,969 2,373 2,373 2,373
b Aggie Studios Technical Director

0 1,969 2,373 2,373 2,373
c Aggie Studios Animators

0 1,969 0 0 0
d Aggie Studios Animators

0 0 0 0 0
e Aggie Studios Lead Animators

0 0 0 0 0
Total Stipend 0 5,907 4,746 4,746 4,746
Start-End Weeks Pay Per Week Num. Weeks Quantity Total
a Aggie Studios Executive Producer 9/25/17-6/14/18 15-51
Exclude:
23, 26-29, 40-41
79.10 30 1 2,373
b Aggie Studios Technical Director 9/25/17-6/14/18 15-51
Exclude:
23, 26-29, 40-41
79.10 30 1 2,373
c Aggie Studios Animators 9/25/17-6/14/18 15-51
Exclude:
23, 26-29, 40-41
0 0 0 0
d Aggie Studios Animators --- --- 0 0 0 0
e Aggie Studios Lead Animators --- --- 0 0 0 0

Hourly
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
---

0 0 0 0 0
a Graphic Designer - Fall

5,535 6,765 7,095 7,095 7,095
b Graphic Designer - Summer

21,978 7,380 7,740 7,740 7,740
c Graphic Designer - Winter/Spring

5,328 14,190 14,850 14,850 14,850
d Computer Programmer - Fall

52,470 18,810 19,470 19,470 19,470
e Computer Programmer - Summer

11,925 15,390 15,930 15,930 15,930
f Computer Programmer - Winter/Spring

6,559 34,073 35,228 35,228 35,228
g Marketing Director - Fall

3,861 3,383 3,548 3,548 3,548
h Marketing Staff - Fall

6,930 2,640 2,772 2,772 2,772
i Marketing Director - Summer

0 1,476 1,548 1,548 1,548
j Marketing Staff - Summer

0 1,200 1,260 1,260 1,260
k Marketing Director - Winter/Spring

0 7,095 7,425 7,425 7,425
l Marketing Staff - Winter/Spring

0 5,412 5,676 5,676 5,676
m Head Designer - Fall

0 1,485 1,551 1,551 1,551
n Head Designer - Summer

0 1,620 1,692 1,692 1,692
o Head Designer - Winter/Spring

0 3,102 3,234 3,234 3,234
p Marketing Project Manager - Fall

0 4,868 5,033 5,033 5,033
q Copywriter - Winter/Spring

0 0 0 0 0
r Social Media Manager - Fall

0 0 0 0 0
s Social Media Manager - Winter/Spring

0 0 0 0 0
t Copywriter - Fall

0 0 0 0 0
u Marketing Project Manager - Summer

0 0 0 0 0
v Marketing Project Manager - Winter/Spring

0 0 0 0 0
w Aggie Studios Executive Producer - Summer

0 0 0 0 0
x Aggie Studios Executive Producer - Fall

0 0 0 0 0
y Aggie Studios Executive Producer - Winter/Spring

0 0 0 0 0
z Aggie Studios Client Media Director - Summer

0 0 0 0 0
za Aggie Studios Client Media Director - Fall

0 0 0 0 0
zb Aggie Studios Client Media Director - Winter/Spring

0 0 0 0 0
zc Aggie Studios Director of Studio Production Coordination - Summer

0 0 0 0 0
zd Aggie Studios Director of Studio Production Coordination - Fall

0 0 0 0 0
ze Aggie Studios Director of Studio Production Coordination - Winter/Spring

0 0 0 0 0
zf Aggie Studios Marketing Manager - Summer

0 0 0 0 0
zg Aggie Studios Marketing Manager - Fall

0 0 0 0 0
zh Aggie Studios Marketing Manager - Winter/Spring

0 0 0 0 0
zi Aggie Studios Technical Director - Summer

0 0 0 0 0
zj Aggie Studios Technical Director - Fall

0 0 0 0 0
zk Aggie Studios Technical Director - Winter/Spring

0 0 0 0 0
zl Lead Computer Programmer - Summer

0 0 0 0 0
zm Lead Computer Programmer - Fall

0 0 0 0 0
zn Lead Computer Programmer - Winter/Spring

0 0 0 0 0
zo Copywriter - Summer

0 0 0 0 0
zp Aggie Studios Photographers - Fall

0 0 0 0 0
zq Aggie Studios Photographers - Winter/Spring

0 0 0 0 0
zr Aggie Studios Lead Photographers - Fall

0 0 0 0 0
zs Aggie Studios Lead Photographers - Winter/Spring

0 0 0 0 0
zt Social Media Manager - Summer

0 0 0 0 0
zu Sponsorship Assistants - Fall

0 0 0 0 0
zv Sponsorship Assistants - Winter/Spring

0 0 0 0 0
Total Hourly 114,586 128,889 134,052 134,052 134,052
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
--- --- 0 0 0 0 0
a Graphic Designer - Fall 9/19/17-12/31/17 12 10.75 11 5 7,095
b Graphic Designer - Summer 6/12/17-9/18/17 12 10.75 12 5 7,740
c Graphic Designer - Winter/Spring 1/1/18-6/15/18 12 11.25 22 5 14,850
d Computer Programmer - Fall 9/19/17-12/31/17 15 14.75 11 8 19,470
e Computer Programmer - Summer 6/12/17-9/18/17 15 14.75 12 6 15,930
f Computer Programmer - Winter/Spring 1/1/18-6/15/18 15 15.25 22 7 35,228
g Marketing Director - Fall 9/19/17-12/31/17 15 10.75 11 2 3,548
h Marketing Staff - Fall 9/19/17-12/31/17 12 10.50 11 2 2,772
i Marketing Director - Summer 6/12/17-9/18/17 12 10.75 12 1 1,548
j Marketing Staff - Summer 6/12/17-9/18/17 10 10.50 12 1 1,260
k Marketing Director - Winter/Spring 1/1/18-6/15/18 15 11.25 22 2 7,425
l Marketing Staff - Winter/Spring 1/1/18-6/15/18 12 10.75 22 2 5,676
m Head Designer - Fall 9/19/17-12/31/17 12 11.75 11 1 1,551
n Head Designer - Summer 6/12/17-9/18/17 12 11.75 12 1 1,692
o Head Designer - Winter/Spring 1/1/18-6/15/18 12 12.25 22 1 3,234
p Marketing Project Manager - Fall 1/1/18-6/15/18 15 15.25 22 1 5,033
q Copywriter - Winter/Spring --- 0 0 0 0 0
r Social Media Manager - Fall --- 0 0 0 0 0
s Social Media Manager - Winter/Spring --- 0 0 0 0 0
t Copywriter - Fall --- 0 0 0 0 0
u Marketing Project Manager - Summer --- 0 0 0 0 0
v Marketing Project Manager - Winter/Spring --- 0 0 0 0 0
w Aggie Studios Executive Producer - Summer --- 0 0 0 0 0
x Aggie Studios Executive Producer - Fall --- 0 0 0 0 0
y Aggie Studios Executive Producer - Winter/Spring --- 0 0 0 0 0
z Aggie Studios Client Media Director - Summer --- 0 0 0 0 0
za Aggie Studios Client Media Director - Fall --- 0 0 0 0 0
zb Aggie Studios Client Media Director - Winter/Spring --- 0 0 0 0 0
zc Aggie Studios Director of Studio Production Coordination - Summer --- 0 0 0 0 0
zd Aggie Studios Director of Studio Production Coordination - Fall --- 0 0 0 0 0
ze Aggie Studios Director of Studio Production Coordination - Winter/Spring --- 0 0 0 0 0
zf Aggie Studios Marketing Manager - Summer --- 0 0 0 0 0
zg Aggie Studios Marketing Manager - Fall --- 0 0 0 0 0
zh Aggie Studios Marketing Manager - Winter/Spring --- 0 0 0 0 0
zi Aggie Studios Technical Director - Summer --- 0 0 0 0 0
zj Aggie Studios Technical Director - Fall --- 0 0 0 0 0
zk Aggie Studios Technical Director - Winter/Spring --- 0 0 0 0 0
zl Lead Computer Programmer - Summer --- 0 0 0 0 0
zm Lead Computer Programmer - Fall --- 0 0 0 0 0
zn Lead Computer Programmer - Winter/Spring --- 0 0 0 0 0
zo Copywriter - Summer --- 0 0 0 0 0
zp Aggie Studios Photographers - Fall --- 0 0 0 0 0
zq Aggie Studios Photographers - Winter/Spring --- 0 0 0 0 0
zr Aggie Studios Lead Photographers - Fall --- 0 0 0 0 0
zs Aggie Studios Lead Photographers - Winter/Spring --- 0 0 0 0 0
zt Social Media Manager - Summer --- 0 0 0 0 0
zu Sponsorship Assistants - Fall --- 0 0 0 0 0
zv Sponsorship Assistants - Winter/Spring --- 0 0 0 0 0

Career
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
a Network Administrator

72,888 76,573 78,104 78,104 78,104
Total Career 72,888 76,573 78,104 78,104 78,104
Start-End Num. Months Paid Pay Per Month Quantity Total
a Network Administrator 7/1/17-6/30/18 12 6,508.70 1 78,104

Employee Benefits
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 114,586 134,796 138,798 138,798 138,798
b Total Career 72,888 76,573 78,104 78,104 78,104
Total General Assistance 187,474 211,369 216,902 216,902 216,902
Employee Benefits Casual (a * 0.01500) 1,490 1,752 2,082 2,082 2,082
Employee Benefits Career (b * 0.51000) 37,683 39,282 39,833 39,833 39,833
General Automotive Employee Liability ((a+b) * 0.00000) 0 0 0 0 0
Composite Benefit Rate ((a+b) * 0.00000) 0 0 0 0 0
Total Employee Benefits 39,173 41,034 41,915 41,915 41,915