We have won a contract to refurbish large volume of mobile phones for another company. We are processing the first few batches currently but before volumes increase they want to send one of their staff to inspect premises and systems.
I need a basic database built tracking the handsets that we are refurbishing. All handsets are from the same company.
As you maybe aware every phone has an IMEI number which is a unique serial number (15 digits)
The functions/processes I need to record on the data base are:
Book Used Phones in (used Phones arrive from customer for refurbishment / arrival date )
Book Refurbished Phones Out (Return to Customer / despatch date)
Book Faulty Phones Out (Return to Customer / despatch date)
Book Outsourced Units Out ( if we outsource the work to another supplier / despatch date)
Book Outsourced Units In (returned from supplier if we outsource the work to another supplier / arrival date)
All the above will be scanned in using a barcode scanner. We currently do this onto excel files.
The reports I would need to run/print are:
Run report to show handsets on our premises at anyone time
Run report to show handsets outstanding at suppliers if we have outsourced the refurbishment.
Despatch Note with all serial numbers on, used when returning phones to customer our outsourcing to supplier.
We need to record the following details for each handset:
Date Booked In
Date Booked Out
Customer who sent stock to us
Supplier we sent to if we outsource work.
Status of phone when returned e.g Refurbished or Faulty (unable to refurbish).
Currently it is only 3 models:
Samsung i9100 / S2
Samsung i9300 / S3
Samsung i9505 / S4
Please bare in mind that we would like to scan in quite a lot in one go. So would need to say select i9100 x 200 units and then scan all, rather than scan each imei into a seperate field.
Uploading a text or excel file may also be quicker. Please note the handsets are booked in and out in large batches not individually. We will probably book approx up to 500 phones in and out in one week in a few batches.
The database is solely to track the physical location/history of every handset. There is no need to involve any financial data.
A search function would be needed to check one IMEI's history.
E.g we could search one IMEI and find out when it came to us, if we outsourced the work or carried it ourself and when it was despatched back to your customer.
5 freelancers are bidding on average £528 for this job
I work with databases over ten years. It is mostly Access, but I also work with FileMaker. Your task is not very difficult, and I need to build my reputation, so price is very fair. Best regards, Kosta