Track materials. Cross check purchases with supplier invoices

Budget 553$ per month
Posted: 5 years ago
Opened
Description
Currently maintaining materials purchased on an Excel spreadsheet.
Below are activities, but it might be easier, if I provide the following:
(a) Our spreadsheet with all details held
(b) Supplier1: Fabric KNITTER PO and Invoice
(c) Supplier2: Fabric DYER PO and Invoice

Summary of activities as follows:
==========================
(1) We raise PO to order X GREIGE (ie undyed) fabric rolls and KG of a specific type of fabric

(2) Supplier1 (ie fabric knitting company) supplies Y number of GREIGE rolls of fabric
(a) May take several deliveries to deliver all the GREIGE Rolls of fabric.
(b) For each delivery, KNITTER provides a different KNITTER'S PO.

(3) Then Z number of GREIGE rolls of fabric sent to Supplier2, the DYERS:
(3a) The DYERS dye the GREIGE fabric different colours (ie becomes finished DYED fabric)
(3b) The DYERS deliver finished DYED fabric, in different quantities, as per as and when it is ready.
DYERS PO provided with every delivery

(3c) Info: There could remain X-(Y+Z) GREIGE rolls of fabric with the dyers (that we are unaware of)
(3d) Info: GREIGE Rolls can be dyed a variety of colours, as per our PO to the dyers

(4) Following needs checking:
(4a) KG and number of rolls of GREIGE fabric supplied by KNITTERS
(4b) KG and number of rolls of FINISHED fabric supplied by DYERS
(4c) YIELD per Roll of dyed fabric (ie calculated by taking PO, then metres dyed per KG of GREIGE Roll).

(5) Match KNITTERS Invoice to KNITTERS PO
--> Check IF all GREIGE fabric has been delivered

(6) Match DYERS Invoice to DYERS PO
--> Also IF check all dyed fabric has been delivered

(7) Identify GREIGE Rolls of fabric with the DYERS (yet to be dyed)

(8) Be able to search database on the following:
(8a) Ragvalley PO
(8b) KNITTERS PO and/or Invoice
(8c) DYERS PO and/or Invoice

There are other activities, but it will make more sense once further information is provided.
Currently we do not need a database, as mentioned, only use Excel spreadsheet.

Other - LAB DIPS to match Pantone colour:
===================================
Sometimes customers ask us to match a specific shade of colour for a specific fabric. This activity is performed by the dyers. The lab dips need to be tracked

ORDERS GIVEN TO DYERS:
======================
All orders and details of each order given to Dyers, need to tracked

IDENTIFY PAYMENTS MADE and OUTSTANDING FOR BOTH GREIGE & DYED FABRIC:
=====================================================================
Match KNITTERS & DYERS statement with purchases made from both
(system should also show greige fabric that has been paid and is outstanding)
Skills:
3d,fabric design,database,knitting,pantone,sales orders and invoices,spreadsheets
Category
Source: peopleperhour.com

Add a bid

days

Similar freelance jobs

$430
I'm looking for someone who's available to start ASAP on some spreadsheets. The data is my customers data and must be handled with care. I will provide the requirements/tasks to anyone who's interested. Please get in touch ASAP. Skills:....
$403
Wife & I were falsely accused of stealing by a major department store, three security guards followed me us to the railway station, they surrounded us in front of the general public who saw everything that was going on, blackmailed us, never apologised when they did not find anything on us: So, basically......
$66
We work with 35 people with Office365. we have MS sharepoint and are going to migrate to MS teams. who can help us with implementing the rights and different project folders. Not a big project. takes an estimated 2-3 days. Can be a intro to future projects. Looking forward! English needs to be good.......
$71
I would like to buy 1000 leads for 15$ targeting UK women aged 20-55, wanting weight loss, a personal trainer or wanting fitness videos for home training. I would like to test the leads first and if they are of good quality i can promise to buy much more. You also offer a script writing of a telesales......
$335
Looking for an expert in structural equation modelling and SPSS. I have a paper in SEM would like your assistance with, The job requires someone with strong knowledge of IBM AMOS and model building. Skills:....
$335
I need a local (UK-based) online and telephone research assistant who can find me the contact details of the key decision makers in the largest 100 nursery groups in England. This will take a mix of online and real world (phoning) sleuthing to identify the right senior level contacts. Although a short......
$128
Having Custom packaging Kraft boxes created for your products can be insanely easy, if you are careful with your choices. Therefore, it’s best that you bring into account some important factors that will allow you to make the right decision. https://custompackagingpro. com/. Skills:....
$216
I have a draft agreement from my potential business partner that needs reviewing. Its is in regards to entering a partnership concerning a new restaurant. I need someone suitably qualified to ensure the details of the contract do not compromise my situation. Skills:....
$168
I am a self employed person. I like to submit my tax return. I have all my records of expense and earning, working as a Courier Driver i already made an excel sheet. kindly let me know how much you will charge for submitting to HMRC, and how much time you require to complete the job Regards Khan. Skills:....
$25
I am looking for qualified primary teachers, with experience in phonics, particularly if you are an english literacy subject leader/coordinator OR Are you in charge of choosing phonics systems for schools, to watch a short 7 minute presentation on my books and tell me how much you think they are worth......
$35
You will have at-least 5 years of experience in: - Carrying out Party wall services in the residential property market - Draft Party wall documents - Preparing and issuing fee proposals and negotiating party wall awards - Business development experience preferred - Client-facing with a positive demeanour......
$168
I need a spreadsheet that's been created tidying up all images same size box's made to look neat. Skills:....
$230
I am marketing an employment agency. The agency is owned by the employees and as such can give different types of payments such as dividends. This means there is different tax treatment. I need someone, who knows Excel well, do build a spreadsheet for me where I can put in a day rate for a contractor......
$13
I am looking for freelancers who can help me with a quick task on eBay. It will takes 2 minutes maximum. You MUST have your own eBay account that is already established - it cannot be newly created. If you have an existing eBay account and want to get paid to do 2 minutes work please get in touch for......
$226
We oparating a Quartz mine in Sri Lanka which has a purity of 99+. We are looking for a bulk buyer and the appreciate set of machinry for crushing into micron sizes as a investment. You can bring investment here and there is no duty will be charged. Also you can bring back the profits you earned by exporting......
$11
I need tax advice on a property transaction. 1) Three of us own a freehold of a property that has been split into three independent flats. We would like to take out a BTL mortgage and have been advised that we should create a lease for each flat. I would like some advice regarding our options and potential......
$84
We currently have a seller central account on Amazon. We require some support with this from someone with experience with Amazon specifically creating and optimising listings. We currently have approx 12 products listed within our seller central. We are aiming to have this completed by mid February at......
$204
I need telesales women to call companies in the united kingdom and speak to key divisions makers. You will be selling our recruitment services. Skills:....
$844
I wanted to find about the hours and cost of running the following project: - Salesforce contacts database is approx 19k of which 17k contacts need to be demoted into a lead record. this requires extracting and re-uploaded to salesforce. - along with this the related information such tasks, activities......
 
At acework (www. acework. io), we are fierce advocates for remote work. Our online platform is built exclusively for matching remote-ready candidates with vetted remote work. We are looking for a Talent and Sales Manager with experience in hiring for profiles and selling our platform to global talent......
$220
Please provide 4-5 detailed slides for macro assessment of local demand and market needs for Modular Homes in CENTRAL Asia. For example, demand and supply of shipping containers (accumulating and availability). It is important for business feasibility calculations and comparison with modular homes made......
View all