Analyze purchases using Excel worksheetsPurchases & Warehouses / Analyze purchases using Excel worksheets
Start : May 20-2021 |
End : May 22-2021 |
Trainer : Eng. Saad Hamad |
Course Fee : 450.00$ |
No. Of Places : 5 Of 12 |
Location : Apt #7 ,Floor 11, Tower 4, Empire Business Towers, Erbil, Kurdistan Region, Iraq. |
who should attend?
Employees who are competent in the departments of procurement, needs, logistics and catering in ministries, institutions, authorities, companies, different departments, banks, and others.
Chairmen and members of the envelope opening committees and tenders decision committees in the entities described above.
Secretaries of tenders and auctions committees.
Employees in contract departments.
Advisers and legal scholars and legal departments.
Personnel departments of sales and marketing departments.
Project Management Specialists.
Employees in warehouse and warehouse departments.
Specialists in the departments of administrative affairs.
Chairmen and members of committees, which constitute acts of tenders and procurement.
objective
How to assess the competitiveness of supplier pricing through developing “Should Cost Models”
How to assess all elements of supplier capabilities by creating weighted average supplier scorecards
How to use Excel’s sophisticated decision support features for procurement analysis
How to visually compare bids, analyze spend, and track supplier performance by creating charts
How to use PivotTables, functions, and subtotals to summarize large amounts of purchasing data
How to develop “Target Pricing Models” for negotiation strategy
How to import data from other systems into Excel for analysis
How to drill down into complex purchasing spreadsheets by using filtering, conditional formatting, VLOOKUP and more
How to use macros to free up time for strategic purchasing work
content
Introduction to MS Excel
Introduction to MS Access
Applied software specialized in procurement
Use the Excel S M program in the chart:
Cost Planning.
Forecast and plan using the Solver Solution Wizard
Analysis and trade-off between decision alternatives using Scenarios scenarios
Systems design using MS Access
Define the objectives of the system.
Identify the main components and components of the system.
Preparation and design of system files.
Designing data entry documents (input forms).
Design of system outputs (information reports).
Linking system elements using Macros macros and Modules modules
Business Development Using Computer 1
Implementation of the full cycle of procurement work
Workshop: Analyzing, recording and summarizing procurement processes and preparing lists using computer
Development of computerized procurement work 2
Audit of procurement elements Result: Audit program and collection of evidence
Full Workshop: Using structured programs to review income and expenditure items, assets items, and obligations prepared electronically
Developing computer procurement work 3
Planning budget and preparation problems
Stages of the criteria and procedures for preparing the current budget
Work development using computer 4
Balancing projects and evaluation survey tasks
Performance Measurement, evaluation and improvement planning
Complete Workshop: Using Computer in Analysis and Criticism
Complete Workshop: Using a computer in the preparation, writing, and presentation of procurement reports