SPE30025R0025.LTC_PID0001.XLSX

XLSX spreadsheet 42 KB Posted Feb 12, 2025

Attached to: Amendment P0002 Solicitation for Fresh Milk, Dairy and Ice Cream Products for DLA Troop Customers in the States of Mississippi, Arkansas and Louisiana
Solicitation number: SPE300-25-R-0025
Issued by: Defense Logistics Agency Troop Support Subsistence

About this file

Written by GovTribe AI · Feb 12, 2025

This is a pricing template spreadsheet for DLA Solicitation SPE300-25-R-0025 covering fresh milk, dairy, and ice cream products across six geographic groups: Mississippi ice cream (Group 1), Mississippi milk/dairy (Group 2), Meridian Naval Air Station milk/dairy (Group 3), Arkansas milk/dairy (Group 4), Fort Johnson LA milk/dairy (Group 5), and Barksdale AFB LA milk/dairy (Group 6). The spreadsheet contains detailed line items organized by product type (ice cream, milk, yogurt, etc.) with columns for vendors to input product codes, wholesale prices, and calculated subtotals.

The template requires vendors to provide pricing for a 36-month base period for fluid milk items with Economic Price Adjustment (EPA), and two-tier pricing for other dairy items (Tier 1: June 2025-June 2027, Tier 2: June 2027-June 2028). Product quantities are specified in various container sizes ranging from 1/2 pint to 5-gallon containers. Major product categories include ice cream in multiple flavors, fluid milk (whole, low-fat, chocolate), yogurt varieties, cottage cheese, sour cream, and fruit drinks. The spreadsheet calculates automatic subtotals for fluid milk and each pricing tier when vendors input their pricing.

View the file

Other files

File	Type	Posted
SPE30025R00250002.PDF	PDF	Mar 26, 2025
SPE30025R00250002.0001.XLSX	XLSX spreadsheet	Mar 26, 2025
P0001.pdf	PDF	Mar 18, 2025
SPE30025R0025.LTC_PID0002.XLSX	XLSX spreadsheet	Feb 12, 2025
SPE30025R0025.LTC_PID0003.PDF	PDF	Feb 12, 2025
SPE30025R0025.PDF	PDF	Feb 12, 2025
SPE30025R0025.LTC_PID0004.PDF	PDF	Feb 12, 2025

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Group 1

SPE300-25-R-0025- Schedule of Items

Group 1: State of Mississippi (Ice Cream)

Offeror:
Cage Code:	Complete Columns J,K,M, N for CLINs#(1-14)

CLINs#	STOCK NUMBER	ITEM DESCRIPTION	CONTAINER SIZE	EST. USAGE (36) MONTHS FLUID MILK	EST. USAGE (24) MONTHS OTHER DAIRY TIER - 1	EST. USAGE (12) MONTHS OTHER DAIRY TIER - 2	UNIT	SPECIFY PRODUCT CODE	SPECIFY WHOLE SALE PRICE	FLUID MILK PRICE - (Fixed w/ EPA)	OTHER DAIRY Tier 1 Price	OTHER DAIRY Tier 2 Price	AUTO CALC SUB-TOTAL FLUID MILK	AUTO CALC SUB-TOTAL TIER - 1	AUTO CALC SUB-TOTAL TIER - 2	REMARKS
		PRODUCT, EXAMPLE (Fluid Milk)	Half Gallon	500			CO	12345	$ 2.00	$ 1.80			$ 900.00
		PRODUCT, EXAMPLE (Other Dairy)	5 LB Container		200	100	CO	6789	$ 4.00		$ 3.50	$ 3.80		$ 700.00	$ 380.00
1	891001E110731	ICE CREAM, CHOC, FZN, MIN 8% MILK FAT, 3 GAL CO	3 Gallon		194	97	CO							$ - 0	ERROR:#VALUE!
2	891001E112786	ICE CREAM, MINT CHOC CHIP, FZN, MIN 10% MILK FAT, 3 GAL CO	3 Gallon		216	108	CO							$ - 0	$ - 0
3	891001E113364	ICE CREAM, COOKIES AND CREAM, FZN, MIN 10% MILK FAT, 3 GAL CO	3 Gallon		334	167	CO							$ - 0	$ - 0
4	891001E114770	ICE CREAM, BUTTER PECAN, FZN, 3 GAL CO	3 Gallon		360	180	CO							$ - 0	$ - 0
5	891001E114772	ICE CREAM, STRAWBERRY, 3 GAL CO	3 Gallon		306	153	CO							$ - 0	$ - 0
6	891001E114773	ICE CREAM, ROCKY ROAD, FZN, 3 GAL CO	3 Gallon		190	95	CO							$ - 0	$ - 0
7	891001E121616	ICE CREAM, VANILLA, FZN, 3 GAL CO	3 Gallon		918	459	CO							$ - 0	$ - 0
8	891001E117805	ICE CREAM, VANILLA, FZN, NO SUGAR ADDED, IND WRAPPED, 4 OZ CO, 48/CS	Case		6	3	CO							$ - 0	$ - 0
9	891001E119504	ICE CREAM, CHOC, FZN, MIN 8% MF, 48/4 OZ CO	Case		6	3	CO							$ - 0	$ - 0
10	891001E119505	ICE CREAM, STRAWBERRY, FZN, MIN 8% MF, 48/4 OZ CO	Case		6	3	CO							$ - 0	$ - 0
11	891001E115633	ICE CREAM CONE, FZN, king cone, 8 oz ea, 12/pg	Package		272	136	PG							$ - 0	$ - 0
12	891001E115660	ICE CREAM NOVELTIES, FZN, VANILLA KLONDIKE BAR, ON STICK, 4.5 OZ, 24/BOX	Box		108	54	BX							$ - 0	$ - 0
13	891001E118045	ICE CREAM SANDWICH, FZN, MRS FIELDS, 10.82 OZ, 12/PK	Package		496	248	PG							$ - 0	$ - 0
14	891001E220604	ICE CREAM NOVELTIES, FZN, SNICKERS BAR, W/O STICK, 2.8 OZ EA, 24/BOX	Box		402	201	BX							$ - 0	$ - 0
													Total Aggregate
												Subtotals:		$0.00	ERROR:#VALUE!

Total: ERROR:#VALUE!

Group 2

SPE300-25-R-0025- Schedule of Items

Group 2: State of Mississippi (Milk & Dairy)

Offeror:
Cage Code:	Complete Columns K,L, (CLINs #1-16); M (CLINs #1-12), N, O (CLINs#13-16)

CLINs#	STOCK NUMBER	ITEM DESCRIPTION	CONTAINER SIZE	EST. USAGE (36) MONTHS FLUID MILK	EST. USAGE (36) MONTHS FLUID MILK	EST. USAGE (24) MONTHS OTHER DAIRY TIER - 1	EST. USAGE (12) MONTHS OTHER DAIRY TIER - 2	UNIT	SPECIFY PRODUCT CODE	SPECIFY WHOLE SALE PRICE	FLUID MILK PRICE - (Fixed w/ EPA) (base + tier period)	OTHER DAIRY Tier 1 Price	OTHER DAIRY Tier 2 Price	AUTO CALC SUB-TOTAL FLUID MILK	AUTO CALC SUB-TOTAL FLUID MILK	AUTO CALC SUB-TOTAL TIER - 1	AUTO CALC SUB-TOTAL TIER - 2	REMARKS
		PRODUCT, EXAMPLE (Fluid Milk)	Half Gallon	500	500			CO	12345	$ 2.00	$ 1.00			ERROR:#REF!	$ 900.00
		PRODUCT, EXAMPLE (Other Dairy)	5 LB Container			200	100	CO	6789	$ 4.00		$ 3.50	$ 3.80			$ 700.00	$ 380.00
1	891001E110535	MILK, WHOLE, CHL, 1/2 GAL CO	1/2 Gallon		180			CO							$ - 0
2	891001E110536	MILK, WHOLE, CHL, 1 GAL CO	1 Gallon		216			CO							$ - 0
3	891001E110539	MILK, LOW FAT, CHL, 1% MILK FAT, 1/2 PT CO	1/2 Pint		220,362			CO							$ - 0
4	891001E110541	MILK, LOW FAT, CHL, 1% MILK FAT, 1/2 GAL CO	1/2 Gallon		72			CO							$ - 0
5	891001E110543	MILK, REDUCED FAT, CHL, 2% MILK FAT, 1 GAL CO	1 Gallon		168			CO							$ - 0
6	891001E110567	MILK, CHOC, WHOLE, CHL, 1/2 GAL CO	1/2 Gallon		192			CO							$ - 0
7	891001E112184	MILK, CHOC, LOW FAT, CHL, 1% MILK FAT, 1/2 PT CO	1/2 Pint		46,053			CO							$ - 0
8	891001E113940	MILK, REDUCED FAT, CHL, 2% MILK FAT, 4.5 GAL BIB	4.5 Gallon		279			CO							$ - 0
9	891001E113941	MILK, LOW FAT, CHL, 1% MILK FAT, 4.5 GAL BIB	4.5 Gallon		7,596			CO							$ - 0
10	891001E114041	MILK, CHOC, LOW FAT, CHL, 1% MILK FAT, 4.5 GAL BIB	4.5 Gallon		4,500			CO							$ - 0
11	891001E114852	MILK, NONFAT, CHL, 4.5 GAL BIB	4.5 Gallon		1,956			CO							$ - 0
12	891001E110550	MILK, NONFAT, CHL,1/2 PT CO	1/2 Pint		10,953			CO							$ - 0
13	891001E110569	BUTTERMILK, CHL, 1/2 GAL CO	1/2 Gallon			36	18	CO								$ - 0	$ - 0
14	891001E110586	EGGNOG, CHL, 1 QT CO	1 Quart			68	34	CO								$ - 0	$ - 0
15	891001E110592	HALF AND HALF, CHL, 10.5% - 18% MILK FAT, 1 QT CO	1 Quart			72	36	CO								$ - 0	$ - 0
16	891001E110607	CREAM, LIGHT, CHL, (WHIPPING), MAX 36% MILK FAT, 1 QT CO	1 Quart			24	12	CO								$ - 0	$ - 0

Subtotals: $0.00 $0.00 $0.00

Total: $0.00

Group 3

SPE300-25-R-0025- Schedule of Items

Group 3: Meridian

Offeror:
Cage Code:	Complete Columns H, I, J (CLINS #1-2)

CLINs#	STOCK NUMBER	ITEM DESCRIPTION	CONTAINER SIZE	EST. USAGE (36) MONTHS FLUID MILK	UNIT	SPECIFY PRODUCT CODE	SPECIFY WHOLE SALE PRICE	FLUID MILK PRICE - (Fixed w/ EPA) (base + tier period)	AUTO CALC SUB-TOTAL FLUID MILK	REMARKS
		PRODUCT, EXAMPLE (Fluid Milk)	Half Gallon	500	CO	12345	$ 2.00	$ 1.00	$ 500.00
		PRODUCT, EXAMPLE (Other Dairy)	5 LB Container		CO	6789	$ 4.00
1	891001E110546	MILK, REDUCED FAT, CHL, 2% MILK FAT, 1/2 PT CO	1/2 Pint	102,900	CO				$ - 0
2	891001E112203	MILK, CHOC, NONFAT, CHL, 1/2 PT CO	1/2 Pint	46,800	CO				$ - 0

Totals: $0.00

Group 4

SPE300-25-R-0025 Schedule of Items

Group 4: Arkansas

Offeror:
Cage Code:	Complete Columns K,L, (CLINs #1-15), M (CLINs #1-4), N, O (CLINs #5-15)

CLINs#	STOCK NUMBER	ITEM DESCRIPTION	CONTAINER SIZE	EST. USAGE (36) MONTHS FLUID MILK	EST. USAGE (36) MONTHS FLUID MILK	EST. USAGE (24) MONTHS OTHER DAIRY TIER - 1	EST. USAGE (12) MONTHS OTHER DAIRY TIER - 2	UNIT	SPECIFY PRODUCT CODE	SPECIFY WHOLE SALE PRICE	FLUID MILK PRICE - (Fixed w/ EPA) (base + tier period)	OTHER DAIRY Tier 1 Price	OTHER DAIRY Tier 2 Price	AUTO CALC SUB-TOTAL FLUID MILK	AUTO CALC SUB-TOTAL FLUID MILK	AUTO CALC SUB-TOTAL TIER - 1	AUTO CALC SUB-TOTAL TIER - 2	REMARKS
		PRODUCT, EXAMPLE (Fluid Milk)	Half Gallon	500	500			CO	12345	$ 2.00	$ 1.00			ERROR:#REF!	$ 900.00
		PRODUCT, EXAMPLE (Other Dairy)	5 LB Container			200	100	CO	6789	$ 4.00		$ 3.50	$ 3.80			$ 700.00	$ 380.00
1	891001E110535	MILK, WHOLE, CHL, 1/2 GAL CO	1/2 Gallon		4,035			CO							$ - 0
2	891001E110539	MILK, LOW FAT, CHL, 1% MILK FAT, 1/2 PT CO	1/2 Pint		17,100			CO							$ - 0
3	891001E110546	MILK, REDUCED FAT, CHL, 2% MILK FAT, 1/2 PT CO	1/2 Pint		16,650			CO							$ - 0
4	891001E112184	MILK, CHOC, LOW FAT, CHL, 1% MILK FAT, 1/2 PT CO	1/2 Pint		17,400			CO							$ - 0
5	891001E110615	SOUR CREAM, CHL, CULTURED, MIN 18% MILK FAT, 5 LB CO	5 LB Container			292	146	CO								$ - 0	$ - 0
6	891001E111722	YOGURT, REGULAR, BLACK CHERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			72	36	CO								$ - 0	$ - 0
7	891001E111767	YOGURT, LOW FAT, BLUEBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			24	12	CO								$ - 0	$ - 0
8	891001E111771	YOGURT, LOW FAT, PEACH, CHL, BLENDED, 6 OZ CO	6 OZ Container			2,716	1,358	CO								$ - 0	$ - 0
9	891001E111775	YOGURT, LOW FAT, RASPBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			2,856	1,428	CO								$ - 0	$ - 0
10	891001E111777	YOGURT, LOW FAT, STRAWBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			3,792	1,896	CO								$ - 0	$ - 0
11	891001E111779	YOGURT, LOW FAT, STRAWBERRY BANANA, CHL, BLENDED, 6 OZ CO	6 OZ Container			48	24	CO								$ - 0	$ - 0
12	891001E111789	YOGURT, LOW FAT, VANILLA, CHL, 6 OZ CO	6 OZ Container			24	12	CO								$ - 0	$ - 0
13	891001E111798	YOGURT, LOW FAT, CHERRY VANILLA, CHL, BLENDED, 6 OZ CO	6 OZ Container			120	60	CO								$ - 0	$ - 0
14	891001E117848	YOGURT, BANANA SPLIT, CHL, BLENDED, 6 OZ CO	6 OZ Container			3,480	1,740	CO								$ - 0	$ - 0
15	891001E112606	CHEESE, COTTAGE, LOW FAT, CHL, CREAMED, LARGE OR SMALL CURD, 1 LB CO	1 LB Container			526	263	CO								$ - 0	$ - 0

Subtotal: $0.00 $0.00 $0.00

Total: $0.00

Group 5

SPE300-25-R-0025- Schedule of Items

Group 5: Fort Johnson, formerly known as Fort Polk, LA

Offeror:
Cage Code:	Complete Columns K,L (CLINs #1-27), M (CLINS #1-7), N, O (CLINs #8-27)

CLINs#	STOCK NUMBER	ITEM DESCRIPTION	CONTAINER SIZE	EST. USAGE (36) MONTHS FLUID MILK	EST. USAGE (36) MONTHS FLUID MILK	EST. USAGE (24) MONTHS OTHER DAIRY TIER - 1	EST. USAGE (12) MONTHS OTHER DAIRY TIER - 2	UNIT	SPECIFY PRODUCT CODE	SPECIFY WHOLE SALE PRICE	FLUID MILK PRICE - (Fixed w/ EPA) (base + tier period)	OTHER DAIRY Tier 1 Price	OTHER DAIRY Tier 2 Price	AUTO CALC SUB-TOTAL FLUID MILK	AUTO CALC SUB-TOTAL FLUID MILK	AUTO CALC SUB-TOTAL TIER - 1	AUTO CALC SUB-TOTAL TIER - 2	REMARKS
		PRODUCT, EXAMPLE (Fluid Milk)	Half Gallon	500	500			CO	12345	$ 2.00	$ 1.00			ERROR:#REF!	$ 900.00
		PRODUCT, EXAMPLE (Other Dairy)	5 LB Container			200	100	CO	6789	$ 4.00		$ 3.50	$ 3.80			$ 700.00	$ 380.00
1	891001E110532	MILK, WHOLE, CHL, 1/2 PT CO	1/2 Pint		72,288			CO							$ - 0
2	891001E110546	MILK, REDUCED FAT, CHL, 2% MILK FAT, 1/2 PT CO	1/2 Pint		123,600			CO							$ - 0
3	891001E110550	MILK, NONFAT, CHL, 1/2 PT CO	1/2 Pint		55,200			CO							$ - 0
4	891001E112152	MILK, REDUCED FAT, CHL, 2% MILK FAT, 5 GAL BIB	5 Gal		2,100			CO							$ - 0
5	891001E112161	MILK, LOW FAT, CHL, 1% MILK FAT, 5 GAL BIB	5 Gal		1,926			CO							$ - 0
6	891001E112184	MILK, CHOC, LOW FAT, CHL, 1% MILK FAT, 1/2 PT CO	1/4 Pint		138,600			CO							$ - 0
7	891001E112644	MILK, CHOC, LOW FAT, CHL, 1% MILK FAT, 5 GAL BIB	5 Gal		2,052			CO							$ - 0
8	891001E110610	SOUR CREAM, CHL, CULTURED, MIN 18% MILK FAT, 1/2 PT CO	1/2 Pint			444	222	CO								$ - 0	$ - 0
9	891001E111724	YOGURT, REGULAR, BLUEBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			2,688	1,344	CO								$ - 0	$ - 0
10	891001E111734	YOGURT, REGULAR, STRAWBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			6,720	3,360	CO								$ - 0	$ - 0
11	891001E111765	YOGURT, LOW FAT, BLACK CHERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			264	132	CO								$ - 0	$ - 0
12	891001E111767	YOGURT, LOW FAT, BLUEBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			7,824	3,912	CO								$ - 0	$ - 0
13	891001E111771	YOGURT, LOW FAT, PEACH, CHL, BLENDED, 6 OZ CO	6 OZ Container			18,720	9,360	CO								$ - 0	$ - 0
14	891001E111775	YOGURT, LOW FAT, RASPBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			4,800	2,400	CO								$ - 0	$ - 0
15	891001E111777	YOGURT, LOW FAT, STRAWBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			10,848	5,424	CO								$ - 0	$ - 0
16	891001E111779	YOGURT, LOW FAT, STRAWBERRY BANANA, CHL, BLENDED, 6 OZ CO	6 OZ Container			6,216	3,108	CO								$ - 0	$ - 0
17	891001E111789	YOGURT, LOW FAT, VANILLA, CHL, 6 OZ CO	6 OZ Container			16,056	8,028	CO								$ - 0	$ - 0
18	891001E111795	YOGURT, LOW FAT, BLACKBERRY, CHL, BLENDED, 6 OZ CO	6 OZ Container			4,488	2,244	CO								$ - 0	$ - 0
19	891001E111798	YOGURT, LOW FAT, CHERRY VANILLA, CHL, BLENDED, 6 OZ CO	6 OZ Container			4,824	2,412	CO								$ - 0	$ - 0
20	891001E111801	YOGURT, LOW FAT, STRAWBERRY CHEESECAKE, CHL, BLENDED, 6 OZ CO	6 OZ Container			8,760	4,380	CO								$ - 0	$ - 0
21	891001E113402	CHEESE, COTTAGE, CHL, CREAMED, LARGE OR SMALL CURD, 5 LB CO	5 Gal			2,840	1,420	CO								$ - 0	$ - 0
22	891001E113403	CHEESE, COTTAGE, LOW FAT, CHL, CREAMED, LARGE OR SMALL CURD, 5 LB CO	5 LB Container			1,038	519	CO								$ - 0	$ - 0
23	891001E119202	SOFT SERVE MIX, VANILLA, CHL, 2.5 GAL BIB	2.5 Gal			274	137	CO								$ - 0	$ - 0
24	891001E119203	SOFT SERVE MIX, CHOC, CHL, 2.5 GAL CO	2.5 Gal			286	143	CO								$ - 0	$ - 0
25	896001E111491	DRINK, ORANGE, CHL, 1/2 PT CO	1/2 Pint			27,200	13,600	CO								$ - 0	$ - 0
26	896001E111497	DRINK, FRUIT PUNCH, CHL, 1/2 PT CO	1/2 Pint			29,400	14,700	CO								$ - 0	$ - 0
27	896001E113759	DRINK, LEMON, CHL, 1/2 PT CO	1/2 Pint			32,374	16,187	CO								$ - 0	$ - 0

Subtotals: $ - 0 $ - 0 $ - 0

Total: $0.00

Group 6

SPE300-25-R-0025- Schedule of Items

Group 6: Barksdale AFB, LA

Offeror:
Cage Code:	Complete Columns H, I, J (CLINS #1-5)

CLINs#	STOCK NUMBER	ITEM DESCRIPTION	CONTAINER SIZE	EST. USAGE (36) MONTHS FLUID MILK	UNIT	SPECIFY PRODUCT CODE	SPECIFY WHOLE SALE PRICE	FLUID MILK PRICE - (Fixed w/ EPA) (base + tier period)	AUTO CALC SUB-TOTAL FLUID MILK	REMARKS
		PRODUCT, EXAMPLE (Fluid Milk)	Half Gallon	500	CO	12,345	$ 2.00	$ 1.00	$ 500.00
		PRODUCT, EXAMPLE (Other Dairy)	5 LB Container		CO	6789	$ 4.00
1	891001E110546	MILK, REDUCED FAT, CHL, 2% MILK FAT, 1/2 PT CO	1/2 Pint	15,150	CO				$ - 0
2	891001E110531	MILK, WHOLE, CHL, 1 GAL CO	1 Gal	1,185	CO				$ - 0
3	891001E110539	MILK, LOW FAT, CHL, 1% MILK FAT, 1/2 PT CO	1/2 Pint	11,775	CO				$ - 0
4	891001E110550	MILK, NONFAT, CHL, 1/2 PT CO	1/2 Pint	7,875	CO				$ - 0
5	891001E112184	MILK, CHOC, LOW FAT, CHL, 1% MILK FAT, 1/2 PT CO	1/2 Pint	14,025	CO				$ - 0

Total: $0.00

File details come from the government source that posted it. Updated Feb 12, 2025.