Difference between revisions of "Actual Expenses Compared to Budget"

From FreekiWiki
Jump to navigation Jump to search
(data entry correction complete)
 
(5 intermediate revisions by the same user not shown)
Line 9: Line 9:
  
 
(Totals and interesting line items are in '''bold''' text.)
 
(Totals and interesting line items are in '''bold''' text.)
 +
 +
[[Image:Income-pie-2006-q1.png|thumb|right|Income Pie Chart.]]
 +
[[Image:Expenses-pie-2006-q1.png|thumb|right|Expenses Pie Chart.]]
  
 
<table border="1">
 
<table border="1">
Line 379: Line 382:
 
<td  valign="bottom"  align="left"  style=" font-size:10pt;">Workers Compensation</td>
 
<td  valign="bottom"  align="left"  style=" font-size:10pt;">Workers Compensation</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;"> $319.73 </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;"> $319.73 </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;"> $  959.19 </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;"> $  319.74 </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;"> $ 639.46 </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;"> $- </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;">300%</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;">100%</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 393: Line 396:
 
<td  valign="bottom"  align="left"  style=" font-size:10pt;"><b>TOTAL EXPENSES</b></td>
 
<td  valign="bottom"  align="left"  style=" font-size:10pt;"><b>TOTAL EXPENSES</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;"><b> $120,741.35 </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;"><b> $120,741.35 </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;"><b> $114,733.65 </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;"><b> $114,094.20 </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;"><b> $(6,007.70)</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;"><b> $(6,647.15)</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; border-right:thin solid #000000;"><b>95%</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; border-right:thin solid #000000;"><b>95%</b></td>
 
</tr>
 
</tr>
Line 407: Line 410:
 
<td  valign="bottom"  align="left"  style=" font-size:10pt;"><b>PROFIT (LOSS)</b></td>
 
<td  valign="bottom"  align="left"  style=" font-size:10pt;"><b>PROFIT (LOSS)</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;"><b> $(3,219.26)</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;"><b> $(3,219.26)</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;"><b> $25,165.51 </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;"><b> $25,804.96 </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;"><b> $28,384.77 </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;"><b> $29,024.22 </b></td>
 
<td  style=" border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000; border-right:thin solid #000000;"><b></b></td>
 
<td  style=" border-top:thin solid #000000; border-bottom:thin solid #000000; border-left:thin solid #000000; border-right:thin solid #000000;"><b></b></td>
 
</tr>
 
</tr>
 
</table>
 
</table>
  
 +
 +
 +
== See Also ==
 +
* [[Finances at a glance, Q1 2006]]
  
 
[[Category: Finances]]
 
[[Category: Finances]]

Latest revision as of 09:10, 20 April 2006

Budgeted Q1
The amount we budgeted (expected to spend and earn) for the first quarter opf 2006
Actual
The amount we actually spent and earned for the first quarter opf 2006
Diff
The difference between the budget and actual expenses in dollars.
%
The difference between the budget and actual expenses as a percentage (above 100% means we were over budget -- less than 100% means we were under budget).

(Totals and interesting line items are in bold text.)

Income Pie Chart.
Expenses Pie Chart.
Income and Expenses 2006, Quarter 1, Budget vs Actual
Budgeted Q1 Actual Diff %
Consulting $ - $ - $ -
Donations, C4K $6.56 $ - $ (6.56) 0%
Donations, Online $539.94 $32.20 $ (507.74) 6%
Donations, Regular $25,854.48 $27,685.59 $1,831.11 107%
Education $404.25 $160.00 $ (244.25) 40%
Fundraisers $348.02 $ - $ (348.02) 0%
Grants $ - $ - $ -
Interest $29.62 $63.12 $ 33.50 213%
Miscellaneous Income $31.75 $ 686.13 $ 654.38 2161%
Monitor Fees $32,934.48 $28,575.50 $(4,358.98) 87%
Outreach Events $912.12 $ - $ (912.12) 0%
Overages $322.44 $917.42 $ 594.98 285%
Pickups $ - $ - $ -
Recycling Income $11,931.96 $18,256.73 $6,324.77 153%
Sales, External $1,048.53 $1,637.78 $ 589.25 156%
Sales, Online $ - $1,795.98 $1,795.98 (UP)
Sales, Retail $38,150.02 $54,612.69 $16,462.67 143%
Sales, Wholesale $2,007.90 $2,371.02 $ 363.12 118%
Space Rental $ - $ - $ -
Sponsorship $ - $ - $ -
Tenant Sublets $3,000.00 $3,105.00 $ 105.00 104%
Untracked Adjustments $ - $ - $ -
TOTAL INCOME $117,522.09 $139,899.16 $22,377.07 119%
Adminstration $1,579.87 $ 1,451.63 $ (128.24) 92%
Advertising $140.44 $69.00 $ (71.44) 49%
Auction fees $50.02 $ - $ (50.02) 0%
Consulting Expenses $ - $ - $ -
Fundraisers $3.41 $ - $ (3.41) 0%
Health Care $11,448.00 $8,824.55 $(2,623.45) 77%
Merchandise Purchases $98.37 $ - $ (98.37) 0%
Miscellaneous Expenses $75.00 $50.00 $ (25.00) 67%
Monitor Recycling $14,505.23 $12,104.56 $(2,400.67) 83%
Other Facility $2,727.30 $4,802.07 $2,074.77 176%
Outreach Events $703.63 $50.00 $ (653.63) 7%
Parts for online sales $ - $ - $ -
Payroll $46,193.85 $45,988.46 $ (205.39) 100%
Payroll Accounting $753.42 $738.48 $ (14.94) 98%
Program Supplies $325.53 $640.62 $ 315.09 197%
Recycling Disposal $59.89 $57.45 $ (2.44) 96%
Rent $20,100.00 $20,100.00 $ - 100%
Shipping $ - $6.72 $ 6.72
Short Tills $129.24 $370.59 $ 241.35 287%
Staff Training and Education $78.75 $ - $ (78.75) 0%
Taxes and Withholding $15,478.59 $11,095.63 $(4,382.96) 72%
Telecom $870.00 $729.76 $ (140.24) 84%
Theft and Fraud $202.78 $ - $ (202.78) 0%
Utilities $4,850.80 $6,436.68 $1,585.88 133%
Volunteer rewards $47.50 $258.26 $ 210.76 544%
Workers Compensation $319.73 $ 319.74 $- 100%
TOTAL EXPENSES $120,741.35 $114,094.20 $(6,647.15) 95%
PROFIT (LOSS) $(3,219.26) $25,804.96 $29,024.22


See Also