Bike Barn

2019 - 2020

Charts
-42.99% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
Income 427,000 467,000 494,000 503,000 503,000

Expenses
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
General Assistance / Benefits 235,440 257,078 273,730 273,480 273,480
Administrative / Programmatic 186,848 199,102 214,102 214,102 214,102
Total Expense 422,288 456,180 487,832 487,582 487,582

Reconciliation
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 4,712 10,820 6,168 15,418 15,418
Charts
5.78% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

190,000 200,000 220,000 221,000 221,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

95,000 100,000 102,000 106,000 106,000
14000 Rental

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

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

130,000 155,000 160,000 164,000 164,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 -200 -200 -200
Total Income 427,000 467,000 494,000 503,000 503,000
Charts
-7.53% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

0 0 0 0 0
21000 Common Goods Assessment

3,435 3,565 3,565 3,565 3,565
30000 Copying & Printing

300 300 300 300 300
31000 Mail

0 0 0 0 0
32000 Office Supplies

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

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

8,000 11,000 10,000 10,000 10,000
36500 Computer Equipment

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

1,500 1,500 1,500 1,500 1,500
50000 Merchandise for Resale

140,000 162,000 185,000 185,000 185,000
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 8,000 0 0 0
55000 Rental expenses for Aggie Bike Buy Storage

0 0 0 0 0
55000 Trade Associations

0 700 700 700 700
56000 Uniforms & Shop Aprons

0 1,000 1,000 1,000 1,000
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 1,500 1,500 1,500
72000 University Recharge

8,321 3,087 3,087 3,087 3,087
79000 OP Tax

0 0 0 0 0
90000 Admin Recharge

7,142 0 0 0 0
90500 Network Administrator

0 0 0 0 0
90600 Creative Media Recharge

4,500 0 0 0 0
93000 ASUCD

0 0 0 0 0
95000 Indirect Cost Recovery

0 0 0 0 0
Total Expenses 186,848 199,102 214,102 214,102 214,102
Charts
-6.48% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2017 - 2018 2018 - 2019 2019 - 2020 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
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
0 Business Manager Summer/Fall

7,130 7,680 8,160 8,040 8,040
a Business Manager Winter/Spring

7,680 8,500 8,500 8,375 8,375
b Inventory Manager Summer/Fall

5,980 6,480 6,960 6,960 6,960
c Inventory Manager Winter/Spring

6,480 7,250 7,500 7,500 7,500
d Service Manager Summer/Fall

12,679 13,770 14,850 14,850 14,850
e Service Manager Winter/Spring

13,770 15,469 16,031 16,031 16,031
f Senior Mechanic Summer/Fall

14,812 16,128 17,472 17,472 17,472
g Senior Mechanic Winter/Spring

16,128 18,200 19,250 19,250 19,250
h Mechanic Summer/Fall

33,810 36,960 40,320 40,320 40,320
j Mechanic Winter/Spring

36,960 42,000 45,500 45,500 45,500
Total Hourly 155,429 172,437 184,543 184,298 184,298
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/1/2019-12/31/2019 20.00 16.75 24 1 8,040
a Business Manager Winter/Spring 1/1/2020-6/30/2020 20.00 16.75 25 1 8,375
b Inventory Manager Summer/Fall 7/1/2019-12/31/2019 20.00 14.50 24 1 6,960
c Inventory Manager Winter/Spring 1/1/2020-6/30/2020 20.00 15.00 25 1 7,500
d Service Manager Summer/Fall 7/1/2019-12/31/2019 15.00 13.75 24 3 14,850
e Service Manager Winter/Spring 1/1/2020-6/30/2020 15.00 14.25 25 3 16,031
f Senior Mechanic Summer/Fall 7/1/2019-12/31/2019 14.00 13.00 24 4 17,472
g Senior Mechanic Winter/Spring 1/1/2020-6/30/2020 14.00 13.75 25 4 19,250
h Mechanic Summer/Fall 7/1/2019-12/31/2019 14.00 12.00 24 10 40,320
j Mechanic Winter/Spring 1/1/2020-6/30/2020 14.00 13.00 25 10 45,500

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

51,444 52,730 54,312 54,312 54,312
b ADMIN OFCR 2 (General Manager)

0 0 0 0 0
c Short Term Employee

0 0 0 0 0
Total Career 51,444 52,730 54,312 54,312 54,312
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/2019-6/30/2020 12 4,526.00 1 54,312
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0
c Short Term Employee --- 0 0 0 0

Employee Benefits
2017 - 2018 2018 - 2019 2019 - 2020 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 155,429 172,437 184,543 184,298 184,298
b Total Career 51,444 52,730 54,312 54,312 54,312
Total General Assistance 206,873 225,167 238,855 238,610 238,610
Employee Benefits Casual (a * 0.01900) 2,331 2,949 3,506 3,502 3,502
Employee Benefits Career (b * 0.53980) 26,236 27,003 29,318 29,318 29,318
General Automotive Employee Liability ((a+b) * 0.00639) 0 1,486 1,526 1,525 1,525
Composite Benefit Rate ((a+b) * 0.00220) 0 473 525 525 525
Total Employee Benefits 28,567 31,911 34,875 34,870 34,870