ARRC_Yard_Ballast-Type-5_BPF_Calculator_Rev_5.0.xlsx

This is a Ballast Pay Factor Calculator spreadsheet utilized by the Alaska Railroad (ARRC) for ITB 26-16-315930, a Seward Yard Ballast Supply contract. The calculator is designed to assess the quality of Type 5 yard ballast material through sieve analysis testing across seven particle size categories (1-1/2", 1", 3/4", 1/2", 1/4", No. 4, and No. 200). The contract posting date was March 25, 2026, with a bid closing date of April 15, 2026. The document contains example test results from five samples collected between June 10-17, 2019, representing a total actual quantity of 5,018.21 tons based on required quality control data and scale tickets. The specification limits are established for each sieve size, with target values and upper and lower acceptable ranges defined to ensure material quality compliance.

The pay factor calculator determines compensation adjustments based on material conformance to specifications. The base unit price is $1.00 per ton, with the full contract price calculated at $5,018.21 for the actual quantity delivered. In the example calculation presented, the adjusted price totals $4,456.17, reflecting an 11.20 percent reduction ($562.04) due to material falling outside specification limits, primarily in the No. 200 sieve category where samples showed excessive fines. The ARRC reserves the right to reject any material failing to meet compliance standards. The pay factor composites range from 0.79 to 0.93 depending on individual sample performance, with weighted factors applied to different sieve sizes to calculate final unit prices ranging from $792.88 to $933.39 per ton.