4-H Dairy Steer Carcass Class Results.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2								Minnesota State Fair 4-H							Mac Scan
3								Market Beef							Dallas McDermott
4	mcdermott.dallas@gmail.com							8/26/26							(712) 579-1615
5
6										Base	Total			Relative
7				Est.	Rib			USDA	USDA	Carc.	Carcass	Carcass		Value of
8			Live	Carc.	Eye		%	Quality	Yield	Price	Premium	Value	% Retail	Retail
9	Exhibitor	ID	Wt.	Wt.	Area	Fat	IMF	Grade	Grade	/ cwt	(Discount)	/cwt	Product	Product	Rank
10	NICK LEIFELD	68834	1410	825	14.1	0.22	9.6	High Choice	2.2	360.00	0.00	360.00	66.57	239.65	1
11	TYSON PRIGGE	67397	1365	799	13.3	0.20	4.8	Low Choice	2.3	360.00	0.00	360.00	66.22	238.39	2
12	KARLIJN SPANGENBERG	50659	1310	766	12.1	0.15	6.3	Choice	2.4	360.00	0.00	360.00	65.58	236.10	3
13	LAWSON JAX	63917	1475	863	14.0	0.29	6.3	Choice	2.5	360.00	0.00	360.00	65.27	234.99	4
14	CARTER DICKE	17655	1505	880	14.0	0.29	4.8	Low Choice	2.6	360.00	0.00	360.00	65.09	234.33	5
15	VINCE BECHTOLD	67536	1310	766	11.7	0.16	6.5	Choice	2.6	360.00	0.00	360.00	65.08	234.28	6
16	GEORGE HERGET	73788	1510	883	14.8	0.39	6.1	Choice	2.6	360.00	0.00	360.00	65.02	234.06	7
17	NORA DOHRN	74625	1545	904	11.4	0.36	10.2	Low Prime	3.7	360.00	23.00	383.00	60.89	233.21	8
18	ROMAN WARMKAGATHJE	75823	1595	933	14.8	0.35	6.3	Choice	2.7	360.00	0.00	360.00	64.71	232.96	9
19	HAZEL VOLKMANN	69618	1430	837	12.3	0.20	7.3	Choice	2.7	360.00	0.00	360.00	64.48	232.13	10
20	TEAGAN GUENTZEL	50660	1320	772	11.3	0.17	5.1	Low Choice	2.8	360.00	0.00	360.00	64.31	231.53	11
21	JOSEPH LONERGAN	66323	1580	924	13.9	0.32	7.8	High Choice	2.9	360.00	0.00	360.00	64.09	230.74	12
22	ELLIOTT RENK	69862	1195	699	11.9	0.37	5.9	Choice	2.8	360.00	0.00	360.00	64.07	230.67	13
23	CARSON WENDINGER	70856	1595	933	14.6	0.40	7.1	Choice	2.9	360.00	0.00	360.00	64.05	230.60	14
24	COLTON GUNNINK	64090	1760	1030	14.4	0.28	6.1	Choice	3.0	360.00	0.00	360.00	63.67	229.21	15
25	CARTER JACOBS	69491	1615	945	15.5	0.93	10.4	Low Prime	4.0	360.00	23.00	383.00	59.68	228.57	16
26	LAURA HERGET	73785	1465	857	14.2	0.20	2.8	Low Select	2.2	360.00	(17.00)	343.00	66.49	228.06	17
27	BEAU LACEY	69397	1620	948	12.9	0.24	4.8	Low Choice	3.1	360.00	0.00	360.00	63.34	228.03	18
28	NORA THORMODSON	75701	1445	845	13.8	0.50	7.6	Choice	3.1	360.00	0.00	360.00	63.15	227.34	19
29	NOLAN WARMKAGATHJE	75112	1545	904	13.6	0.41	8.4	High Choice	3.1	360.00	0.00	360.00	63.00	226.82	20
30	RIDLEY WILLS	73347	1655	968	13.2	0.29	5.8	Low Choice	3.2	360.00	0.00	360.00	62.88	226.38	21
31	THOMAS HAGSTROM	21571	1320	772	10.7	0.26	6.9	Choice	3.2	360.00	0.00	360.00	62.76	225.93	22
32	KILEIGH BROCKWAY	70750	1610	942	13.0	0.32	4.7	Low Choice	3.2	360.00	0.00	360.00	62.72	225.80	23
33	GAVIN LEWISON	73775	1720	1006	14.7	0.44	6.3	Choice	3.2	360.00	0.00	360.00	62.72	225.79	24
34	MAKENZIE MEYERS	68878	1305	763	11.3	0.35	5.9	Choice	3.2	360.00	0.00	360.00	62.63	225.47	25
35	SAMANTHA BECHTOLD	67534	1745	1021	14.0	0.35	9.1	High Choice	3.3	360.00	0.00	360.00	62.57	225.27	26
36	BRIANNA BROGAN	64752	1280	749	9.6	0.20	6.0	Choice	3.3	360.00	0.00	360.00	62.34	224.42	27
37	THAIN SMIDT	64938	1325	775	13.2	0.30	2.3	Low Select	2.5	360.00	(17.00)	343.00	65.35	224.15	28
38	CHLOE HAUGEN	69614	1515	886	13.7	0.54	5.4	Low Choice	3.3	360.00	0.00	360.00	62.13	223.66	29
39	KAMRYN LEHNERTZ	75841	1620	948	13.1	0.38	4.5	Low Choice	3.4	360.00	0.00	360.00	62.12	223.65	30
40	LEXIS LEHNERTZ	75842	1685	986	13.8	0.42	6.3	Choice	3.4	360.00	0.00	360.00	62.08	223.50	31
41	LINCOLN DICKE	69753	1520	889	13.3	0.49	5.3	Low Choice	3.4	360.00	0.00	360.00	62.06	223.41	32
42	BO HOLST	69714	1690	989	14.5	0.51	5.6	Low Choice	3.4	360.00	0.00	360.00	62.02	223.28	33
43	MILES MUEHLENHARDT	59815	1635	956	15.8	0.73	7.2	Choice	3.4	360.00	0.00	360.00	61.90	222.85	34
44	LUKAS LEHNERTZ	75844	1495	875	11.9	0.36	7.6	Choice	3.4	360.00	0.00	360.00	61.83	222.58	35
45	GABBY PETERS	60728	1650	965	15.4	0.68	7.2	Choice	3.4	360.00	0.00	360.00	61.82	222.55	36
46	MASON VANNURDEN	59582	1600	936	14.6	0.68	7.5	Choice	3.6	360.00	0.00	360.00	61.21	220.36	37
47	HUDSON SCHLAUDERAFF	68199	1645	962	11.9	0.33	9.1	High Choice	3.7	360.00	0.00	360.00	60.97	219.49	38
48	LANDON DOERING	69831	1590	930	14.0	0.64	7.1	Choice	3.6	360.00	0.00	360.00	60.95	219.42	39
49	ELIZABETH ENDE	67539	1680	983	12.0	0.32	6.3	Choice	3.7	360.00	0.00	360.00	60.91	219.27	40
50	KAMDEN PETERS	75439	1465	857	11.6	0.46	8.0	High Choice	3.7	360.00	0.00	360.00	60.77	218.77	41
51	JOSEPH BUCK	69418	1705	997	14.6	0.64	6.7	Choice	3.7	360.00	0.00	360.00	60.74	218.66	42
52	KARINA ERICKSON	69467	1550	907	13.0	0.57	7.1	Choice	3.7	360.00	0.00	360.00	60.70	218.53	43
53	ADDISON MATTSON	69442	1605	939	15.4	0.87	8.0	High Choice	3.8	360.00	0.00	360.00	60.19	216.69	44
54	BRINLEIGH BROCKWAY	72293	1690	989	13.2	0.54	8.3	High Choice	3.9	360.00	0.00	360.00	60.13	216.47	45
55	ANNA CORBIN	70744	1630	954	12.5	0.54	6.5	Choice	4.0	360.00	0.00	360.00	59.82	215.35	46
56	MILLIE DOHRN	74655	1645	962	14.5	0.77	7.3	Choice	3.9	360.00	0.00	360.00	59.81	215.32	47
57	ROYCE JAX	63915	1570	918	13.0	0.65	5.8	Choice	3.9	360.00	0.00	360.00	59.79	215.25	48
58	LEO SMITH	73028	1625	951	13.0	0.63	5.0	Low Choice	4.0	360.00	(16.00)	344.00	59.55	204.86	49
59	EMILY BROGAN	64747	1585	927	10.3	0.38	8.6	High Choice	4.2	360.00	(16.00)	344.00	58.95	202.78	50
60	LANCE PETERS	69419	1545	904	13.3	0.89	5.5	Low Choice	4.4	360.00	(16.00)	344.00	57.94	199.33	51
61	JACKSEN WILLS	73343	1430	837	9.0	0.66	5.3	Low Choice	5.0	360.00	(16.00)	344.00	55.77	191.84	52
62
63
64	Base Price - Choice, YG 3					Quality Grade Premiums			Quality Grade Discounts				Carcass Weight Discounts
65	$360.00					$23 - Prime			$18 - Select				>1100# - $15
66						$7 - CAB			$45 - Standard				<550# - $45
67
68	Dairy Steer Discount					Yield Grade Premiums			Yield Grade Discounts				Dressing %
69	$0/cwt					$10 - YG1			$16 - YG 4				Beef - 62.5%
70						$5- YG2			$32.00 - YG 5				Dairy - 58.5%
71
72	% Retail Product = 65.59-(9.931xFat)+(1.2259xRib Eye)-(0.013166xCarcass Wt.)-(1.29xKPH)
73	Relative Value of Retail Product = Carcass Price per Lb. X % Retail Product
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