material planning

Closed Posted 3 months ago Paid on delivery
Closed Paid on delivery

Material Planning Project

Skills and Experience:

- Strong knowledge and experience in material planning

- Familiarity with raw materials, finished goods, and packaging materials

- Ability to work with specific suppliers for material procurement

- Proficient in replenishing materials on a monthly basis


* Receiving Sheet

* COA's, (Batch numbesrs, manufacturer etc)

* Production Orders per customer per SKU

* Production Planning (Report on Planned vs actual)

* BOM's for all products.

* Material Requirements based on planned production, Raws, packs etc, needs to show what stock I have on hand and what is required for the production run

* Yield Sheet, after every production, I do a yield sheet per product, showing the opening stock you had, what was actualy used as per the BOM/Recipe. How many Lt's was mixed and total Lt's in Good Stock, This then shows the waste on each component,

* Finished Goods,

Batch Numbers,

Manuf Date

Expiry Date

Collections per POD

Invoiced qty

Outstanding Invoice qty

(Showing Total Manuf, Collected and Closing Stock on Dashboard)

* Inventory Management (Actaul Stock count vs System qty's and write off totals per item

* Waste Report p/production run.

I have 6 warehouses, 4000 squares each. making it difficuilt to only manage with different excels.

Project Description:

I am looking for a skilled material planner to assist me in managing and organizing the procurement of various materials for my business. The project involves planning for raw materials, finished goods, and packaging materials on a monthly basis.

Key Responsibilities:

- Collaborate with me to determine the specific materials needed for production

- Work with our existing supplier to ensure the timely and efficient delivery of materials

- Monitor inventory levels and forecast future material requirements

- Develop and implement strategies to optimize material planning and minimize costs

- Coordinate with other teams to ensure smooth material flow throughout the production process

Ideal Candidate:

The ideal candidate for this project should have previous experience in material planning, specifically with raw materials, finished goods, and packaging materials. They should be comfortable working with a specific supplier and have the ability to replenish materials on a monthly basis. Strong communication and organizational skills are essential for this role.

If you have the necessary skills and experience, and are interested in this project, please submit your proposal outlining your

Excel VBA Excel Macros

Project ID: #37475747

About the project

11 proposals Remote project Active 1 mo ago

11 freelancers are bidding on average $343 for this job


Hi there! With a proven track record in material planning, particularly in managing diverse materials for production, I bring expertise in determining material needs, coordinating with suppliers for prompt deliveries, More

$250 USD in 1 day
(14 Reviews)

Top 1% in Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More

$500 USD in 7 days
(48 Reviews)

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 2 days

$320 USD in 1 day
(41 Reviews)

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto More

$250 USD in 1 day
(17 Reviews)

Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how More

$250 USD in 4 days
(22 Reviews)

Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tabl More

$300 USD in 3 days
(0 Reviews)

Hello there, my name is Saim and I am a freelancer with extensive experience in material planning and procurement. I understand that you are looking for a skilled material planner to assist you in managing and organizi More

$250 USD in 1 day
(0 Reviews)

Hello client! My name is Abdul and I am a professional data analyst with experience in material planning. I understand that you are looking for a skilled material planner to assist you in managing and organizing the pr More

$250 USD in 1 day
(0 Reviews)