Bike Barn

2015 - 2016

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

Gained Money

No Change

Lost Money

No Last Year Information

2013 - 2014 2014 - 2015 2015 - 2016 Proposed President's Final Approved
Income 550,100 447,753 506,969 521,969 506,969
Expenses
 2013 - 2014 2014 - 2015 2015 - 2016 Proposed President's Final Approved
General Assistance / Benefits 221,613 227,456 211,582 241,625 211,582
Administrative / Programmatic 308,380 220,297 198,127 229,437 198,127
Total Expense 529,993 447,753 409,709 471,062 409,709
Reconciliation
 2013 - 2014 2014 - 2015 2015 - 2016 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 20,107 0 97,260 50,907 97,260
Charts
13.23% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

$21,667 avg/mo x 12 mo

 		276,000 260,000 245,000 275,000 245,000
11500 Parts Sales - Bike hub

Location discontinued

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

Location discontinued

 		4,800 0 0 0 0
12000 Employee Sales

Category Discontinued, Now Factored Into 1100 Part Sales Bike Barn

 		0 0 0 0 0
13000 Labor

$7,500 avg/mo x 12 mo; increased to reflect actuals and select price increases

 		66,000 75,000 95,000 105,000 95,000
14000 Rental

$2,083 avg/mo x 12 mode; increased to reflect actuals

 		36,000 20,500 35,000 25,000 35,000
15000 Bank Card Percent

$<650> avg/mo x 12 mo

 		-7,800 -7,800 -7,800 -7,800 -7,800
16000 Bike Sales

$9,583 avg/mo x 12 mo -Includes Bike Buy; increased to reflect actuals

 		144,000 100,200 140,000 125,000 140,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

Reflects actuals

 		0 0 0 0 0
19000 Over and Short

$<19.25> avg/mo x 12 mo; decreased to reflect actuals

 		-100 -147 -231 -231 -231
Total Income 550,100 447,753 506,969 521,969 506,969
Charts
-10.06% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

To be used for transportation and expenses to industry trade shows

 		0 0 0 0 0
21000 Common Goods Assessment

0 0 0 0 0
30000 Copying & Printing

Copying expenses

 		500 500 500 500 500
31000 Mail

Mailing expenses; adjusted to reflect actuals

 		300 100 100 10 100
32000 Office Supplies

Misc. supplies; adjusted to reflect actuals

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

No longer applicable; funds being used for Consultant

 		8,000 0 0 0 0
34000 Telephone Equipment

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

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

No longer applicable

 		0 0 0 0 0
35000 Telephone Toll Charges

Long distance costs - calling vendors, etc.

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

No longer applicable

 		0 0 0 0 0
36000 Equipment Purchase

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

 		7,500 7,000 2,000 2,000 2,000
36500 Computer Equipment

To be used for digitizing workflow and replacing depreciated equipment; increased with anticipation of purchase of new computers

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

Building repairs - Doors/Lighting; Major structural, decreased to reflect actuals

 		8,000 8,000 2,000 3,000 2,000
50000 Merchandise for Resale

Bike parts for resale, increased to reflect actuals (anticipated decrease from 2014-15 actuals)

 		250,000 161,000 150,000 180,000 150,000
51000 Services Rendered

0 0 0 0 0
52000 Publicity

Advertising; creating websites, Employee t-shirts; Marketing for Aggie Bike Buy; can be used towards creative media if needed

 		2,200 2,200 1,000 0 1,000
53000 Staff Development

Bi-annual shop party; manager's meetings

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

Funds paying for Consultant for the year

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

No longer Applicable

 		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

Now under 50000 - Merchandise for Re\sale

 		0 0 0 0 0
56001 Upkeep for Aggie Bike Buy

No longer Applicable

 		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,000 15,000 15,000 15,000 15,000
79000 OP Tax

153 0 0 0 0
90000 Admin Recharge

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

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

1,000 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 308,380 220,297 198,127 229,437 198,127
Charts
-6.98% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

0 0 0 0 0
a Business Manager Winter/Spring

9,880 13,160 14,100 14,100 14,100
b Inventory Manager Summer/Fall

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

7,980 10,810 11,750 11,750 11,750
d Service Manager Summer/Fall

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

44,460 50,525 44,180 44,180 44,180
f Senior Mechanic Summer/Fall

30,780 28,200 22,748 31,020 22,748
g Senior Mechanic Winter/Spring

14,108 19,564 19,270 28,905 19,270
h Mechanic Summer/Fall

27,360 31,725 23,500 35,250 23,500
j Mechanic Winter/Spring

0 0 0 0 0
Total Hourly 150,148 153,984 135,548 165,205 135,548
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/07/14-6/07/15 0 0 0 0 0
a Business Manager Winter/Spring 7/5/15-6/11/16 20.00 15.00 47 1 14,100
b Inventory Manager Summer/Fall 7/07/14-6/07/15 0 0 0 0 0
c Inventory Manager Winter/Spring 7/5/15-6/11/16 20.00 12.50 47 1 11,750
d Service Manager Summer/Fall 7/07/14-6/07/15 0 0 0 0 0
e Service Manager Winter/Spring 7/5/15-6/11/16 20.00 11.75 47 4 44,180
f Senior Mechanic Summer/Fall 7/5/15-6/11/16 11.00 11.00 47 4 22,748
g Senior Mechanic Winter/Spring 7/5/15-6/11/16 10.00 10.25 47 4 19,270
h Mechanic Summer/Fall 7/5/15-6/11/16 10.00 10.00 47 5 23,500
j Mechanic Winter/Spring 3/30/14-3/30/15 0 0 0 0 0
Career
 2013 - 2014 2014 - 2015 2015 - 2016 Proposed President's Final Approved
a Blank Assistant III (General Manager)

47,000 47,520 48,960 48,960 48,960
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,520 48,960 48,960 48,960
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/15-6/30/16 12 4,080.00 1 48,960
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0
c Short Term Employee --- 0 0 0 0
Employee Benefits
 2013 - 2014 2014 - 2015 2015 - 2016 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 150,148 153,984 135,548 165,205 135,548
b Total Career 47,000 47,520 48,960 48,960 48,960
Total General Assistance 197,148 201,504 184,508 214,165 184,508
Employee Benefits Casual (a * 0.01300) 1,952 2,002 1,762 2,148 1,762
Employee Benefits Career (b * 0.51700) 22,513 23,950 25,312 25,312 25,312
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 24,465 25,952 27,074 27,460 27,074