Compare supplier quotes after pack size and freight

You need at least 95 units within seven days. Compare the cost of feasible orders, including the supplier’s pack size and one freight charge.

SOURCE DATA
"supplier","unit_usd","pack_units","minimum_units","freight_usd","lead_days"
"A","4","10","100","30","5"
"B","3.8","25","25","60","6"
"C","3.5","20","20","20","9"

RULES
Order quantity is the smallest pack multiple at least as large as both 95 units and the minimum order.
A quote is eligible only when lead_days ≤ 7. There are no taxes, discounts or other fees in this fixture.
Compare order quantity × unit price + freight. Report the extra cost of the second-cheapest eligible offer.

MY FIGURES
Eligible suppliers: __________
Units from the selected supplier: __________
Selected order total (USD): __________
Extra cost of next eligible quote (USD): __________

MY REVIEW NOTE
________________________

METHOD
All three quotes require 100 units after pack rounding. Do not compare a 95-unit hypothetical order that suppliers will not accept.
A costs 100 × 4 + 30 = 430; B costs 100 × 3.8 + 60 = 440.
C has a lower nominal total of 370 but misses the required arrival window. Select A from the two feasible offers.

REFERENCE ANSWERS — try first
Eligible suppliers: 2. Only A and B meet the seven-day requirement.
Units from the selected supplier: 100. A’s minimum order is 100 and its pack size is 10.
Selected order total (USD): 430. 400 in goods + 30 in freight.
Extra cost of next eligible quote (USD): 10. 440 − 430 = 10.

The lowest unit price is not necessarily the lowest usable order cost. First check feasibility, then compare the full order.

For a real comparison, document quotation validity, currency and included charges before adding taxes or currency conversion. The fixture’s omitted fees should not silently become real-world zeroes.

Occupational context: O*NET 31.0 Database, USDOL/ETA, Task 1145, occupation 13-1023.00. https://www.onetcenter.org/dl_files/database/db_31_0_csv/task_statements.csv
CC BY 4.0: https://creativecommons.org/licenses/by/4.0/
Original practice material and adaptations by Skill Workbench. USDOL/ETA has not approved, endorsed or tested these additions. O*NET is a trademark of USDOL/ETA.