Creative Media

2019 - 2020

Charts
19.56% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
Income 15,948 17,948 79,000 89,500 89,500

Expenses
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
General Assistance / Benefits 258,817 286,716 301,427 301,427 301,427
Administrative / Programmatic -62,745 -48,803 -45,493 -45,493 -45,493
Total Expense 196,072 237,913 255,934 255,934 255,934

Reconciliation
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
Subsidy 180,124 219,965 176,934 166,434 166,434
Transfers To/From Reserve 0 0 0 0 0
Charts
340.16% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

0 2,000 8,000 8,000 8,000
12000 ---

0 0 0 0 0
13000 Graphics Income

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

0 0 0 0 0
15000 Sponsorships

0 0 60,000 70,000 70,000
17000 Web Rental/Services

12,948 12,948 8,000 8,000 8,000
18000 Bad Checks

0 0 0 0 0
19000 Over and Short

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

0 0 0 0 0
Total Income 15,948 17,948 79,000 89,500 89,500
Charts
6.78% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
21000 Common Goods Assessment

3,640 3,982 3,982 3,982 3,982
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

7,500 7,500 7,500 7,500 7,500
37000 Repair & Maintenance

1,500 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

800 400 400 400 400
54000 ---

0 0 0 0 0
55000 Software & Licensing

3,000 3,000 6,000 6,000 6,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

125 125 125 125 125
90000 Admin Recharge

9,690 9,690 10,000 10,000 10,000
90500 Network Recharge

0 0 0 0 0
90600 Creative Media Recharge

-89,000 -95,000 -95,000 -95,000 -95,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

0 20,000 20,000 20,000 20,000
93000 ASUCD

0 0 0 0 0
94000 Network Recharge

0 0 0 0 0
Total Expenses -62,745 -48,803 -45,493 -45,493 -45,493
Charts
-5.13% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
a Aggie Studios Executive Producer

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

2,373 0 0 0 0
c Aggie Studios Animators

0 0 0 0 0
d Aggie Studios Animators

0 0 2,200 2,200 2,200
Total Stipend 4,746 0 2,200 2,200 2,200
Start-End Weeks Pay Per Week Num. Weeks Quantity Total
a Aggie Studios Executive Producer --- --- 0 0 0 0
b Aggie Studios Technical Director --- --- 0 0 0 0
c Aggie Studios Animators --- --- 0 0 0 0
d Aggie Studios Animators 6/14/2019 - 6/11/2020 17, 19, 21, 23, 25, 31, 33, 35, 37, 43, 45, 47, 49 42.31 13 4 2,200

Hourly
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
---

0 0 0 0 0
a Graphic Designer - Fall

7,095 6,072 5,346 5,346 5,346
b Graphic Designer - Summer

7,740 3,096 8,064 8,064 8,064
c Graphic Designer - Winter/Spring

14,850 13,200 11,484 11,484 11,484
d Computer Programmer - Fall

19,470 20,130 14,355 14,355 14,355
e Computer Programmer - Summer

15,930 21,240 7,020 7,020 7,020
f Computer Programmer - Winter/Spring

35,228 42,900 30,690 30,690 30,690
g Marketing Director - Fall

3,548 2,021 2,228 2,228 2,228
h Marketing Staff - Fall

2,772 0 0 0 0
i Marketing Director - Summer

1,548 1,656 672 672 672
j Marketing Staff - Summer

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

7,425 4,373 4,785 4,785 4,785
l Marketing Staff - Winter/Spring

5,676 0 1,430 1,430 1,430
m Head Designer - Fall

1,551 1,650 4,703 4,703 4,703
n Head Designer - Summer

1,692 2,820 7,080 7,080 7,080
o Head Designer - Winter/Spring

3,234 3,564 10,065 10,065 10,065
p Marketing Project Manager - Fall

5,033 1,518 2,269 2,269 2,269
q Copywriter - Winter/Spring

0 4,125 3,630 3,630 3,630
r Social Media Manager - Fall

0 1,452 1,650 1,650 1,650
s Social Media Manager - Winter/Spring

0 3,960 3,564 3,564 3,564
t Copywriter - Fall

0 2,063 1,683 1,683 1,683
u Marketing Project Manager - Summer

0 864 2,394 2,394 2,394
v Marketing Project Manager - Winter/Spring

0 4,455 4,868 4,868 4,868
w Aggie Studios Executive Producer - Summer

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

0 1,250 2,186 2,186 2,186
y Aggie Studios Executive Producer - Winter/Spring

0 2,700 4,703 4,703 4,703
z Aggie Studios Client Media Director - Summer

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

0 1,380 1,650 1,650 1,650
zb Aggie Studios Client Media Director - Winter/Spring

0 2,750 3,564 3,564 3,564
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 1,380 1,100 1,100 1,100
zk Aggie Studios Technical Director - Winter/Spring

0 2,750 2,376 2,376 2,376
zl Lead Computer Programmer - Summer

0 0 0 0 0
zm Lead Computer Programmer - Fall

0 0 2,475 2,475 2,475
zn Lead Computer Programmer - Winter/Spring

0 0 5,280 5,280 5,280
zo Copywriter - Summer

0 0 954 954 954
zp Aggie Studios Photographers - Fall

0 0 2,156 2,156 2,156
zq Aggie Studios Photographers - Winter/Spring

0 0 4,664 4,664 4,664
Total Hourly 134,052 153,369 159,088 159,088 159,088
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
--- --- 0 0 0 0 0
a Graphic Designer - Fall --- 12 13.50 11 3 5,346
b Graphic Designer - Summer --- 12 14.00 12 4 8,064
c Graphic Designer - Winter/Spring --- 12 14.50 22 3 11,484
d Computer Programmer - Fall --- 15 14.50 11 6 14,355
e Computer Programmer - Summer --- 13 15.00 12 3 7,020
f Computer Programmer - Winter/Spring --- 15 15.50 22 6 30,690
g Marketing Director - Fall --- 15 13.50 11 1 2,228
h Marketing Staff - Fall --- 0 0 0 0 0
i Marketing Director - Summer --- 4 14.00 12 1 672
j Marketing Staff - Summer --- 0 0 0 0 0
k Marketing Director - Winter/Spring --- 15 14.50 22 1 4,785
l Marketing Staff - Winter/Spring --- 5 13.00 11 2 1,430
m Head Designer - Fall --- 15 14.25 11 2 4,703
n Head Designer - Summer --- 40 14.75 12 1 7,080
o Head Designer - Winter/Spring --- 15 15.25 22 2 10,065
p Marketing Project Manager - Fall --- 15 13.75 11 1 2,269
q Copywriter - Winter/Spring --- 12 13.75 22 1 3,630
r Social Media Manager - Fall --- 12 12.50 11 1 1,650
s Social Media Manager - Winter/Spring --- 12 13.50 22 1 3,564
t Copywriter - Fall --- 12 12.75 11 1 1,683
u Marketing Project Manager - Summer --- 14 14.25 12 1 2,394
v Marketing Project Manager - Winter/Spring --- 15 14.75 22 1 4,868
w Aggie Studios Executive Producer - Summer --- 0 0 0 0 0
x Aggie Studios Executive Producer - Fall --- 15 13.25 11 1 2,186
y Aggie Studios Executive Producer - Winter/Spring --- 15 14.25 22 1 4,703
z Aggie Studios Client Media Director - Summer --- 0 0 0 0 0
za Aggie Studios Client Media Director - Fall --- 12 12.50 11 1 1,650
zb Aggie Studios Client Media Director - Winter/Spring --- 12 13.50 22 1 3,564
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 --- 8 12.50 11 1 1,100
zk Aggie Studios Technical Director - Winter/Spring --- 8 13.50 22 1 2,376
zl Lead Computer Programmer - Summer --- 20 15.50 12 0 0
zm Lead Computer Programmer - Fall --- 15 15.00 11 1 2,475
zn Lead Computer Programmer - Winter/Spring --- 15 16.00 22 1 5,280
zo Copywriter - Summer --- 6 13.25 12 1 954
zp Aggie Studios Photographers - Fall --- 8 12.25 11 2 2,156
zq Aggie Studios Photographers - Winter/Spring --- 8 13.25 22 2 4,664

Career
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
a Network Administrator

78,104 85,080 87,632 87,632 87,632
Total Career 78,104 85,080 87,632 87,632 87,632
Start-End Num. Months Paid Pay Per Month Quantity Total
a Network Administrator --- 12 7,302.70 1 87,632

Employee Benefits
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 138,798 153,369 161,288 161,288 161,288
b Total Career 78,104 85,080 87,632 87,632 87,632
Total General Assistance 216,902 238,449 248,920 248,920 248,920
Employee Benefits Casual (a * 0.01900) 2,082 2,623 3,064 3,064 3,064
Employee Benefits Career (b * 0.53980) 39,833 43,569 47,304 47,304 47,304
General Automotive Employee Liability ((a+b) * 0.00639) 0 1,574 1,591 1,591 1,591
Composite Benefit Rate ((a+b) * 0.00220) 0 501 548 548 548
Total Employee Benefits 41,915 48,267 52,507 52,507 52,507