[Finance] Draft Budgets

[Mark Cohoe]

HI,

Amanda and I met over the weekend and did a detailed run through of the 
numbers for bicycle valet to come up with pricing for small (<50 bikes), 
medium (50-150 bikes) and large (> 150 bikes) setups. For the Bombers, 
we developed 4 scenarios based on capacities of 1250, 1000, 750 and 500 
bikes, 500 being the status quo. Amanda, I've made a few small changes 
to the numbers from what we had Saturday, but mainly to deal with the 
service hours. I also decided you were right about listing the capital 
costs under expenditures in the budget, so that's in there too.

To develop the prices, we broke down costs into fixed and operational 
costs. We borrowed Jeremy's idea of service hours to help factor fixed 
costs into the rates. To calculate a service hour fee, we assigned a 
fixed number of service hours to each setup type, multiplied that number 
by the estimated number of each contracted setup type to determine a 
service hours total for the season, and then divided fixed costs by that 
number to get a service hour cost. See the Cost Analysis Spreadsheet to 
review these calculations.

The service hour fee was then combined with estimated variable costs to 
get a total setup cost (which included transport and a fixed number of 
operational hours) and hourly rate for any additional hours.

Note that because the Bombers contract takes up such a large portion of 
our contract setups, the service hour costs depends on which capacity 
scenario the Bombers choose for 2014. The actual service hour charge is 
listed on each tab (Bombers-1250, Bombers-1000, etc.) as a fixed number 
rather than as a linked cell. In each case it was calculated by setting 
the service hours cell on the rates tab and adjusting the quantity of 
new stations and racks in the depreciation calculation.

I've marked the 1250 bike capacity option as the preferred option. If 
the Bombers go with that option, we would have to come up with an 
additional $12,000 for capital acquisition. Amanda and I thought it 
would be best to ask for a multi-year contract from the Bombers, so 
ideally this would give us ability to get a loan. We also recognized 
that regardless of what option is chosen by the Bombers, we will need to 
bill game by game to manage our cash flow.

For the BV and BW budgets, I've made calculations based on the Status 
Quo option, which gives capacity for 500 bikes/game. We had a capacity 
for 400-450 last year.

To balance the BV budget, I pushed the Bomber rate up a bit to 
$1300/game. The BW budget includes a contingency of 4% of expenses (BV 
and BW Core).

Cheers,
Mark

-- 
Mark Cohoe
Executive Director
Bike Winnipeg
www.bikewinnipeg.ca
204-894-6540


-------------- next part --------------
A non-text attachment was scrubbed...
Name: Draft-Bike-Winnipeg-Budget-2014 v3.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 16550 bytes
Desc: not available
URL: <http://lists.bikewinnipeg.ca/pipermail/finance-bikewinnipeg.ca/attachments/20140310/ddb327b9/attachment.xlsx>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BV-Draft-Budget-V3.ods
Type: application/vnd.oasis.opendocument.spreadsheet
Size: 6929 bytes
Desc: not available
URL: <http://lists.bikewinnipeg.ca/pipermail/finance-bikewinnipeg.ca/attachments/20140310/ddb327b9/attachment-0006.ods>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BV-Draft-Budget-V3.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 12194 bytes
Desc: not available
URL: <http://lists.bikewinnipeg.ca/pipermail/finance-bikewinnipeg.ca/attachments/20140310/ddb327b9/attachment-0001.xlsx>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BV-Draft-Costs-2014-V2.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 37403 bytes
Desc: not available
URL: <http://lists.bikewinnipeg.ca/pipermail/finance-bikewinnipeg.ca/attachments/20140310/ddb327b9/attachment-0002.xlsx>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BV-Draft-Costs-2014-V2.ods
Type: application/vnd.oasis.opendocument.spreadsheet
Size: 26617 bytes
Desc: not available
URL: <http://lists.bikewinnipeg.ca/pipermail/finance-bikewinnipeg.ca/attachments/20140310/ddb327b9/attachment-0007.ods>