小森牧場和牛販売実績
うし
2022-11-09
1 種牛別㎏単価
## # A tibble: 6 × 10
## SEX cattle price date age weight agd year_month sex
## <chr> <chr> <dbl> <dttm> <dbl> <dbl> <dbl> <chr> <chr>
## 1 ♂ 勝早桜５_… 842 2022-07-12 00:00:00 257 348 1.35 2022-07 mail
## 2 ♂ 勝早桜５_… 788 2022-07-12 00:00:00 263 323 1.23 2022-07 mail
## 3 ♂ 勝早桜５_… 806 2022-07-12 00:00:00 272 333 1.22 2022-07 mail
## 4 ♂ 福之姫_も… 837 2022-07-12 00:00:00 273 340 1.25 2022-07 mail
## 5 ♂ 百合白清… 879 2022-07-12 00:00:00 284 374 1.32 2022-07 mail
## 6 ♂ 知恵久_ゆ… 799 2022-06-15 00:00:00 272 388 1.43 2022-06 mail
## # ℹ 1 more variable: kg_price <dbl>
## # A tibble: 6 × 10
## SEX cattle price date age weight agd year_month sex
## <chr> <chr> <dbl> <dttm> <dbl> <dbl> <dbl> <chr> <chr>
## 1 ♂ 勝早桜５_… 842 2022-07-12 00:00:00 257 348 1.35 2022-07 mail
## 2 ♂ 勝早桜５_… 788 2022-07-12 00:00:00 263 323 1.23 2022-07 mail
## 3 ♂ 勝早桜５_… 806 2022-07-12 00:00:00 272 333 1.22 2022-07 mail
## 4 ♂ 福之姫_も… 837 2022-07-12 00:00:00 273 340 1.25 2022-07 mail
## 5 ♂ 百合白清… 879 2022-07-12 00:00:00 284 374 1.32 2022-07 mail
## 6 ♂ 知恵久_ゆ… 799 2022-06-15 00:00:00 272 388 1.43 2022-06 mail
## # ℹ 1 more variable: kg_price <dbl>
2 販売価格と出荷日齢
昨年の秋以降、急激に出荷価格が落ち込んだため日齢が進むにつれて低下しているように見えますが実際は６０日前後で80kg前後と抜群の発育です。
3 販売実績
3.1 子牛(精液_母牛)
3.2 父牛(精液)主軸にプロット
3.3 母牛を主軸にプロット
4 分析
4.1 和牛販売価格を母牛で集計
和牛販売価格を母牛で集計(雄牛) | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
母牛 | あいこ３０, N = 41 | うめはなやすみ, N = 41 | かお, N = 11 | かぐら１２, N = 11 | かつひめふく, N = 11 | さきひさ, N = 11 | さくら, N = 11 | はなふくひさ, N = 11 | ひさこ, N = 21 | ひさじげ, N = 71 | ひさゆき, N = 111 | ふくのひめ, N = 61 | ふくひめ, N = 51 | みらい１, N = 71 | もこ, N = 21 | ゆりひさこ, N = 71 | ゆりふじきよ, N = 31 |
price | 850(782,872) | 805(653,900) | 615(615,615) | 833(833,833) | 739(739,739) | 842(842,842) | 796(796,796) | 879(879,879) | 694(684,704) | 853(678,936) | 836(667,949) | 758(703,797) | 826(750,907) | 803(620,871) | 914(837,991) | 840(744,929) | 715(704,719) |
year | |||||||||||||||||
2022 | 4 (100%) | 2 (50%) | 0 (0%) | 1 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 1 (100%) | 2 (100%) | 7 (100%) | 10 (91%) | 3 (50%) | 4 (80%) | 5 (71%) | 2 (100%) | 4 (57%) | 3 (100%) |
2023 | 0 (0%) | 2 (50%) | 1 (100%) | 0 (0%) | 1 (100%) | 1 (100%) | 1 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 1 (9.1%) | 3 (50%) | 1 (20%) | 2 (29%) | 0 (0%) | 3 (43%) | 0 (0%) |
1中央値(最小値,最大値); n (%) | |||||||||||||||||
和牛販売価格を母牛で集計(雌牛) | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
母牛 | あいこ３０, N = 81 | うめはなやすみ, N = 51 | かぐら１２, N = 11 | さきひさ, N = 11 | はなひさ, N = 21 | ひさかみ, N = 11 | ひさじげ, N = 21 | ひさゆき, N = 71 | ふくのひめ, N = 21 | ふくひめ, N = 41 | みらい１, N = 51 | もこ, N = 21 | ゆりひさこ, N = 81 | ゆりふじきよ, N = 21 |
price | 686(500,750) | 649(611,671) | 653(653,653) | 669(669,669) | 686(655,716) | 605(605,605) | 513(452,574) | 657(612,748) | 526(451,602) | 666(652,704) | 587(531,697) | 722(650,793) | 710(682,777) | 694(694,694) |
year | ||||||||||||||
2022 | 8 (100%) | 3 (60%) | 0 (0%) | 1 (100%) | 2 (100%) | 1 (100%) | 1 (50%) | 6 (86%) | 1 (50%) | 4 (100%) | 5 (100%) | 2 (100%) | 6 (75%) | 2 (100%) |
2023 | 0 (0%) | 2 (40%) | 1 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 1 (50%) | 1 (14%) | 1 (50%) | 0 (0%) | 0 (0%) | 0 (0%) | 2 (25%) | 0 (0%) |
1中央値(最小値,最大値); n (%) | ||||||||||||||
4.2 和牛販売価格を父牛で集計
和牛販売価格を父牛で集計(雄牛) | ||||||||
|---|---|---|---|---|---|---|---|---|
父牛(精液) | 勝早桜５, N = 91 | 安福久, N = 41 | 百合白清２, N = 71 | 知恵久, N = 31 | 福之姫, N = 301 | 美国桜, N = 21 | 若百合, N = 81 | 貴隼桜, N = 11 |
price | 796(653,842) | 710(615,719) | 862(776,879) | 791(744,799) | 854(667,991) | 694(684,704) | 748(620,888) | 833(833,833) |
year | ||||||||
2022 | 7 (78%) | 3 (75%) | 6 (86%) | 3 (100%) | 22 (73%) | 2 (100%) | 4 (50%) | 1 (100%) |
2023 | 2 (22%) | 1 (25%) | 1 (14%) | 0 (0%) | 8 (27%) | 0 (0%) | 4 (50%) | 0 (0%) |
1中央値(最小値,最大値); n (%) | ||||||||
和牛販売価格を父牛で集計(雌牛) | ||||||
|---|---|---|---|---|---|---|
父牛(精液) | 勝早桜５, N = 81 | 奈津百合５５, N = 11 | 百合白清２, N = 71 | 知恵久, N = 21 | 福之姫, N = 281 | 若百合, N = 41 |
price | 657(611,704) | 650(650,650) | 650(452,716) | 686(682,691) | 690(500,793) | 538(451,602) |
year | ||||||
2022 | 7 (88%) | 1 (100%) | 6 (86%) | 2 (100%) | 23 (82%) | 3 (75%) |
2023 | 1 (12%) | 0 (0%) | 1 (14%) | 0 (0%) | 5 (18%) | 1 (25%) |
1中央値(最小値,最大値); n (%) | ||||||
和牛販売価格を父牛で集計(雄牛) | |||||||||
|---|---|---|---|---|---|---|---|---|---|
父牛(精液) | 勝早桜５, N = 171 | 奈津百合５５, N = 11 | 安福久, N = 41 | 百合白清２, N = 141 | 知恵久, N = 51 | 福之姫, N = 581 | 美国桜, N = 21 | 若百合, N = 121 | 貴隼桜, N = 11 |
sex | |||||||||
femail | 8 (47%) | 1 (100%) | 0 (0%) | 7 (50%) | 2 (40%) | 28 (48%) | 0 (0%) | 4 (33%) | 0 (0%) |
9 (53%) | 0 (0%) | 4 (100%) | 7 (50%) | 3 (60%) | 30 (52%) | 2 (100%) | 8 (67%) | 1 (100%) | |
price | 704(611,842) | 650(650,650) | 710(615,719) | 746(452,879) | 744(682,799) | 767(500,991) | 694(684,704) | 690(451,888) | 833(833,833) |
year | |||||||||
2022 | 14 (82%) | 1 (100%) | 3 (75%) | 12 (86%) | 5 (100%) | 45 (78%) | 2 (100%) | 7 (58%) | 1 (100%) |
2023 | 3 (18%) | 0 (0%) | 1 (25%) | 2 (14%) | 0 (0%) | 13 (22%) | 0 (0%) | 5 (42%) | 0 (0%) |
1n (%); 中央値(最小値,最大値) | |||||||||
4.3 販売価格を集計
4.3.1 年ごとに販売価格を集計
年ごとに販売価格を集計 | |||
|---|---|---|---|
年 | 全体, N = 1141 | 2022, N = 901 | 2023, N = 241 |
sex | |||
femail | 50 (44%) | 42 (47%) | 8 (33%) |
64 (56%) | 48 (53%) | 16 (67%) | |
price | 742(451,991) | 740(451,991) | 742(452,949) |
1n (%); 中央値(最小値,最大値) | |||
4.3.2 性別で販売価格を集計
性別で販売価格を集計 | |||
|---|---|---|---|
性別 | 全体, N = 1141 | femail, N = 501 | mail, N = 641 |
price | 742(451,991) | 664(451,793) | 804(615,991) |
year | |||
2022 | 90 (79%) | 42 (84%) | 48 (75%) |
2023 | 24 (21%) | 8 (16%) | 16 (25%) |
1中央値(最小値,最大値); n (%) | |||
## # A tibble: 114 × 3
## sex price year_month
## <chr> <dbl> <chr>
## 1 femail 650 2022-08
## 2 femail 587 2022-08
## 3 femail 652 2022-07
## 4 mail 842 2022-07
## 5 mail 788 2022-07
## 6 mail 806 2022-07
## 7 femail 611 2022-07
## 8 mail 837 2022-07
## 9 femail 650 2022-07
## 10 femail 640 2022-07
## # ℹ 104 more rows