Production Schedule Calculator

Looking to create an excel production schedule calculator. There are multiple production lines in the facility and they run different products. Each production line + product being run has a specific throughput of bottles run per shift. I would like to create a production schedule and calendar to be able to input the product SKU and designated line to run on and it would calculate the number of days needed to complete production. It would also spread the production across a calendar in the file. For example, if a specific product SKU on production line 1 has a shift throughput of 10,000 bottles per shift, and we run 2 shifts per day, and we have total production demand of 100,000, that would require 5 production days running 10,000 per shift x 2 shifts to equal 20,000 units per day and would require 5 days production time on that line. I would like the production to be displayed in a calendar format so we can see when the actual production would start and the estimated date for it to be complete.

If this sheet could be automated with a drop down for each SKU (SKU info to be provided) and then a selection of the line it would run on (line info to be provided), based on those selections it would populate across the calendar to show daily production. I would also like to have the ability to sequence another SKU to schedule after the initial SKU. For example SKU 1 to run on Line 3 and it will take 15 days to complete production, I would like to be able to show SKU 9 to run on Line 3 after SKU 1 has completed, and show that it would start after the first 15 days and would take 5 days for SKU 9 to be completed.

Taidot: Excel, tietojenkäsittely, Tiedonsyöttö, Visual Basic, Excel Macros

Näytä lisää: calculate number days dates using javascript, infopath 2003 date calculate script, website development production schedule, parts per hour calculator, production per hour formula, production rate calculator, cycle time calculator online, cycle time calculator, production time calculator excel, production calculation formula, cycle time calculator excel, production schedule web designers, infopath 2003 calculate number days, example production schedule event, mt4 expired date account number, excel csv date text number, web design production schedule, looking forwarding telephone number, calculate number tiles needed tile floor, javascript program calculate number days date

Tietoa työnantajasta:
( 0 arvostelua ) Walnut Creek, United States

Projektin tunnus: #27968770

14 freelancers are bidding on average $15/hour for this job


Hi, Greetings! ✅checked your project details: Production Schedule Calculator ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. I Lisää

$15 USD / tunti
(427 arvostelua)
(319 arvostelua)
(298 arvostelua)
(66 arvostelua)

Hi, As I understand you are looking for production schedule calculator. I have experience on Excel formulas and macros and can help with you. Please share more details on the existing production line. Looking forward Lisää

$20 USD / tunti
(134 arvostelua)

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfille Lisää

$15 USD / tunti
(92 arvostelua)

Hi. I have 6+ years of experience in Mobile (iOS/Android/Kotlin) app development and 6+ year Exp in Web development(PHP,Mageto .NET, Firebase,JAVA,HTML5). I can use Native/Xamarin/Ionic/PhoneGap/Flutter for mobile deve Lisää

$25 USD / tunti
(1 arvostelu)

Although I am relatively new to Freelancer, I have 25 years experience developing Excel, Access and VBA Scripts for a major computer corporation. I have reviewed your project and would like to recommend a solution tha Lisää

$12 USD / tunti
(3 arvostelua)

Hi. This is Shakil,I am from Bangladesh.I read about your project already. i am so happy for that, my experience is enough for your project. if you select me for your project, i'll submit your project in time with you Lisää

$10 USD / tunti
(0 arvostelua)

Hello. I can complete this project. I created VBA and Python scripts for analyzing large data sets from oilfields for the actualization oil well models.

$12 USD / tunti
(0 arvostelua)

I'm a senior Computer Science Specialised Student. It's really a easy task for me to complete it through making a proper computer program. I've done many live projects thought. Thankyou.

$9 USD / tunti
(0 arvostelua)

Hi there,   Greetings, If you are open for a web application then can make a nice scheduling application. Please check once. 1. Case Management system [login to view URL] you Lisää

$15 USD / tunti
(0 arvostelua)

Hi. I am used to be a production planner in an FMCG factory. I totally understand what you want from this project. Please let me know about the details and I will start my job to deliver the results right on time.

$8 USD / tunti
(0 arvostelua)

Hello, potential client! A freelancer, fast-learner, and a good listener. A freelancer that can give you a satisfactory or exemplary output or results for a low cost. I'm proficient when it comes to the use of the Micr Lisää

$10 USD / tunti
(0 arvostelua)