J.2 BPA Price Workbook.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
Brand Name or Equal Apple Hardware BPA
Solicitation number
USCA25R0110
Issued by

About this file

This is a pricing workbook template for a Blanket Purchase Agreement (BPA) for Apple hardware or equivalent products for the Administrative Office of the U.S. Courts and Federal Judiciary. The workbook contains seven sample orders across various courts and judicial offices, requiring vendors to provide pricing for Apple products including iPads, MacBooks, iMacs, Mac Studios, and related AppleCare+ warranties across five ordering periods (base plus four option periods).

The workbook requires vendors to submit OEM market prices and discounted prices for each product, with formulas calculating the percentage discounts. Vendors must provide publicly available links to verify OEM pricing, and all prices must be fully burdened including shipping costs. The evaluation will be conducted on a Lowest Price Technically Acceptable (LPTA) basis, with the lowest price determined by the cumulative discounted price across all sample orders. Technical acceptability requires vendors to provide pricing for all line items, and modification of workbook formulas will result in disqualification.

View the file

Other files

File Type Posted
USCA25R0110 0001 Brand Name or Equal Apple BPA Solicitation QuestionsResponses - Copy.xlsx XLSX spreadsheet
Specifications Matrix MOD 0001.xlsx XLSX spreadsheet
USCA25R0110 0001.pdf PDF
J.2 BPA Price Workbook MOD 0001.xlsx XLSX spreadsheet
J.1 BPA SOW MOD 0001.pdf PDF
J.1 BPA SOW.pdf PDF
Specifications Matrix.xlsx XLSX spreadsheet
USCA25R0110.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

1. Instructions

Instructions to Offerors

Tab 2. Sample Orders and Pricing - identifies product categories that align with various brand name or equal Apple products minimum essential characteristics. Offerors must provide Original Equipment Manufacturer (OEM) market pricing, discount pricing, and percentage discounts that will be applied to each call order issued under the BPA. Further discounting on the call level is encouraged.

Tab 3. Product Category Percent (%) Discounts - identifies the average percent discounts for each ordering period that will be applied to the associated product categories. The average percent discounts are generated from Tab 2.

Tab 4. Pricing Notes - Offerors may provide notes related to the offered pricing that they believe the AO should consider, as well as any reasonable assumptions they believe are applicable to their proposal. Use of this tab is not required.

Sample Orders 1-7

1. Please submit one (1) sample quote for each of the sample call orders. Quotes should be for the base year ordering period only and be aware of the various quantity amounts. A total of seven (7) quotes should be completed and submitted. Quotes must include the product OEM/brand, product name, and product code/number.

BPA Pricing and Product Category Percent Discount

2. Fill in ALL yellow highlighted cells, that are associated with the Sample Orders on Tab 2. Please complete all five (5) ordering periods with a quantity of one (1) for each line item. List the OEM market price and the discounted price. The percent discounts will populate on the worksheet.

The product category percent discount for each ordering period will populate on Tab 3. Product Category Percent (%) Discounts.

3. The Offeror is responsible for providing an easily accessible active link to the OEM pricing for ALL of the products. OEM pricing must be publicly available.

The Government will pay a discounted price that is the product category percent discount of the OEM market price associated with the product category. The discounted price is fully burdened, and the Government will not pay any other fees or shipping costs for the product. Please factor in any additional costs that may be required to cover the delivery of the product to the Government purchaser.

LPTA Evaluation

The AO will evaluate the offeror’s submitted pricing volume for accuracy and that pricing is fair and reasonable. If an offeror is found to have modified a formula in the workbook, the offeror will be deemed non-responsive and technically unacceptable. Please see Solicitation, section M.1 Evaluation Criteria, Evaluation Approach Criteria.

For your sample quotes to be considered technically acceptable, your organization must be able to provide OEM pricing and discount pricing for all line items in the sample call orders.

The Government will analyze the proposed pricing against the OEM’s publicly posted market pricing. The lowest price will be determined by the lowest cumulative discounted price (shown in cell M2, Tab 2. Sample Orders and Pricing).

2. Sample Orders and Pricing

The AO requires Brand Name or Equal to Apple Hardware. All technically acceptable products must meet all the minimun essential characteristics.
Quotes must include the product brand, product name, and product code/number.Total Cumulative Discounted Price0
1. Small OrderFederal Public Defender - District of Arizona
PRODUCT CODEPRODUCTCATEGORYQTYMinimum Essential CharacteristicsBase Ordering PeriodOrdering Period 1Ordering Period 2Ordering Period 3Ordering Period 4
STD PROCESSORSTD RAM (GB)STD STORAGE (GB)DISPLAYOTHERTYPEOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent Discount
MQ6T3LL/A10.9-inch iPad Wi-Fi Silver (10th Generation)Tablets/iPad16 core CPU/4 core GPU2566410.9"Tablet$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SGFC2LL/AAppleCare+ for iPad (10th Generation)AppleCare1N/AN/AN/AN/A2 YearsWarranty$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
Free ShippingFree ShippingShipping1N/AN/AN/AN/AShipping
2. Small OrderUS Court of Appeals - Sixth Circuit
PRODUCT CODEPRODUCTCATEGORYQTYMinimum Essential Characteristics
STD PROCESSORSTD RAM (GB)STD STORAGE (GB)DISPLAYOTHERTYPEOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent Discount
MRX33LL/A16-inch MacBook Pro Space BlackMac/MacBook Pro114-core CPU/20-core GPU2451216"Laptop$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SGAQ2LL/AAppleCare+ for 14-inch MacBook ProAppleCare1N/AN/AN/AN/A3 YearsWarranty$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
Free ShippingFree ShippingShipping1N/AN/AN/AN/AShipping
3. Midsize OrderUS District Court - Western District of Washington
PRODUCT CODEPRODUCTCATEGORYQTYMinimum Essential Characteristics
STD PROCESSORSTD RAM (GB)STD STORAGE (GB)DISPLAYOTHERTYPEOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent Discount
MQ6T3LL/A10.9-inch iPad Silver (10th Generation)Tablets/iPad116 core CPU/4 core GPU25625610.9"Tablet$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MQRC3LL/A24-inch iMac with Retina 4.5K display - BlueMac/iMac38-core CPU/8-core GPU825624" 4kAll-In-One$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MMFJ3Z1211Mac mini (Z16K)Mac/Mac mini18-core CPU/10-core GPU8256N/ASmall Desktop$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SGFC2LL/AAppleCare+ for iPad (10th Generation)AppleCare1N/AN/AN/AN/A2 YearsWarranty$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SLA62LL/AAppleCare+ for iMacAppleCare1N/AN/AN/AN/A3 YearsWarranty$ 1.00$ - 0100%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
Free ShippingFree ShippingShipping1N/AN/AN/AN/AN/AShipping
4. Midsize OrderUS Probation Office - District of Nebraska
PRODUCT CODEPRODUCTCATEGORYQTYMinimum Essential Characteristics
STD PROCESSORSTD RAM (GB)STD STORAGE (GB)DISPLAYOTHERTYPEOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent Discount
MUXD3LL/A11-inch iPad Air Wi-Fi Space Gray (M2)Tablets/iPad Air118-core CPU/9-core GPU812811"Tablet$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MZ171LL/AMac Pro - Tower: Apple M2 UltraMac/Mac Pro124-core CPU/60-core GPU641000N/ADesktop$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SM2V2LL/AAppleCare+ for 11-inch iPad AirAppleCare1N/AN/AN/AN/A2 YearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
S9718LL/AAppleCare+ Mac ProAppleCare1N/AN/AN/AN/A3 YearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
Free ShippingFree ShippingShipping1N/AN/AN/AN/AShipping
5. Midsize OrderUS District Court - Eastern District of New York
PRODUCT CODEPRODUCTCATEGORYQTYMinimum Essential Characteristics
STD PROCESSORSTD RAM (GB)STD STORAGE (GB)DisplayOtherTypeOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent Discount
MQH63Z211Mac Studio (M2 Ultra)Mac/Mac Studio124-core CPU/60-core GPU1281024N/ADesktop$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MQKV3Z121215-inch MacBook Air - Starlight (Z18S)Mac/MacBook Air28-core CPU/10-core GPU1651215"Maximum Weight 3.3 lbsLaptop$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SJGC2LL/AAppleCare+ for Mac Studio M2AppleCare1N/AN/AN/AN/A3 YearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SJFY2LL/AAppleCare+ for 15-inch M2 MacBook AirAppleCare1N/AN/AN/AN/A3 YearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
Free ShippingFree ShippingShipping1N/AN/AN/AN/AShipping
6. Large OrderUS District Court - District of Puerto Rico
PRODUCT CODEPRODUCTCATEGORYQTYMinimum Essential Characteristics
STD PROCESSORSTD RAM (GB)STD STORAGE (GB)DISPLAYOTHERTYPEOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent Discount
MWRQ3LL/A11-inch iPad Pro Wi-Fi Nano-texture glass - Silver (M4)Tablets/iPad Pro1710-core CPU/10-core GPU16102411"Tablet$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MK7T3LL/AiPad miniTablets/iPad mini106-core CPU/5-core GPU42568.3"Tablet$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MQKV3Z121213-inch MacBook Air - Starlight (Z18S)Mac/MacBook Air108-core CPU/10-core GPU1651213"Maximum Weight 2.7 lbsLaptop$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MK0U3LL/AApple Studio Display - Standard Glass - Tilt-Adjustable StandMac Accessories/Displays527" 5KIntergrated webcam, USB-C port hubMonitor$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SM2X2LL/AAppleCare+ for 11-inch iPad ProAppleCare1N/AN/AN/AN/A2 YearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SCLH2LL/AAppleCare+ for iPad miniAppleCare1N/AN/AN/AN/A2 YearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SGAQ2LL/AAppleCare+ for 14-inch MacBook ProAppleCare1N/AN/AN/AN/A3 YearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
Free ShippingFree ShippingShipping1N/AN/AN/AN/AN/AShipping
7. Large OrderUS District Court - District of North Dakota
PRODUCT CODEPRODUCTCATEGORYQTYMinimum Essential Characteristics
STD PROCESSORSTD RAM (GB)STD STORAGE (GB)DisplayOtherTypeOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent DiscountOEM Market PriceDiscounted PricePercent Discount
MVXT3LL/A13-inch iPad Pro Wi-Fi Standard Glass - Silver (M4)Tablets/iPad Pro169-core CPU/10-core GPU825613"Tablet$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MVV93LL/A11-inch iPad Pro Wi-Fi 256GB Standard Glass - Silver (M4)Tablets/iPad Pro149-core CPU/10-core GPU825611"Tablet$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
MRX33LL/A14-inch MacBook Pro Space BlackMac/MacBook Pro510-core CPU/10-core GPU1651214"Laptop$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SM2W2LL/AAppleCare+ for 13-inch iPad ProAppleCare1N/AN/AN/AN/A2 yearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SM2X2LL/AAppleCare+ for 11-inch iPad ProAppleCare1N/AN/AN/AN/A2 yearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
SGAQ2LL/AAppleCare+ for 14-inch MacBook ProAppleCare1N/AN/AN/AN/A3 yearsWarranty$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%$ 1.00$ - 0100.00%
Free ShippingFree ShippingShipping1N/AN/AN/AN/AShipping
Base Order PeriodTotal
Discounted PriceOrder Period 1Total
Discounted PriceOrder Period 2Total
Discounted PriceOrder Period 3Total
Discounted PriceOrder Period 4Total

Discounted Price $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

3. Product Category % Discounts

PRODUCT CATEGORY PERCENT (%) DISCOUNTS

CategoryBase PeriodOrdering Period 1Ordering Period 2Ordering Period 3Ordering Period 4TOTAL CUMULATIVE DISCOUNTED COSTS OF SAMPLE ORDERS$ - 0
All-In-One100.00%100.00%100.00%100.00%100.00%
Tablet100.00%100.00%100.00%100.00%100.00%
Tablet100.00%100.00%100.00%100.00%100.00%
Tablet100.00%100.00%100.00%100.00%100.00%
Tablet100.00%100.00%100.00%100.00%100.00%
Tablet100.00%100.00%100.00%100.00%100.00%
Tablet100.00%100.00%100.00%100.00%100.00%
Tablet100.00%100.00%100.00%100.00%100.00%
Small Desktop100.00%100.00%100.00%100.00%100.00%
Desktop100.00%100.00%100.00%100.00%100.00%
Laptop100.00%100.00%100.00%100.00%100.00%
Laptop100.00%100.00%100.00%100.00%100.00%
Laptop100.00%100.00%100.00%100.00%100.00%
Laptop100.00%100.00%100.00%100.00%100.00%
Monitor100.00%100.00%100.00%100.00%100.00%
Warranty Tablets100.00%100.00%100.00%100.00%100.00%
Warranty All in One100.00%100.00%100.00%100.00%100.00%
Warranty Laptop/Desktop100.00%100.00%100.00%100.00%100.00%

5. Pricing Notes

File details come from the government source that posted it. Updated .