Subprimal Allocation Decision Tool

Daily Workflow

1. Pull USDA Prices to refresh market values for 50's, 65's, 85's, and 90's.
2. Review the Market Scoreboard to compare USDA value, target price, offer price, and sell/run guidance.
3. Confirm premiums: NAT Premium is a percent; USDA Premium is dollars per pound.
4. Enter available pounds for each cut under NAT lb and CONV lb.
5. Choose the CL Scenario: use Typical for normal planning; Low and High for risk checks.
6. Set allocations in NAT Allocation and CONV Allocation. Each row should total 100%.
7. Review outputs: Revenue, Opportunity, Bin Summary, Scenario Summary, and CL Feedback.
8. Download PDF Report when the math needs to be saved or shared.

Inputs to Review

CL Scenario

Controls which chemical lean estimate is used: Low, Typical, or High.

NAT Premium (%)

Natural-program premium over CONV price. Enter 10 for 10%.

USDA Premium ($/lb)

Company over-USDA spread added to USDA price to produce the CONV selling price.

Offer Prices

Enter customer or internal transfer offers in Bin Inputs. Those offers drive Sell vs Run internally.

Subprimal Inputs

CL assumptions and available pounds by cut. CL fields are entered as whole percentages, such as 92 for 92%.

Bin Inputs

Minimum lean, USDA price, demand, and offer prices by bin. USDA prices can be refreshed automatically or edited manually.

How to Read the Results

• Total Revenue is the revenue from the current routing plan.
• Total Opportunity estimates money left on the table when material is routed below its highest eligible bin.
• Market Scoreboard shows each downloaded USDA value, report date, target price, offer price, and recommendation.
• Bin Summary shows pounds into each bin, weighted CL, demand fill, and pass/fail against minimum lean.
• Scenario Summary compares revenue under Low, Typical, and High CL while keeping routing unchanged.
• CL Feedback uses Lot Log actuals to show whether Typical CL assumptions should be raised or lowered.

Rules of Thumb

• Percent inputs use whole percentages: enter 92, not 0.92.
• Sell guidance means the entered offer is at or above the target premium; run internally means the offer is below target.
• Allocation rows should total 100%. Rows that do not total 100% need review.
• Red or warning statuses mean the row, bin, or assumption needs attention before relying on the result.
• The tool supports the routing decision; the scheduler can still override the recommendation for customer, inventory, or operational reasons.