Copy 2 of KTC StepByStep Budget Builder Training - Start Up Farm.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1		SALES
2
3		INPUT													START HERE
4		DO NOT TOUCH													Annual Sales Goal
5			Set your sales goal and adjust the check digit cell to relfect it.												$400,000
6			Input sales per customer per month in orange cells.
7		Customer/Sales Channel	January	February	March	April	May	June	July	August	September	October	November	December	Subtotals/customer
8		CSA	$7,500	$8,300	$14,200	$17,000	$25,000	$35,000	$19,000	$28,500	$24,500	$40,000	$14,000	$2,000	$235,000
9		Farmers Market	$0		$0		$5,900	$5,100	$6,000	$5,000	$3,000	$3,000	$800	$0	$28,800
10		Wholesale	$365	$500	$800	$1,600	$1,000	$1,000	$500	$500	$500	$800	$600	$794	$8,959
11															$0
12															$0
13															$0
14															$0
15															$0
16															$0
17															$0
18															$0
19		Totals/month	$7,865	$8,800	$15,000	$18,600	$31,900	$41,100	$25,500	$34,000	$28,000	$43,800	$15,400	$2,794
20
21															$272,759	Annual total sales
22														This is the remainder to achieve:	-$127,241	Check digit for annual goal
23
24															45.00%	Labor % of sales		35-38% is a healthy labor ratio, but does not include owner pay
25															$122,742	Labor allowance		Use 45-48% if you are including owner pay in your labor budget
26
27
28		LABOR
29
30
31				Input hours per month per employee in the orange cells.
32			$/hr	Jan	$$$	Feb	$$$	Mar	$$$	Apr	$$$	May	$$$	Jun	$$$	Jul	$$$	Aug	$$$	Sep	$$$	Oct	$$$	Nov	$$$	Dec	$$$	Subtotals	Salary	Over/Under
33		Asst Mng	$22.00		$0	80	$1,760	172	$3,784	172	$3,784	172	$3,784	172	$3,784	172	$3,784	172	$3,784	172	$3,784	172	$3,784	172	$3,784	86	$1,892	$37,708	$40,000	$2,292
34		Pack Shed Mng	$20.00		$0		$0	172	$3,440	172	$3,440	172	$3,440	172	$3,440	172	$3,440	172	$3,440	172	$3,440	172	$3,440	172	$3,440	86	$1,720	$32,680	$35,000	$2,320
35		Apprentice	$13.00		$0		$0	172	$2,236	172	$2,236	172	$2,236	172	$2,236	172	$2,236	172	$2,236	172	$2,236	172	$2,236	172	$2,236		$0	$20,124	$20,000	-$124
36		Farmhand FT	$16.00		$0		$0	150.5	$2,408	150.5	$2,408	172	$2,752	172	$2,752	172	$2,752	172	$2,752	172	$2,752	172	$2,752	150.5	$2,408		$0	$23,736	$25,000	$1,264
37		Farmhand PT1	$16.00		$0		$0		$0		$0	86	$1,376	86	$1,376	86	$1,376	86	$1,376	86	$1,376	86	$1,376	43	$688		$0	$8,944	$10,000	$1,056
38		Farmhand PT2	$16.00		$0		$0		$0		$0		$0	86	$1,376	86	$1,376	86	$1,376	86	$1,376		$0		$0		$0	$5,504	$5,000	-$504
39		Farm Owner(s)	$35.00	129	$4,515	120	$4,200	172	$6,020	193.5	$6,773	193.5	$6,773	215	$7,525	215	$7,525	215	$7,525	215	$7,525	193.5	$6,773	172	$6,020	129	$4,515	$75,688	$70,000	-$5,688
40																												$204,384	$205,000	$617
41			Monthly hours totals	129		200		838.5		860		967.5		1075		1075		1075		1075		967.5		881.5		301
42			Monthly dollars totals		$4,515		$5,960		$17,888		$18,641		$20,361		$22,489		$22,489		$22,489		$22,489		$20,361		$18,576		$8,127
43
44		Full time person equivalent per week		0.8		1.2		4.9		5.0		5.6		6.3		6.3		6.3		6.3		5.6		5.1		1.8
45
46		Grand total dollars
47		$204,384
48
49	40%	$510,959	Required revenue for the projected labor based on %
50
51	45%	$454,186	Required revenue for the projected labor based on %
52
53		$122,742	Labor allowance from Sales calculation
54
55	13%	$26,570	Potential % fringe (taxes, benefits, etc)
56
57		-$108,212	Check digit for allowance minus projected costs
58
59
60
61
62
63
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