Purchase Requisition (Studio) (ACME System 1)

[Dream_Catcher]

Hello Everyone,
I am doing automation as an electives during my studies, and during 5 days of class I barley got a chance to learn and sadly my deadline is just around the corner. I need your help and assistance guys. It will be really appreciated.
Case: Full part is:
Purchase requisition
**In your company, internal orders are reported by means of a form to the procurement
department, which processes them. For this purpose, the completed form is sent to
procurement by e-mail as a PDF. The relevant employee opens the mail, views the
purchase requisition and checks the availability of the articles in the ERP system. If the
article is available from more than one supplier, the employee selects the supplier with
the lowest article price. Then the employee orders the ordered quantity of the items via
ERP system.
#Relevant sub-systems
**Vendors tab
**PDF
**Email
**Email Guideline
**As subject of the incoming mail order request is used in each case

With all the above information given, I tried to learn from youtube and forum and completed till half part and now I need your precious help for further process.

From here;
Views the purchase requisition and checks the availability of the articles in the ERP system. If the article is available from more than one supplier, the employee selects the supplier with
the lowest article price. Then the employee orders the ordered quantity of the items via
ERP system.
New Microsoft Excel Worksheet.xlsx (8.2 KB)
pdf.zip (1.2 MB)
These are the pdf I extracted data into excel above.

From this excel, I have to take description and check in ACME system 1 VENDOR tab (i.e. Vendor stock) for the availability of goods! And choose the lowest price and order quantity. But I don’t know how to do that I tried but seems like totally lost.

Please help me with this if possible. Thank you very much for your time and kindness. I wish you have a good days ahead.