COST PER CWT BEEF SOLD beefcost.xls
by: d. stein 9/03
1 GROSS TOTAL DOLLARS OF CATTLE SALES per year =====> $
2 Amount sold; lbs*==> Income / cwt;===> /cwt
3 Beef Calves sold
4 Cull Cows sold
5 total cattle sales
Gross sales of farm items other than beef:
6 Other Livestock: ====>
7 Corn, Wheat,ect; ===>
8 Other crops; ======>
9 Gov. Program Payment
10
11 Other==>
Total income $0
Cash Farm Expenses (mostly from Part II, Tax Form Schedule F)
12 Car, Truck 26 a & b Rent, Lease
13 Chemicals 27 Repairs, maint.
14 Conservation 28 Seeds, plants
15 Custom Hire 30 Supplies
18 Feed Purchase 31 Taxes
19 Fertilizer, Lime 32 Utilities
20 Freight, Trucking 33 Vet, breed, medicine
21 Gas, Fuel, Oil
22 Insurance 34 Other- Misc
23 Interest 35 marketing
24 Labor 36 legal/accounting
36 b
37 Feeder & heifer pur.
38 Cash Expenses Totaled You should adjust for inventory carried in (prior year)
Cost per cwt sold and pre-paids carried out for next year.
* Inventory changes=>
OUTPUT SECTION:::::
44 Non-beef income items totaled (lines 6+7+8+9+10+11)=======>
45 Cash expenses (line 38) minus non-beef income(line44); =======>
46 Cwt. beef form Line 2: -----------------------------------------------------------> cwts
47 Adjusted cash cost per cwt= (Line 45 divided by Line46) ------------------ /cwt
NET BEEF INCOME ---- /cwt
OVERHEAD
48 Family living; ======> /cwt
49 (Line 47+48) Cash Cost + family living per cwt.; =============> /cwt
50 Depreciation; ======> /cwt
51 Principal paid; ====> /cwt
52 Cash Exp. +FamilyLiv. + Depreciation ======> /cwt
53 Cash Exp. +FamilyLiv. + Principal =========> /cwt
by; d stein
SWINE COST OF PRODUCTION 12/8/2011
COST PER HEAD HOGS SOLD 2008 hogcost_head.xls
by: d. stein 3/06
1 GROSS TOTAL DOLLARS OF HOG SALES per year =============>
2 Amount sold; Hd.*==>
3 Income / Hd.;===> /head
4 Feeders sold 0
5 Cull Sows/Boars sold 0
6 total hog sales $0
7 Gross sales of farm items other than beef:
8 Other Livestock: ====>
9 Corn, Wheat,ect; ===>
10 Pat Div
11 Gov. Program Payment
12 Custom work
13 Other==>
14 Total income $0
15
16 Cash Farm Expenses (mostly from Part II, Tax Form Schedule F)
17 $/head $/head
18 Car, Truck #DIV/0! 26 a & b Rent, Lease #DIV/0!
19 Chemicals #DIV/0! 27 Repairs, maint. #DIV/0!
20 Conservation #DIV/0! 28 Seeds, plants #DIV/0!
21 Custom Hire #DIV/0! 30 Supplies #DIV/0!
22 Feed Purchase #DIV/0! 31 Taxes #DIV/0!
23 Fertilizer, Lime #DIV/0! 32 Utilities #DIV/0!
24 Freight, Trucking #DIV/0! 33 Vet, breed, medicine #DIV/0!
25 Gas, Fuel, Oil #DIV/0! Drying fuel #DIV/0!
26 Insurance #DIV/0! 34 Other- Misc #DIV/0!
27 Interest #DIV/0! 35 marketing #DIV/0!
28 Labor #DIV/0! 36 legal/accounting #DIV/0!
29 #DIV/0! 36 b crop insurance #DIV/0!
30 37 Feeder & heifer pur. #DIV/0!
31
32 Cash Expenses Totaled $0 You should adjust for inventory carried in (prior year)
33 All Cost per cwt sold #DIV/0! and pre-paids carried out for next year.
34 Total income per cwt #DIV/0! * Inventory changes=>
35
36 OUTPUT SECTION:::::
37 Non-Hog income items totaled (lines 6+7+8+9+10+11)=======> $0
38 Cash expenses (line 38) minus non-beef income(line44); =======> $0
39 Number of Hog sold form Line 2: -----------------------------------------------------> 0.00 Hd.
40 Adjusted cash cost per cwt= (Line 45 divided by Line46) ------------------> #DIV/0! /Hd.
41 NET ADJUSTED HOG INCOME ----> $0 #DIV/0! /Hd.
42 OVERHEAD
43 Family living; ======> #DIV/0! /Hd.
44 (Line 47+48) Cash Cost + family living per cwt.; =============> $0 #DIV/0! /Hd.
45 Depreciation; ======> #DIV/0! /Hd.
46 Principal paid; ====> #DIV/0! /Hd.
47 Cash Exp. +FamilyLiv. + Depreciation ======> $0 #DIV/0! /Hd.
48 Cash Exp. +FamilyLiv. + Principal =========> $0 #DIV/0! /Hd.
49
50
51
\\HOGcost_head.xls