Creative Media

2021 - 2022

Charts
34.02% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
Income 89,500 21,000 8,000 8,000 8,000

Expenses
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
General Assistance / Benefits 301,427 372,630 202,017 202,017 222,390
Administrative / Programmatic -45,493 -42,993 9,607 69,607 69,607
Total Expense 255,934 329,637 211,624 271,624 291,997

Reconciliation
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
Subsidy 166,434 308,637 203,624 263,624 283,997
Transfers To/From Reserve 0 0 0 0 0
Charts
-61.9% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

8,000 10,000 0 0 0
12000 ---

0 0 0 0 0
13000 Graphics Income

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

0 0 0 0 0
15000 Sponsorships

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

8,000 8,000 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 89,500 21,000 8,000 8,000 8,000
Charts
122.35% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
21000 Common Goods Assessment

3,982 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 500 500 500
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 9,000 0 0 0
37000 Repair & Maintenance

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

ASUCD-wide Branding, Promotion, Social Media

0 0 100,000 85,000 85,000
52000 Publicity

400 400 0 0 0
54000 ---

0 0 0 0 0
55000 Software & Licensing

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

10,000 10,000 0 0 0
90500 Network Recharge

0 0 0 0 0
90600 Creative Media Recharge

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

20,000 20,000 0 0 0
93000 ASUCD

0 0 0 0 0
94000 Network Recharge

0 0 0 0 0
Total Expenses -45,493 -42,993 9,607 69,607 69,607
Charts
-45.79% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
a Aggie Studios Executive Producer

0 0 0 0 0
b Aggie Studios Technical Director

0 0 0 0 0
c Aggie Studios Animators

0 0 0 0 0
d Aggie Studios Animators

2,200 0 0 0 0
e Aggie Studios Lead Animators

0 9,000 0 0 0
Total Stipend 2,200 9,000 0 0 0
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 --- --- 0 0 0 0
e Aggie Studios Lead Animators --- --- 0 0 0 0

Hourly
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
---

0 0 0 0 0
a Graphic Designer - Fall

5,346 9,744 10,620 10,620 10,620
b Graphic Designer - Summer

8,064 9,048 3,540 3,540 3,540
c Graphic Designer - Winter/Spring

11,484 18,600 20,790 20,790 20,790
d Computer Programmer - Fall

14,355 19,530 0 0 0
e Computer Programmer - Summer

7,020 9,672 0 0 0
f Computer Programmer - Winter/Spring

30,690 37,125 0 0 0
g Marketing Director - Fall

2,228 3,045 0 0 0
h Marketing Staff - Fall

0 1,484 0 0 0
i Marketing Director - Summer

672 1,131 0 0 0
j Marketing Staff - Summer

0 689 0 0 0
k Marketing Director - Winter/Spring

4,785 5,813 0 0 0
l Marketing Staff - Winter/Spring

1,430 3,563 0 0 0
m Head Designer - Fall

4,703 3,203 0 0 0
n Head Designer - Summer

7,080 2,974 0 0 0
o Head Designer - Winter/Spring

10,065 6,094 0 0 0
p Marketing Project Manager - Fall

2,269 3,098 3,819 3,819 3,819
q Copywriter - Winter/Spring

3,630 4,425 4,158 4,158 4,158
r Social Media Manager - Fall

1,650 4,536 4,248 4,248 4,248
s Social Media Manager - Winter/Spring

3,564 8,700 8,316 8,316 8,316
t Copywriter - Fall

1,683 2,310 2,124 2,124 2,124
u Marketing Project Manager - Summer

2,394 2,301 2,412 2,412 2,412
v Marketing Project Manager - Winter/Spring

4,868 5,906 7,420 7,420 7,420
w Aggie Studios Executive Producer - Summer

0 1,112 1,098 1,098 1,098
x Aggie Studios Executive Producer - Fall

2,186 2,993 3,477 3,477 3,477
y Aggie Studios Executive Producer - Winter/Spring

4,703 5,719 6,793 6,793 6,793
z Aggie Studios Client Media Director - Summer

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

1,650 2,268 2,655 2,655 2,655
zb Aggie Studios Client Media Director - Winter/Spring

3,564 4,350 5,198 5,198 5,198
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

1,100 1,512 2,655 2,655 2,655
zk Aggie Studios Technical Director - Winter/Spring

2,376 2,900 5,198 5,198 5,198
zl Lead Computer Programmer - Summer

0 3,120 0 0 0
zm Lead Computer Programmer - Fall

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

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

954 715 708 708 708
zp Aggie Studios Photographers - Fall

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

4,664 0 0 0 0
zr Aggie Studios Lead Photographers - Fall

0 2,968 0 0 0
zs Aggie Studios Lead Photographers - Winter/Spring

0 5,700 0 0 9,735
zt Social Media Manager - Summer

0 2,106 2,124 2,124 2,124
zu Sponsorship Assistants - Fall

0 4,160 0 0 0
zv Sponsorship Assistants - Winter/Spring

0 8,960 0 0 0
zw Art Director - Summer

0 0 0 0 0
zx Art Director - Fall

0 0 0 0 0
zy Art Director - Winter/Spring

0 0 0 0 10,065
zz Administrative Assistant - Summer

0 0 0 0 0
zza Administrative Assistant - Fall

0 0 0 0 0
zzb Administrative Assistant - Winter/Spring

0 0 0 0 0
Total Hourly 159,088 222,660 98,061 98,061 117,861
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
--- --- 0 0 0 0 0
a Graphic Designer - Fall 9/19/21-1/1/22 12 14.75 12 5 10,620
b Graphic Designer - Summer 6/13/21-9/18/21 4 14.75 12 5 3,540
c Graphic Designer - Winter/Spring 1/2/22-6/11/22 12 15.75 22 5 20,790
d Computer Programmer - Fall --- 0 0 0 0 0
e Computer Programmer - Summer --- 0 0 0 0 0
f Computer Programmer - Winter/Spring --- 0 0 0 0 0
g Marketing Director - Fall --- 0 0 0 0 0
h Marketing Staff - Fall --- 0 0 0 0 0
i Marketing Director - Summer --- 0 0 0 0 0
j Marketing Staff - Summer --- 0 0 0 0 0
k Marketing Director - Winter/Spring --- 0 0 0 0 0
l Marketing Staff - Winter/Spring --- 0 0 0 0 0
m Head Designer - Fall --- 0 0 0 0 0
n Head Designer - Summer --- 0 0 0 0 0
o Head Designer - Winter/Spring --- 0 0 0 0 0
p Marketing Project Manager - Fall 9/19/21-1/1/22 19 16.75 12 1 3,819
q Copywriter - Winter/Spring 1/2/22-6/11/22 12 15.75 22 1 4,158
r Social Media Manager - Fall 9/19/21-1/1/22 12 14.75 12 2 4,248
s Social Media Manager - Winter/Spring 1/2/22-6/11/22 12 15.75 22 2 8,316
t Copywriter - Fall 9/19/21-1/1/22 12 14.75 12 1 2,124
u Marketing Project Manager - Summer 6/13/21-9/18/21 12 16.75 12 1 2,412
v Marketing Project Manager - Winter/Spring 1/2/22-6/11/22 19 17.75 22 1 7,420
w Aggie Studios Executive Producer - Summer 6/13/21-9/18/21 6 15.25 12 1 1,098
x Aggie Studios Executive Producer - Fall 9/19/21-1/1/22 19 15.25 12 1 3,477
y Aggie Studios Executive Producer - Winter/Spring 1/2/22-6/11/22 19 16.25 22 1 6,793
z Aggie Studios Client Media Director - Summer 6/13/21-9/18/21 4 14.75 12 1 708
za Aggie Studios Client Media Director - Fall 9/19/21-1/1/22 15 14.75 12 1 2,655
zb Aggie Studios Client Media Director - Winter/Spring 1/2/22-6/11/22 15 15.75 22 1 5,198
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 6/13/21-9/18/21 0 14.75 12 1 0
zj Aggie Studios Technical Director - Fall 9/19/21-1/1/22 15 14.75 12 1 2,655
zk Aggie Studios Technical Director - Winter/Spring 1/2/22-6/11/22 15 15.75 22 1 5,198
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 6/13/21-9/18/21 4 14.75 12 1 708
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 9/19/21-1/1/22 0 14.75 12 2 0
zs Aggie Studios Lead Photographers - Winter/Spring 1/2/22-6/11/22 15 14.75 22 2 9,735
zt Social Media Manager - Summer 6/13/21-9/18/21 6 14.75 12 2 2,124
zu Sponsorship Assistants - Fall --- 0 0 0 0 0
zv Sponsorship Assistants - Winter/Spring --- 0 0 0 0 0
zw Art Director - Summer 6/13/21-9/18/21 8 15.25 12 0 0
zx Art Director - Fall 9/19/21-1/1/22 15 15.25 12 0 0
zy Art Director - Winter/Spring 1/2/22-6/11/22 15 15.25 22 2 10,065
zz Administrative Assistant - Summer 6/13/21-9/18/21 4 15.25 12 0 0
zza Administrative Assistant - Fall 9/19/21-1/1/22 15 15.25 12 0 0
zzb Administrative Assistant - Winter/Spring 1/2/22-6/11/22 15 16.25 22 0 0

Career
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
a Network Administrator

87,632 87,632 0 0 0
b Full Time Marketing

0 0 66,000 66,000 66,000
Total Career 87,632 87,632 66,000 66,000 66,000
Start-End Num. Months Paid Pay Per Month Quantity Total
a Network Administrator --- 0 0 0 0
b Full Time Marketing 6/13/21-6/11/22 12 5,500.00 1 66,000

Employee Benefits
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 161,288 231,660 98,061 98,061 117,861
b Total Career 87,632 87,632 66,000 66,000 66,000
Total General Assistance 248,920 319,292 164,061 164,061 183,861
Employee Benefits Casual (a * 0.01900) 3,064 4,402 1,863 1,863 2,239
Employee Benefits Career (b * 0.52200) 47,304 45,744 34,452 34,452 34,452
General Automotive Employee Liability ((a+b) * 0.00780) 1,591 2,490 1,280 1,280 1,434
Composite Benefit Rate ((a+b) * 0.00220) 548 702 361 361 404
Total Employee Benefits 52,507 53,338 37,956 37,956 38,529