ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
East Bend Farm Jan - Dec, 2019 (PY) Jan - Dec, 2020 TrendDriverFactor2021
2
Profit & LossSales Sensitivity0%
3
4
 Income
5
 Farm grown product$144,798$121,086-16%
PY Sales Inc.
30% $ 157,412
6
 Rent and other Income$381$46823%
PY Sales Inc.
0% $ 468
7
 Resale product income$18,879$17,733-6%
PY Sales Inc.
0% $ 17,733
8
 Total Income$164,058$139,288$175,613
9
Cost of Goods Sold
10
 Farm grown products$242
11
 Seeds$9,363$6,4985.4%% of sales5% $ 7,871
12
 Soil purchases$3370.3%% of sales2% $ 3,148
13
 Total Farm grown products$9,605$6,8355.6%% of sales$11,019
14
 Rental and other$715% of sales0% $ -
15
 Resale product$13,274$11,08262.5%% of sales60% $ 10,640
16
Total Cost of Goods Sold$23,594$17,917$21,659
17
Gross Profit$140,464$121,370$153,955
18
Expenses
19
 Labor
20
 Payroll Wages$49,360$51,29336.8%% of sales35% $ 61,465
21
 Contract Labor$6150.0%% of sales0% $ -
22
 Other Payroll Expense$6,422$6,6694.8%% of sales5% $ 8,781
23
 Total Labor$56,397$57,962$70,245
24
 Fixed Expenses
25
 Insurance$8,992$7,262-19.2%Fixed8000 $ 8,000
26
 Interest$2,290$3,10035.4%Fixed2500 $ 2,500
27
 Total Fixed Expenses$11,282$10,362$10,500
28
 General & Admin$25$40Budgeted100 $ 100
29
 Bank Service Charges$153$63-59%Budgeted50 $ 50
30
 Dues & Subscriptions$1,425$1,074-25%Budgeted1500 $ 1,500
31
 General & Admin - Other$1,525$1,426-7%Budgeted1500 $ 1,500
32
 Marketing$63-100%Budgeted0 $ -
33
 General$3,555$811-77%Budgeted100 $ 100
34
 Events$2,122$0-100%Budgeted500 $ 500
35
 Website + Print$2,010$1,937-4%Budgeted2000 $ 2,000
36
 Total Marketing$7,749$2,748$2,600
37
 Office Supplies$561$361-36%Budgeted500 $ 500
38
 Professional Fees$12,500$8,177-35%Budgeted5000 $ 5,000
39
 Total General & Admin$23,938$13,889$11,250
40
 Operating Expense
42
 Farming Supplies$4,722$1,2210.9%% of sales0.90% $ 1,581
43
 Fuel$2,621$2,5991.9%% of sales2% $ 3,512
44
 Farmers Market Fees$2,052$1,9641.4%% of sales1% $ 1,756
45
 Feed for livestock$3,036$2,4581.8%% of sales2% $ 3,512
46
 Repairs & Maintenance$5,761$3,9732.9%% of sales3% $ 5,268
47
 Credit Card Process Fees$2,348$2,0141.4%% of sales2% $ 3,512
48
 Sales Supplies for Market$539$1,0290.7%% of sales1% $ 1,756
49
 Utilities$4,677$5,0583.6%% of sales4% $ 7,025
50
 Rentals2,607.29 2,286.41 1.6%% of sales6% $ 10,537
51
 Total Operating Expense$28,363$22,602$38,459
52
 Uncategorized Expense$700$406
53
Total Expenses$120,680$105,221$130,455
54
Net Operating Income$19,783$16,149$23,500
55
Other Expenses
59
 Total Owner Draw$14,063$15,81012%Budgeted$30,000
60
 Reconciliation Discrepancies$0$1
61
Total Other Expenses$14,063$15,811$30,000
62
Net Other Income-$14,063-$15,811-$30,000
63
Net Income$5,720$339-$6,500
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104