2005 Budget

From FreekiWiki
Jump to navigation Jump to search

The development process

Develop Profit and Loss report for 2005
Gather numbers on income and expenses for 2005. This will be the basis for what will happen in 2006.
Status: DONE (May be a few minor changes coming.)
Develop a "Status Quo" budget
Research trends that are likely to change those numbers and apply. (Lease determines rent, for example. This is a known. Database shows how fast we're growing. This is an estimate.) This version of the budget says if we change nothing at all about how we do things, what is likely to happen? This is where we currently are in the process.
Status: DONE (This is the budget you see listed below.)
Address the weak spots
Take action necessary to address any problems identified in the "Status Quo" budget and incorporate them into the budget. This version is supposed to fixes any leaks with minimal changes in how we do things.
Status: DONE (The first half of the year looks weak, but is addressed in the second half and the operational reserve helps cushion the problem.)
Add planned changes
When do we want to hire more people? Increase wages? Rent more space? Start up a new program? How will these generate money? How much will they cost? This requires the organization to decide on its plans as we research and incorporate.
Status: NEED TO DO (This requires prioritization and plans for implementation.)
Change the quarterly budget into a monthly budget
Some categories will just get divided by 3 to produce this. In other cases we'll make assumptions about when costs and income will happen.
Status: NEED TO DO (The last step, waiting for the above to finish.)

All throughout the process get as much feedback as possible from as many people as possible to catch as many oversights as we can. This is a process.

Income and Expenses for 2005

To start with, here's a profit and loss statement by quarter for 2005.There may be a few transactions for the month of December that will need to be adjusted, but this should be very close.


2005 Income and Expenses
. Q1 . Q2 . Q3 . Q4 . YEAR
Consulting $- $- $- $7,135.00 $7,135.00
Donations, C4K $25.00 $25.00
Donations, Online $370.00 $1,551.91 $10.00 $125.00 $2,056.91
Donations, Regular $20,044.91 $34,929.12 $24,406.04 $19,113.18 $98,493.25
Education $1,040.00 $380.00 $120.00 $- $1,540.00
Fundraisers $1,325.79 $- $1,325.79
Grants $1,708.25 $1,000.00 $11,300.00 $16,200.00 $30,208.25
Interest $30.52 $18.64 $12.16 $51.52 $112.84
Miscellaneous Income $- $- $0.97 $120.00 $120.97
Monitor Fees $27,600.50 $25,953.10 $34,795.94 $26,806.00 $115,155.54
Outreach Events $193.75 $1,379.00 $1,902.00 $- $3,474.75
Overages $- $- $476.41 $751.95 $1,228.36
Pickups $- $- $175.00 $- $175.00
Recycling Income $8,944.32 $16,259.75 $8,564.52 $11,686.51 $45,455.10
Sales, External $- $- $414.05 $1,036.10 $1,450.15
Sales, Online $908.14 $1,005.23 $- $- $1,913.37
Sales, Retail $36,330.36 $35,450.98 $40,388.15 $44,531.89 $156,701.38
Sales, Wholesale $609.42 $40.00 $398.25 $977.90 $2,025.57
Space Rental $- $- $- $40.00 $40.00
Sponsorship $- $167.70 $3.80 $- $171.50
Tenant Sublets $2,392.00 $1,072.00 $1,037.00 $2,070.00 $6,571.00
Untracked Adjustments $- $- $950.75 $- $950.75
TOTAL INCOME $101,497.96 $119,207.43 $124,955.04 $130,670.05 $476,330.48
Adminstration $1,978.12 $1,678.80 $1,412.50 $949.13 $6,018.55
Advertising $- $- $- $535.00 $535.00
Auction fees $74.11 $47.64 $11.24 $- $132.99
Consulting Expenses $- $- $1,160.00 $7,135.00 $8,295.00
Fundraisers $12.98 $- $- $- $12.98
Health Care $9,891.99     $7,438.19     $7,941.10     $7,504.56 $32,775.84
Merchandise Purchases $109.78 $264.96 $- $- $374.74
Miscellaneous Expenses $- $- $- $- $-
Monitor Recycling $10,832.00 $9,551.50 $15,558.08 $14,776.00 $50,717.58
Other Facility $3,144.74     $1,423.29     $793.02     $1,528.68 $6,889.73
Outreach Events $216.51 $544.62 $1,919.36 $- $2,680.49
Parts for online sales $79.64 $- $- $- $79.64
Payroll $49,621.20     $44,551.80     $43,539.67     $46,193.85 $183,906.52
Payroll Accounting $775.54     $532.99     $792.46     $769.17 $2,870.16
Program Supplies $309.75 $2.99 $788.41 $138.98 $1,240.13
Recycling Disposal $- $78.12 $103.57 $46.48 $228.17
Rent $19,900.00     $20,100.00     $20,100.00     $20,100.00 $80,200.00
Shipping $68.13 $460.74 $86.69 $- $615.56
Short Tills $- $- $255.48 $236.87 $492.35
Staff Training and Education $- $- $300.00 $- $300.00
Taxes and Withholding $17,265.65 $14,259.59 $14,482.23 $14,741.51 $60,748.98
Telecom $792.84     $744.37     $749.46     $742.39 $3,029.06
Theft and Fraud $299.00 $- $376.50 $97.00 $772.50
Utilities $4,926.06     $3,682.00     $4,292.21     $4,739.00 $17,639.27
Volunteer rewards $- $42.00 $- $138.95 $180.95
Workers Compensation $304.50     $304.50     $304.50     $304.50 $1,218.00
TOTAL EXPENSES $120,602.54 $105,708.10 $114,966.48 $120,677.07 $461,954.19
PROFIT (LOSS) $(19,104.58) $13,499.33 $9,988.56 $9,992.98 $14,376.29

Current Budget (for 2006)

Current Budget (2006)
. Q1 . Q2 . Q3 . Q4 . YEAR
Growth Assumps
Consulting $- $- $- $- $- Z
Donations, C4K $6.56 $6.56 $6.56 $6.56 $26.25 105%
Donations, Online $539.94 $539.94 $539.94 $539.94 $2,159.76 105%
Donations, Regular $25,854.48 $25,854.48 $25,854.48 $25,854.48 $103,417.91 105%
Education $404.25 $404.25 $404.25 $404.25 $1,617.00 105%
Fundraisers $348.02 $348.02 $348.02 $348.02 $1,392.08 105%
Grants $- $- $- $- $- Z
Interest $29.62 $29.62 $29.62 $29.62 $118.48 105%
Miscellaneous Income $31.75 $31.75 $31.75 $31.75 $127.02 105%
Monitor Fees $32,934.48 $30,401.06 $30,401.06 $32,934.48 $126,671.09 110% U
Outreach Events $912.12 $912.12 $912.12 $912.12 $3,648.49 105%
Overages $322.44 $322.44 $322.44 $322.44 $1,289.78 105%
Pickups $- $- $- $- $- Z
Recycling Income $11,931.96 $11,931.96 $11,931.96 $11,931.96 $47,727.86 105%
Sales, External $1,048.53 $1,116.92 $1,162.50 $1,230.89 $4,558.84 110% G, YEC
Sales, Online $- $929.03 $988.96 $1,078.87 $2,996.86 110% G, Q2
Sales, Retail $38,150.02 $40,638.07 $42,296.76 $44,784.81 $165,869.66 110% G
Sales, Wholesale $2,007.90 $2,138.85 $2,226.15 $2,357.10 $8,729.98 110% G
Space Rental $- $- $- $- $- Z
Sponsorship $- $- $- $- $- Z
Tenant Sublets $3,000.00 $3,000.00 $3,000.00 $3,000.00 $12,000.00 F $1,000
Untracked Adjustments $- $- $- $- $- Z
TOTAL INCOME $117,522.09 $118,605.07 $120,456.60 $125,767.30 $482,351.06
Adminstration $1,579.87 $1,579.87 $1,579.87 $1,579.87 $6,319.48 105%
Advertising $140.44 $140.44 $140.44 $140.44 $561.75 105%
Auction fees $50.02 $50.02 $50.02 $50.02 $200.09 105% Q2
Consulting Expenses $- $- $- $- $- Z
Fundraisers $3.41 $3.41 $3.41 $3.41 $13.63 105%
Health Care $11,448.00 $11,448.00 $11,448.00 $12,592.80 $43,936.80 105% HC
Merchandise Purchases $98.37 $98.37 $98.37 $98.37 $393.48 105%
Miscellaneous Expenses $75.00 $75.00 $75.00 $75.00 $300.00 F $25
Monitor Recycling $14,505.23 $13,389.44 $13,389.44 $14,505.23 $55,789.34 110% U
Other Facility $2,727.30 $2,727.30 $2,727.30 $2,727.30 $10,909.22 105%
Outreach Events $703.63 $703.63 $703.63 $703.63 $2,814.51 105%
Parts for online sales $- $77.77 $82.79 $90.31 $250.87 105% Q2
Payroll $46,193.85 $46,193.85 $46,193.85 $46,193.85 $184,775.40 100% YEC
Payroll Accounting $753.42 $753.42 $753.42 $753.42 $3,013.67 105% YEC
Program Supplies $325.53 $325.53 $325.53 $325.53 $1,302.14 105%
Recycling Disposal $59.89 $59.89 $59.89 $59.89 $239.58 105%
Rent $20,100.00 $20,100.00 $20,100.00 $20,100.00 $80,400.00 100%
Shipping $- $66.53 $70.82 $77.26 $214.61 105% Q2
Short Tills $129.24 $129.24 $129.24 $129.24 $516.97 105%
Staff Training and Education $78.75 $78.75 $78.75 $78.75 $315.00 105%
Taxes and Withholding $15,478.59 $15,478.59 $15,478.59 $15,478.59 $61,914.34 105%
Telecom $870.00 $870.00 $870.00 $870.00 $3,480.00 F $290.00
Theft and Fraud $202.78 $202.78 $202.78 $202.78 $811.13 105%
Utilities $4,850.80 $4,850.80 $4,850.80 $4,850.80 $19,403.20 110%
Volunteer rewards $47.50 $47.50 $47.50 $47.50 $190.00 105% YEC
Workers Compensation $319.73 $319.73 $319.73 $319.73 $1,278.90 105%
TOTAL EXPENSES $120,741.34 $119,769.85 $119,779.16 $122,053.72 $482,344.08
PROFIT (LOSS) $(3,219.25) $(1,164.78) $677.43 $3,713.59 $6.98
-2.67% -0.97% 0.57% 3.04% 0.00%
Assumption Key
F -- flat monthly amount
HC -- F $318*12 with 15% rise in Nov, Dec
Q2 -- begin in 2nd quarter
G -- growth (rising curve) 23% 25% 26% 27%
U -- U shaped curve 26% 24% 24% 26%
YEC -- year end constant
Z -- zero money in 2006
5% payroll = $3,125.23 $3,125.23 $3,125.23 $3,125.23 $12,500.92
10% payroll = $6,250.46 $6,250.46 $6,250.46 $6,250.46 $25,001.84
15% payroll = $9,375.69 $9,375.69 $9,375.69 $9,375.69 $37,502.76

Proposed Budget Changes (increases)

DRAFT - brainstorm list at the moment, add your line items, numbers and projects. These are not listed in any order of priority (yet).

Increase cash reserve amount to one months operating expenses

  • Approx. $30,000 ($10,000 existing and $40,000 current monthly expenses).
  • The cost of this item goes up with some of the budget increases proposed below.

Increase wages

  • Cost: unknown

Increase Staff

  • Cost: at current wages/hours approx. $2,200/month per 35 hour per week employee.

Increase Staff Hours

  • Adding hours for those who want more.
  • Increasing the maximum hours per week (up to 40)
  • Cost: unknown

Increase Wages

  • Cost: unknown

Open an additional day

  • Cost: unknown

Upgrade floor in mezzanine

  • $1,600 (materials only)

Upgrade lighting/acoustics in offices/classrooms

  • $20,000 (WAG)
  • Repairs to existing drywall ceiling to be paid for by landlord (approx. $2,500).

Upgrade lighting and lighting controls in warehouse

  • $1,200 (WAG)

Steel/cardboard bailer

  • $4,000 for equipment
  • $10,000 for electrical upgrades, concrete pad and fenced/roofed enclosure installation.

Notes and Assumptions

I started with the above Profit and Loss report for 2005, and then I started plugging in assumptions for each income and expense stream.

  • The last three rows show how much across the board staff raises would cost. They are not part of this conservative budget. Rather they are an option that could be added on if profit goes up more than anticipated by this budget.
  • This budget should be a conservative one that mostly assumes the status quo. We can use it to see what is likely to happen in 2006 without adding any "extras".
  • This budget shows a loss for the first two quarters of 2006, but those losses are recovered in the last two quarters. There is an operational reserve of around $10,000 that would get dipped into at the beginning of the year and replenished later on, if reality plays out like this budget predicts.
  • The "Growth" column should show how much growth in the budget exists over the previous year.
    • We're assuming a 5% growth rate in most small categories by default. This is represented by 105% in the "Factor" column.
    • Sales numbers were not tracked separately very well in 2005. That is, while we had separate categories for Retail and Wholesale sales, many wholesale sales were actually recorded in the Retail Sales expense account. Therefore, we've lumped all the sales numbers together to start with and then broken out the percentages for each type of sales from there (estimating 95% retail and 5% wholesale). Because of this, the growth factor for wholesale sales looks a bit high, but probably isn't.
    • Part way through 2005, we stopped selling stuff online and farmed it out to another organization. Therefore, there is activity in the Online Sales in Quarters 1 and 2, followed by activity in External Sales in Quarters 3 and 4. We are assuming that we will start selling items online again sometime in 2006 -- beginning of Quarter 2. This helps account for the larger growth factors reported in those categories.
    • Somewhere on the web it said that utilities would go up (PGE up by 5.3%, NW Natural up by 15.2%). We're guessing all utilities up by 10%.
    • Based on trends reflected in the database overall donations of major items (Monitors, Systems, and Printers) for 2006 will increase 10% over 2005. Monitors are expected to do significantly better due to low prices for LCD monitors. Monitor related accounts are therefore expected to grow by some measure higher than 10%. Nevertheless, we're using a 10% growth factor.
  • Tenant Sublets are supposed to be bringing in around $1,000 per month. We are investigating why this was not the case for 2005.
  • Certain categories of expense and income are altogether eliminated in this version. They might be reintroduced as a strategy for addressing weak spots or for other reasons in later versions of this budget. The eliminated categories in this version are marked with a Z in the assumptions column.

Old Notes

From the RT ticket we have a list of random things that should be included. Some of these may overlap with categories we already have in the books. Some may not even be desired -- this is just a brainstorm for now.

substitute fund
to pay workers to cover for vacation that staff takes, sick days, etc.
hiring expenses
get numbers from this year's hirings, estimate the number of hirings in 2006, and calculate
vacation payoffs
how many people will be quitting in 2006 (estimate based on past trends, estimate amount of unused vacation, calculate)
- (The way to this is to combind the "Substitute fund" above and this into an account for accrued payroll expenses - every pay period an amount equal to vacation time earned that period should be added to the fund and whenever vacation is used it should come out of this fund weather is a payoff or just vacation pay
nice to have a general fund
what's this mean?
a "staff vacation to breitenbush" fund
ha! sounds fun!
a physical plant fund for maintenance
we should anticipate projects that we might want to accomplish, and look at past expenses for maintenance.
repayment of personal loan
$1,000 per month to starting (April 2005) and ending at the end of 2005 (this will need to be included for a few months if we slip on our 2005 timeline)
re-keying the building
How much? We should do this every year and figure it into budget.
Board and officers insurance
Oso's getting a quote
Credit card processing fees
How much?
food for core breakfast and retreats, etc.
We should estimate how much it would cost to re-establish this practice
shawn wants a $100/mo ad fund
Like for outreach in general. $100 is an ideal number. Starting with $50 or even $25/month would be a good start.