Bike Barn

2013 - 2014

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

Gained Money

No Change

Lost Money

No Last Year Information

2011 - 2012 2012 - 2013 2013 - 2014 Proposed President's Final Approved
Income 462,427 513,246 550,100 550,100 550,100
Expenses
 2011 - 2012 2012 - 2013 2013 - 2014 Proposed President's Final Approved
General Assistance / Benefits 170,474 201,493 221,613 221,613 221,613
Administrative / Programmatic 291,953 313,573 307,380 308,380 308,380
Total Expense 462,427 515,066 528,993 529,993 529,993
Reconciliation
 2011 - 2012 2012 - 2013 2013 - 2014 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 0 -1,820 21,107 20,107 20,107
Charts
7.18% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

$23000 avg/mo x 12 mo

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

$2600 avg/mo x 12 mo

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

$400avg/mo x 12 mo

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

Category Discontinued, Now Factored Into 1100 Part Sales Bike Barn

 		8,000 8,000 0 0 0
13000 Labor

$5,500 avg/mo x 12 mo

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

$3000 avg/mo x 12 mo

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

$<650> avg/mo x 12 mo

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

$12000 avg/mo x 12 mo -Includes Bike Buy

 		95,427 95,824 144,000 144,000 144,000
17000 Refunds

Not accounted independently due to business software constraints

 		0 0 0 0 0
17500 ---

0 0 0 0 0
18000 Bad Checks

Adjusted to reflect actuals

 		0 0 0 0 0
19000 Over and Short

-$10 avg/mo x 12 mo ; Increased to reflect actuals

 		0 0 -100 -100 -100
Total Income 462,427 513,246 550,100 550,100 550,100
Charts
-1.97% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
 2011 - 2012 2012 - 2013 2013 - 2014 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 500 500 500
31000 Mail

Mailing expenses

 		150 150 300 300 300
32000 Office Supplies

Misc. supplies

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

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

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

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

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

Now under 34000 - Telephone Equipment

 		0 50 0 0 0
35000 Telephone Toll Charges

Long distance costs - calling vendors, etc.

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

Now under 35000 - Telephone Charges

 		0 70 0 0 0
36000 Equipment Purchase

Tools, benches, air compressors

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

To be used for digitizing workflow and replacing depreciated equipment

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

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

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

Bike parts for resale

 		229,994 230,000 250,000 250,000 250,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 5,000 2,200 2,200 2,200
53000 Staff Development

Bi-annual shop party; manager's meetings

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

0 0 0 0 0
55000 Trade Shows

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

No longer Applicable

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

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

No longer Applicable

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

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

0 2,320 3,000 153 153
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

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

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

0 0 0 1,000 1,000
93000 ASUCD

0 0 0 0 0
95000 Indirect Cost Recovery

0 0 0 0 0
Total Expenses 291,953 313,573 307,380 308,380 308,380
Charts
-9.99% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

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

18,130 7,429 9,880 9,880 9,880
b Inventory Manager (Summer/Fall)

17,640 5,985 7,980 7,980 7,980
c Inventory Manager (Winter/Spring)

15,680 5,700 7,980 7,980 7,980
d Service Manager (Summer/Fall)

16,170 9,263 7,600 7,600 7,600
e Service Manager (Winter/Spring)

10,780 32,490 44,460 44,460 44,460
f Senior Mechanic (Summer/Fall)

12,495 6,460 30,780 30,780 30,780
g Senior Mechanic (Winter/Spring)

8,575 17,556 14,108 14,108 14,108
h Mechanic (Summer/Fall)

8,330 19,760 27,360 27,360 27,360
j Mechanic (Winter/Spring)

0 10,260 0 0 0
Total Hourly 107,800 132,003 150,148 150,148 150,148
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 1 0
a Business Manager (Winter/Spring) 7/07/13-6/07/14 20.00 13.00 38 1 9,880
b Inventory Manager (Summer/Fall) 7/07/13-6/07/14 20.00 10.50 38 1 7,980
c Inventory Manager (Winter/Spring) 7/07/13-6/07/14 20.00 10.50 38 1 7,980
d Service Manager (Summer/Fall) 7/07/13-6/07/14 20.00 10.00 38 1 7,600
e Service Manager (Winter/Spring) 7/07/13-6/07/14 20.00 9.75 38 6 44,460
f Senior Mechanic (Summer/Fall) 7/07/13-6/07/14 15.00 9.00 38 6 30,780
g Senior Mechanic (Winter/Spring) 7/07/13-6/07/14 15.00 8.25 38 3 14,108
h Mechanic (Summer/Fall) 7/07/13-6/07/14 15.00 8.00 38 6 27,360
j Mechanic (Winter/Spring) 3/30/13-3/30/14 0 0 0 0 0
Career
 2011 - 2012 2012 - 2013 2013 - 2014 Proposed President's Final Approved
a Blank Assistant III (General Manager)

43,704 47,000 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 47,000 47,000 47,000 47,000
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/13-6/30/14 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
 2011 - 2012 2012 - 2013 2013 - 2014 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 107,800 132,003 150,148 150,148 150,148
b Total Career 43,704 47,000 47,000 47,000 47,000
Total General Assistance 151,504 179,003 197,148 197,148 197,148
Employee Benefits Casual (a * 0.01300) 1,401 1,716 1,952 1,952 1,952
Employee Benefits Career (b * 0.47900) 17,569 20,774 22,513 22,513 22,513
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 18,970 22,490 24,465 24,465 24,465