Creating a Gantt Chart for projecting lead time in manufacturing.

Hfd804

New Member
Joined
May 26, 2017
Messages
1
I am needing to create a gantt chart for calculating lead times for building products in my manufacturing business. I am not very advanced in Excel and would really like some help with this subject. I need to be able to set how many products I can manufacture in a day, (such as 30) and then, when I get an order for 50 pieces for Monday, it would put 30 pieces on Monday and 20 pieces on Tuesday and so on.... Saturdays and Sundays and major Holidays would be excluded from the schedule. Would need to be a monthly view. Any advice from anyone would be appreciated.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,109,275
Messages
5,527,728
Members
409,785
Latest member
AdamPriest

This Week's Hot Topics

Top