Template:Quarterly 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