Firm ID Cost of Animal Feed (per animal per year) Cost of Plant Supplies (per bushel produced per year) Cost of Labor (annually) Livestock sold (annually) Crop Production (bu annually) Livestock price Crop price Acres Land price per acre Annuitized value of land (annual) Explicit Costs 1 500 41 0 206 88 4 0 885 1724 9 119936 1100 59 0 2 579 44 0 224 16 6 0 632 1868 0 239309 31 29 803 6 3 69 34 0 373 8 62 0 100 3115 4 470973 974 9 443 14 4 670 77 0 1197 96 25 0 789 9983 2 942435 2056 2 1868 73 5 364 34 0 4625 64 82 0 938 38547 22 018249 59411 62 4989 98 6 72 67 0 168 84 29 0 97 1407 4 920597 484 63 241 51 7 328 31 0 256 08 4 0 992 2134 7 814499 1167 33 584 39 8 372 85 0 221 52 6 0 564 1846 6 463397 835 2 594 37 9 0 2 89 7 98 0 65 6 18 133 14 890977 138 64 10 87 10 0 2 61 483 42 0 6771 3 57 8057 11 185653 6308 6 486 03 11 177 56 0 1155 30 0 640 9625 12 729232 8576 32 1332 56 12 0 3 5 1041 36 0 15778 3 3 17356 3 742177 4546 45 1044 86 13 596 11 0 235 44 6 0 697 1962 1 87974 258 16 831 55 14 586 14 0 1251 31 0 674 10425 0 810625 591 55 1837 14 15 0 4 83 55 08 0 444 6 2 918 4 616972 296 69 59 91 16 299 6 0 156 24 3 0 973 1302 16 218664 1478 17 455 84 17 0 3 38 108 66 0 1141 4 76 1811 16 910508 2143 74 112 04 18 3 73 0 777 72 2441 0 5 31 6481 5 468252 2480 78 781 45 19 375 2 0 2712 6 58 0 780 22605 9 140271 14463 11 3087 8 20 424 28 0 54 84 2 0 511 457 4 721532 151 04 479 12 21 19 02 0 73 2 17 0 71 610 19 850377 847 61 92 22 22 284 37 0 125 76 3 0 746 1048 8 702271 638 4 410 13 23 0 2 91 67 32 0 1093 3 08 1122 1 850954 145 37 70 23 24 0 4 05 92 4 0 733 6 3 1540 9 674864 1042 95 96 45 25 0 2 68 717 78 0 9779 3 67 11963 11 013941 9223 18 720 46 26 5 75 0 139 32 380 0 6 1 1161 0 693678 56 38 145 07 27 0 4 65 170 46 0 1837 4 64 2841 0 977592 194 41 175 11 28 0 2 16 102 06 0 1379 3 7 1701 9 05254 1077 89 104 22 29 288 87 0 147 3 0 842 1225 14 79942 1269 05 435 87 30 0 3 04 45 24 0 413 5 48 754 26 131048 1379 2 48 28 31 519 07 0 2656 44 53 0 826 22137 6 18266 9580 59 3175 51 32 0 4 49 71 7 0 941 3 81 1195 11 686033 977 54 76 19 33 0 2 42 383 94 0 3014 6 37 6399 24 741842 11082 61 386 36 34 55 03 0 729 24 126 0 96 6077 5 595748 2380 38 784 27 35 672 97 0 11986 08 258 0 774 99884 1 157156 8090 69 12659 05 36 531 04 0 205 32 6 0 620 1711 1 457621 174 58 736 36 37 0 3 19 35 82 0 580 3 09 597 3 344673 139 77 39 01 38 394 05 0 149 28 3 0 820 1244 18 296109 1593 23 543 33 39 166 04 0 902 28 24 0 640 7519 10 12395 5328 54 1068 32 40 600 53 0 211 44 3 0 998 1762 7 449563 918 83 811 97 41 204 89 0 1472 28 36 0 672 12269 17 26285 14825 85 1677 17 42 683 59 0 920 88 25 0 611 7674 3 533534 1898 14 1604 47 43 299 61 0 4662 12 88 0 876 38851 8 914322 24243 12 4961 73 44 0 5 04 3118 38 0 32551 4 79 51973 4 366871 15887 16 3123 42 45 27 04 0 9705 6 2378 0 68 80880 8 886149 50309 82 9732 64 46 150 17 0 43 44 1 0 655 362 16 357044 414 49 193 61 47 0 4 95 271 5 0 2754 4 93 4525 1 282678 406 29 276 45 48 0 3 96 10 68 0 109 4 9 178 9 225674 114 95 14 64 49 0 2 3 4505 76 0 44878 5 02 75096 20 377932 107121 08 4508 06 50 4 04 0 48 48 153 0 5 27 404 2 255842 63 8 52 52 51 39 47 0 5087 16 874 0 97 42393 17 761262 52706 72 5126 63 52 483 01 0 3166 56 65 0 804 26388 11 989788 22147 06 3649 57 53 409 33 0 2611 92 79 0 553 21766 3 979846 6063 77 3021 25 54 128 31 0 102 6 3 0 518 855 10 608187 634 9 230 91 55 655 15 0 3704 04 80 0 770 30867 2 742335 5925 34 4359 19 56 272 31 0 233 64 7 0 546 1947 17 394664 2370 72 505 95 57 1055 75 0 170 16 3 0 997 1418 5 015677 497 86 1225 91 58 0 4 21 71 58 0 530 6 75 1193 13 844895 1156 19 75 79 59 83 67 0 338 04 54 0 104 2817 4 999716 985 89 421 71 60 521 18 0 1468 32 26 0 925 12236 5 158781 4418 6 1989 5 61 0 1 48 86 46 0 994 4 35 1441 37 006037 3732 8 87 94 62 609 02 0 1878 48 32 0 969 15654 9 20658 10088 39 2487 5 63 54 48 0 5569 56 1497 0 62 46413 1 427903 4639 13 5624 04 64 98 37 0 38 76 5 0 119 323 1 403189 31 73 137 13 65 0 1 24 91 2 0 1104 4 13 1520 20 818829 2215 12 92 44 66 2 74 0 147 48 323 0 7 61 1229 20 015557 1721 94 150 22 67 748 51 0 67 92 2 0 651 566 9 467261 375 09 816 43 68 693 65 0 197 52 3 0 995 1646 5 475298 630 86 891 17 69 71 88 0 2205 6 548 0 67 18380 3 545967 4562 24 2277 48 70 0 3 81 610 38 0 5847 5 22 10173 9 350174 6658 35 614 19 71 0 2 63 109 86 0 854 6 43 1831 30 310087 3884 84 112 49 72 801 83 0 215 04 5 0 711 1792 6 915977 867 54 1016 87 73 1111 81 0 166 92 3 0 959 1391 5 754824 560 35 1278 73 74 0 4 2 773 88 0 7632 5 07 12898 8 670266 7828 04 778 08 75 788 91 0 105 24 2 0 702 877 5 173238 317 58 894 15 76 293 5 0 982 32 27 0 589 8186 17 553303 10058 39 1275 82 77 0 4 34 34 32 0 289 5 94 572 7 857762 314 63 38 66 78 326 03 0 188 04 5 0 619 1567 6 726956 737 88 514 07 79 0 3 26 50 64 0 619 4 09 844 5 184822 306 32 53 9 80 98 35 0 13 2 3 0 91 110 5 206727 40 09 111 55 81 52 25 0 152 76 31 0 83 1273 4 44839 396 4 205 01 82 275 58 0 220 32 6 0 645 1836 16 009858 2057 59 495 9 83 485 01 0 737 04 18 0 673 6142 6 300348 2708 77 1222 05 84 1 63 0 418 56 1301 0 5 36 3488 20 746846 5065 55 420 19 85 493 09 0 843 96 19 0 731 7033 9 643346 4747 52 1337 05 86 25 66 0 850 08 189 0 75 7084 12 330339 6114 37 875 74 87 62 12 0 168 33 0 85 1400 5 005471 490 54 230 12 88 363 98 0 153 36 5 0 551 1278 11 301408 1011 02 517 34 89 0 6 82 246 12 0 2075 5 93 4102 10 429115 2994 62 252 94 90 0 3 67 452 76 0 4208 5 38 7546 13 178631 6961 22 456 43 91 226 3 0 558 84 17 0 544 4657 20 194761 6583 29 785 14 92 8 38 0 526 56 1114 0 7 88 4388 2 808933 862 79 534 94 93 274 29 0 989 4 28 0 582 8245 8 182696 4722 64 1263 69 94 338 4 0 1431 48 36 0 654 11929 15 475537 12922 54 1769 88 95 371 23 0 179 28 4 0 881 1494 18 222691 1905 73 550 51 96 372 23 0 205 2 5 0 716 1710 6 352731 760 42 577 43 97 0 3 36 84 24 0 818 5 15 1404 20 187457 1984 02 87 6 98 32 4 0 4759 08 702 0 113 39659 16 597003 46075 44 4791 48 99 715 86 0 76 92 2 0 693 641 1 770608 79 45 792 78 100 0 3 53 5214 36 0 51730 5 04 86906 8 238137 50116 05 5217 89 Are there any farms that are not economically profitable How many A farm which is just barely on the cusp of earning economic profit is what percentile of profit

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 12, 2024

Firm ID Cost of Animal Feed (per animal per year) Cost of Plant Supplies (per bushel produced per year) Cost of Labor (annually) Livestock sold

Firm ID	Cost of Animal Feed (per animal per year)	Cost of Plant Supplies (per bushel produced per year)	Cost of Labor (annually)	Livestock sold (annually)	Crop Production (bu annually)	Livestock price	Crop price	Acres	Land price per acre	Annuitized value of land (annual)	Explicit Costs
1	500.41	0	206.88	4	0	885		1724	9.119936	1100.59	0
2	579.44	0	224.16	6	0	632		1868	0.239309	31.29	803.6
3	69.34	0	373.8	62	0	100		3115	4.470973	974.9	443.14
4	670.77	0	1197.96	25	0	789		9983	2.942435	2056.2	1868.73
5	364.34	0	4625.64	82	0	938		38547	22.018249	59411.62	4989.98
6	72.67	0	168.84	29	0	97		1407	4.920597	484.63	241.51
7	328.31	0	256.08	4	0	992		2134	7.814499	1167.33	584.39
8	372.85	0	221.52	6	0	564		1846	6.463397	835.2	594.37
9	0	2.89	7.98	0	65		6.18	133	14.890977	138.64	10.87
10	0	2.61	483.42	0	6771		3.57	8057	11.185653	6308.6	486.03
11	177.56	0	1155	30	0	640		9625	12.729232	8576.32	1332.56
12	0	3.5	1041.36	0	15778		3.3	17356	3.742177	4546.45	1044.86
13	596.11	0	235.44	6	0	697		1962	1.87974	258.16	831.55
14	586.14	0	1251	31	0	674		10425	0.810625	591.55	1837.14
15	0	4.83	55.08	0	444		6.2	918	4.616972	296.69	59.91
16	299.6	0	156.24	3	0	973		1302	16.218664	1478.17	455.84
17	0	3.38	108.66	0	1141		4.76	1811	16.910508	2143.74	112.04
18	3.73	0	777.72	2441	0	5.31		6481	5.468252	2480.78	781.45
19	375.2	0	2712.6	58	0	780		22605	9.140271	14463.11	3087.8
20	424.28	0	54.84	2	0	511		457	4.721532	151.04	479.12
21	19.02	0	73.2	17	0	71		610	19.850377	847.61	92.22
22	284.37	0	125.76	3	0	746		1048	8.702271	638.4	410.13
23	0	2.91	67.32	0	1093		3.08	1122	1.850954	145.37	70.23
24	0	4.05	92.4	0	733		6.3	1540	9.674864	1042.95	96.45
25	0	2.68	717.78	0	9779		3.67	11963	11.013941	9223.18	720.46
26	5.75	0	139.32	380	0	6.1		1161	0.693678	56.38	145.07
27	0	4.65	170.46	0	1837		4.64	2841	0.977592	194.41	175.11
28	0	2.16	102.06	0	1379		3.7	1701	9.05254	1077.89	104.22
29	288.87	0	147	3	0	842		1225	14.79942	1269.05	435.87
30	0	3.04	45.24	0	413		5.48	754	26.131048	1379.2	48.28
31	519.07	0	2656.44	53	0	826		22137	6.18266	9580.59	3175.51
32	0	4.49	71.7	0	941		3.81	1195	11.686033	977.54	76.19
33	0	2.42	383.94	0	3014		6.37	6399	24.741842	11082.61	386.36
34	55.03	0	729.24	126	0	96		6077	5.595748	2380.38	784.27
35	672.97	0	11986.08	258	0	774		99884	1.157156	8090.69	12659.05
36	531.04	0	205.32	6	0	620		1711	1.457621	174.58	736.36
37	0	3.19	35.82	0	580		3.09	597	3.344673	139.77	39.01
38	394.05	0	149.28	3	0	820		1244	18.296109	1593.23	543.33
39	166.04	0	902.28	24	0	640		7519	10.12395	5328.54	1068.32
40	600.53	0	211.44	3	0	998		1762	7.449563	918.83	811.97
41	204.89	0	1472.28	36	0	672		12269	17.26285	14825.85	1677.17
42	683.59	0	920.88	25	0	611		7674	3.533534	1898.14	1604.47
43	299.61	0	4662.12	88	0	876		38851	8.914322	24243.12	4961.73
44	0	5.04	3118.38	0	32551		4.79	51973	4.366871	15887.16	3123.42
45	27.04	0	9705.6	2378	0	68		80880	8.886149	50309.82	9732.64
46	150.17	0	43.44	1	0	655		362	16.357044	414.49	193.61
47	0	4.95	271.5	0	2754		4.93	4525	1.282678	406.29	276.45
48	0	3.96	10.68	0	109		4.9	178	9.225674	114.95	14.64
49	0	2.3	4505.76	0	44878		5.02	75096	20.377932	107121.08	4508.06
50	4.04	0	48.48	153	0	5.27		404	2.255842	63.8	52.52
51	39.47	0	5087.16	874	0	97		42393	17.761262	52706.72	5126.63
52	483.01	0	3166.56	65	0	804		26388	11.989788	22147.06	3649.57
53	409.33	0	2611.92	79	0	553		21766	3.979846	6063.77	3021.25
54	128.31	0	102.6	3	0	518		855	10.608187	634.9	230.91
55	655.15	0	3704.04	80	0	770		30867	2.742335	5925.34	4359.19
56	272.31	0	233.64	7	0	546		1947	17.394664	2370.72	505.95
57	1055.75	0	170.16	3	0	997		1418	5.015677	497.86	1225.91
58	0	4.21	71.58	0	530		6.75	1193	13.844895	1156.19	75.79
59	83.67	0	338.04	54	0	104		2817	4.999716	985.89	421.71
60	521.18	0	1468.32	26	0	925		12236	5.158781	4418.6	1989.5
61	0	1.48	86.46	0	994		4.35	1441	37.006037	3732.8	87.94
62	609.02	0	1878.48	32	0	969		15654	9.20658	10088.39	2487.5
63	54.48	0	5569.56	1497	0	62		46413	1.427903	4639.13	5624.04
64	98.37	0	38.76	5	0	119		323	1.403189	31.73	137.13
65	0	1.24	91.2	0	1104		4.13	1520	20.818829	2215.12	92.44
66	2.74	0	147.48	323	0	7.61		1229	20.015557	1721.94	150.22
67	748.51	0	67.92	2	0	651		566	9.467261	375.09	816.43
68	693.65	0	197.52	3	0	995		1646	5.475298	630.86	891.17
69	71.88	0	2205.6	548	0	67		18380	3.545967	4562.24	2277.48
70	0	3.81	610.38	0	5847		5.22	10173	9.350174	6658.35	614.19
71	0	2.63	109.86	0	854		6.43	1831	30.310087	3884.84	112.49
72	801.83	0	215.04	5	0	711		1792	6.915977	867.54	1016.87
73	1111.81	0	166.92	3	0	959		1391	5.754824	560.35	1278.73
74	0	4.2	773.88	0	7632		5.07	12898	8.670266	7828.04	778.08
75	788.91	0	105.24	2	0	702		877	5.173238	317.58	894.15
76	293.5	0	982.32	27	0	589		8186	17.553303	10058.39	1275.82
77	0	4.34	34.32	0	289		5.94	572	7.857762	314.63	38.66
78	326.03	0	188.04	5	0	619		1567	6.726956	737.88	514.07
79	0	3.26	50.64	0	619		4.09	844	5.184822	306.32	53.9
80	98.35	0	13.2	3	0	91		110	5.206727	40.09	111.55
81	52.25	0	152.76	31	0	83		1273	4.44839	396.4	205.01
82	275.58	0	220.32	6	0	645		1836	16.009858	2057.59	495.9
83	485.01	0	737.04	18	0	673		6142	6.300348	2708.77	1222.05
84	1.63	0	418.56	1301	0	5.36		3488	20.746846	5065.55	420.19
85	493.09	0	843.96	19	0	731		7033	9.643346	4747.52	1337.05
86	25.66	0	850.08	189	0	75		7084	12.330339	6114.37	875.74
87	62.12	0	168	33	0	85		1400	5.005471	490.54	230.12
88	363.98	0	153.36	5	0	551		1278	11.301408	1011.02	517.34
89	0	6.82	246.12	0	2075		5.93	4102	10.429115	2994.62	252.94
90	0	3.67	452.76	0	4208		5.38	7546	13.178631	6961.22	456.43
91	226.3	0	558.84	17	0	544		4657	20.194761	6583.29	785.14
92	8.38	0	526.56	1114	0	7.88		4388	2.808933	862.79	534.94
93	274.29	0	989.4	28	0	582		8245	8.182696	4722.64	1263.69
94	338.4	0	1431.48	36	0	654		11929	15.475537	12922.54	1769.88
95	371.23	0	179.28	4	0	881		1494	18.222691	1905.73	550.51
96	372.23	0	205.2	5	0	716		1710	6.352731	760.42	577.43
97	0	3.36	84.24	0	818		5.15	1404	20.187457	1984.02	87.6
98	32.4	0	4759.08	702	0	113		39659	16.597003	46075.44	4791.48
99	715.86	0	76.92	2	0	693		641	1.770608	79.45	792.78
100	0	3.53	5214.36	0	51730		5.04	86906	8.238137	50116.05	5217.89

Are there any farms that are not economically profitable? How many? A farm which is just barely on the cusp of earning economic profit is what percentile of profit?