Creative Media

2022 - 2023

Previous Years
Things To Do
Prepared By
  • Morayah Horovitz
Budget No.
  • 8041241
Charts
-38.71% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
Income 21,000 8,000 21,000 21,000 21,000
Expenses
 2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
General Assistance / Benefits 372,630 222,560 315,176 315,176 315,176
Administrative / Programmatic -42,993 69,607 100,000 100,000 100,500
Total Expense 329,637 292,167 415,176 415,176 415,676
Reconciliation
 2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
Subsidy 308,637 284,167 394,176 394,176 394,676
Transfers To/From Reserve 0 0 0 0 0
Charts
162.5% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

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

0 0 0 0 0
13000 Graphics Income

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

0 0 0 0 0
15000 Sponsorships

0 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
t0 ---

0 0 0 0 0
Total Income 21,000 8,000 21,000 21,000 21,000
Charts
-43.66% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

3,982 3,982 0 0 0
30000 Copying & Printing

0 0 0 0 0
31000 Mail

0 0 0 0 0
32000 Office Supplies

0 500 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

9,000 0 0 0 0
37000 Repair & Maintenance

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

Bringing product to the audience through brand awareness, loyalty, sales, SWAG, social media, etc.

 		0 85,000 85,000 85,000 85,000
52000 Publicity/Promotion

Communicate a product to the audience through sales, digital promotion, advertising, targeted promotion, etc.

 		400 0 14,500 14,500 14,500
54000 ---

0 0 0 0 0
55000 Software & Licensing

7,000 0 0 0 0
55999 Volunteer Incentive/Retention

Aggie Studios volunteers

 		0 0 0 0 500
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 0 0 0
90000 Admin Recharge

10,000 0 0 0 0
90500 Network Recharge

0 0 0 0 0
90600 Creative Media Recharge

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

0 0 0 0 0
94000 Network Recharge

0 0 0 0 0
Total Expenses -42,993 69,607 100,000 100,000 100,500
Charts
-41.61% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
 2020 - 2021 2021 - 2022 2022 - 2023 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

0 0 0 0 0
e Aggie Studios Lead Animators

9,000 0 0 0 0
Total Stipend 9,000 0 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
 2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
---

0 0 0 0 0
a Graphic Designer - Fall

9,744 10,620 13,950 13,950 13,950
b Graphic Designer - Summer

9,048 3,540 4,030 4,030 4,030
c Graphic Designer - Winter/Spring

18,600 20,790 22,320 22,320 22,320
d Computer Programmer - Fall

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

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

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

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

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

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

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

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

3,563 0 0 0 0
m Sr. Graphic Designer - Fall

3,203 0 0 0 0
n Sr. Graphic Designer - Summer

2,974 0 0 0 0
o Sr. Graphic Designer - Winter/Spring

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

3,098 3,819 5,130 5,130 5,130
q Copywriter - Winter/Spring

4,425 4,158 8,928 8,928 8,928
r Social Media Manager - Fall

4,536 4,248 8,640 8,640 8,640
s Social Media Manager - Winter/Spring

8,700 8,316 13,824 13,824 13,824
t Copywriter - Fall

2,310 2,124 5,580 5,580 5,580
u Marketing Project Manager - Summer

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

5,906 7,420 8,208 8,208 8,208
w Aggie Studios Executive Producer - Summer

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

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

5,719 6,793 8,208 8,208 8,208
z Aggie Studios Client Media Director - Summer

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

2,268 2,655 3,825 3,825 3,825
zb Aggie Studios Client Media Director - Winter/Spring

4,350 5,198 6,120 6,120 6,120
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,512 2,655 2,400 2,400 2,400
zk Aggie Studios Technical Director - Winter/Spring

2,900 5,198 3,072 3,072 3,072
zl Lead Computer Programmer - Summer

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

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

6,800 0 0 0 0
zo Copywriter - Summer

715 708 806 806 806
zp Aggie Studios Photographers - Fall

0 0 3,720 3,720 3,720
zq Aggie Studios Photographers - Winter/Spring

0 0 5,952 5,952 5,952
zr Aggie Studios Lead Photographers - Fall

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

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

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

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

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

0 0 2,652 2,652 2,652
zx Art Director - Fall

0 0 7,650 7,650 7,650
zy Art Director - Winter/Spring

0 10,065 12,240 12,240 12,240
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
zzc Aggie Studios Assistant Client Media Director - Fall

0 0 2,040 2,040 2,040
zzd Aggie Studios Assistant Client Media Director - Winter/Spring

0 0 3,264 3,264 3,264
zze Aggie Studios Animator - Summer

0 0 1,612 1,612 1,612
zzf Aggie Studios Animator - Fall

0 0 3,720 3,720 3,720
zzg Aggie Studios Animator - Winter/Spring

0 0 5,952 5,952 5,952
zzh Aggie Studios Editors - Summer

0 0 3,224 3,224 3,224
zzi Aggie Studios Editors - Fall

0 0 7,440 7,440 7,440
zzj Aggie Studios Editors - Winter/Spring

0 0 11,904 11,904 11,904
zzk Aggie Studios Videographers - Fall

0 0 2,790 2,790 2,790
zzk Aggie Studios Videographers - Winter/Spring

0 0 4,464 4,464 4,464
zzn CM Chief of Staff - Summer

0 0 1,248 1,248 1,248
zzo CM Chief of St - Fall

0 0 3,600 3,600 3,600
zzp CM Chief of Staff - Winter/Spring

0 0 5,760 5,760 5,760
zzq Sr. Social Media Manager Summer/Fall

0 0 0 0 0
zzr Sr. Social Media Manager Winter/Spring

0 0 0 0 0
Total Hourly 222,660 118,026 216,059 216,059 216,059
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
--- --- 0 0 0 0 0
a Graphic Designer - Fall 9/19/22-12/30/22 12.00 15.50 15 5 13,950
b Graphic Designer - Summer 6/16/22-9/16/22 4.00 15.50 13 5 4,030
c Graphic Designer - Winter/Spring 1/2/23-6/15/23 12.00 15.50 24 5 22,320
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 Sr. Graphic Designer - Fall --- 0 0 0 0 0
n Sr. Graphic Designer - Summer --- 0 0 0 0 0
o Sr. Graphic Designer - Winter/Spring --- 0 0 0 0 0
p Marketing Project Manager - Fall 9/19/22-12/30/22 19.00 18.00 15 1 5,130
q Copywriter - Winter/Spring 1/2/23-6/15/23 12.00 15.50 24 2 8,928
r Social Media Manager - Fall 9/19/22-12/30/22 12.00 16.00 15 3 8,640
s Social Media Manager - Winter/Spring 1/2/23-6/15/23 12.00 16.00 24 3 13,824
t Copywriter - Fall 9/19/22-12/30/22 12.00 15.50 15 2 5,580
u Marketing Project Manager - Summer 6/16/22-9/16/22 8.00 18.00 13 1 1,872
v Marketing Project Manager - Winter/Spring 1/2/23-6/15/23 19.00 18.00 24 1 8,208
w Aggie Studios Executive Producer - Summer 6/16/22-9/16/22 6.00 18.00 13 1 1,404
x Aggie Studios Executive Producer - Fall 9/19/22-12/30/22 19.00 18.00 15 1 5,130
y Aggie Studios Executive Producer - Winter/Spring 1/2/23-6/15/23 19.00 18.00 24 1 8,208
z Aggie Studios Client Media Director - Summer 6/16/22-9/16/22 4.00 17.00 13 1 884
za Aggie Studios Client Media Director - Fall 9/19/22-12/30/22 15.00 17.00 15 1 3,825
zb Aggie Studios Client Media Director - Winter/Spring 1/2/23-6/15/23 15.00 17.00 24 1 6,120
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 0
zj Aggie Studios Technical Director - Fall 9/19/22-12/30/22 10.00 16.00 15 1 2,400
zk Aggie Studios Technical Director - Winter/Spring 1/2/23-6/15/23 8.00 16.00 24 1 3,072
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/16/22-9/16/22 2.00 15.50 13 2 806
zp Aggie Studios Photographers - Fall 9/19/22-12/30/22 8.00 15.50 15 2 3,720
zq Aggie Studios Photographers - Winter/Spring 1/2/23-6/15/23 8.00 15.50 24 2 5,952
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 6/16/22-9/16/22 4.00 16.00 13 3 2,496
zu Sponsorship Assistants - Fall --- 0 0 0 0 0
zv Sponsorship Assistants - Winter/Spring --- 0 0 0 0 0
zw Art Director - Summer 6/16/22-9/16/22 6.00 17.00 13 2 2,652
zx Art Director - Fall 9/19/22-12/30/22 15.00 17.00 15 2 7,650
zy Art Director - Winter/Spring 1/2/23-6/15/23 15.00 17.00 24 2 12,240
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
zzc Aggie Studios Assistant Client Media Director - Fall 9/19/22-12/30/22 8.00 17.00 15 1 2,040
zzd Aggie Studios Assistant Client Media Director - Winter/Spring 1/2/23-6/15/23 8.00 17.00 24 1 3,264
zze Aggie Studios Animator - Summer 6/16/22-9/16/22 4.00 15.50 13 2 1,612
zzf Aggie Studios Animator - Fall 9/19/22-12/30/22 8.00 15.50 15 2 3,720
zzg Aggie Studios Animator - Winter/Spring 1/2/23-6/15/23 8.00 15.50 24 2 5,952
zzh Aggie Studios Editors - Summer 6/16/22-9/16/22 8.00 15.50 13 2 3,224
zzi Aggie Studios Editors - Fall 9/19/22-12/30/22 16.00 15.50 15 2 7,440
zzj Aggie Studios Editors - Winter/Spring 1/2/23-6/15/23 16.00 15.50 24 2 11,904
zzk Aggie Studios Videographers - Fall 9/19/22-12/30/22 6.00 15.50 15 2 2,790
zzk Aggie Studios Videographers - Winter/Spring 1/2/23-6/15/23 6.00 15.50 24 2 4,464
zzn CM Chief of Staff - Summer 6/16/22-9/16/22 6.00 16.00 13 1 1,248
zzo CM Chief of St - Fall 9/19/22-12/30/22 15.00 16.00 15 1 3,600
zzp CM Chief of Staff - Winter/Spring 1/2/23-6/15/23 15.00 16.00 24 1 5,760
zzq Sr. Social Media Manager Summer/Fall --- 0 0 0 0 0
zzr Sr. Social Media Manager Winter/Spring --- 0 0 0 0 0
Career
 2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
a Network Administrator

87,632 0 0 0 0
b Marketing Director

0 66,000 60,500 60,500 60,500
Total Career 87,632 66,000 60,500 60,500 60,500
Start-End Num. Months Paid Pay Per Month Quantity Total
a Network Administrator --- 0 0 0 0
b Marketing Director 8/1/2022-6/30/2023 11 5,500.00 1 60,500
Employee Benefits
 2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 231,660 118,026 216,059 216,059 216,059
b Total Career 87,632 66,000 60,500 60,500 60,500
Total General Assistance 319,292 184,026 276,559 276,559 276,559
Employee Benefits Casual (a * 0.01900) 4,402 2,242 4,105 4,105 4,105
Employee Benefits Career (b * 0.52200) 45,744 34,452 31,581 31,581 31,581
General Automotive Employee Liability ((a+b) * 0.00840) 2,490 1,435 2,323 2,323 2,323
Composite Benefit Rate ((a+b) * 0.00220) 702 405 608 608 608
Total Employee Benefits 53,338 38,534 38,617 38,617 38,617