FORD CPA (Capacity Planning Analysis) User Guide for Suppliers

B

beyaz

#1
Hello,

I'm looking for FORD CPA (Capacity Planning analysis) user guide for suppliers. I couldn't find in internet.
Where can I get it ? Does anybody help me?

Thanks
 
Elsmar Forum Sponsor

mbehmazia

Involved In Discussions
#4
FYI - the previous post that listed the CAR spreadsheet is outdated. Ford's latest revision for the CAR is 4.3 as of this posting.
 

Jim Wynne

Staff member
Admin
#5
FYI - the previous post that listed the CAR spreadsheet is outdated. Ford's latest revision for the CAR is 4.3 as of this posting.
Are you referring to the Capacity Planning Analysis workbool posted by antoine.dias (as opposed to a CAR document)? I don't see a revision level on it anywhere, except for a "revision level# 18 in the footer, which appears to be the revision level applied by the user of the form.
 

mbehmazia

Involved In Discussions
#6
The CAR is also part of the CPA tool that Ford uses. Not sure where Antoine obtained the one in the link however Ford uses a completely different CAR with additional requirements.I am currently working for Ford working as an STA Capacity Analyst and this is not the one we are sending our suppliers. I wish I could post the latest and greatest here however if you send me your email I might be able to forward one to you soon. Hope this helps.
 

mbehmazia

Involved In Discussions
#8
Can you tell me how should I calculate APW and MPW for Predicted Good Parts/Week in lower left side of the document?

This metric is automatically calculated. The Predicted Good Parts/Week is a calculation that takes into consideration the Maximum Parts Possible/Week (P) and adjusts is based on the demonstrated (surrogate) OEE. The cell will turn RED if the predicted good parts/week (B2) is less than the required good parts/week to support next process (J). This cell is directly correlated to OEE - if the predicted good parts/week is less than the required good parts/week, it is given that the demonstrated OEE is also less than the required OEE.
 
#9
Can you tell me how should I calculate APW and MPW for Predicted Good Parts/Week in lower left side of the document?

This metric is automatically calculated. The Predicted Good Parts/Week is a calculation that takes into consideration the Maximum Parts Possible/Week (P) and adjusts is based on the demonstrated (surrogate) OEE. The cell will turn RED if the predicted good parts/week (B2) is less than the required good parts/week to support next process (J). This cell is directly correlated to OEE - if the predicted good parts/week is less than the required good parts/week, it is given that the demonstrated OEE is also less than the required OEE.
Please see my attachment. In my file it is not calculated automatically. If you have a formula please give it to me to complete my file. I am requested to put data from here in CGP an on PSW.
 

Attachments

mbehmazia

Involved In Discussions
#10
Interesting. What I would do here is take the lowest number on B5 then subtract planned scrap losses in row H. This will get you where you need to be so you can enter accurate data on the GCP site.
 
Thread starter Similar threads Forum Replies Date
H FORD's project milestone acronyms Customer and Company Specific Requirements 4
R Ford Q1 Manufacturing Site assessment result Customer and Company Specific Requirements 3
Ron Rompen Ford Method - Position Capability with MMC Modifier Capability, Accuracy and Stability - Processes, Machines, etc. 14
M Ford Q1 Revocation Recovery Process Customer and Company Specific Requirements 5
A Is normal for FORD EU ask for the PSW every year APQP and PPAP 5
C A couple CSR (Customer Specific Requirements) questions... Esp. Ford & Toyota Customer and Company Specific Requirements 5
V What document to use to document Welding PV testing - Supplier to Ford APQP and PPAP 1
E Ford Phased PPAP and T2 timing APQP and PPAP 1
S Where to get Ford document FAP 03-111 FMEA and Control Plans 10
Q Ford's Q1 Score Prediction Customer and Company Specific Requirements 2
V Ford Dimensional Tag Characteristics requirements APQP and PPAP 2
R Ford Motor Company new CSR document - May 2014 Customer and Company Specific Requirements 1
K Q1-Ford - Does anyone have any Q1 templates? Document Control Systems, Procedures, Forms and Templates 2
Ron Rompen Ford Paint Audit Checklist Customer and Company Specific Requirements 4
S ASTM-D4000 & FORD "ZW" Call-Outs Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
S Dimensional Issues because of the last years FORD Recall Manufacturing and Related Processes 2
J JMP Gauge R&R with FORD MSA Data Quality Tools, Improvement and Analysis 2
A Statistical Software Calibration using Ford's "Sample Calibration File" Statistical Analysis Tools, Techniques and SPC 8
V Where I can find an AAR form on Ford Covisint? APQP and PPAP 1
Marc Ford is introducing an Aluminum F-150 Pick 'em Up Truck World News 1
V Webasto Ford Exceptions Form APQP and PPAP 1
Marc Ford - Self-parking technology called Fully Assisted Parking Aid World News 1
M Advise on R Chart with Ppk of 17.85 for Ford Capability, Accuracy and Stability - Processes, Machines, etc. 37
V What Ford Phase PPAP Level should DV testing be submitted? APQP and PPAP 1
Stijloor Ford - June 2013 Customer Specific Requirements (CSR) Customer and Company Specific Requirements 1
T What innovations led to Ford's production line? Coffee Break and Water Cooler Discussions 5
Ajit Basrur On Henry Ford's 150th Birthday, His Greatest Insight Has Been Tragically Forgotten Coffee Break and Water Cooler Discussions 11
D How long must we provide service parts to Ford? IATF 16949 - Automotive Quality Systems Standard 7
S Ford Motor Engineering Change Level definition Customer and Company Specific Requirements 6
C Will Ford accept AS9100 certification in place of ISO9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16
R Ford SQDCME manual Manufacturing and Related Processes 1
D What is the Ford Troubled Supplier group? Manufacturing and Related Processes 7
V Ford SREA (Supplier Request for Engineering Approval) 2007 revision Document Control Systems, Procedures, Forms and Templates 2
C New Ford CQI 15 Rollout Requirement and reference to ESBC24-5005-AB IATF 16949 - Automotive Quality Systems Standard 3
D What is a Ford Single Scale? Customer and Company Specific Requirements 2
J Ford changing their acronym for Significant Characteristics from HIC to CTQ Customer and Company Specific Requirements 2
K How to fill out an SREA (Supplier Request for Engineering Approval) form at Ford? APQP and PPAP 3
G Ford - Type 1 Gage Study MSA (Measurement Systems Analysis) acceptable? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
xfngrs What does the Ford Europe acronym ISRD stand for? APQP and PPAP 6
V Where to find FORD Specific PPAP Training Training - Internal, External, Online and Distance Learning 3
M For Bulk Material (eg. paint), are there any guidelines for Ford PPAP Requirements? APQP and PPAP 1
J Ford Acronym - What the acronym "ym" means in Ford lingo? Customer and Company Specific Requirements 1
C Does anyone have the Ford Supplier Requirements Manual (including Q1)? Customer and Company Specific Requirements 2
B TS16949 Annual PPAP Submission Requirements for Ford and Chrysler Parts IATF 16949 - Automotive Quality Systems Standard 2
V FORD Phased PPAPs Information APQP and PPAP 3
M Chrysler, GM, and Ford Tooling Records Requirements - What are Tooling Records? IATF 16949 - Automotive Quality Systems Standard 4
F Requesting Help in Identifying Ford Suppliers Supplier Quality Assurance and other Supplier Issues 6
S Nonconformance - Not meeting Ford requirements for TS Certification IATF 16949 - Automotive Quality Systems Standard 11
xfngrs Ford WERS Location and Access Customer and Company Specific Requirements 3
Stijloor Mulally, Bill Ford awarded more than $98 million in stock World News 1
Similar threads


















































Top Bottom