Bike Barn

2012 - 2013

Previous Years
Things To Do
Prepared By
  • Amelia Badish
  • Basile Senesi
  • Robert St.
Budget No.
  • 8041091
Charts
0% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
Income 461,324 462,427 513,246 513,246 513,246
Expenses
 2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
General Assistance / Benefits 169,371 170,474 201,493 201,493 201,493
Administrative / Programmatic 291,953 291,953 314,073 313,573 313,573
Total Expense 461,324 462,427 515,566 515,066 515,066
Reconciliation
 2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 0 0 -2,320 -1,820 -1,820
Charts
10.99% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

$20,333 avg/mo x 12 mo

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

$3000 avg/mo x 12 mo

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

$500avg/mo x 12 mo

 		0 0 6,000 6,000 6,000
12000 Employee Sales

$666 avg/mo x 12 mo

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

$5,500 avg/mo x 12 mo

 		66,000 66,000 60,000 60,000 60,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 -8,000 -8,000 -8,000
16000 Bike Sales

$7,860 avg/mo x 12 mo

 		94,324 95,427 95,824 95,824 95,824
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 461,324 462,427 513,246 513,246 513,246
Charts
-7.58% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
 2010 - 2011 2011 - 2012 2012 - 2013 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,500 3,500 3,500 3,000 3,000
33000 Transportation

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

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

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

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

20 per phone + 10 depreciation credit

 		0 0 50 50 50
35000 Telephone Toll Charges

Long distance costs - calling vendors, etc.

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

Additional Line + set up costs

 		0 0 70 70 70
36000 Equipment Purchase

Tools, benches, air compressors

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

To be used for digitizing workflow and replacing depreciated equipment

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

Building repairs - Doors/Lighting; Major structura; Repairs to be completed 2012-2013

 		13,000 13,000 15,000 15,000 15,000
50000 Merchandise for Resale

Bike parts for resale

 		229,994 229,994 230,000 230,000 230,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

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

Bi-annual shop party; manager's meetings

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

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

Maximum rental rate for summer storage

 		0 0 2,500 2,500 2,500
55000 Trade Associations

0 0 0 0 0
56000 Uniforms & Shop Aprons

0 0 0 0 0
56000 Bike Garage Merchandise for Resale

Inventory for Bike Garage (tubes, fenders, etc)

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

Software, training, IT etc.

 		0 0 1,200 1,200 1,200
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 2,320 2,320 2,320
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 291,953 291,953 314,073 313,573 313,573
Charts
-18.2% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

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

18,130 18,130 7,429 7,429 7,429
b Inventory Manager Summer/Fall

17,640 17,640 5,985 5,985 5,985
c Inventory Manager Winter/Spring

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

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

10,780 10,780 32,490 32,490 32,490
f Senior Mechanic Summer/Fall

12,495 12,495 6,460 6,460 6,460
g Senior Mechanic Winter/Spring

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

8,330 8,330 19,760 19,760 19,760
j Mechanic Winter/Spring

0 0 10,260 10,260 10,260
Total Hourly 107,800 107,800 132,003 132,003 132,003
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/08/12-6/08/13 50.00 9.00 38 1 17,100
a Business Manager Winter/Spring 7/08/12-6/08/13 17.00 11.50 38 1 7,429
b Inventory Manager Summer/Fall 7/08/12-6/08/13 15.00 10.50 38 1 5,985
c Inventory Manager Winter/Spring 7/08/12-6/08/13 15.00 10.00 38 1 5,700
d Service Manager Summer/Fall 7/08/12-6/08/13 25.00 9.75 38 1 9,263
e Service Manager Winter/Spring 7/08/12-6/08/13 15.00 9.50 38 6 32,490
f Senior Mechanic Summer/Fall 7/08/12-6/08/13 10.00 8.50 38 2 6,460
g Senior Mechanic Winter/Spring 7/08/12-6/08/13 14.00 8.25 38 4 17,556
h Mechanic Summer/Fall 7/08/12-6/08/13 5.00 8.00 38 13 19,760
j Mechanic Winter/Spring 4/01/12-4/01/13 30.00 9.00 38 1 10,260
Career
 2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
a Blank Assistant III (General Manager)

43,704 43,704 47,000 47,000 47,000
b ADMIN OFCR 2 (General Manager)

0 0 0 0 0
c Short Term Employee

0 0 0 0 0
Total Career 43,704 43,704 47,000 47,000 47,000
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/11-6/30/12 12 3,916.67 1 47,000
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0
c Short Term Employee --- 0 0 0 0
Employee Benefits
 2010 - 2011 2011 - 2012 2012 - 2013 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 107,800 107,800 132,003 132,003 132,003
b Total Career 43,704 43,704 47,000 47,000 47,000
Total General Assistance 151,504 151,504 179,003 179,003 179,003
Employee Benefits Casual (a * 0.01300) 3,008 1,401 1,716 1,716 1,716
Employee Benefits Career (b * 0.44200) 14,859 17,569 20,774 20,774 20,774
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 17,867 18,970 22,490 22,490 22,490