Bike Barn

2022 - 2023

Charts
149.56% 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 307,878 458,000 472,000 472,000 472,000

Expenses
2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
General Assistance / Benefits 181,906 281,855 290,201 290,201 290,201
Administrative / Programmatic 126,337 174,337 177,287 176,087 176,087
Total Expense 308,243 456,192 467,488 466,288 466,288

Reconciliation
2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
Subsidy 365 -1,808 -4,512 -5,712 -5,712
Transfers To/From Reserve 0 0 0 0 0
Charts
3.06% 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 Parts Sales - Bike Barn

139,678 200,000 200,000 200,000 200,000
12000 Employee Sales

0 0 0 0 0
13000 Labor

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

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

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

100,000 140,000 150,000 150,000 150,000
17000 Refunds

0 0 0 0 0
18000 Bad Checks

0 0 0 0 0
19000 Over and Short

0 0 0 0 0
Total Income 307,878 458,000 472,000 472,000 472,000
Charts
-1.69% 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

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

150 300 300 300 300
31000 Mail

1,500 0 0 0 0
32000 Office Supplies

Printing paper, post it notes, pens, ink, envelopes, etc

1,500 2,000 500 500 500
33000 Transportation

Attending trade shows, events, trainings, etc.

0 1,000 1,500 1,500 1,500
34000 Telephone Equipment

0 0 0 0 0
35000 Telephone Toll Charges

150 150 150 150 150
36000 Equipment Purchase

Tools, shop supplies, repair equipment, etc.

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

2,000 0 0 0 0
37000 Repair & Maintenance

Building Maintenance and Repair (plumbing issues, lighting issues, AC/heating maintenance, etc)

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

92,500 147,000 150,000 150,000 150,000
52000 Publicity

Banners, A-frames, vinyl, social media etc.

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

Staff engagement, development, entertainment, and experience (e.g. events, staff lunches, coffee for a morning managers' meeting)

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

0 0 0 0 0
55000 Trade Associations

750 800 500 800 800
56000 Uniforms & Shop Aprons

Mechanic shirts, aprons, gloves, faceshields, safety glasses, etc.

500 1,500 1,250 1,250 1,250
57000 Trade Shows

Registration, housing, meals

0 0 1,500 1,500 1,500
60000 Benefits

0 0 0 0 0
71000 Replacement Reserve

1,500 0 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 126,337 174,337 177,287 176,087 176,087
Charts
-2.96% 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
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
2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
0 Business Manager Summer/Fall

4,278 6,897 6,358 6,358 6,358
a Business Manager Winter/Spring

5,104 7,752 7,140 7,140 7,140
b Inventory Manager Summer/Fall

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

4,945 7,524 6,936 6,936 6,936
d Service Manager Summer/Fall

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

14,355 17,280 17,820 17,820 17,820
f Senior Mechanic Summer/Fall

11,178 17,864 19,096 19,096 19,096
g Senior Mechanic Winter/Spring

13,877 19,344 21,504 21,504 21,504
h Mechanic Summer/Fall

10,764 43,120 43,560 43,560 43,560
j Mechanic Winter/Spring

13,398 46,800 49,104 49,104 49,104
Total Hourly 93,493 188,119 193,529 193,529 193,529
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/1/2022-12/31/2022 17.00 17.00 22 1 6,358
a Business Manager Winter/Spring 1/1/2023-6/30/2023 17.00 17.50 24 1 7,140
b Inventory Manager Summer/Fall 7/1/2022-12/31/2022 17.00 16.50 22 1 6,171
c Inventory Manager Winter/Spring 1/1/2023-6/30/2023 17.00 17.00 24 1 6,936
d Service Manager Summer/Fall 7/1/2022-12/31/2022 15.00 16.00 22 3 15,840
e Service Manager Winter/Spring 1/1/2023-6/30/2023 15.00 16.50 24 3 17,820
f Senior Mechanic Summer/Fall 7/1/2022-12/31/2022 14.00 15.50 22 4 19,096
g Senior Mechanic Winter/Spring 1/1/2023-6/30/2023 14.00 16.00 24 4 21,504
h Mechanic Summer/Fall 7/1/2022-12/31/2022 11.00 15.00 22 12 43,560
j Mechanic Winter/Spring 1/1/2023-6/30/2023 11.00 15.50 24 12 49,104

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

55,941 57,624 0 59,340 0
b ADMIN OFCR 2 (General Manager)

0 0 59,340 0 59,340
c Short Term Employee

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

Employee Benefits
2020 - 2021 2021 - 2022 2022 - 2023 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 93,493 188,119 193,529 193,529 193,529
b Total Career 55,941 57,624 59,340 59,340 59,340
Total General Assistance 149,434 245,743 252,869 252,869 252,869
Employee Benefits Casual (a * 0.01900) 1,776 3,574 3,677 3,677 3,677
Employee Benefits Career (b * 0.52200) 29,201 30,080 30,975 30,975 30,975
General Automotive Employee Liability ((a+b) * 0.00840) 1,166 1,917 2,124 2,124 2,124
Composite Benefit Rate ((a+b) * 0.00220) 329 541 556 556 556
Total Employee Benefits 32,472 36,112 37,332 37,332 37,332