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

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

0 0 0 0 0
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
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,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.00 16.00 24 1 7,680
a Business Manager (Winter/Spring) 1/1/2019-6/30/2019; 29-51, exclude: 29, 40-41 20.00 17.00 25 1 8,500
b Inventory Manager (Summer/Fall) 7/1/2018-12/31/2018; 15-28, Excluded: 23, 26-28 20.00 13.50 24 1 6,480
c Inventory Manager (Winter/Spring) 1/1/2019-6/30/2019; 29-51, exclude: 29, 40-41 20.00 14.50 25 1 7,250
d Service Manager (Summer/Fall) 7/1/2018-12/31/2018; 15-28, Excluded: 23, 26-28 15.00 12.75 24 3 13,770
e Service Manager (Winter/Spring) 1/1/2019-6/30/2019; 29-51, exclude: 29, 40-41 15.00 13.75 25 3 15,469
f Senior Mechanic (Summer/Fall) 7/1/2018-12/31/2018; 15-28, Excluded: 23, 26-28 14.00 12.00 24 4 16,128
g Senior Mechanic (Winter/Spring) 1/1/2019-6/30/2019, 29-51, exclude: 29, 40-41 14.00 13.00 25 4 18,200
h Mechanic (Summer/Fall) 7/1/2018-12/31/2018; 15-28, Excluded: 23, 26-28 14.00 11.00 24 10 36,960
j Mechanic (Winter/Spring) 1/1/2019-6/30/2019; 29-51, exclude: 29, 40-41 14.00 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
c Short Term Employee

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
c Short Term Employee --- 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