Find Jobs
Hire Freelancers

Manufacturing Capacity Planning Script

$250-750 USD

Completed
Posted almost 9 years ago

$250-750 USD

Paid on delivery
We need to solve a capacity planning problem. We need a script to balance our production lines allocating a supplier for each product. We have a set of production orders that need to be schedulled/allocated considering capacity constraints. ---------------------------- Input Data: We have a set of tables with the following fields: Table: Production Orders: Description: A set of orders Fields: * SKU - the product code * Product Family * Limit Date - the date the product has to be completed (at the latest). * Quantity - the quantity of units to manufacture Table: Supplier and Products feasibility table Description: A relationship table that states which supplier can manufacture each product. Relationship is product family to supplier. A product can be manufactured in several suppliers and each supplier can make several diferent products. We can assume each supplier works strictly for our company, the don't have any other clients Fields: * Supplier code * Product Family Table: Supplier Capacity. Description: A table that indicates how many units each supplier can deliver to us. For each day in the schedulling horizon we have the capacity for each supplier. Fields: * Supplier code * Date * Capacity Table: Supplier Work In Progress Description: A list of products that are currently in each supplier. Fields: * SKU * Product Family * Quantity ------------------------------- Output: On the table Production Orders, we expect a new field: "Suggested Date". On the table Supplier Capacity, we expect a new field: "Reserved capacity" ------------------------------ Script Operation: The script should walk thru the items, starting from the farthest production order, and the most complex product. The complexity of products is defined by how many AVAILABLE suppliers can make the product. If there is not enough capacity for this product, the product has to be moved to a previous day. Once the a supplier is selected, you should have to add this product quantity to "reserved capacity" for this supplier. A supplier can't have more units than its capacity. Aditionaly, the list of "Work In Progress" should be considered as initial reserved capacity. The script should use a only work days (monday to friday) and consider a list of holydays. Also, a product should be allocated to a supplier that already has this product. This is desirable whenever posible but not a hard constraint.
Project ID: 7896853

About the project

11 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hola! I'm looking forward to working for you on this project. I'm an experienced developer, having worked with Python and PHP mainly. If that matters, I have a basic understanding of Spanish (l have worked with a Mexican guy and was partner with one from Argentina in a startup project). Saludos, Danilo G. Botelho
$600 USD in 10 days
5.0 (6 reviews)
4.0
4.0
11 freelancers are bidding on average $765 USD for this job
User Avatar
is these MYSQL tables accessed already via some admin panel or you using PHPMyadmin to view these? let me know please. I have 11+ years of experience in PHP/MYSQL and i can code this. Price we can negotiate once we discuss items of work to be done.
$1,000 USD in 10 days
4.9 (326 reviews)
7.6
7.6
User Avatar
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
$793 USD in 15 days
4.8 (41 reviews)
6.6
6.6
User Avatar
Hello Sir, I read full project descriptions and we are ready to start right away . We have good team on Custom PHP, MySQl, HTML, HTML5, CSS3, JavaScript, Jquery. Please response me for the further discussions. Queries: 1 On which platform you you want to build this? 2 What type of graphics you want? 3 Do you want any feature to include? 4 Do you want mobile compatibility ? Please allow us to discuss more about your project to make it perfect. About US : Since 2004 we are working as an extended teams for our clients, helping them to reduce Time To Market (TTM) and enhance Return On Investment (ROI). Our focus is to deliver 'value for money' rather than just a low cost solution. We regularly work with technologies such as PHP, .NET and Mobile platforms like iOS and Android to design and deliver the best solutions for client requirements. Other areas of competence includes Web Design and Digital Marketing. Specialties:- - Custom PHP Application Development - WordPress, Drupal, Magento - Mobile App Development (iOS & Android) - Responsive Graphic Design - Responsive Web Design - Yii, Zend, CodeIgniter, Symfony - Digital Marketing (SEO/SEM/SMO etc) Kindly feel free to contact us, and it would be my pleasure to address all your queries and clarifications or any support that you may require. Thanks
$790 USD in 10 days
4.6 (3 reviews)
4.4
4.4

About the client

Flag of ARGENTINA
San isidro, Argentina
5.0
1
Payment method verified
Member since Aug 15, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.