Bike Barn

2014 - 2015

Previous Years
Things To Do
Prepared By
  • Jelena Weinstein
Budget No.
  • 8041091
Charts
0% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2012 - 2013 2013 - 2014 2014 - 2015 Proposed President's Final Approved
Income 513,246 550,100 447,753 447,753 447,753
Expenses
 2012 - 2013 2013 - 2014 2014 - 2015 Proposed President's Final Approved
General Assistance / Benefits 201,493 221,613 227,456 227,456 227,456
Administrative / Programmatic 313,573 308,380 220,297 220,297 220,297
Total Expense 515,066 529,993 447,753 447,753 447,753
Reconciliation
 2012 - 2013 2013 - 2014 2014 - 2015 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve -1,820 20,107 0 0 0
Charts
-18.61% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Income
 2012 - 2013 2013 - 2014 2014 - 2015 Proposed President's Final Approved
11000 Parts Sales - Bike Barn

$20,833 avg/mo x 12 mo; decreased to reflect actuals

 		260,422 276,000 260,000 260,000 260,000
11500 Parts Sales - Bike hub

Location discontinued

 		36,000 31,200 0 0 0
11800 Parts Sales - Bike Garage

Location discontinued

 		6,000 4,800 0 0 0
12000 Employee Sales

Category Discontinued, Now Factored Into 1100 Part Sales Bike Barn

 		8,000 0 0 0 0
13000 Labor

$6,250 avg/mo x 12 mo; increased to reflect actuals

 		60,000 66,000 75,000 75,000 75,000
14000 Rental

$1,708 avg/mo x 12 mode; creased to reflect actuals

 		55,000 36,000 20,500 20,500 20,500
15000 Bank Card Percent

$<650> avg/mo x 12 mo

 		-8,000 -7,800 -7,800 -7,800 -7,800
16000 Bike Sales

$8,350 avg/mo x 12 mo -Includes Bike Buy; decreased to reflect actuals

 		95,824 144,000 100,200 100,200 100,200
17000 Refunds

Not accounted independently due to business software constraints

 		0 0 0 0 0
17500 ---

0 0 0 0 0
18000 Bad Checks

Reflects actuals

 		0 0 0 0 0
19000 Over and Short

-$12.25 avg/mo x 12 mo

0 -100 -147 -147 -147
Total Income 513,246 550,100 447,753 447,753 447,753
Charts
-28.56% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
 2012 - 2013 2013 - 2014 2014 - 2015 Proposed President's Final Approved
---

0 0 0 0 0
21000 Common Goods Assessment

0 0 0 0 0
30000 Copying & Printing

Copying expenses

 		149 500 500 500 500
31000 Mail

Mailing expenses; adjusted to reflect actuals

 		150 300 100 100 100
32000 Office Supplies

Misc. supplies; adjusted to reflect actuals

 		3,000 1,200 3,000 3,000 3,000
33000 Transportation

No longer applicable; funds being used for Consultant

 		10,000 8,000 0 0 0
34000 Telephone Equipment

2 Phone Lines (1 phone, 1 modem for credit card swipe machine)

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

No longer applicable

 		50 0 0 0 0
35000 Telephone Toll Charges

Long distance costs - calling vendors, etc.

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

No longer applicable

 		70 0 0 0 0
36000 Equipment Purchase

Tools, benches, air compressors, security systems; adjusted to reflect actuals

 		10,000 7,500 7,000 7,000 7,000
36500 Computer Equipment

To be used for digitizing workflow and replacing depreciated equipment; adjusted to reflect actuals

 		10,000 3,000 2,000 2,000 2,000
37000 Repair & Maintenance

Building repairs - Doors/Lighting; Major structural

 		15,000 8,000 8,000 8,000 8,000
50000 Merchandise for Resale

Bike parts for resale

 		230,000 250,000 161,000 161,000 161,000
51000 Services Rendered

0 0 0 0 0
52000 Publicity

Advertising; creating websites, Bike History Conference; Marketing for Aggie Bike Buy; can be used towards creative media if needed

 		5,000 2,200 2,200 2,200 2,200
53000 Staff Development

Bi-annual shop party; manager's meetings

 		1,000 2,000 1,000 1,000 1,000
54000 Consultant Fees

Funds paying for Consultant for the year

 		0 0 8,000 8,000 8,000
55000 Rental expenses for Aggie Bike Buy Storage

No longer Applicable

 		2,500 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

Now under 50000 - Merchandise for Re\sale

 		1,474 0 0 0 0
56001 Upkeep for Aggie Bike Buy

No longer Applicable

 		1,200 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,460 1,500 1,500 1,500 1,500
72000 University Recharge

15,000 15,000 15,000 15,000 15,000
79000 OP Tax

2,320 153 0 0 0
90000 Admin Recharge

3,500 3,500 5,470 5,470 5,470
90500 Network Administrator

0 2,847 2,847 2,847 2,847
90600 Creative Media Recharge

0 1,000 1,000 1,000 1,000
93000 ASUCD

0 0 0 0 0
95000 Indirect Cost Recovery

0 0 0 0 0
Total Expenses 313,573 308,380 220,297 220,297 220,297
Charts
-2.64% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
 2012 - 2013 2013 - 2014 2014 - 2015 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
 2012 - 2013 2013 - 2014 2014 - 2015 Proposed President's Final Approved
0 Business Manager Summer/Fall

17,100 0 0 0 0
a Business Manager Winter/Spring

7,429 9,880 13,160 13,160 13,160
b Inventory Manager Summer/Fall

5,985 7,980 0 0 0
c Inventory Manager Winter/Spring

5,700 7,980 10,810 10,810 10,810
d Service Manager Summer/Fall

9,263 7,600 0 0 0
e Service Manager Winter/Spring

32,490 44,460 50,525 50,525 50,525
f Senior Mechanic Summer/Fall

6,460 30,780 28,200 28,200 28,200
g Senior Mechanic Winter/Spring

17,556 14,108 19,564 19,564 19,564
h Mechanic Summer/Fall

19,760 27,360 31,725 31,725 31,725
j Mechanic Winter/Spring

10,260 0 0 0 0
Total Hourly 132,003 150,148 153,984 153,984 153,984
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/07/13-6/07/14 0 0 0 0 0
a Business Manager Winter/Spring 7/07/13-6/07/14 20.00 14.00 47 1 13,160
b Inventory Manager Summer/Fall 7/07/13-6/07/14 0 0 0 0 0
c Inventory Manager Winter/Spring 7/07/13-6/07/14 20.00 11.50 47 1 10,810
d Service Manager Summer/Fall 7/07/13-6/07/14 0 0 0 0 0
e Service Manager Winter/Spring 7/07/13-6/07/14 20.00 10.75 47 5 50,525
f Senior Mechanic Summer/Fall 7/07/13-6/07/14 15.00 10.00 47 4 28,200
g Senior Mechanic Winter/Spring 7/07/13-6/07/14 15.00 9.25 47 3 19,564
h Mechanic Summer/Fall 7/07/13-6/07/14 15.00 9.00 47 5 31,725
j Mechanic Winter/Spring 3/30/13-3/30/14 0 0 0 0 0
Career
 2012 - 2013 2013 - 2014 2014 - 2015 Proposed President's Final Approved
a Blank Assistant III (General Manager)

47,000 47,000 47,520 47,520 47,520
b ADMIN OFCR 2 (General Manager)

0 0 0 0 0
c Short Term Employee

0 0 0 0 0
Total Career 47,000 47,000 47,520 47,520 47,520
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/13-6/30/14 12 3,960.00 1 47,520
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0
c Short Term Employee --- 0 0 0 0
Employee Benefits
 2012 - 2013 2013 - 2014 2014 - 2015 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 132,003 150,148 153,984 153,984 153,984
b Total Career 47,000 47,000 47,520 47,520 47,520
Total General Assistance 179,003 197,148 201,504 201,504 201,504
Employee Benefits Casual (a * 0.01300) 1,716 1,952 2,002 2,002 2,002
Employee Benefits Career (b * 0.50400) 20,774 22,513 23,950 23,950 23,950
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 22,490 24,465 25,952 25,952 25,952