Tab_5_SPE4AX-14-D-9413_Parker_011092400_Synopsis_Attachment_-_IOR.xlsx

XLSX spreadsheet 214 KB Posted May 23, 2016

Attached to: Parker Hannifin Next-Gen Contract Effort
Solicitation number: SPE4AX-13-R-0016
Issued by: Defense Logistics Agency Aviation

About this file

From the source

IOR

View the file

Other files

File	Type	Posted
SPE4AX14D9413_J&A_Amendment_0002_Redacted.pdf	PDF	Dec 1, 2017
Tab_5_Parker_GE_COI_Synopsis_Attachment.xlsx	XLSX spreadsheet	Aug 18, 2015
Tab_5_Parker_GE_COI_Synopsis_Attachment.xlsx	XLSX spreadsheet	Aug 12, 2015
Tab_5_SPE4AX-14-D-9413_Parker_Tinker_Expiring_Synopsis_Attachment_IOR.xlsx	XLSX spreadsheet	Jul 24, 2015
SPE4AX-13-R-0016_Parker_Synopsis_Amendment_0003_Identification_of_Requirements.xlsx	XLSX spreadsheet	Jan 23, 2015
SPE4AX-13-R-0016_Parker_Redacted_J A_Amendment_1.pdf	PDF	Sep 18, 2014
Tab_6_SPE4AX-13-R-0016_Parker_Redacted_J A.pdf	PDF	Sep 18, 2014
SPE4AX-14-D-9413_Parker_Next-Generation_LTC.pdf	PDF	Aug 12, 2014
SPE4AX-13-R-0016_Parker_Synopsis_Amendment_0002_Identification_of_Requirements.xlsx	XLSX spreadsheet	Apr 14, 2014
SPE4AX-13-R-0016_Amendment_0001.pdf	PDF	Aug 27, 2013
Contract_Data_Requirements_List_(DD_1423).pdf	PDF	Jun 4, 2013
PARKER_LTC_PID_PACK__20130423_212019.txt	TXT text file	Jun 4, 2013
Parker_Solicitation_rev_05292013.pdf	PDF	Jun 4, 2013
Parker_Identification_of_Requirements.xlsx	XLSX spreadsheet	May 17, 2013

Show all 14

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 LTC Pull

Federal Supply Class (FSC)

National Item Identification Number (NIIN)

Part Number

Estimated Annual Quantity (EAQ)

Acquisition Advice Code (AAC)

Acquisition Method Code (AMC)

Acquisition Method Suffix Code (AMSC)

Nomenclature

North American Industry Classification System (NAICS) Code

Weapon System Designator Code (WSDC)

Weapon System Information Code (WSIC)

Contractor and Government Entity (CAGE) Code

Contractor Name

4320

011092400

24 45600 1044 2

110

"GEAR ROTOR SET,ROTARY PUMP"

333911

BEF

86329

Parker

Notes

General Notes:

All Quantities presented are converted to Sales Unit of Measure (order unit)

LTC Candidate Analysis Fields

Simulation Fields

LTC CANDIDATE ANALYSIS TAB

FIELDS IDENTIFIED

		NIIN	National Item Identification Number
		FSC	Federal Supply Class
		ON LTC	Will indicate if on Traditional LTC or Captain of Industry PBL
		ON SSA	YES if on current SSA List
		IPV NIIN	IPV NIIN Flag
		CROWN JEWEL	YES if FY16 Crown Jewel
		ON SSP	YES if on FY16 SSP Listing
		FY16 Adds	YES if on FY16 Add Listing
		FY16 Renewals	YES if on FY16 Renewal Listing
		PROFIT CENTER	Profit Center
		SPLY CHN	Supply Chain
		DIV	"Virtual Division" presented, i.e. working division symbol as opposed to General Order
		IST	"Virtual IST" presented, i.e. working IST symbol as opposed to General Order
		IST TEXT	"Virtual IST" presented, i.e. working IST text as opposed to General Order
		COMMODITY
(BASED ON FSC)	FSC description
		Project	Project
		Execution Area	Execution Area
		Projects Projected Award Date	Projects Projected Award Date
		Assigned To	Project assigned to in AAA tool
		Project from AAA	Project came from AAA tool (Y or N)
		PIIN	LTC Contract - No Dummy LTCs are included on this list - if Multiple LTCs exist, then shows one with Validity End Date that is farthest out
		Option Period	Option Period
		Vendor	Vendor Commercial and Government Entity Code from Jay's most current Weekly LTC file
		Vendor Name	Vendor Name from Jay's most current Weekly LTC file
		LTC VALIDITY END DATE	LTC Current Option Year Validity End date (If Multiple Contracts, this field will show end date that is farthest out)
		LTC FINAL EXPIRATION DATE	LTC Final Expiration Date (If Multiple Contracts, this field will show date where Validity End is farthest out)
		AVTN PPT CODE	Indicates Planning Priority Code (A-L) on Aviation Items ONLY
		BDC	Business Driver Category
		AAC	Acquisition Advice code
		AMC	Acquisition Method Code
		AMSC	Acquisition Method Suffix Code
		ADF	Annual Demand Frequency
		ADQ	Annual Demand Quantity
		ADV	Annual Demand Value = Cost Basis Price * Annual Demand Quantity
		ADV Baseline	Annual Demand Value = Cost Basis Price * Annual Demand Quantity SSP Baseline
		ALT	Administrative Lead Time
		PLT	Production Lead Time
		RMC	Report Method Code
		PIC	Place of Inspection
		SPC	Special Procedures Code (03,05,06, 07 are CSI)
		CSI	Based on SPC, indicates which category of CSI
		SOLE SOURCE	AMC = 3,4,5
		KIT NIIN	Indicates YES if NIIN is a Kitting NIIN
		KIT COMPONENT NIIN	KIT COMPONENT NIIN
		COTS INDIC	Commercial Off The Shelf Indicator
		DIST CHNL	Distribution Channel
		UFO LINES	Number of UFO Lines "as of" Date data is pulled
		SAFETY STOCK LVL	Safety Stock Level
		SPR QTY	Special Program Requirements Quantity
		COV DUR	Coverage Duration
		COST BASIS PRICE	Price to DLA
		STD U PRICE	Standard Unit Price
		SALES UNIT CONV FCTR	Sales Unit Conversion Factor
		ORDER UNIT	Order Unit
		BASE UNIT	Base Unit
		ITEM CONSUMPTION RATE	Consumption Rate for previous month
		CONSUMPTION HISTORY	Consumption History - Average Annual Demand over Last 2 Years (24 Months of Demand divided by 2)
		CONSUMPTION FORECAST	Consumption Forecast - Projected monthly demand based on the average of the next 12 months forecast (total of next 12 months forecast divided by 12). It is computed only on RMC R Items
		CRIT PART IND	Critical Part Indicator
		TOR CD	Tech Ops Review Code
		TOR DATE	Tech Ops Review Date
		PKGING RVW CD	Packaging Review Code
		FAT	First Article Test Indicator
		EXPRT CTRL	Export Control Indicator
		DWG RQRD	Drawing Required Indicator
		LAST DEMAND DATE	Last Demand Date
		LAST AWARD DATE	Last Award Date
		NOMEN	Nomenclature (Item Name)
		SUPPLY PLANNER	Supply Planner
		AVTN SUPPLY PLNR NAME	Supply Planner Name
		AVTN PA BRANCH	Supply Planner Office Code
		PRODUCT SPEC	Product Specialist
		PACKAGING CONTACT	Packaging Contact
		RESOLUTION SPEC	Resolution Specialist
		NAICS	North American Industry Classification System
		QCC	Quality Control Code
		HAZ MAT INDIC	Hazardous Material Indicator
		WSDC MM BD1	WSDC from Material Master
		WSIC	Weapons System Indicator Code
		SHELF LIFE CD	Shelf Life Type
		SSA CAGE	If on SSA List, Associated CAGE
		SSA	If on SSA List, Associated Company Name
		PNUM RCRD CNT	Reveals total number of part number records present in system
	AMPL ITEM IDENTIFYING PART NUMERS - LIMITED TO FIVE RECORDS	PN CAGE 01	CAGEs and Part Numbers Provided are Primary Item Identifying (RNCC/RNVC 3/2) or Secondary Item Identifying (RNCC/RNVC 5/2) The Primary Item Identifying Parts are listed first
		P NUM 01
		PN CAGE 02
		P NUM 02
		PN CAGE 03
		P NUM 03
		PN CAGE 04
		P NUM 04
		PN CAGE 05
		P NUM 05
	LAST 10 AWARDEES ON NIIN
		CAGE 01
		CAGE NAME 01	CAGE for Last Award Made on NIIN

EMPL AVG 01	Business Size of Last Awardee
SMALL BUS IND 01	Indicator if Last Awardee was a Small Business

CAGE 02

CAGE NAME 02

EMPL AVG 02

SMALL BUS IND 02

CAGE 03

CAGE NAME 03

EMPL AVG 03

SMALL BUS IND 03

CAGE 04

CAGE NAME 04

EMPL AVG 04

SMALL BUS IND 04

CAGE 05

CAGE NAME 05

EMPL AVG 05

SMALL BUS IND 05

CAGE 06

CAGE NAME 06

EMPL AVG 06

SMALL BUS IND 06

CAGE 07

CAGE NAME 07

EMPL AVG 07

SMALL BUS IND 07

CAGE 08

CAGE NAME 08

EMPL AVG 08

SMALL BUS IND 08

CAGE 09

CAGE NAME 09

EMPL AVG 09

SMALL BUS IND 09

CAGE 10

CAGE NAME 10

EMPL AVG 10

SMALL BUS IND 10

SIMULATION DATA FIELDS IDENTIFIED
SIMULATION DATA	Estimated Annual Quantity	Estimated Annual QTY based on the average of projected PRs for years 1-5 based on LTC (Revised) Simulation.
	Estimated Annual Value	Estimated Annual $ value based on the average of projected PRs
	Minimum Yearly Contract Qty	Min QTY for R items= [(Estimated Annual) - (6* ICR)] Min QTY for N items=[(Estimated Annual) -(Consumpt Hist * .5)]
	Min Yearly Dollar Value	Min Yearly Dollar Value
	Max Yearly Contract Qty	Max QTY for R items= [(Estimated Annual) + (6* ICR)] Max QTY for N items=[(Estimated Annual) + (Consumpt Hist * .5)]
	Max Dollar Value	$ value of Max QTY
	Minimum Order Qty	Minimum Order Qty
	Maximum Order Qty	Maximum Order Qty
	Yr 1 PR Count	The number of projected PRs by Yr. Based on the LTC (Revised)Simulation (if items was on LTC –Cov Dur=90 days ALT= 15 days)
	Yr 1 PR Qty
	Yr 1 PR Value
	Yr 2 PR Count	The number of projected PRs by Yr. Based on the LTC (Revised)Simulation (if items was on LTC –Cov Dur=90 days ALT= 15 days)
	Yr 2 PR Qty
	Yr 2 PR Value
	Yr 3 PR Count	The number of projected PRs by Yr. Based on the LTC (Revised)Simulation (if items was on LTC –Cov Dur=90 days ALT= 15 days)
	Yr 3 PR Qty
	Yr 3 PR Value
	Yr 4 PR Count	The number of projected PRs by Yr. Based on the LTC (Revised)Simulation (if items was on LTC –Cov Dur=90 days ALT= 15 days)
	Yr 4 PR Qty
	Yr 4 PR Value
	Yr 5 PR Count	The number of projected PRs by Yr. Based on the LTC (Revised)Simulation (if items was on LTC –Cov Dur=90 days ALT= 15 days)
	Yr 5 PR Qty
	Yr 5 PR Value
	5 Year Spend	The dollar value of the 5 yr PR total
	5 Year OA Savings	This is the OA savings item would achieve if added to LTC. It is the delta between the Original 5 Yr Spend and Revised 5 Yr Spend
	5 Year IHC Savings	This is the Inventory Holding Cost savings item would achieve if added to LTC. It is the delta between the Original 5 Yr Inventory Holding Cost Projection and Revised 5 Yr Inventory Holding Cost Projection
	5 Year Setup Cost Savings	This is the Set up Cost (Admin) savings item would achieve if added to LTC. Simulation uses VSRM cost factors for Small and Large Purchases to calculate administrative savings from going from manual to automated workload
	5 Year Manual Workload Savings	This is Manual workload avoided if item is added to LTC. It is the 5 yr total of the Original PR projection.
	Del Ord Cost Diff 5Yr	Savings/cost accrued by the PR system delivery costs for 5 years.
	Potential Savings	Sum of the OA, IHC, Manual PR, and Delivery Order Savings
	LTC ADD SCORE	LTC ADD SCORE
		The process used was to assign a value (1-5) to each NIIN based on:
		Requirements-Use PR projections for next 5 yrs and assign value based on if NIIN had any projected PR in the given year.
		Savings are also considered when prioritizing our candidates.

The fields we would consider would be what are currently in our simulation data and we are tracking for Big Ideas. They are:

-Inventory Holding Cost Saving

-OA Savings

-Set-up Cost Savings

-Manual Workload

Top 20% highest Savings=5

20%-40% highest Savings =4

40%-60% highest Savings =3

60%-80% highest Savings =2

80%-100% highest Savings =1

If item has a projected PR in 1YR= 5, 2YR=4, 3YR=3, 4YR=2, 5YR=1

For example if NIIN had requirements in all 5 yrs, it total would be

(5+4+3+2+1)

LTC Add Score Weighting Table

		A	B	C	D	E	F	G	H	I	J	K	L
		20	18	16	14	12	10	8	6	4	2	0	-2
Yr 1, 4+	20	20	19.34	18.68	18.02	17.36	16.7	12.832	12.304	7.36	7.03	6.7	6.37
Yr 1, 3	19	19.33	18.67	18.01	17.35	16.69	16.03	12.296	11.768	7.025	6.695	6.365	6.035
Yr 1, 2	18	18.66	18	17.34	16.68	16.02	12.288	11.76	11.232	6.69	6.36	6.03	5.7
Yr 1, 1	17	17.99	17.33	16.67	16.01	15.35	11.752	11.224	10.696	6.355	6.025	5.695	5.365
Yr 2, 4+	16	17.32	16.66	16	15.34	11.744	11.216	10.688	10.16	6.02	5.69	5.36	5.03
Yr 2, 3	15	16.65	15.99	15.33	14.67	11.208	10.68	10.152	9.624	5.685	5.355	5.025	4.695
Yr 2, 2	14	15.98	15.32	14.66	11.2	10.672	10.144	9.616	9.088	5.35	5.02	4.69	4.36
Yr 2, 1	13	15.31	14.65	13.99	10.664	10.136	9.608	9.08	8.552	5.015	4.685	4.355	4.025
Yr 3, 4+	12	14.64	13.98	10.656	10.128	9.6	9.072	8.544	8.016	4.68	4.35	4.02	3.69
Yr 3, 3	11	13.97	13.31	10.12	9.592	9.064	8.536	8.008	7.48	4.345	4.015	3.685	3.355
Yr 3 ,2	10	6.65	6.32	5.99	5.66	5.33	5	4.67	4.34	4.01	3.68	3.35	3.02
Yr 3, 1	9	6.315	5.985	5.655	5.325	4.995	4.665	4.335	4.005	3.675	3.345	3.015	2.685
Yr 4, 4+	8	5.98	5.65	5.32	4.99	4.66	4.33	4	3.67	3.34	3.01	2.68	2.35
Yr 4 ,3	7	5.645	5.315	4.985	4.655	4.325	3.995	3.665	3.335	3.005	2.675	2.345	2.015
Yr 4 ,2	6	5.31	4.98	4.65	4.32	3.99	3.66	3.33	3	2.67	2.34	2.01	1.68
Yr 4, 1	5	4.975	4.645	4.315	3.985	3.655	3.325	2.995	2.665	2.335	2.005	1.675	1.345
Yr 5, 4+	4	4.64	4.31	3.98	3.65	3.32	2.99	2.66	2.33	2	1.67	1.34	1.01
Yr 5, 3	3	4.305	3.975	3.645	3.315	2.985	2.655	2.325	1.995	1.665	1.335	1.005	0.675
Yr 5, 2	2	3.97	3.64	3.31	2.98	2.65	2.32	1.99	1.66	1.33	1	0.67	0.34
Yr 5, 1	1	3.635	3.305	2.975	2.645	2.315	1.985	1.655	1.325	0.995	0.665	0.335	0.005
Yr 5, 0	0	3.3	2.97	2.64	2.31	1.98	1.65	1.32	0.99	0.66	0.33	0	-0.33

		Factor	Planning Recommendation
Score computed as:		1	Add, in score sequence, use descending ADF for tie-breaker for same score
	LTC Score * .67	0.8	Add, in score sequence, use descending ADF for tie-breaker for same score
plus	PPT Score * .33	0.5	Not recommended to add at this time (PR not expected w/in next 2 1/2 yrs, low MA impact)
times	Factor

LTC CANDIDATE SELECTION CRITERIA:

NIINs ON THIS REPORT MUST BE

*MEMBER OF AVIATION SUPPLY CHAIN

*MEMBER OF SSA LISTING

AND

IS NOT AAC J, Y, or V

CONSUMPTION HISTORY > 0

ITEM CONSUMPTION RATE >0

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