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 Trade Shows

0 0 0 0 0
55000 Rental expenses for Aggie Bike Buy Storage

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
88888 Aramark Services

0 0 0 0 0
88888 Promotional

0 0 0 0 0
88888 University Recharge

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