Bike Barn

2018 - 2019

Charts
37.65% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2016 - 2017 2017 - 2018 2018 - 2019 Proposed President's Final Approved
Income 462,047 427,000 457,000 467,000 467,000

Expenses
2016 - 2017 2017 - 2018 2018 - 2019 Proposed President's Final Approved
General Assistance / Benefits 227,070 235,440 246,412 257,078 257,078
Administrative / Programmatic 201,626 186,848 204,102 199,102 199,102
Total Expense 428,696 422,288 450,514 456,180 456,180

Reconciliation
2016 - 2017 2017 - 2018 2018 - 2019 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 33,351 4,712 6,486 10,820 10,820
Charts
7.03% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

215,000 190,000 190,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

95,000 95,000 100,000 100,000 100,000
14000 Rental

35,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

125,000 130,000 155,000 155,000 155,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

-153 -200 -200 -200 -200
Total Income 462,047 427,000 457,000 467,000 467,000
Charts
-9.23% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

0 0 0 0 0
21000 Common Goods Assessment

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

100 300 300 300 300
31000 Mail

1 0 0 0 0
32000 Office Supplies

1,300 1,500 1,500 1,500 1,500
33000 Transportation

0 0 2,800 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

2,000 8,000 12,000 11,000 11,000
36500 Computer Equipment

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

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

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

0 0 0 0 0
55000 Trade Associations

0 0 700 700 700
56000 Uniforms & Shop Aprons

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

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

0 0 0 0 0
90000 Admin Recharge

6,825 7,142 0 0 0
90500 Network Administrator

0 0 0 0 0
90600 Creative Media Recharge

4,500 4,500 0 0 0
93000 ASUCD

0 0 0 0 0
95000 Indirect Cost Recovery

0 0 0 0 0
Total Expenses 201,626 186,848 204,102 199,102 199,102
Charts
-4.66% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

6,900 7,130 7,440 7,680 7,680
a Business Manager Winter/Spring

7,440 7,680 8,000 8,500 8,500
b Inventory Manager Summer/Fall

5,750 5,980 6,240 6,480 6,480
c Inventory Manager Winter/Spring

6,240 6,480 6,750 7,250 7,250
d Service Manager Summer/Fall

12,161 12,679 13,230 13,770 13,770
e Service Manager Winter/Spring

13,230 13,770 14,344 15,469 15,469
f Senior Mechanic Summer/Fall

14,168 14,812 15,456 16,128 16,128
g Senior Mechanic Winter/Spring

15,456 16,128 16,800 18,200 18,200
h Mechanic Summer/Fall

32,200 33,810 35,280 36,960 36,960
j Mechanic Winter/Spring

35,280 36,960 38,500 42,000 42,000
Total Hourly 148,825 155,429 162,040 172,437 172,437
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/1/2018-12/31/2018 ; 15-28, Excluded: 23, 26-28 20 16.00 24 1 7,680
a Business Manager Winter/Spring 1/1/2019-6/30/2019; 29-51, exclude: 29, 40-41 20 17.00 25 1 8,500
b Inventory Manager Summer/Fall 7/1/2018-12/31/2018; 15-28, Excluded: 23, 26-28 20 13.50 24 1 6,480
c Inventory Manager Winter/Spring 1/1/2019-6/30/2019; 29-51, exclude: 29, 40-41 20 14.50 25 1 7,250
d Service Manager Summer/Fall 7/1/2018-12/31/2018; 15-28, Excluded: 23, 26-28 15 12.75 24 3 13,770
e Service Manager Winter/Spring 1/1/2019-6/30/2019; 29-51, exclude: 29, 40-41 15 13.75 25 3 15,469
f Senior Mechanic Summer/Fall 7/1/2018-12/31/2018; 15-28, Excluded: 23, 26-28 14 12.00 24 4 16,128
g Senior Mechanic Winter/Spring 1/1/2019-6/30/2019, 29-51, exclude: 29, 40-41 14 13.00 25 4 18,200
h Mechanic Summer/Fall 7/1/2018-12/31/2018; 15-28, Excluded: 23, 26-28 14 11.00 24 10 36,960
j Mechanic Winter/Spring 1/1/2019-6/30/2019; 29-51, exclude: 29, 40-41 14 12.00 25 10 42,000

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

50,436 51,444 52,730 52,730 52,730
b ADMIN OFCR 2 (General Manager)

0 0 0 0 0
Total Career 50,436 51,444 52,730 52,730 52,730
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/2018-6/30/2018 12 4,394.18 1 52,730
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0

Employee Benefits
2016 - 2017 2017 - 2018 2018 - 2019 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 148,825 155,429 162,040 172,437 172,437
b Total Career 50,436 51,444 52,730 52,730 52,730
Total General Assistance 199,261 206,873 214,770 225,167 225,167
Employee Benefits Casual (a * 0.01710) 1,935 2,331 2,771 2,949 2,949
Employee Benefits Career (b * 0.51210) 25,874 26,236 27,003 27,003 27,003
General Automotive Employee Liability ((a+b) * 0.00660) 0 0 1,417 1,486 1,486
Composite Benefit Rate ((a+b) * 0.00210) 0 0 451 473 473
Total Employee Benefits 27,809 28,567 31,642 31,911 31,911