Bike Barn

2017 - 2018

Charts
-85.87% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
Income 506,969 462,047 427,000 427,000 427,000

Expenses
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
General Assistance / Benefits 211,582 227,070 235,440 235,440 235,440
Administrative / Programmatic 198,127 201,626 186,848 186,848 186,848
Total Expense 409,709 428,696 422,288 422,288 422,288

Reconciliation
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 97,260 33,351 4,712 4,712 4,712
Charts
-7.59% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

245,000 215,000 190,000 190,000 190,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 95,000 95,000 95,000
14000 Rental

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

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

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

-231 -153 -200 -200 -200
Total Income 506,969 462,047 427,000 427,000 427,000
Charts
-7.33% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

0 0 0 0 0
21000 Common Goods Assessment

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

500 100 300 300 300
31000 Mail

100 1 0 0 0
32000 Office Supplies

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

0 0 0 0 0
34000 Telephone Equipment

1,500 0 0 0 0
34002 Telephone Equip - Bike Hub

0 0 0 0 0
35000 Telephone Toll Charges

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

0 0 0 0 0
36000 Equipment Purchase

2,000 2,000 8,000 8,000 8,000
36500 Computer Equipment

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

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

150,000 145,000 140,000 140,000 140,000
51000 Services Rendered

0 0 0 0 0
52000 Publicity

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

1,000 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 0 0 0
56000 Uniforms & Shop Aprons

0 0 0 0 0
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,000 15,750 8,321 8,321 8,321
79000 OP Tax

0 0 0 0 0
90000 Admin Recharge

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

2,847 0 0 0 0
90600 Creative Media Recharge

1,000 4,500 4,500 4,500 4,500
93000 ASUCD

0 0 0 0 0
95000 Indirect Cost Recovery

0 0 0 0 0
Total Expenses 198,127 201,626 186,848 186,848 186,848
Charts
-3.69% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

0 6,900 7,130 7,130 7,130
a Business Manager Winter/Spring

14,100 7,440 7,680 7,680 7,680
b Inventory Manager Summer/Fall

0 5,750 5,980 5,980 5,980
c Inventory Manager Winter/Spring

11,750 6,240 6,480 6,480 6,480
d Service Manager Summer/Fall

0 12,161 12,679 12,679 12,679
e Service Manager Winter/Spring

44,180 13,230 13,770 13,770 13,770
f Senior Mechanic Summer/Fall

22,748 14,168 14,812 14,812 14,812
g Senior Mechanic Winter/Spring

19,270 15,456 16,128 16,128 16,128
h Mechanic Summer/Fall

23,500 32,200 33,810 33,810 33,810
j Mechanic Winter/Spring

0 35,280 36,960 36,960 36,960
Total Hourly 135,548 148,825 155,429 155,429 155,429
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/07/16-12/31/16 20.00 15.50 23 1 7,130
a Business Manager Winter/Spring 1/1/17-6/30/17 20.00 16.00 24 1 7,680
b Inventory Manager Summer/Fall 7/07/16-12/31/16 20.00 13.00 23 1 5,980
c Inventory Manager Winter/Spring 1/1/17-6/30/17 20.00 13.50 24 1 6,480
d Service Manager Summer/Fall 7/07/16-12/31/16 15.00 12.25 23 3 12,679
e Service Manager Winter/Spring 1/1/17-6/30/17 15.00 12.75 24 3 13,770
f Senior Mechanic Summer/Fall 7/07/16-12/31/16 14.00 11.50 23 4 14,812
g Senior Mechanic Winter/Spring 1/1/17-6/30/17 14.00 12.00 24 4 16,128
h Mechanic Summer/Fall 7/07/16-12/31/16 14.00 10.50 23 10 33,810
j Mechanic Winter/Spring 1/1/17-6/30/17 14.00 11.00 24 10 36,960

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

48,960 50,436 51,444 51,444 51,444
b ADMIN OFCR 2 (General Manager)

0 0 0 0 0
c Short Term Employee

0 0 0 0 0
Total Career 48,960 50,436 51,444 51,444 51,444
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/16-6/30/17 12 4,287.00 1 51,444
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0
c Short Term Employee --- 0 0 0 0

Employee Benefits
2015 - 2016 2016 - 2017 2017 - 2018 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 135,548 148,825 155,429 155,429 155,429
b Total Career 48,960 50,436 51,444 51,444 51,444
Total General Assistance 184,508 199,261 206,873 206,873 206,873
Employee Benefits Casual (a * 0.01500) 1,762 1,935 2,331 2,331 2,331
Employee Benefits Career (b * 0.51000) 25,312 25,874 26,236 26,236 26,236
General Automotive Employee Liability ((a+b) * 0.00000) 0 0 0 0 0
Composite Benefit Rate ((a+b) * 0.00000) 0 0 0 0 0
Total Employee Benefits 27,074 27,809 28,567 28,567 28,567