Subprimal Allocation Decision Tool

Daily Workflow

1. Pull USDA Prices to refresh the market price for 50's, 65's, 85's, and 90's.
2. Review premiums: NAT Premium is entered as a percent, and USDA Premium is entered as dollars per pound.
3. Enter available pounds for each subprimal under NAT lb and CONV lb.
4. Choose the CL Scenario: Typical is the normal planning case; Low and High show how sensitive the schedule is to lean forecast changes.
5. Set allocation percentages in the NAT and CONV allocation tables. Each row should total 100%.
6. Check the outputs: Total Revenue, Total Opportunity, Bin Summary, Scenario Summary, and CL Feedback.

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.

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, and demand 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.
• 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.
• 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.