Bike Barn

2016 - 2017

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

Gained Money

No Change

Lost Money

No Last Year Information

2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
Income 447,753 506,969 407,000 462,047 462,047
Expenses
 2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
General Assistance / Benefits 227,456 211,582 224,836 227,070 227,070
Administrative / Programmatic 220,297 198,127 175,127 201,626 201,626
Total Expense 447,753 409,709 399,963 428,696 428,696
Reconciliation
 2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
Subsidy 0 0 0 0 0
Transfers To/From Reserve 0 97,260 7,037 33,351 33,351
Charts
-19.72% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

$17,500 avg/mo x 12 mo; decreased to reflect actuals

 		260,000 245,000 200,000 215,000 215,000
11500 Parts Sales - Bike hub

Location discontinued

 		0 0 0 0 0
11800 Parts Sales - Bike Garage

Location discontinued

 		0 0 0 0 0
12000 Employee Sales

Category Discontinued, Now Factored Into 11000 Part Sales Bike Barn

 		0 0 0 0 0
13000 Labor

$7,500 avg/mo x 12 mo; decreased to reflect actuals

 		75,000 95,000 85,000 95,000 95,000
14000 Rental

$2500 avg/mo x 12 mode; decreased to reflect actuals

 		20,500 35,000 25,000 35,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; decreased to reflect actuals

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

Reflects actuals

 		-147 -231 -200 -153 -153
Total Income 447,753 506,969 407,000 462,047 462,047
Charts
-11.61% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
 2014 - 2015 2015 - 2016 2016 - 2017 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 5,500 5,500
30000 Copying & Printing

Copying expenses

 		500 500 500 100 100
31000 Mail

Mailing expenses; adjusted to reflect actuals

 		100 100 100 1 1
32000 Office Supplies

Misc. supplies; adjusted to reflect actuals

 		3,000 2,000 2,000 1,300 1,300
33000 Transportation

No longer applicable; funds being used for Consultant

 		0 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 0 0
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 150 150
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,000 2,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

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

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

 		8,000 2,000 2,000 1,500 1,500
50000 Merchandise for Resale

Bike parts for resale, decreased to reflect more efficient purchasing practices

 		161,000 150,000 130,000 150,000 145,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 1,000 1,000 1,000 1,000
53000 Staff Development

Bi-annual shop party; manager's meetings

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

Funds paying for Consultant for the year

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

0 0 0 0 0
90000 Admin Recharge

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

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

1,000 1,000 1,000 4,500 4,500
93000 ASUCD

0 0 0 0 0
95000 Indirect Cost Recovery

0 0 0 0 0
Total Expenses 220,297 198,127 175,127 201,626 201,626
Charts
-6.26% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

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

0 0 6,900 6,900 6,900
a Business Manager Winter/Spring

13,160 14,100 7,440 7,440 7,440
b Inventory Manager Summer/Fall

0 0 5,750 5,750 5,750
c Inventory Manager Winter/Spring

10,810 11,750 6,240 6,240 6,240
d Service Manager Summer/Fall

0 0 12,161 12,161 12,161
e Service Manager Winter/Spring

50,525 44,180 13,230 13,230 13,230
f Senior Mechanic Summer/Fall

28,200 22,748 14,168 14,168 14,168
g Senior Mechanic Winter/Spring

19,564 19,270 15,456 15,456 15,456
h Mechanic Summer/Fall

31,725 23,500 32,200 32,200 32,200
j Mechanic Winter/Spring

0 0 35,280 35,280 35,280
Total Hourly 153,984 135,548 148,825 148,825 148,825
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager Summer/Fall 7/07/16-12/31/16 20.00 15.00 23 1 6,900
a Business Manager Winter/Spring 1/1/17-6/30/17 20.00 15.50 24 1 7,440
b Inventory Manager Summer/Fall 7/07/16-12/31/16 20.00 12.50 23 1 5,750
c Inventory Manager Winter/Spring 1/1/17-6/30/17 20.00 13.00 24 1 6,240
d Service Manager Summer/Fall 7/07/16-12/31/16 15.00 11.75 23 3 12,161
e Service Manager Winter/Spring 1/1/17-6/30/17 15.00 12.25 24 3 13,230
f Senior Mechanic Summer/Fall 7/07/16-12/31/16 14.00 11.00 23 4 14,168
g Senior Mechanic Winter/Spring 1/1/17-6/30/17 14.00 11.50 24 4 15,456
h Mechanic Summer/Fall 7/07/16-12/31/16 14.00 10.00 23 10 32,200
j Mechanic Winter/Spring 1/1/17-6/30/17 14.00 10.50 24 10 35,280
Career
 2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
a Blank Assistant III (General Manager)

47,520 48,960 48,960 50,436 50,436
b ADMIN OFCR 2 (General Manager)

0 0 0 0 0
c Short Term Employee

0 0 0 0 0
Total Career 47,520 48,960 48,960 50,436 50,436
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) 7/1/16-6/30/17 12 4,203.00 1 50,436
b ADMIN OFCR 2 (General Manager) --- 0 0 0 0
c Short Term Employee --- 0 0 0 0
Employee Benefits
 2014 - 2015 2015 - 2016 2016 - 2017 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 153,984 135,548 148,825 148,825 148,825
b Total Career 47,520 48,960 48,960 50,436 50,436
Total General Assistance 201,504 184,508 197,785 199,261 199,261
Employee Benefits Casual (a * 0.01300) 2,002 1,762 1,935 1,935 1,935
Employee Benefits Career (b * 0.51300) 23,950 25,312 25,116 25,874 25,874
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 25,952 27,074 27,051 27,809 27,809