Bike Barn

2011 - 2012

Charts
0% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
Income 432,151 461,324 462,427 462,427 462,427

Expenses
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
General Assistance / Benefits 153,092 169,371 170,474 170,474 170,474
Administrative / Programmatic 279,059 291,953 291,953 291,953 291,953
Total Expense 432,151 461,324 462,427 462,427 462,427

Reconciliation
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 0 0 0 0 0
Charts
0.24% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Income
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
11000 Parts Sales - Bike Barn

$20,333 avg/mo x 12 mo

229,151 244,000 244,000 244,000 244,000
11500 Parts Sales - Bike hub

0 0 0 0 0
11800 Parts Sales - Bike Garage

0 0 0 0 0
12000 Employee Sales

$666 avg/mo x 12 mo

6,000 8,000 8,000 8,000 8,000
13000 Labor

$5,500 avg/mo x 12 mo

62,000 66,000 66,000 66,000 66,000
14000 Rental

$4,583 avg/mo x 12 mo

55,000 55,000 55,000 55,000 55,000
15000 Bank Card Percent

$<500> avg/mo x 12 mo

-6,000 -6,000 -6,000 -6,000 -6,000
16000 Bike Sales

$7,860 avg/mo x 12 mo

86,000 94,324 95,427 95,427 95,427
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

0 0 0 0 0
Total Income 432,151 461,324 462,427 462,427 462,427
Charts
0.0% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
2009 - 2010 2010 - 2011 2011 - 2012 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 149 149 149 149
31000 Mail

Mailing expenses

150 150 150 150 150
32000 Office Supplies

Misc. supplies

3,000 3,500 3,500 3,500 3,500
33000 Transportation

Transportation costs to attend workshops/ trade shows/certification/training seminar

4,000 4,000 4,000 4,000 4,000
34000 Telephone Equipment

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

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

0 0 0 0 0
35000 Telephone Toll Charges

Long distance costs - calling vendors, etc.

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

0 0 0 0 0
36000 Equipment Purchase

Tools, benches, air compressors

10,000 10,000 10,000 10,000 10,000
36500 Computer Equipment

Computer software and hardware products

4,000 4,000 4,000 4,000 4,000
37000 Repair & Maintenance

Building repairs - Doors/Lighting

12,000 13,000 13,000 13,000 13,000
50000 Merchandise for Resale

Bike parts for resale

220,000 229,994 229,994 229,994 229,994
51000 Services Rendered

0 0 0 0 0
52000 Publicity

Advertising; creating websites, Bike History Conference

4,000 4,500 4,500 4,500 4,500
53000 Staff Development

Bi-annual shop party; manager's meetings

900 1,000 1,000 1,000 1,000
54000 Consultant Fees

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

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

0 0 0 0 0
90000 Admin Recharge

3,500 3,500 3,500 3,500 3,500
90500 Network Administrator

0 0 0 0 0
90600 Creative Media Recharge

0 0 0 0 0
93000 ASUCD

0 0 0 0 0
95000 Indirect Cost Recovery

0 0 0 0 0
Total Expenses 279,059 291,953 291,953 291,953 291,953
Charts
-0.65% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
2009 - 2010 2010 - 2011 2011 - 2012 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
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
0 Business Manager Summer/Fall

0 0 0 0 0
a Business Manager Winter/Spring

13,597 18,130 18,130 18,130 18,130
b Inventory Manager Summer/Fall

13,965 17,640 17,640 17,640 17,640
c Inventory Manager Winter/Spring

15,680 15,680 15,680 15,680 15,680
d Service Manager Summer/Fall

16,170 16,170 16,170 16,170 16,170
e Service Manager Winter/Spring

10,290 10,780 10,780 10,780 10,780
f Senior Mechanic Summer/Fall

8,330 12,495 12,495 12,495 12,495
g Senior Mechanic Winter/Spring

8,575 8,575 8,575 8,575 8,575
h Mechanic Summer/Fall

8,820 8,330 8,330 8,330 8,330
j Mechanic Winter/Spring

0 0 0 0 0
Total Hourly 95,427 107,800 107,800 107,800 107,800
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall --- 0 0 0 0 0
a Business Manager Winter/Spring 7/10/11-6/09/12 40.00 9.25 49 1 18,130
b Inventory Manager Summer/Fall 7/10/11-6/09/12 40.00 9.00 49 1 17,640
c Inventory Manager Winter/Spring 7/10/11-6/09/12 40.00 8.00 49 1 15,680
d Service Manager Summer/Fall 7/10/11-6/09/12 40.00 8.25 49 1 16,170
e Service Manager Winter/Spring 7/10/11-6/09/12 20.00 11.00 49 1 10,780
f Senior Mechanic Summer/Fall 7/10/11-6/09/12 30.00 8.50 49 1 12,495
g Senior Mechanic Winter/Spring 7/10/11-6/09/12 20.00 8.75 49 1 8,575
h Mechanic Summer/Fall 7/10/11-6/09/12 20.00 8.50 49 1 8,330
j Mechanic Winter/Spring --- 0 0 0 0 0

Career
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
a Blank Assistant III (General Manager)

41,047 43,704 43,704 43,704 43,704
b ADMIN OFCR 2 (General Manager)

0 0 0 0 0
c Short Term Employee

0 0 0 0 0
Total Career 41,047 43,704 43,704 43,704 43,704
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/11-6/30/12 12 3,642.00 1 43,704
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0
c Short Term Employee --- 0 0 0 0

Employee Benefits
2009 - 2010 2010 - 2011 2011 - 2012 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 95,427 107,800 107,800 107,800 107,800
b Total Career 41,047 43,704 43,704 43,704 43,704
Total General Assistance 136,474 151,504 151,504 151,504 151,504
Employee Benefits Casual (a * 0.01300) 2,662 3,008 1,401 1,401 1,401
Employee Benefits Career (b * 0.40200) 13,956 14,859 17,569 17,569 17,569
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 16,618 17,867 18,970 18,970 18,970