Bike Barn

-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

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

-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) &amp;amp;amp;amp;amp;amp;amp; 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 Associations	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
Total Expenses		174,337	176,087	184,337	184,187	184,187

-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