Difference between revisions of "Budget 2007 Q1"

From FreekiWiki
Jump to navigation Jump to search
Line 1,179: Line 1,179:
  
 
=== G ===
 
=== G ===
 +
<table border="1">
 +
<tr>
 +
<td colspan="2"  valign="bottom"  align="left"  style=" font-size:10pt;"><b>Committee</b></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  valign="bottom"  align="left"  style=" font-size:10pt;">Q1</td>
 +
<td  valign="bottom"  align="left"  style=" font-size:10pt;">Q2</td>
 +
<td  valign="bottom"  align="left"  style=" font-size:10pt;">Q3</td>
 +
<td  valign="bottom"  align="left"  style=" font-size:10pt;">Q4</td>
 +
<td  valign="bottom"  align="left"  style=" font-size:10pt;">Q1 2008</td>
 +
<td  valign="bottom"  align="left"  style=" font-size:10pt;">Notes</td>
 +
</tr>
 +
<tr>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
<td colspan="2"  bgcolor="#CCFFFF" valign="bottom"  align="left"  style="background:#CCFFFF; font-size:10pt;"><i>Expenses</i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $168,476.52 </i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $179,957.77 </i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $180,463.92 </i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $188,247.10 </i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $192,844.51 </i></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
</tr>
 +
<tr>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="left"  style="background:#CCFFFF; font-size:10pt;"><i>Income</i></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $146,657.70 </i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $150,781.48 </i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $149,304.16 </i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $153,621.94 </i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $157,678.69 </i></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
</tr>
 +
<tr>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""><i></i></td>
 +
<td  style=""></td>
 +
<td  style=""><i></i></td>
 +
<td  style=""><i></i></td>
 +
<td  style=""><i></i></td>
 +
<td  style=""><i></i></td>
 +
<td  style=""><i></i></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="left"  style="background:#CCFFFF; font-size:10pt;"><i>Profit</i></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $(21,818.82)</i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $(29,176.29)</i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $(31,159.76)</i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $(34,625.16)</i></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="right"  style="background:#CCFFFF; font-size:10pt;"><i> $(35,165.81)</i></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"></td>
 +
</tr>
 +
<tr>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td colspan="3"  bgcolor="#CCFFFF" valign="bottom"  align="left"  style="background:#CCFFFF; font-size:10pt;"><b>Nonrecurring Expenses</b></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"><b></b></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="left"  style="background:#CCFFFF; font-size:10pt;"><b>Amount</b></td>
 +
<td  bgcolor="#CCFFFF" valign="bottom"  align="left"  style="background:#CCFFFF; font-size:10pt;"><b>Approved</b></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"><b></b></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"><b></b></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"><b></b></td>
 +
<td  bgcolor="#CCFFFF" style="background:#CCFFFF;"><b></b></td>
 +
</tr>
 +
<tr>
 +
<td colspan="3"  valign="bottom"  align="left"  style=" font-size:10pt;">Shipping Containers</td>
 +
<td  style=""></td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;"> $2,500.00 </td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;">10/1/06</td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td colspan="3"  valign="bottom"  align="left"  style=" font-size:10pt;">Carts and pallet jack</td>
 +
<td  style=""></td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;"> $1,000.00 </td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;">1/10/07</td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td colspan="2"  valign="bottom"  align="left"  style=" font-size:10pt;">Wiring black hole</td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;"> $1,500.00 </td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;">1/10/07</td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td colspan="3"  valign="bottom"  align="left"  style=" font-size:10pt;">Wiring advanced testing</td>
 +
<td  style=""></td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;"> $2,000.00 </td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;">1/10/07</td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td colspan="3"  valign="bottom"  align="left"  style=" font-size:10pt;">Classic gaming library</td>
 +
<td  style=""></td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;"> $  0.25 </td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;">1/10/07</td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td colspan="3"  valign="bottom"  align="left"  style=" font-size:10pt;">Plastic pallets for wholesale</td>
 +
<td  style=""></td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;"> $500.00 </td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;">1/10/07</td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
<tr>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  valign="bottom"  align="right"  style=" font-size:10pt;"> $7,500.25 </td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
<td  style=""></td>
 +
</tr>
 +
</table>

Revision as of 19:04, 12 January 2007

Income

Income Budget 2007
Category Q1 Q2 Q3 Q4 Q1 2008
Donations, C4K $− $− $− $- $-
Donations, Online $1,500.00 $750.00 $250.00 $250.00 $250.00
Donations, Other $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00
Donations, Regular $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00
Education $50.00 $50.00 $50.00 $50.00 $50.00
Fundraisers $− $− $− $− $−
Grants $− $− $− $− $−
Interest $150.00 $175.00 $200.00 $200.00 $200.00
Miscellaneous Income $500.00 $500.00 $500.00 $500.00 $500.00
Monitor Fees $29,011.13 $30,461.69 $27,629.65 $31,774.10 $33,362.80
Outreach Events $− $1,729.29 $1,800.00 $- $-
Overages $900.00 $900.00 $900.00 $900.00 $900.00
Pickups $− $− $− $− $−
Recycling Income $18,246.57 $18,611.50 $18,983.73 $19,553.24 $20,139.84
Sales, Online and External $2,600.00 $2,990.00 $3,438.50 $3,954.27 $4,547.42
Sales, Retail $50,000.00 $51,000.00 $52,020.00 $53,060.40 $54,121.61
Sales, Wholesale $10,700.00 $10,914.00 $11,132.28 $11,354.93 $11,582.02
Space Rental $− $− $- $- $-
Tech Support Income $750.00 $750.00 $750.00 $750.00 $750.00
Tenant Sublets $2,250.00 $1,950.00 $1,650.00 $1,275.00 $1,275.00
TOTAL INCOME $146,657.70 $150,781.48 $149,304.16 $153,621.94 $157,678.69

Expenses

Action Commiteee Expenses

Committee Q1 Q2 Q3 Q4 Q1 2008 Notes
Action
Facility
Equipment $200.00 $200.00 $200.00 $200.00 $200.00
Forklift $300.00 $300.00 $300.00 $300.00 $300.00
Improvements $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 ?
Maintainance $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 ?
Supplies $100.00 $100.00 $100.00 $100.00 $100.00
other
Receiving $150.00 $150.00 $150.00 $150.00 $150.00
Recycling
Disposal $50.00 $50.00 $50.00 $50.00 $50.00
Monitor Recycling $15,000.00 $15,750.00 $16,537.50 $17,364.38 $18,232.59 new vendor
Supplies $100.00 $100.00 $100.00 $100.00 $100.00
other
Safety $200.00 $200.00 $200.00 $200.00 $200.00
Tools $500.00 $500.00 $500.00 $500.00 $500.00
other
$19,600.00 $20,350.00 $21,137.50 $21,964.38 $22,832.59


C7 Committee Expenses

Committee Q1 Q2 Q3 Q4 Q1 2008 Notes
C7
Adminstration
Board and Officers Insurance $500.00 $500.00 $500.00 $500.00 $500.00 ?
Fees and Deposits $1,100.00 $1,100.00 $1,100.00 $1,100.00 $1,100.00 includes credit card fees
Legal Fees $300.00 $300.00 $300.00 $300.00 $300.00
Liability insurance $464.50 $464.50 $464.50 $464.50 $464.50
Mail and Postage $50.00 $50.00 $50.00 $50.00 $50.00
Office Supplies $325.00 $ 331.50 $ 338.13 $ 344.89 $ 351.79
Printing $150.00 $150.00 $150.00 $150.00 $150.00
Theft and Fraud $50.00 $50.00 $50.00 $50.00 $50.00
Rent $20,100.00 $20,100.00 $20,100.00 $20,100.00 $20,100.00 when does lease expire?
Short Tills
Front Desk Shortages $130.00 $130.00 $130.00 $130.00 $130.00
Other Petty Cash Shortages $130.00 $130.00 $130.00 $130.00 $130.00
Thrift Store Shortages $130.00 $130.00 $130.00 $130.00 $130.00
Staff
Employee Withholding
Federal $3,546.87 $3,901.56 $3,901.56 $4,038.11 $4,179.45
Medicare $1,051.95 $1,157.15 $1,157.15 $1,197.65 $1,239.57
OR State $3,555.47 $3,911.02 $3,911.02 $4,047.91 $4,189.58
Social Security $4,498.10 $4,947.91 $4,947.91 $5,121.09 $5,300.32
Total Employee Withholding $12,652.40 $13,917.64 $13,917.64 $14,404.76 $14,908.92
Health Care $15,258.67 $15,258.67 $15,258.67 $18,000.00 $18,000.00
Payroll Accounting $710.00 $710.00 $710.00 $710.00 $710.00
Payroll Taxes
Medicare $1,051.95 $1,157.15 $1,157.15 $1,197.65 $1,239.57
OR SUI $1,160.81 $1,276.90 $1,276.90 $1,321.59 $1,367.84
Social Security $4,498.10 $4,947.91 $4,947.91 $5,121.09 $5,300.32
Total Payroll Taxes $6,710.87 $7,381.95 $7,381.95 $7,640.32 $7,907.73
Payroll, Commision $650.00 $747.50 $859.63 $988.57 $1,136.85
Payroll, Regular $53,940.56 $59,334.61 $59,334.61 $61,411.32 $63,560.72
Payroll, Substitutes $5,205.38 $5,725.91 $5,725.91 $5,926.32 $6,133.74
Workers Compensation $315.63 $315.63 $315.63 $315.63 $315.63
Transportation
Bus fare reimbursement $55.00 $55.00 $55.00 $55.00 $55.00
Fuel $10.00 $10.00 $10.00 $10.00 $10.00
Parking $10.00 $10.00 $10.00 $10.00 $10.00
Rentals $50.00 $50.00 $50.00 $50.00 $50.00
Utilities
Electricity $3,249.00 $3,249.00 $3,249.00 $3,249.00 $3,249.00
Garbage $81.40 $81.40 $81.40 $81.40 $81.40
Gas $1,100.00 $200.00 $200.00 $1,000.00 $1,100.00
Other Telecom $85.53 $85.53 $85.53 $85.53 $85.53
Phone $735.45 $735.45 $735.45 $735.45 $735.45
Water and Sewer $908.87 $908.87 $908.87 $908.87 $908.87
other
$144,521.52 $153,512.77 $153,631.52 $161,076.64 $165,231.80
HR
Staff Training and Education $250.00 $250.00 $250.00 $250.00 $250.00
other
$ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00

B

C

D

E

F

G

Committee Q1 Q2 Q3 Q4 Q1 2008 Notes
Expenses $168,476.52 $179,957.77 $180,463.92 $188,247.10 $192,844.51
Income $146,657.70 $150,781.48 $149,304.16 $153,621.94 $157,678.69
Profit $(21,818.82) $(29,176.29) $(31,159.76) $(34,625.16) $(35,165.81)
Nonrecurring Expenses Amount Approved
Shipping Containers $2,500.00 10/1/06
Carts and pallet jack $1,000.00 1/10/07
Wiring black hole $1,500.00 1/10/07
Wiring advanced testing $2,000.00 1/10/07
Classic gaming library $ 0.25 1/10/07
Plastic pallets for wholesale $500.00 1/10/07
$7,500.25