Procurement Excel Dashboard

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.


Skills: Data Entry, Data Processing, Excel, Order Processing, Project Management

See more: procurement excel sheet, excel dashboard procurement, procurement dashboard excel, dashboard procurement, procurement excel, excel reports procurement, procurement excel order status, purchase order dashboard, procurement dashboard, procurement dashboard report, excel procurement status report, excel dashboard procurement purchase, project procurement excel, basic procurement reports excel, procurement reports excel, futures hours, data entry methods, dashboard procurement excel, purchase order excel dashboard, master excel, technical data sheet, invoice processing, excel reports, excel PIVOT, Dashboard

About the Employer:
( 0 reviews ) lahore, Pakistan

Project ID: #2504200

12 freelancers are bidding on average $357 for this job


Hi, i can do it. Im programmer for years and very familiar with Excel as well as VBA for Excel automation tasks like what you need. Please send the sample file of your current data and what you've already designed/w More

$380 USD in 15 days
(23 Reviews)

Dear Hiring Manager Please check your PM Inbox Thanks You

$300 USD in 2 days
(3 Reviews)

Hi..I have 1o years Project management experience and handled varies projects in India and many types.. its really easy i can do it with in 24 Hrs..

$250 USD in 1 day
(3 Reviews)

hi,plz give me this opportunity.

$450 USD in 1 day
(0 Reviews)

Myself has worked on various excel sheet projects to prepare company's cash flows.

$400 USD in 10 days
(0 Reviews)

I clearly understand your need. I have worked on 3 such projects. It will be a great chance to work with you.

$500 USD in 4 days
(0 Reviews)

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.

$250 USD in 15 days
(8 Reviews)

dear sir i am familiar with using excel for industrial management,operation research and quality control data [url removed, login to view] check your pm.

$250 USD in 7 days
(0 Reviews)

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

$250 USD in 5 days
(0 Reviews)

Hi, developping similar tools in excel used to be my job in subsequent multinational companies I used to work for. Many of these involved gathering, evaluating and presenting data from several suppliers, involving diff More

$400 USD in 15 days
(0 Reviews)

I can do this for you.

$250 USD in 7 days
(0 Reviews)

I am ready for this job

$600 USD in 1 day
(0 Reviews)