Difference between revisions of "User:Rfs/Other Scratch Page"
< User:Rfs
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | + | <table border="1"> | |
+ | <caption>Sheet1</caption> | ||
+ | <tr> | ||
+ | <td style=""></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i>Q1 (1-3, 2005)</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i>Q2 (4-6, 2005)</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i>Q3 (7-9, 2005)</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i>Q4 (10-12, 2005 est)</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i><b>Year</b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i><b>Income Accounts:</b></i></td> | ||
+ | <td style=""></td> | ||
+ | <td style=""></td> | ||
+ | <td style=""></td> | ||
+ | <td style=""></td> | ||
+ | <td style=""><i><b></b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Consulting</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $7,135.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $7,135.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>E-scrap Recovery</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $8,944.32 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $16,259.75 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $8,564.52 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $13,772.51 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $47,541.10 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Education</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,040.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $380.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $120.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $1,540.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>External Sales</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $414.05 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $959.90 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $1,373.95 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Fundraisers</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,519.54 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,379.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,902.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $4,800.54 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Interest</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $30.52 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $18.64 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $12.16 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $8.43 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $69.75 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Miscellaneous Income</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $180.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $180.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Monitor Fees</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $27,560.50 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $25,953.10 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $34,785.94 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $23,724.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $112,023.54 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Online Donations</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $370.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,551.91 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $10.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $1,931.91 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Online Sales</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $908.14 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,005.23 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $1,913.37 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Overages</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,481.41 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $545.42 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $2,026.83 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Pickups</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $175.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $175.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Regular Donations</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $20,044.91 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $34,929.12 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $24,406.04 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $17,976.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $97,356.07 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Retail Sales</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $36,071.36 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $35,450.98 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $40,195.65 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $41,216.18 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $152,934.17 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Space Rental</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $100.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $100.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Sponsorship</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $167.70 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $3.80 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $171.50 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Tenant Sublets</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $2,292.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $998.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $987.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,675.50 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $5,952.50 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Wholesale Sales</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $609.42 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $40.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $398.25 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $728.85 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $1,776.52 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i><b>Total Income</b></i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $99,490.71 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $118,133.43 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $113,455.82 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $107,921.77 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i><b> $439,001.73 </b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style=""><i></i></td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td style=""></td> | ||
+ | <td style=""><i></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style=""></td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td style=""></td> | ||
+ | <td style=""><i></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i><b>Expense Accounts:</b></i></td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;">   </td> | ||
+ | <td style=""></td> | ||
+ | <td style=""><i></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Adminstration</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,978.12 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,678.80 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,412.50 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,061.24 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $6,130.66 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Auction fees</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $74.11 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $47.64 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $11.24 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $132.99 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Consulting Expenses</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,160.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $7,135.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $8,295.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Facility, Other</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$3,144.74</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$1,423.29</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$793.02</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $513.59 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $5,874.64 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Facility, Rent</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$19,900.00</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$20,100.00</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$20,100.00</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $20,100.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $80,200.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Facility, Telecom</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$792.84</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$744.37</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$749.46</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $663.95 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $2,950.62 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Facility, Utilities</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$4,926.06</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$3,682.00</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$4,292.21</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $4,528.59 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $17,428.86 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Fundraisers</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $229.49 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $544.62 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $1,919.36 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $2,693.47 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Merchandise Purchases</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $109.78 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $264.96 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $374.74 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Miscellaneous Expenses</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $600.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $600.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Monitor Recycling</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $10,832.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $9,551.50 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $15,558.08 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $12,328.50 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $48,270.08 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Parts for online sales</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $79.64 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $79.64 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Program Supplies</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $309.75 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $2.99 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $788.41 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $145.49 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $1,246.64 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Recycling Disposal</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $78.12 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $103.57 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $100.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $281.69 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Shipping</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $68.13 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $460.74 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $86.69 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $615.56 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Short Tills</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $235.73 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $23.39 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $259.12 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Staff, Health Care</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$9,891.99</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$7,438.19</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$7,941.10</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $7,436.16 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $32,707.44 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Staff, Other</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$18,041.19</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$14,792.58</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$15,274.69</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $15,016.25 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $63,124.71 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Staff, Payroll</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$49,621.20</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$44,551.80</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$43,539.67</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $46,000.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $183,712.67 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Staff, Workers Compensation</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$304.50</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$304.50</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;">$304.50</td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $304.50 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $1,218.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Staff Training and Education</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $300.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $300.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Theft and Fraud</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $60.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $60.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><i>Volunteer rewards</i></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $42.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $- </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"> $120.00 </td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i> $162.00 </i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><b>Total Expenses</b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $120,303.54 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $105,708.10 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $114,630.23 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $116,076.63 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i><b> $456,718.50 </b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style=""></td> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><i><b></b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><b>Profit (without Grants)</b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $(20,812.83)</b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $12,425.33 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $(1,174.41)</b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $(8,154.86)</b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i><b> $(17,716.77)</b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style=""></td> | ||
+ | <td style=""></td> | ||
+ | <td style=""></td> | ||
+ | <td style=""></td> | ||
+ | <td style=""></td> | ||
+ | <td style=""><i><b></b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><b>Grants</b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $1,708.25 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $1,000.00 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $11,300.00 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $16,200.00 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i><b> $30,208.25 </b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><b></b></td> | ||
+ | <td style=""><i><b></b></i></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td valign="bottom" align="left" style=" font-size:10pt;"><b>Profit (with Grants)</b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $(19,104.58)</b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $13,425.33 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $10,125.59 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><b> $8,045.14 </b></td> | ||
+ | <td valign="bottom" align="right" style=" font-size:10pt;"><i><b> $12,491.48 </b></i></td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | <p><table border="1"> | ||
+ | <caption>Sheet2</caption> | ||
+ | <tr> | ||
+ | <td style=""></td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | <p><table border="1"> | ||
+ | <caption>Sheet3</caption> | ||
+ | <tr> | ||
+ | <td style=""></td> | ||
+ | </tr> | ||
+ | </table> |
Revision as of 16:20, 6 December 2005
Q1 (1-3, 2005) | Q2 (4-6, 2005) | Q3 (7-9, 2005) | Q4 (10-12, 2005 est) | Year | |
Income Accounts: | |||||
Consulting | $- | $- | $- | $7,135.00 | $7,135.00 |
E-scrap Recovery | $8,944.32 | $16,259.75 | $8,564.52 | $13,772.51 | $47,541.10 |
Education | $1,040.00 | $380.00 | $120.00 | $- | $1,540.00 |
External Sales | $- | $- | $414.05 | $959.90 | $1,373.95 |
Fundraisers | $1,519.54 | $1,379.00 | $1,902.00 | $- | $4,800.54 |
Interest | $30.52 | $18.64 | $12.16 | $8.43 | $69.75 |
Miscellaneous Income | $- | $- | $- | $180.00 | $180.00 |
Monitor Fees | $27,560.50 | $25,953.10 | $34,785.94 | $23,724.00 | $112,023.54 |
Online Donations | $370.00 | $1,551.91 | $10.00 | $- | $1,931.91 |
Online Sales | $908.14 | $1,005.23 | $- | $- | $1,913.37 |
Overages | $- | $- | $1,481.41 | $545.42 | $2,026.83 |
Pickups | $- | $- | $175.00 | $- | $175.00 |
Regular Donations | $20,044.91 | $34,929.12 | $24,406.04 | $17,976.00 | $97,356.07 |
Retail Sales | $36,071.36 | $35,450.98 | $40,195.65 | $41,216.18 | $152,934.17 |
Space Rental | $100.00 | $- | $- | $- | $100.00 |
Sponsorship | $- | $167.70 | $3.80 | $- | $171.50 |
Tenant Sublets | $2,292.00 | $998.00 | $987.00 | $1,675.50 | $5,952.50 |
Wholesale Sales | $609.42 | $40.00 | $398.25 | $728.85 | $1,776.52 |
Total Income | $99,490.71 | $118,133.43 | $113,455.82 | $107,921.77 | $439,001.73 |
Expense Accounts: | |||||
Adminstration | $1,978.12 | $1,678.80 | $1,412.50 | $1,061.24 | $6,130.66 |
Auction fees | $74.11 | $47.64 | $11.24 | $- | $132.99 |
Consulting Expenses | $- | $- | $1,160.00 | $7,135.00 | $8,295.00 |
Facility, Other | $3,144.74 | $1,423.29 | $793.02 | $513.59 | $5,874.64 |
Facility, Rent | $19,900.00 | $20,100.00 | $20,100.00 | $20,100.00 | $80,200.00 |
Facility, Telecom | $792.84 | $744.37 | $749.46 | $663.95 | $2,950.62 |
Facility, Utilities | $4,926.06 | $3,682.00 | $4,292.21 | $4,528.59 | $17,428.86 |
Fundraisers | $229.49 | $544.62 | $1,919.36 | $- | $2,693.47 |
Merchandise Purchases | $109.78 | $264.96 | $- | $- | $374.74 |
Miscellaneous Expenses | $- | $- | $- | $600.00 | $600.00 |
Monitor Recycling | $10,832.00 | $9,551.50 | $15,558.08 | $12,328.50 | $48,270.08 |
Parts for online sales | $79.64 | $- | $- | $- | $79.64 |
Program Supplies | $309.75 | $2.99 | $788.41 | $145.49 | $1,246.64 |
Recycling Disposal | $- | $78.12 | $103.57 | $100.00 | $281.69 |
Shipping | $68.13 | $460.74 | $86.69 | $- | $615.56 |
Short Tills | $- | $- | $235.73 | $23.39 | $259.12 |
Staff, Health Care | $9,891.99 | $7,438.19 | $7,941.10 | $7,436.16 | $32,707.44 |
Staff, Other | $18,041.19 | $14,792.58 | $15,274.69 | $15,016.25 | $63,124.71 |
Staff, Payroll | $49,621.20 | $44,551.80 | $43,539.67 | $46,000.00 | $183,712.67 |
Staff, Workers Compensation | $304.50 | $304.50 | $304.50 | $304.50 | $1,218.00 |
Staff Training and Education | $- | $- | $300.00 | $- | $300.00 |
Theft and Fraud | $- | $- | $60.00 | $- | $60.00 |
Volunteer rewards | $- | $42.00 | $- | $120.00 | $162.00 |
Total Expenses | $120,303.54 | $105,708.10 | $114,630.23 | $116,076.63 | $456,718.50 |
Profit (without Grants) | $(20,812.83) | $12,425.33 | $(1,174.41) | $(8,154.86) | $(17,716.77) |
Grants | $1,708.25 | $1,000.00 | $11,300.00 | $16,200.00 | $30,208.25 |
Profit (with Grants) | $(19,104.58) | $13,425.33 | $10,125.59 | $8,045.14 | $12,491.48 |