Financial Trends 2009 - Revision history

Rfs: /* Overview */

2010-01-09T20:05:22Z

Overview

Rfs: /* Hard Drives */

2009-12-10T00:05:55Z

Hard Drives

Dave: /* Hard Drives */

2009-12-09T20:27:20Z

Hard Drives

Dave: /* Network Devices */

2009-12-09T02:52:22Z

Network Devices

Dave: /* Network Devices */

2009-12-09T02:48:01Z

Network Devices

Dave: /* Laptops */

2009-12-09T01:41:16Z

Laptops

Rfs: /* Recycling */

2009-12-09T00:54:35Z

Recycling

Rfs: /* Front Desk */

2009-12-09T00:49:25Z

Front Desk

Rfs: /* Occupancy */

2009-12-09T00:48:37Z

Occupancy

Rfs: /* Staffing */

2009-12-09T00:46:09Z

Staffing

← Older revision		Revision as of 20:05, 9 January 2010
Line 2:		Line 2:

	== Overview ==		== Overview ==
		+
		+	<table border="1">
		+	<caption>Quarter by Quarter Income and Expenses 2008-2009</caption>
		+	<tr>
		+	<td style=""><b></b></td>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Q1 2008</b></td>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Q2 2008</b></td>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Q3 2008</b></td>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Q4 2008</b></td>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Q1 2009</b></td>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Q2 2009</b></td>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Q3 2009</b></td>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Q4 2009</b></td>
		+	</tr>
		+	<tr>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Income</b></td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $229,744.99 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $217,708.27 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $218,767.35 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $187,418.39 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $205,752.82 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $233,876.62 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $262,149.86 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000; border-right:thin solid #000000;"> $281,813.02 </td>
		+	</tr>
		+	<tr>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Expenses</b></td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $192,906.49 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $197,644.73 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $207,570.77 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $211,437.01 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $187,025.35 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $197,683.52 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000;"> $209,334.00 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-left:thin solid #000000; border-right:thin solid #000000;"> $219,874.84 </td>
		+	</tr>
		+	<tr>
		+	<td valign="bottom" align="left" style=" font-size:10pt;"><b>Net</b></td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000;"> $ 36,838.50 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000;"> $ 20,063.54 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000;"> $ 11,196.58 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000;"> $  (24,018.62)</td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000;"> $ 18,727.47 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000;"> $ 36,193.10 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000;"> $ 52,815.86 </td>
		+	<td valign="bottom" align="right" style=" font-size:10pt; border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000; border-right:thin solid #000000;"> $ 61,938.18 </td>
		+	</tr>
		+	</table>
		+
		+	[[Image:IncomeExpenseHistory.svg]]
		+
		+	The above table shows and chart shows the years 2008 and 2009, quarter by quarter, with income and expenses compared. Except for Q4 2008 income exceeded expenses and the net income has been growing since. The problem with Q4 were severalfold, including a snow storm that shut us down for much of December, the collapse of the commodities market which cut into recycling income, and the general financial meltdown which diminished monetary contributions.

	[[Image:IncomePie.svg]] [[Image:ExpensePie.svg]]		[[Image:IncomePie.svg]] [[Image:ExpensePie.svg]]

@@ Line 100: / Line 100: @@
 [[Image:HardDrives.svg]]
-In 2009 hard drive scarcity started to ease up quite a bit.  Historically HDs had been
+In 2009 hard drive scarcity started to ease up quite a bit.  Historically HDs had been a limiting factor as to what could be built and sold.  Due to increased quality and quantity of donations we now have many more hard drives that can be both built into systems and sold on their own in the store.
 The dip in December 2008 could be related to the snow storm.

@@ Line 100: / Line 100: @@
 [[Image:HardDrives.svg]]
-The dip in December 2008 could be related to the snow storm.
+In 2009 hard drive scarcity started to ease up quite a bit.  Historically HDs had been
-Any other comments?
+The dip in December 2008 could be related to the snow storm.
 ==== LCD Monitors ====

@@ Line 124: / Line 124: @@
 [[Image:NetDevices.svg]]
-The jump on January that can be seen in the upward trend correlates with improvements that were made to the network testing procedures in advanced testing.
+The jump in January 2009 that can be seen in the upward trend correlates with improvements that were made to the network testing procedures in advanced testing.
 ==== Macintoshes ====

@@ Line 124: / Line 124: @@
 [[Image:NetDevices.svg]]
-What happened in January 2009 that made that line jump up like that? What was happening in Advanced Testing?
+The jump on January that can be seen in the upward trend correlates with improvements that were made to the network testing procedures in advanced testing.
 ==== Macintoshes ====

@@ Line 93: / Line 93: @@
 [[Image:Laptops.svg]]
-When did Jeff leave as Laptop Coordinator?
+Jeff started winding down in his role as coordinator of laptops in August 2008 and left completely in Nov of 2008.  We tried out a different coordinator in the area for a few months.  We became unsatisfied with the results and then Dave and Ali took over leadership roles in the area in April of 2009.
-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.
+Starting in Spring of 2009 there were more laptop classes set up. You can see Dave and Ali's vacations reflected in the bottom points of the "W" shape in July and September.
 ==== Hard Drives ====

@@ Line 56: / Line 56: @@
 [[Image:Recycling.svg]]
-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).
+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.
 === Sales ===

← Older revision		Revision as of 00:49, 9 December 2009
Line 50:		Line 50:

	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).		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).
		+
		+	What explains that bump in July 2009?

	=== Recycling ===		=== Recycling ===

← Older revision		Revision as of 00:48, 9 December 2009
Line 42:		Line 42:
	This is our second biggest expense. This covers rent and utilities and associated costs.		This is our second biggest expense. This covers rent and utilities and associated costs.

		+	Rent and most utilities are paid monthly. Water and sewage is paid quarterly, explaining the quarterly spikes. Heating in the winter and cooling in the summer mostly cancel each other out. Starting in July 2009, we got a property tax exemption which reduced our rent.

	== Major Income Streams ==		== Major Income Streams ==

← Older revision		Revision as of 00:46, 9 December 2009
Line 31:		Line 31:

	This is our biggest expense. This covers payroll and all benefits and associated costs.		This is our biggest expense. This covers payroll and all benefits and associated costs.
		+
		+	In 2008 and 2009 most of the slow increase reflects gradually more hours being paid for. In November there was a bonus given out (explains the peak for that month). In December 2008 most of the hourly workers went unpaid due to unexpected snow closures.
		+
		+	Starting September 2009, Staff Collective went from 37 to 40 paid hours per week, explaining the most recent upward slope.

	=== Occupancy ===		=== Occupancy ===