We are looking someone who can develop a excel file(s) for procurement purposes. Key requirements are
1. Dashboard. (generate basic reports like pending purchase orders, delivery to factory , list of purchase orders, Pending orders from factory, Purchase requisition separation, GRN(good received report, Invoice and payments status) [Graphic and pivot preferred, however, you are allowed to use other methods]
Important: at point of data entry PR should be categories as Technical, General/admin (non-technical), and import deliveries.
2. A master sheet where basic data can be enter (PR date number, PR received , purchase orders numbers , delivery GRN)
3. [Technical] Separate data entry point from 3 departments (Purchase order , GRN and invoicing , and dispatch)
Master sheet must be protected and other dept only provided data for master sheet and should NOT be allowed add/delete.
Sheet should be user-friendly. Futures changes should allowed. You should be able to complete project with 24 hours and submit for testing.
12 freelancers are bidding on average $357 for this job
I am a hard worker. I have done other projects like this one. If you choose me, you will not be disappointed. Thank you for your time. I look forward to working for you.
Good Day, I am freelancer here and would really like to handle your project. You would have my undivided attention to your project and I will ensure my work is 100% quality that exceeds your expectations. Thanks