PGM Settlement Desk / single-page assay dashboard

Sold value (today)
–
P/L on current blend
–
Held upside (future − today)
–

Break-even selling price per metal, per lot

Allocated = the workbook's method: purchase cost split across Pt/Pd/Rh, divided by recoverable ounces. Solo = the price at which selling 100% of that metal alone covers the lot's full cost + treatment/fees with the other two held at 0%. Solo is the number that matters if you are deciding which single metal to liquidate.

Required price for target profit at current sale blend

Holds every other input at its current value and solves the one price that hits the target, given each metal's current sale %. “—” means that metal's sale % is 0, so no price can carry the lot.

Global assumptions

Settlement prices ($/ozt) safe input

These are the prices the workbook's profit line actually uses (solved exactly from “The required amount”).

Reference / market prices ($/ozt) safe input

The workbook's side block (N16:O29) values the same ounces ~19% higher with these. The gap between decks is unexplained — see Accountant Review.

Returnable / recovery rates safe input

Back-solved from the workbook: 97.5% Pt/Pd, 91.5% Rh — standard refiner returnables. Verified on all nine metal/lot pairs.

Cost allocation used by the workbook's break-even rows safe input

Profit target solver

Lock sale percentages (the solver keeps these fixed)

Example: lock Rh at 100%, Pt and Pd at 0%, solve “required price of Rhodium” for your target — that is the Rh price you need if Rhodium carries the lot alone. If the target is unreachable, the solver says why and shows the closest achievable scenario.

Future price assumptions editable scenario inputs — not price forecasts or financial advice

Defaults follow your stated view: Rh flat (= today's settlement price), Pt +15%, Pd +12%. Change them to whatever you believe — every figure below recomputes.

Sell today vs hold to future

“Sell all today” prices every ounce at today's settlement deck. “Current blend + hold” sells your dashboard percentages today and values the remainder at the future deck. “Hold all” values everything at the future deck (ignores carrying cost and price risk — both are real).

Which metal to sell first

Ranking is pure arithmetic on your own assumptions: the metal with the lowest future-vs-today ratio costs you the least upside when liquidated first. It is not a market prediction.

Accountant review — discrepancies found in the workbook

1. The $500 Lot P fee is listed but never deducted. Cell F24 carries a 500 lot fee, but the net amount F32 (136,943.956) equals required amount F22 minus treatment F23 only. Lot P's net and profit are overstated by $500 in the workbook. This app deducts it, so Lot P shows −$8,804.04 instead of the sheet's −$8,304.04. F24, F32, F33
2. The whole workbook is hardcoded values — there are zero live formulas. Every figure was pasted as a value. Changing any input in Excel changes nothing downstream. This app reconstructs the full chain so edits actually recalculate. Sheet1 (all cells)
3. Two unlabeled price decks, ~19% apart. The profit line uses implied prices of exactly $1,700 Pt / $1,220 Pd / $8,227 Rh (solved from “The required amount”), while the side block values the same ounces at $2,080 / $1,549 / $9,650. Nothing in the sheet says which is contract, which is spot, or as of when. If the higher deck is realizable, lot A is profitable (+$59,915), not −$106,642. This needs a dated source for each deck. B22/F22/J22 vs N16:O29
4. Rhodium ppm is stored as text, not numbers, in every lot (and in the comparison block). In a live spreadsheet this silently breaks any formula referencing those cells. B12, F12, J12, M12, N12
5. Lot A "weight loss" is negative: 10,628 lb sent, 10,631 lb received — 3 lb appeared in transit. Small (0.03%) but a scale-calibration question worth asking the processor. B4, B5, B6
6. The 15% / 50% / 35% cost allocation is arbitrary. The break-even rows split purchase cost 15/50/35 across Pt/Pd/Rh. At the settlement deck, lot A's actual value mix is 11.5% / 50.7% / 37.8%. The mismatch distorts per-metal break-evens — e.g. it understates the Pt break-even and overstates Rh. The app keeps the workbook method (labeled “allocated”) and adds a true “solo” break-even alongside it. rows 35–38
7. Treatment cost ≈ $1.00/lb of received weight, but never stated, and slightly off. Lot A: 10,631.37 vs 10,631 lb received; P: 1,977.03 vs 1,977; B: 2,075.18 vs 2,075. Likely computed from unrounded weights. The app carries the sheet's exact figures as overrides; clear the override and it computes received × rate. B23, F23, J23
8. Refining, shipping, wire, and interest are all zero on every lot. PGM refiners normally charge per-ounce refining on at least Rh, and three settlements with zero wire fees and zero interest is unlikely. If these costs exist, every profit figure is optimistic. Fields are provided — fill them when you have the refiner's schedule. rows 25–30
9. Junk artifacts and unlabeled blocks. Moisture% divided by cat count (meaningless), ounces duplicated in rows 16–18, an assay comparison block labeled only “القديم” (the old) with a note “…لو لم نتأخر” (“…if we hadn't delayed”) comparing lot B's assay (156.2/652.9/77.7 ppm) against a lower set (137/511/57) — looks like a buyer's competing assay; if so, the delay cost is real and should be documented. C8/G8/K8, rows 16–18, L2:P5, M10:N12, M15
Note on scope: the request mentioned sodium — there is no sodium anywhere in this workbook. The materials are platinum, palladium, and rhodium only (catalytic-converter PGMs). If a sodium assay exists, it's in a different file.

What was verified and preserved

Dry weight = received − moisture (matches “Weight analyzer” on all lots). Ounces = dry lb × ppm ÷ 10⁶ × 14.58333 ozt/lb, rounded to 3 dp, × recovery (97.5/97.5/91.5%), rounded again — reproduces all nine ounce figures exactly. Gross, net, and profit reproduce the workbook to the cent on lots A and B, and on lot P after the $500 correction. Break-even rows 35–38 reproduce exactly. Market-deck side block reproduces exactly. 40 automated checks pass.