Subscribe
Administrator Assistant
Remote Available
SALARY
10000000 - 10000000 IDR
INDUSTRY
Others
JOB TYPE
SKILLS
Quickbooks | Stock Resupply | English Proficiency
JOB DESCRIPTION
Working Hours: Weekdays, 10AM to 6PM (GMT+8)
Public Holidays: Follow Singapore Public Holidays
Annual Leave: 7 Days per year (+1 per year)
Medical Leave: 14 Days per year
Salary: IDR 10,000,000 (Indonesia)
JOB RESPONSIBILITY
- Purchase goods from our various suppliers.
- Restock goods when low stock.
- Handle RMA exchanges with supplier.
- Input invoices into Quickbooks.
JOB REQUIREMENT
Requirements:
- Requires Good English (Written and Reading)
- Requires Excellent Excel skills.
- Requires vast knowledge in console games and their online region restrictions.
- Preferably fluent in written Mandarin as well.
Job Description:
- Restock products by contacting various suppliers and getting a price quote.
- Work with QuickBooks to enter invoices.
- Buy products from multiple international suppliers.
- Adhere to strict release dates for products and follow protocol.
- Good understanding of products we sell. Check https://www.qisahn.com/ for a general list of our products.
- Regular adjustment of prices based on competitors.
- All applications must be sent to admin@qisahn.com with a copy of your resume, as well as the answer to the test question below. Applications not sent to admin@qisahn.com are rejected.
Test Question:
Your Sales Manager is about to make a purchase from Supplier A. Before making the order though, he wants to check the price against Supplier B, to ensure the company is paying the lowest prices.
Using Excel or Google Spreadsheet, semi-automate the process of checking prices between 2 price lists for him. To use your spreadsheet, Sales Manager only needs to copy data into the first 2 tabs.
The first tab for Supplier A and second tab for Supplier B.
Your 3rd tab will then show:
1. Product Name as per Supplier A,
2. UPC as per Supplier A,
3. Wholesale Price as per Supplier A and
4. The price difference between Supplier A and B for this product.
Supplier A Data - https://www.dropbox.com/scl/fi/6booe54ey867qf5aljgsa/Supplier_A.xlsx?rlkey=s0p4zkigzr8ch4j50tif86xkl&dl=0
Supplier B Data - https://www.dropbox.com/scl/fi/1p1lc76vqy68beygfrh2p/Supplier_B.xlsx?rlkey=oi8kmqi29agn98onmcdji9dyf&dl=0
Deliver your spreadsheet to pass the interview. List the limitations of your spreadsheet (if any) and the manual workaround for the limitation (if any).
Email your Excel file or Google Spreadsheet link to admin@qisahn.com
- Include a simple resume about yourself.