Financial Trends 2009
This is for showing financial trends in 2008 and 2009. I'll put graphs and explanations here.
Overview
These income and expense pie charts help to understand where the money comes from and goes in general. The data is based on monthly averages for the 2008-2009 years (so far).
The above chart shows Free Geek's Income, month by month, over the period of 2008 and 2009 (so far). This chart excludes one time income since its purpose is to show the overall trends. You can see that the largest income stream is Sales with Donations and Recycling coming in about tied for second place.
The above chart shows Free Geek's Income, month by month, over the period of 2008 and 2009 (so far). This chart excludes one time expenses since its purpose is to show the overall trends. You can see that Staffing expenses are the largest expense by far. Occupancy expenses are next, about a quarter of staffing.
This shows the results of subtracting expenses from income, that is the net income (or loss). This chart excludes one time income and expenses since its purpose is to show the overall trends.
Same chart, but this one includes one time income and expenses. You may note that net income is positive in the same months, regardless of the one time income and expenses.
Major Expense Streams
Staffing
This is our biggest expense. This covers payroll and all benefits and associated costs.
Occupancy
This is our second biggest expense. This covers rent and utilities and associated costs.
Major Income Streams
Front Desk
Here are the income streams related to the Front Desk. You can see that mandatory Fees dropped dramatically at the beginning of 2009 (due to the e-waste legislation).
Recycling
This shows the basic recycling income stream, plus the reimbursements from NCER (which started at the beginning of 2009 along with the e-waste legislation. Also included is a related expense. Note that recycling expenses (the red line) were much larger in 2008 (before the legislation) compared to 2009 (after).
Sales
Sales is the biggest income stream for Free Geek. You can see the effect of the December 2008 weather which closed Free Geek for much of the month. Also, short months such as November and February show slight dips. The overall trend is upward, though.
The following charts show trends based on various gizmo types and categories. Please note that the sales numbers below are different that the sales numbers used above. This is due to a quirk in our database code. The database reports that produce the below reports show sales based on total retail price -- that is the amount the item sold for as if coupons and discounts were real money. The above sales chart shows the actual amount of money charged for the items (a lower number). However, it appears that the trends are similar between the two ways of counting the money.
Breaking down sales income:
- Regular systems (non-Mac) make up about 21% of the sales.
- Laptops (including some of the Mac Laptop sales) make up about 11%.
- Hard Drives 8%
- LCD Monitors 7%
- Cards 5%
- Stuff from printerland 4%
- Net Devices 4%
- Mac Systems (including some Mac laptops) 3%
- Everything else that can be easily tracked is 3% or less, combined to 37%.
Systems
Systems seem to be on a bumpy slope downwards, probably due mostly to increased laptop and mac sales.
Laptops
When did Jeff leave as Laptop Coordinator?
Starting in Spring of 2009 there were more laptop classes set up. Dave and Ali started focusing more on the area. You can see Dave and Ali's vacations reflected in the bottom points of the "W" shape in July and September.
Hard Drives
The dip in December 2008 could be related to the snow storm.
Any other comments?
LCD Monitors
Growth, obviously. Any comments?
It would be good to compare this with incoming numbers.
Cards
Comments?
Printerland
Kind of bumpy. When were which staff in charge? What did they do? When was Printerland more or less organized (and more or less disorganized)?
Network Devices
What happened in January 2009 that made that line jump up like that? What was happening in Advanced Testing?
Macintoshes
There is obviously a spike in October. Why?
There was a conscious decision to focus on higher end stuff, increase the number of Mac classes, and get volunteer interns involved in the process. When did this happen?
Miscellaneous
2008 seems pretty flat compared to 2009. Was there anything happening (in the store as opposed to improved production flow) to explain that?
Volunteer interns started to take hold in the first and second quarter of 2009.
When did we start putting more paid sales hours on the schedule?