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.

Навыки: Excel, Обработка данных, Ввод данных, Visual Basic, Excel Macros

Показать больше: 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

О работодателе:
( 0 отзыв(-а, -ов) ) Walnut Creek, United States

ID проекта: #27968770

14 фрилансеров(-а) готовы выполнить эту работу в среднем за $15/час


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 Больше

$15 USD / час
(427 отзывов(-а))
(319 отзывов(-а))
(298 отзывов(-а))
(66 отзывов(-а))

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 Больше

$20 USD / час
(134 отзывов(-а))

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 Больше

$15 USD / час
(92 отзывов(-а))

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 Больше

$25 USD / час
(1 отзыв)

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 Больше

$12 USD / час
(3 отзывов(-а))

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 Больше

$10 USD / час
(0 отзывов(-а))

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 / час
(0 отзывов(-а))

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 / час
(0 отзывов(-а))

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 Больше

$15 USD / час
(0 отзывов(-а))

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 / час
(0 отзывов(-а))

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 Больше

$10 USD / час
(0 отзывов(-а))