Bike Barn

2023 - 2024

Previous Years
Things To Do
Prepared By
  • Oscar McBain
Budget No.
  • 8041091
Charts
-101.16% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

2021 - 2022 2022 - 2023 2023 - 2024 Proposed President's Final Approved
Income 458,000 472,000 482,000 482,000 482,000
Expenses
 2021 - 2022 2022 - 2023 2023 - 2024 Proposed President's Final Approved
General Assistance / Benefits 281,855 290,201 297,729 299,439 297,729
Administrative / Programmatic 174,337 176,087 184,337 184,187 184,187
Total Expense 456,192 466,288 482,066 483,626 481,916
Reconciliation
 2021 - 2022 2022 - 2023 2023 - 2024 Proposed President's Final Approved
Subsidy -1,808 -5,712 66 1,626 -84
Transfers To/From Reserve 0 0 0 0 0
Charts
2.12% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Income
 2021 - 2022 2022 - 2023 2023 - 2024 Proposed President's Final Approved
11000 Parts Sales - Bike Barn

200,000 200,000 205,000 205,000 205,000
12000 Employee Sales

0 0 0 0 0
13000 Labor

110,000 110,000 110,000 110,000 110,000
14000 Rental

15,000 20,000 25,000 25,000 25,000
15000 Bank Card Percent

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

140,000 150,000 150,000 150,000 150,000
17000 Refunds

0 0 0 0 0
18000 Bad Checks

0 0 0 0 0
19000 Over and Short

0 0 0 0 0
Total Income 458,000 472,000 482,000 482,000 482,000
Charts
-4.69% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Expenses
 2021 - 2022 2022 - 2023 2023 - 2024 Proposed President's Final Approved
21000 Common Goods Assessment

3,000 0 0 0 0
30000 Copying & Printing

300 300 300 300 300
32000 Office Supplies

2,000 500 500 500 500
33000 Transportation

1,000 1,500 1,000 1,000 1,000
35000 Telephone Toll Charges

150 150 150 0 0
36000 Equipment Purchase

10,000 10,000 7,500 7,500 7,500
37000 Repair & Maintenance

2,500 2,500 2,500 2,500 2,500
50000 Merchandise for Resale

147,000 150,000 160,000 160,000 160,000
52000 Publicity

Promotional materials (A-frames, lawn signs, stickers) & giveaways items and incentives.

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

Staff Retention, Engagement, Development, and Experience (e.g. events, staff lunches, coffee for a morning managers' meeting, etc)

 		1,000 2,000 2,000 2,000 2,000
55000 Trade Shows

800 800 800 800 800
56000 Uniforms & Shop Aprons

Mechanic shirts/apparel, aprons, gloves, faceshields, safety glasses/PPE etc.

 		1,500 1,250 1,500 1,500 1,500
57000 Trade Shows

0 1,500 1,000 1,000 1,000
72000 University Recharge

3,087 3,087 3,087 3,087 3,087
88888 Promotional

0 0 0 0 0
88888 University Recharge

0 0 0 0 0
88888 Aramark Services

0 0 0 0 0
Total Expenses 174,337 176,087 184,337 184,187 184,187
Charts
-2.59% Difference from Last Year

Gained Money

No Change

Lost Money

No Last Year Information

Stipend
 2021 - 2022 2022 - 2023 2023 - 2024 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
 2021 - 2022 2022 - 2023 2023 - 2024 Proposed President's Final Approved
0 Business Manager (Summer/Fall)

6,897 6,358 5,698 5,544 5,698
a Business Manager (Winter/Spring)

7,752 7,140 6,216 6,216 6,216
b Inventory Manager (Summer/Fall)

6,688 6,171 5,544 5,544 5,544
c Inventory Manager (Winter/Spring)

7,524 6,936 6,048 6,216 6,048
d Service Manager (Summer/Fall)

14,850 15,840 13,860 13,464 13,860
e Service Manager (Winter/Spring)

17,280 17,820 15,120 15,120 15,120
f Senior Mechanic (Summer/Fall)

17,864 19,096 24,310 24,310 24,310
g Senior Mechanic (Winter/Spring)

19,344 21,504 24,480 25,200 24,480
h Mechanic (Summer/Fall)

43,120 43,560 39,930 39,930 39,930
j Mechanic (Winter/Spring)

46,800 49,104 43,560 44,880 43,560
Total Hourly 188,119 193,529 184,766 186,424 184,766
Start-End Hours/Week Pay Per Hour Num. Weeks Quantity Total
0 Business Manager (Summer/Fall) 7/1/2023-12/31/2023 14.00 18.50 22 1 5,698
a Business Manager (Winter/Spring) 1/1/2024-6/30/2024 14.00 18.50 24 1 6,216
b Inventory Manager (Summer/Fall) 7/1/2023-12/31/2023 14.00 18.00 22 1 5,544
c Inventory Manager (Winter/Spring) 1/1/2024-6/30/2024 14.00 18.00 24 1 6,048
d Service Manager (Summer/Fall) 7/1/2023-12/31/2023 12.00 17.50 22 3 13,860
e Service Manager (Winter/Spring) 1/1/2024-6/30/2024 12.00 17.50 24 3 15,120
f Senior Mechanic (Summer/Fall) 7/1/2023-12/31/2023 13.00 17.00 22 5 24,310
g Senior Mechanic (Winter/Spring) 1/1/2024-6/30/2024 12.00 17.00 24 5 24,480
h Mechanic (Summer/Fall) 7/1/2023-12/31/2023 11.00 16.50 22 10 39,930
j Mechanic (Winter/Spring) 1/1/2024-6/30/2024 11.00 16.50 24 10 43,560
Career
 2021 - 2022 2022 - 2023 2023 - 2024 Proposed President's Final Approved
a Blank Assistant III (General Manager)

57,624 0 0 0 0
b ADMIN OFCR 2 (General Manager)

0 59,340 61,716 61,716 61,716
c Short Term Employee

0 0 8,000 8,000 8,000
Total Career 57,624 59,340 69,716 69,716 69,716
Start-End Num. Months Paid Pay Per Month Quantity Total
a Blank Assistant III (General Manager) --- 0 0 0 0
b ADMIN OFCR 2 (General Manager) 7/1/23-6/30/23 12 5,143.00 1 61,716
c Short Term Employee 7/1/23-11/4/23 4 2,000.00 1 8,000
Employee Benefits
 2021 - 2022 2022 - 2023 2023 - 2024 Proposed President's Final Approved
a Total Stipend + Hourly Salaries 188,119 193,529 184,766 186,424 184,766
b Total Career 57,624 59,340 69,716 69,716 69,716
Total General Assistance 245,743 252,869 254,482 256,140 254,482
Employee Benefits Casual (a * 0.02800) 3,574 3,677 5,173 5,220 5,173
Employee Benefits Career (b * 0.53620) 30,080 30,975 37,382 37,382 37,382
General Automotive Employee Liability ((a+b) * 0.00000) 1,917 2,124 0 0 0
Composite Benefit Rate ((a+b) * 0.00272) 541 556 692 697 692
Total Employee Benefits 36,112 37,332 43,247 43,299 43,247