Admin (Excel Vlookup)

The Supreme HR Advisory Pte Ltd; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A leading HR consultancy firm based in Singapore is looking for a Sales Coordinator to provide administrative support to the sales team. The role involves managing customer inquiries, processing orders, and coordinating with vendors. Candidates should have at least two years of relevant experience and proficiency in Microsoft Excel. This position is full-time, with a salary commencing at S$2,880, and working hours from 8 am to 5:18 pm, Monday to Friday.

Qualifications

• Experience with Microsoft Windows and Excel required.
• Ability to travel to meet customers and vendors if necessary.
• At least 2 years of experience in a similar role.

Responsibilities

• Provide sales administrative services to sales team.
• Process customer inquiries and follow up on orders.
• Manage inventory and purchase orders effectively.

Skills

Customer enquiry management

Order management

Inventory management

Vendor negotiation

Microsoft Excel

Job description

Sales Coordinator

• Working Location: Loyang (Changi)
• Working Days: Monday - Friday
• Working Hours: 8am – 5:18pm
• Salary Range: $2,880 (After confirmation: $3,200)

Main Responsibility

Provide sales administrative services to the Sales Manager and Sales Executive to whom the Sales Coordinator is assigned, in the aspect of:

1. A. Customer Enquiry Management – Products and Services
   • Process all inquiries from customers promptly and send out price quotations, request for information such as brochures, samples, etc.
   • Follow-up on customer inquiries to check status of inquiries; if inquiries turned to orders and if not, reason for not getting the order.
   • Monthly statistical report on the number of inquiries turned to sales.
2. B. Customer Order Management
   • Acknowledge customer orders promptly after checking through specific details and instructions.
   • Generate and process the Sales Order, either for immediate or deferred delivery, in accordance to customer’s instructions.
   • Update customers on order status, delivery date and inform of any discrepancy or delay in shipment.
   • Upon delivery of the order, inform customer the shipping details promptly.
   • For Back Orders and inform customers of any changes in the delivery status.
   • Perform Sales Invoicing function when necessary.
3. C. Vendors Price Enquiry
   • Search and identify appropriate vendors and suppliers for product information. And obtain price quotation.
   • Negotiate price and other pertinent matters such as delivery time, payment terms, etc.
4. D. Purchase Order Processing
   • Perform purchasing function to fulfill customer’s order as well as inventory.
   • Generate Purchase Orders to appropriate vendors.
   • Track delivery status.
5. E. Inventory Management
   • Monitor and manage inventory level such that it is adequate to meet customer’s requirement.
   • Place replenishment order when stock level of inventory items falls below the prescribed level.
   • Monitor and manage slow moving and non-moving inventory.
   • Assist in routine (annual) and non-routine stock audit exercises.

Auxiliary Responsibilities

1. A. Sales & Marketing Function
   • When required, to carry out market research and intelligence on behalf Sales Manager and Executive.
   • Organize, manage and maintain products literature, catalogue, service bulletins, newsletter and other relevant information.
   • Assist in the administration of special projects, contracts and works orders.
   • Assist in all matters relating to marketing of product and services such as promotions and exhibition.
   • Provide assistance and input in routine report on sales and inventory e.g. data print-out.
   • Develop and maintain close ties and rapport with customers and vendors through regular interactions by periodic visits or telecommunication contacts.
2. B. Inter-department Coordination
   • Assist account departments in customer’s credit evaluation and accounts receivables (overdue accounts).
   • Perform sales and invoicing function, as a back-up whenever necessary.
   • Liaise with Quality Assurance Department on vendor qualification process.
   • Co-ordinate with other departments on related matters.

Requirements

• Experience in application program such as Microsoft Windows, Excel and others.
• Able to travel to meet customers and vendors when required.
• At least two years in experience in currently held position.

LIEW ONN KEE REG NO : R22108518

THE SUPREME HR ADVISORY EA NO:14C7279