<div dir="auto">Thanks Mark for that additional info.<div dir="auto"><br></div><div dir="auto">I can't make tonight's meeting. Please send an email out if we'll need another meeting to discuss the budget content before the final draft is circulated to the board a few days before the Dec. 7th board meeting.</div><div dir="auto"><br></div><div dir="auto">Thanks,</div><div dir="auto">Clayton</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Nov 22, 2022, 6:05 PM Mark Cohoe, <<a href="mailto:mark.e.cohoe@gmail.com">mark.e.cohoe@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi,</div><div><br></div><div>I wanted to add a few points for clarification:</div><div><ol><li>The Local Bike Groups Coordinator position would be dependent on a Canada Summer Jobs grant. We've had good success with this of late, so I feel safe budgeting it. Failure to get the job would pull the plug on this position.</li><ol><li>Additional funding of approximately $3750 would come from bicycle valet event day staffing charged to the bike valet account and a potential secondment of time to Bike Week Winnipeg</li><li>We are helped out with thes from recent increases to minimum wage, which effectively increases CSJ funding<br></li></ol><li>Cash flow for the Social Entreprises position will be a challenge. We may need to time this as a spring hire and manage bicycle valet internally until then.</li><ol><li>Revenue through bicycle valet is assumed to be about $22,500</li><li>net revenue from the bike racks project is projected at $3000 based on a 15% admin fee on installation of $21,500 worth of racks<br></li></ol><li>The change from a contracted out Bicycle Valet Coordinator to a salaried position adds a lot of flexibility to the bicycle valet service that have not had under recent contracts. In particular, it allows us ways to offer discounted bicycle valet services if we choose. I do think we need to look at our pricing structure for bicycle valet and come up with a program that offers a limited number of subsidized events.</li><li>The budgeted revenues for memberships, donations and sponsorships are in line with recent years. I would not categorize this as a conservative estimate. We will need to work hard to achieve these goals.<br></li><li>There is a built in assumption that admin revenue of approximately $2500 would help fund the ED position and our fixed expenses such as insurance, po box, zoom, etc.</li><ol><li>That would amount to $40-$50K in grants that allow for an admin cost, so on par with the grants we have been receiving, but not without risk/effort.</li><li>This is essentially replacing revenue from the 15% we take from bike valet.</li></ol><li>We've also built in an assumption of net profit of $2,000 from events, in particular a fall concert or something similar. We lost money this year, so this is definitely a risk, but we have surpassed this in previous years as well.<br></li></ol><div>We'll need to work on the presentation of the budget. <br></div><div><br></div><div>Cheers,</div><div>Mark<br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, Nov 20, 2022 at 1:34 PM Luke Lorentz <<a href="mailto:llorentz@gmail.com" target="_blank" rel="noreferrer">llorentz@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="auto">Thanks Clayton,<div><br></div><div>I will take a look through it in detail later this week . </div><div><br></div><div>Only thing that jumps out is your comment re the small cash surplus… Depreciation is a non cash item so it doesn’t effect the balance at all. Are you referring to income?</div><div><br></div><div>Thx</div><div><br></div><div>Luke</div><div><br></div><div><div dir="ltr">Sent from my iPhone</div><div dir="ltr"><br><blockquote type="cite">On Nov 19, 2022, at 6:57 PM, Clayton Rudy <<a href="mailto:clayton@bikewinnipeg.ca" target="_blank" rel="noreferrer">clayton@bikewinnipeg.ca</a>> wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="ltr">Hi Finance Committee,<div><br></div><div>Mark and I met today to get some rough numbers into <a href="https://docs.google.com/spreadsheets/d/1-i-QR2NDnK9eicLFc-KkCAnhROX8rjG1BW4kOVYaGrc/edit?usp=sharing" target="_blank" rel="noreferrer">the budget</a> (first tab of the spreadsheet). I'm assuming we'll go through it in detail at <b>Tuesday's meeting</b> then email the board with a final draft prior to the scheduled budget approval vote at the December board meeting (Dec. 7th).</div><div><br></div><div>Based on what Mark and I prepared today, below is a draft budget narrative which I assume we'll modify and expand at this week's FinCmte meeting before sending it to the board.</div><div><br></div><div><u>Staffing</u></div><div>The biggest change to next year's budget may be that we've budgeted to hire a <b>Social Enterprise Manager</b> (or similar title) primarily as an <u>office-based</u> position to do all the marketing, advertising, booking, reporting, invoicing, and event-day-staff oversight/scheduling for Bicycle Valet events. The budget includes expenses for <u>1 casual event-day staff</u> so that the manager doesn't get burdened with all the evening/weekend work as was the case in past years. For the dual purposes of making this position more financially viable and to take a chunk of work off Mark's plate, we're <u>combining</u> the Bicycle Valet work with the rack installation contract hence the "Social Enterprise Manager" (or similar) title which encompasses both valet and rack installation activities. These are also both CIPS Program activities. We think BW's at the point where we can hire a salaried, permanent, though part-time position with the intention of growing it to a full-time position in the medium term. If you go to Schedule B (row 188) in the spreadsheet you can see that we can balance a staffing budget for these two activities when combined.</div><div><br></div><div>On a related note to the valet and racks, we're also confident that we can fund a Local Bike Groups (LBGs) Coordinator through the busiest May through August months, but not a permanent year-round position this year. Check out Row 391 of the spreadsheet and you'll see that the LBG sub-budget balances without any major grant revenue and with a Bike Week partnership plus some valet event staffing.</div><div><br></div><div>In summary, without any major grant revenue, we'll be able to hire a <u>permanent part-time Social Enterprise Manager</u> and a <u>temporary full-time Local Bike Groups Coordinator</u>.</div><div><br></div><div><u>Revenue</u></div><div>We are very conservatively budgeting a drop in budgeted revenue from donations, grants, sponsorships, and social enterprises based on assumed/likely/perceived/forecasted 2022 actuals and expectations for 2023. We're budgeting for a 35% drop in revenue, though with board and volunteer involvement there is a HUGE potential to bring in a lot more (for example with grants which we regularly underbudget by a drastic amount).</div><div><br></div><div><br></div><div><u>Expenses</u></div><div>We have a commensurate drop in expenses based on lower budgeted revenue. There's also an unrelated 20% drop in core mgmt & admin expenses based due to belt tightening.</div><div><br></div><div><br></div><div><u>Overall</u></div><div>With a significant and conservative drop in revenue we're still able to budget for a new permanent staff position while covering Executive Director and core mgmt & admin expenses. There's a <u>ton of upside</u> on this budget. The only thing thing in the way of a major increase in sponsorship revenue is finding <u>a volunteer</u> to lead the next evolution of our approach to sponsorship (with lots of support), and there's a perennial likelihood that our grant revenue will be way higher than expected since we normally budget <i>very</i> conservatively for grants which means we get by without much grant revenue but our programming grows tremendously -- and temporarily -- if/when grants come in.</div><div><br></div><div>We have a <b>small cash surplus</b> which disappears after depreciation, but Bike Wpg doesn't get too concerned about the depreciation of our capital assets as there are many grants available when we need to replenish/renew/rebuild/grow any physical assets.</div><div><br></div><div><br></div><div>Cheers,</div><div>Clayton<br><div><div dir="ltr"><div dir="ltr"><div style="color:rgb(136,136,136)"><div><span style="color:rgb(0,0,0)">204.770.5449</span><br></div></div><div style="color:rgb(136,136,136)"><div><br></div></div></div></div></div></div></div>
<span>_______________________________________________</span><br><span>Finance mailing list</span><br><span><a href="mailto:Finance@lists.bikewinnipeg.ca" target="_blank" rel="noreferrer">Finance@lists.bikewinnipeg.ca</a></span><br><span><a href="http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca" target="_blank" rel="noreferrer">http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca</a></span><br></div></blockquote></div></div>_______________________________________________<br>
Finance mailing list<br>
<a href="mailto:Finance@lists.bikewinnipeg.ca" target="_blank" rel="noreferrer">Finance@lists.bikewinnipeg.ca</a><br>
<a href="http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca" rel="noreferrer noreferrer" target="_blank">http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca</a><br>
</blockquote></div>
_______________________________________________<br>
Finance mailing list<br>
<a href="mailto:Finance@lists.bikewinnipeg.ca" target="_blank" rel="noreferrer">Finance@lists.bikewinnipeg.ca</a><br>
<a href="http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca" rel="noreferrer noreferrer" target="_blank">http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca</a><br>
</blockquote></div>