Sales Tier Percentage Example Spreadsheet REVISED JS.xlsx

This is a pricing template spreadsheet that demonstrates the tiered fee structure for a Sales and Marketing contract with UNICOR Office Furniture Group under solicitation FN1611-26 issued by the Department of Justice Bureau of Prisons Correctional Facilities. The template illustrates two distinct pricing methodologies: a monthly sales tier system and a factory/seating category tier system.

The monthly sales tier system applies a progressive percentage fee based on total monthly sales volume, with Tier 1 charging 1% on sales from $0–$7,500,000, Tier 2 charging 1.25% on sales from $7,500,001–$10,000,000, and Tier 3 charging 1.50% on sales exceeding $10,000,001. The example demonstrates that January sales of $13,000,000 would generate a total monthly fee of $151,249.97. The factory/seating category tier system applies fees based on previous year sales benchmarks adjusted by a 25% increase threshold, with Tier 1 assessed at 1% and Tier 2 at 1.25%. The template provides category examples for Ashland and Seating divisions, showing how current year sales above the previous year plus 25% benchmark are assessed at the higher Tier 2 rate. The solicitation closing date is September 4, 2026, with a deadline for questions on an earlier date in September 2026.