Bike Barn

2021 - 2022

Charts
-368.77% 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 503,000 307,878 458,000 458,000 458,000

Expenses
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
General Assistance / Benefits 273,480 181,906 282,682 282,682 281,855
Administrative / Programmatic 214,102 126,337 174,337 174,337 174,337
Total Expense 487,582 308,243 457,019 457,019 456,192

Reconciliation
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
Subsidy 0 365 -981 -981 -1,808
Transfers To/From Reserve 15,418 0 0 0 0
Charts
48.76% 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 Parts Sales - Bike Barn

221,000 139,678 200,000 200,000 200,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

106,000 70,000 110,000 110,000 110,000
14000 Rental

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

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

164,000 100,000 140,000 140,000 140,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 0 0 0 0
Total Income 503,000 307,878 458,000 458,000 458,000
Charts
-37.99% 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
---

0 0 0 0 0
21000 Common Goods Assessment

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

300 150 300 300 300
31000 Mail

0 1,500 0 0 0
32000 Office Supplies

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

1,300 0 1,000 1,000 1,000
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

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

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

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

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

0 0 0 0 0
52000 Publicity

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

500 500 1,000 1,000 1,000
54000 Consultant Fees

0 0 0 0 0
55000 Trade Associations

700 750 800 800 800
56000 Uniforms & Shop Aprons

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

0 0 0 0 0
56001 Upkeep for Aggie Bike Buy

0 0 0 0 0
57000 Trade Shows

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 0 0 0
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 214,102 126,337 174,337 174,337 174,337
Charts
-55.4% 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
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
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
0 Business Manager Summer/Fall

8,040 4,278 6,897 6,897 6,897
a Business Manager Winter/Spring

8,375 5,104 8,160 8,160 7,752
b Inventory Manager Summer/Fall

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

7,500 4,945 7,920 7,920 7,524
d Service Manager Summer/Fall

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

16,031 14,355 17,280 17,280 17,280
f Senior Mechanic Summer/Fall

17,472 11,178 17,864 17,864 17,864
g Senior Mechanic Winter/Spring

19,250 13,877 19,344 19,344 19,344
h Mechanic Summer/Fall

40,320 10,764 43,120 43,120 43,120
j Mechanic Winter/Spring

45,500 13,398 46,800 46,800 46,800
Total Hourly 184,298 93,493 188,923 188,923 188,119
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/1/2021-12/31/2021 19.00 16.50 22 1 6,897
a Business Manager Winter/Spring 1/1/2022-6/30/2022 19.00 17.00 24 1 7,752
b Inventory Manager Summer/Fall 7/1/2021-12/31/2021 19.00 16.00 22 1 6,688
c Inventory Manager Winter/Spring 1/1/2022-6/30/2022 19.00 16.50 24 1 7,524
d Service Manager Summer/Fall 7/1/2021-12/31/2021 15.00 15.00 22 3 14,850
e Service Manager Winter/Spring 1/1/2022-6/30/2022 15.00 16.00 24 3 17,280
f Senior Mechanic Summer/Fall 7/1/2021-12/31/2021 14.00 14.50 22 4 17,864
g Senior Mechanic Winter/Spring 1/1/2022-6/30/2022 13.00 15.50 24 4 19,344
h Mechanic Summer/Fall 7/1/2021-12/31/2021 14.00 14.00 22 10 43,120
j Mechanic Winter/Spring 1/1/2022-6/30/2022 13.00 15.00 24 10 46,800

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

54,312 55,941 57,624 57,624 57,624
b ADMIN OFCR 2 (General Manager)

0 0 0 0 0
c Short Term Employee

0 0 0 0 0
Total Career 54,312 55,941 57,624 57,624 57,624
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/2021-6/30/2022 12 4,802.00 1 57,624
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0
c Short Term Employee --- 0 0 0 0

Employee Benefits
2019 - 2020 2020 - 2021 2021 - 2022 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 184,298 93,493 188,923 188,923 188,119
b Total Career 54,312 55,941 57,624 57,624 57,624
Total General Assistance 238,610 149,434 246,547 246,547 245,743
Employee Benefits Casual (a * 0.01900) 3,502 1,776 3,590 3,590 3,574
Employee Benefits Career (b * 0.52200) 29,318 29,201 30,080 30,080 30,080
General Automotive Employee Liability ((a+b) * 0.00780) 1,525 1,166 1,923 1,923 1,917
Composite Benefit Rate ((a+b) * 0.00220) 525 329 542 542 541
Total Employee Benefits 34,870 32,472 36,135 36,135 36,112