Bike Barn

2020 - 2021

Charts
-97.91% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
Income 467,000 503,000 308,200 310,200 310,200

Expenses
2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
General Assistance / Benefits 257,078 273,480 181,541 181,541 181,541
Administrative / Programmatic 199,102 214,102 126,337 126,337 126,337
Total Expense 456,180 487,582 307,878 307,878 307,878

Reconciliation
2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 10,820 15,418 322 2,322 2,322
Charts
-38.73% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Income
2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
11000 Parts Sales - Bike Barn

200,000 221,000 140,000 142,000 142,000
11500 Parts Sales - Bike hub

0 0 0 0 0
11800 Parts Sales - Bike Garage

0 0 0 0 0
12000 Employee Sales

0 0 0 0 0
13000 Labor

100,000 106,000 70,000 70,000 70,000
14000 Rental

20,000 20,000 2,000 2,000 2,000
15000 Bank Card Percent

-7,800 -7,800 -3,800 -3,800 -3,800
16000 Bike Sales

155,000 164,000 100,000 100,000 100,000
17000 Refunds

0 0 0 0 0
17500 ---

0 0 0 0 0
18000 Bad Checks

0 0 0 0 0
19000 Over and Short

-200 -200 0 0 0
Total Income 467,000 503,000 308,200 310,200 310,200
Charts
-40.99% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
---

0 0 0 0 0
21000 Common Goods Assessment

3,565 3,565 1,200 1,200 1,200
30000 Copying & Printing

300 300 150 150 150
31000 Mail

0 0 1,500 1,500 1,500
32000 Office Supplies

1,500 2,500 1,500 1,500 1,500
33000 Transportation

1,300 1,300 0 0 0
34000 Telephone Equipment

0 0 0 0 0
34002 Telephone Equip - Bike Hub

0 0 0 0 0
35000 Telephone Toll Charges

150 150 150 150 150
35002 Telephone Toll Charges - Bike Hub

0 0 0 0 0
36000 Equipment Purchase

11,000 10,000 5,000 5,000 5,000
36500 Computer Equipment

2,000 2,000 2,000 2,000 2,000
37000 Repair & Maintenance

1,500 1,500 15,000 15,000 15,000
50000 Merchandise for Resale

162,000 185,000 92,500 92,500 92,500
51000 Services Rendered

0 0 0 0 0
52000 Publicity

1,000 1,000 1,000 1,000 1,000
53000 Staff Development

500 500 500 500 500
54000 Consultant Fees

8,000 0 0 0 0
55000 Trade Associations

700 700 750 750 750
55000 Rental expenses for Aggie Bike Buy Storage

0 0 0 0 0
56000 Uniforms & Shop Aprons

1,000 1,000 500 500 500
56000 Bike Garage Merchandise for Resale

0 0 0 0 0
56001 Upkeep for Aggie Bike Buy

0 0 0 0 0
60000 Benefits

0 0 0 0 0
70000 Allowance for Uncollectables

0 0 0 0 0
71000 Replacement Reserve

1,500 1,500 1,500 1,500 1,500
72000 University Recharge

3,087 3,087 3,087 3,087 3,087
79000 OP Tax

0 0 0 0 0
90000 Admin Recharge

0 0 0 0 0
90500 Network Administrator

0 0 0 0 0
90600 Creative Media Recharge

0 0 0 0 0
93000 ASUCD

0 0 0 0 0
95000 Indirect Cost Recovery

0 0 0 0 0
Total Expenses 199,102 214,102 126,337 126,337 126,337
Charts
-33.62% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
There are no Stipend entries.
Total Stipend 0 0 0 0 0
Start-End Weeks Pay Per Week Num. Weeks Quantity Total
There are no stipend entries.

Hourly
2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
0 Business Manager Summer/Fall

7,680 8,040 4,278 4,278 4,278
a Business Manager Winter/Spring

8,500 8,375 5,104 5,104 5,104
b Inventory Manager Summer/Fall

6,480 6,960 4,002 4,002 4,002
c Inventory Manager Winter/Spring

7,250 7,500 4,945 4,945 4,945
d Service Manager Summer/Fall

13,770 14,850 11,592 11,592 11,592
e Service Manager Winter/Spring

15,469 16,031 14,355 14,355 14,355
f Senior Mechanic Summer/Fall

16,128 17,472 11,178 11,178 11,178
g Senior Mechanic Winter/Spring

18,200 19,250 13,877 13,877 13,877
h Mechanic Summer/Fall

36,960 40,320 10,764 10,764 10,764
j Mechanic Winter/Spring

42,000 45,500 13,398 13,398 13,398
Total Hourly 172,437 184,298 93,493 93,493 93,493
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 07/01/2020-12/11/2020 12 15.50 23 1 4,278
a Business Manager Winter/Spring 01/04/2021-06/30/2021 11 16.00 29 1 5,104
b Inventory Manager Summer/Fall 07/01/2020-12/11/2020 12 14.50 23 1 4,002
c Inventory Manager Winter/Spring 01/04/2021-06/30/2021 11 15.50 29 1 4,945
d Service Manager Summer/Fall 07/01/2020-12/11/2020 12 14.00 23 3 11,592
e Service Manager Winter/Spring 01/04/2021-06/30/2021 11 15.00 29 3 14,355
f Senior Mechanic Summer/Fall 07/01/2020-12/11/2020 12 13.50 23 3 11,178
g Senior Mechanic Winter/Spring 01/04/2021-06/30/2021 11 14.50 29 3 13,877
h Mechanic Summer/Fall 07/01/2020-12/11/2020 12 13.00 23 3 10,764
j Mechanic Winter/Spring 01/04/2021-06/30/2021 11 14.00 29 3 13,398

Career
2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
a Blank Assistant III (General Manager)

52,730 54,312 55,941 55,941 55,941
Total Career 52,730 54,312 55,941 55,941 55,941
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 07/01/2020-06/30/2021 12 4,661.75 1 55,941

Employee Benefits
2018 - 2019 2019 - 2020 2020 - 2021 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 172,437 184,298 93,493 93,493 93,493
b Total Career 52,730 54,312 55,941 55,941 55,941
Total General Assistance 225,167 238,610 149,434 149,434 149,434
Employee Benefits Casual (a * 0.01900) 2,949 3,502 1,776 1,776 1,776
Employee Benefits Career (b * 0.51600) 27,003 29,318 28,866 28,866 28,866
General Automotive Employee Liability ((a+b) * 0.00760) 1,486 1,525 1,136 1,136 1,136
Composite Benefit Rate ((a+b) * 0.00220) 473 525 329 329 329
Total Employee Benefits 31,911 34,870 32,107 32,107 32,107