ATTACHMENT E-Economic Price Adjustment Sample Calculation Worksheet.xls

XLS spreadsheet 47 KB Posted

Attached to
Fluid Milk Products for 58 Commissaries
Solicitation number
HDEC02-11-R-0006
Issued by

About this file

From the source

ATTACHMENT E-Economic Price Adjustment Sample Calculation Worksheet.xls

View the file

Other files

File Type Posted
Amendment 0001_ATTACHMENT D_SCHEDULE OF SUPPLIES_11-R-0006.xls XLS spreadsheet
Amendment 0001- 11-R-0006.doc DOC document
ATTACHMENT D_SCHEDULE OF SUPPLIES_11-R-0006.xls XLS spreadsheet
Map - Dairy 2011 revised .pptx PPTX presentation

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.

April 09

ATTACHMENT E
EPA CALCULATION SAMPLE WORKSHEET
CLASS I
*FED ORDER 30
EFFECTIVE:1-Jul-11
BASE PRICEADJUSTED PRICE
DATEDATE
MONTHPRICEPUBLISHEDMONTHPRICEPUBLISHED
Jun-11$12.465/20/11Jul-11$13.076/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 .