ATTACHMENT E-Economic Price Adjustment Sample Calculation Worksheet.xls

XLS spreadsheet 47 KB Posted Jun 21, 2011

Attached to: Fluid Milk Products for 58 Commissaries Federal contract opportunity
Solicitation number: HDEC02-11-R-0006
Issued by: Defense Commissary Agency

About this file

From the source

Other files attached to Fluid Milk Products for 58 Commissaries, newest first.
File	Type	Posted
Amendment 0001_ATTACHMENT D_SCHEDULE OF SUPPLIES_11-R-0006.xls	XLS spreadsheet	Jun 29, 2011
Amendment 0001- 11-R-0006.doc	DOC document	Jun 29, 2011
ATTACHMENT D_SCHEDULE OF SUPPLIES_11-R-0006.xls	XLS spreadsheet	Jun 21, 2011
Map - Dairy 2011 revised .pptx	PPTX presentation	May 24, 2011

On GovTribe

Try for free Login

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

April 09

		ATTACHMENT E
EPA CALCULATION SAMPLE WORKSHEET
		CLASS I
		*FED ORDER 30
					EFFECTIVE:	1-Jul-11
	BASE PRICE			ADJUSTED PRICE
		DATE				DATE
MONTH	PRICE	PUBLISHED		MONTH	PRICE	PUBLISHED
Jun-11	$12.46	5/20/11		Jul-11	$13.07	6/17/11
BASE PRICE:			$12.46
ADJUSTED PRICE:			$13.07
		.
DIFFERENCE:			$0.61
GAL/CWT:			$11.63
CHANGE PER GALLON:			$0.05
	ADJUSTMENT BY UNIT
GALLON: 128 OZ			$0.05
HALF GAL: 64 OZ			$0.03
QUART: 32 OZ			$0.01
PINT: 16 OZ			$0.01
HALF PINT: 8 OZ			$0.00
1. Cell B10: Enter base price from previous month
2. Cell F10: Enter adjustment price for Federal Milk Marketing Order published on or before the 23rd of the month.
3. Cell D16: The difference between the adjusting price and the base price.
4. Cell D18: The cwt (one hundred weight) = 11.63 gallons of milk deliverable under this contract
5. Cell D20: The change per gallon is difference divided by the gallon/cwt (rounded 2 places)
7. Cells D24-D28: Reflects the change per gallon, half gallon, quart, pint, and half pint.
FEDERAL MILK MARKET ORDER # 30 IS FOR SAMPLE PURPOSES ONLY

File details come from the government source that posted it. Updated Nov 14, 2017.