|
IndCarc
|
AggCarc
|
BEPs
|
Grid Pricing Spreadsheet: Individual Carcass Data
(Data entry cells are highlighted.)
Base price
$/cwt
Lot size
Head
Total carcasses check
Premiums
$/cwt
Prime-Upper Choice, Yield 1-2
Sum
Discounts
$/cwt
Select-Standard, Yield 4-5
Weight
Other
Sum
Net premium/discount $/cwt
Net price
$/cwt
Packer Grid Premiums and Discounts ($/cwt)
Yield grade
Quality grade
1
2
3
4
5
Prime
Upper Choice
Choice
0.00
Select
Standard
Weight discount
$/cwt
Less than 550 lbs
More than 950 lbs
Other discounts
$/cwt
Dark cutters
Heiferettes
Stags
Carcass Distribution (number of head)
Yield grade
Quality grade
1
2
3
4
5
Total
Prime
Upper Choice
Choice
Select
Standard
Total
Weight
Less then 550 lbs
Live weight (lbs)
More than 950 lbs
Carcass weight (lbs)
Other
Dark cutters
Dressing %
Heiferettes
Stags
Carcass Premiums and Discounts ($/cwt)
Yield grade
Quality grade
1
2
3
4
5
Prime
Upper Choice
Choice
0.00
Select
Standard
Weight
Less then 550 lbs
More than 950 lbs
Other
Dark cutters
Heiferettes
Stags
|
IndCarc
|
AggCarc
|
BEPs
|
Grid Pricing Spreadsheet: Aggregated Carcass Data
(Data entry cells are highlighted.)
Base price
$/cwt
Lot size
Head
Total carcasses check 1
Total carcasses check 2
Premiums
$/cwt
Prime-Upper Choice, Yield 1-2
Sum
Note: Not exact sum of premiums.
Discounts
$/cwt
Select-Standard, Yield 4-5
Weight
Other
Sum
Note: Not exact sum of discounts.
Net premium/discount $/cwt
Note: Correct net.
Net price
$/cwt
Packer Grid Premiums and Discounts
Carcass Distribution
Quality grade
($/cwt.)
Quality grade
(head)
Prime
Prime
Upper Choice
Upper Choice
Choice
0.00
Choice
Select
Select
Standard
Standard
Yield grade
Yield grade
1
1
2
2
3
0.00
3
4
4
5
5
Weight dis
count
$/cwt
Weight
Less than 550 lbs
Less then 550 lbs
More than 950 lbs
More than 950 lbs
Other disc
ounts
$/cwt
Other
Dark cutters
Dark cutters
Heiferettes
Heiferettes
Stags
Stags
Live weight (lbs)
Carcass weight (lbs)
Dressing %
Carcass Premiums and Discounts ($/cwt)
Yield grade
Quality grade
1.00
2.00
3.00
4.00
5.00
Prime
Upper Choice
Choice
0.00
Select
Standard
Weight
Less then 550 lbs
More than 950 lbs
Other
Dark cutters
Heiferettes
Stags
|
IndCarc
|
AggCarc
|
BEPs
|
Grid Pricing Spreadsheet: Breakeven Analysis
(Data entry cells are highlighted.)
Case 1
Case 2
Case 3
Placement weight
Lbs
Cost of gain
$/lb
Dressed weight
Lbs
Live weight
Lbs
Dressing percentage
%
Net price
$/cwt
Prime, YG 1
$/cwt
Upper Choice, YG2
$/cwt
Choice, YG 3 (Base)
$/cwt
Select, YG 4
$/cwt
Standard, YG 5
$/cwt
Case 1
Case 2
Case 3
Breakeven Price
Net price
$/cwt
Prime, YG 1
$/cwt
&n