(20 points) There are 4 machines. A part moves through each machine automatically. The machining times and automated set up times for each part are shown in the table. Machines operate two 10hr shifts a day. Machines are expected to be down about 5% of the time for regular maintenance. The demand is 25 parts per day. Each part must go on each machine. The cycle time is the time the machine run with the part on it. The set up time is the time is takes to load the part into the machine. a. What is the takt time based on demand? Make sure to include the correct units. (5pts) b. Graph the percentage load chart as a stacked bar chart in excel. (7pts) (The graph must show both cycle time and set up time as a stacked bar and include the takt timeline on the graph.) c. Can we meet demand based on the percentage load chart? (3pts) (Hint: In order to meet the demand, for every machine, cycle time + setup time should be equal to or less than takt time.) d. Is this line efficient? Explain your reasons. (5pts) (20 points) There are 4 machines. A part moves through each machine automatically. The machining times and automated set up times for each part are shown in the table. Machines operate two 10hr shifts a day. Machines are expected to be down about 5% of the time for regular maintenance. The demand is 25 parts per day. Each part must go on each machine. The cycle time is the time the machine run with the part on it. The set up time is the time is takes to load the part into the machine. a. What is the takt time based on demand? Make sure to include the correct units. (5pts) b. Graph the percentage load chart as a stacked bar chart in excel. (7pts) (The graph must show both cycle time and set up time as a stacked bar and include the takt timeline on the graph.) c. Can we meet demand based on the percentage load chart? (3pts) (Hint: In order to meet the demand, for every machine, cycle time + setup time should be equal to or less than takt time.) d. Is this line efficient? Explain your reasons. (5pts)