Foreign trade and customs clearance with purchasing management and logistics and Excel
Free of cost
by funding
-
Certificates: Microsoft Excel" certificate
Certificate "Purchasing Management 4.0 with TÜV Rheinland certified qualification"
Certificate "Foreign trade and customs clearance" -
Examination: Practical project work with final presentations
Module examination Microsoft Excel
Purchasing management 4.0 with TÜV Rheinland-certified qualification -
Teaching Times: Full-timeMonday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
-
Language of Instruction: German
-
Duration: 10 Weeks
Spreadsheet calculation with Microsoft Excel
Spreadsheet calculation with Excel (full-time 10 days/part-time 20 days)
Basics of table editing
Working with formulas and functions
Formatting cells, editing and printing tables
Filling, moving and copying
Calculating with date and time
Creating and editing diagrams
Using individual print settings
Manage workbooks
Using chart templates and chart layouts
Using Excel templates
Sorting and filtering data
Purchasing management and logistics
Purchasing 4.0: What is it and where is it going? (approx. 1.5 days)
Change in procurement in the digital age
Digitalization in purchasing
Centralized vs. decentralized purchasing
Back door selling
Maverick buying
Procurement marketing
Structuring the supply chain
Analysis methods
Basics of supply (approx. 1 day)
Target triangle of modern purchasing within the value chain
Purchasing cards, bullwhip effect
Advanced/Autonomous Procurement
Supplier Management 4.0 - eProcurement (approx. 0.5 days)
Introduction of e-procurement and Procure2Pay, e-invoicing
Strategic analyses (approx. 2 days)
ABC analysis: Procedure and possible applications
XYZ analysis: selection of inventory strategies
Supply strategies: single, global or unit sourcing
Basic data for the development of supply chain and purchasing strategies
Early Involvement
Volume bundling
Supply Chain Reference Model (SCOR)
Balanced scorecard and strategy maps
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Inquiry and tender (approx. 2 days)
Inquiries for goods and services
Inquiry strategies: Price inquiries
Service description
Rules for handling inquiries and tenders
Offer analysis: composition of costs
Simple, partial or weighted multi-factor comparison
Supplier selection and supply chain management (approx. 2.5 days)
Strategic 360° supplier selection
SCOPE supplier selection process
Segmentation of the supplier portfolio
Risk assessment
Supplier certification
Supplier audits
Supplier classification and evaluation
Supplier policy
Supplier homepage
Portfolio analyses/portfolio matrices
Interface management
Supply chain management
Process optimization and design
E-procurement solutions
Electronic catalogs
Electronic order management
Product Information Management (PIM)
Electronic Data Interchange (EDI)
Basics of procurement strategies (approx. 0.5 days)
Make-or-buy analyses
Price structure analysis (approx. 1.5 days)
Composition of a price
Price calculation with the "50-25-25" formula
Cost accounting methods
Performance management
KPI
Performance evaluation
Partial cost accounting (contribution margin)
Break-even analysis
Price regression
Best practice
Price structure analysis in the supply chain
Evaluation and methodology
Value management, value engineering, value analysis (approx. 0.5 days)
Contractual agreements (approx. 2 days)
Use of price escalation clauses
Learning curve and bonus agreements
Quality management
Agreements with suppliers
Supplier rating system
Legal issues in purchasing and data protection (approx. 1 day)
Sustainability in the supply chain
Supply chain due diligence law
DSGVO
IT cybersecurity
Agile purchasing organization (approx. 0.5 days)
Strategic and operational purchasing
Lead buying in the supply chain
Purchasing controlling (approx. 1.5 days)
Objectives and tasks of purchasing controlling
Methods for developing key figures
Professional service in the supply chain
Service providers
Hard savings vs. soft savings
Success in purchasing
Design of purchasing reports
Supplier and supply chain controlling
Project work, certification preparation and certification exam "Purchasing Management 4.0 with TÜV Rheinland certified qualification" (approx. 3 days)
Foreign trade and customs clearance
Foreign trade (approx. 1 day)
Trade in Europe and world trade
Importance of sea freight transportation in foreign trade (approx. 1 day)
Advantages and disadvantages of sea freight transportation
Ship types and freight areas
Importance of air freight transport in foreign trade (approx. 1 day)
Known consignor and regulated agent
Advantages of groupage shipments in air freight
Incoterms® 2020 (approx. 1 day)
One-point and two-point clauses
Criteria for a suitable Incoterms® 2020 clause
Risk hedging (approx. 1 day)
Payment and delivery risks in foreign trade
Documentary collection
Documentary letter of credit
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Customs procedure (approx. 5 days)
Import procedure
Customs certificate and release
Import duties
Customs duties and customs value
Electronic customs tariff (EZT)
Export procedure
The Automated Tariff and Local Customs Clearance System ATLAS
Export licenses
EU customs law
The Union Customs Code
Preferences and certificates of origin
Security provisions in the international movement of goods
EU customs security initiative
Customs warehouse
Processing ATLAS customs procedures with Dakosy ZODIAK GE (approx. 5 days)
Create and edit customer data
Create and edit article data
Create import customs declaration
Processing input requests
Processing errors
Creating export declarations
Creating transit procedures in the NCTS system
Creating an import and export customs declaration
Creating a transit declaration
Possible prompts and errors
International Trade (approx. 1 day)
The International Chamber of Commerce ICC
EU legal bases
Supply Chain Due Diligence Act (LkSG)
Forwarder documents for foreign trade (approx. 1 day)
FIATA-FCR and FIATA-FCT
FIATA-Multimodal Transport
Bill of Lading
Project work (approx. 3 days)
To consolidate the content learned
Presentation of the project results
Changes are possible. The course content is updated regularly.
You understand the concept of spreadsheets and master the use of Excel quickly and confidently in order to achieve optimal and accurate work results.
You also have knowledge of operational and strategic purchasing tools, digital e-procurement, as well as price analysis, calculation and negotiation. You are familiar with supply chain management and supplier selection and know methods for price analysis and calculation.
You will also be familiar with the work processes and legal conditions for foreign trade in Europe and beyond. You will acquire knowledge in the field of customs clearance and will be able to apply this in practice with the ZODIAK software.
The course is aimed at people with training or professional experience in the commercial or administrative field, specialists from the areas of sales, purchasing, materials management and people with a degree in economics or business administration.
Specialists in the field of purchasing are in demand at companies in all sectors. Your new skills will open up career opportunities in a wide range of fields.
You prove your newly acquired knowledge with a TÜV Rheinland-certified qualification.
Didactic concept
Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).
You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.
Virtual classroom alfaview®
Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face lessons via video technology.
The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).