A new product is being designed that has two components that will require machining on a CNC milling machine. Component A takes 4.4 minutes and Component B takes 6.1 minutes. The machine is estimated to run at 90% efficiency and 85% reliability. Set up a spreadsheet to calculate the number of milling machines required to produce 250 parts per day if the machines are expected to be operated for 7.5 hours during an 8-hour shift. Calculate the number of CNC machines required under the following conditions: a. Each CNC machine is operated for 1 shift b. Each CNC machine is operated for 2 shifts C. All CNC machines operate for 1 shift and don't have any idle time. Your solution to (c) will require running the machines overtime to meet the demand. d. Calculate the number of hours of overtime per machine (using the number of machines in part (c)) that would be needed to meet the demand. Each machine will be leased for a cost of $1100/day and operators are paid $30/hour for an 8-hour shift, and $40/hour for each hour of overtime. e. Determine the cost of each option (1 shift, 2 shifts, 1 shift + overtime) f. Identify which option you would recommend and explain why. A new product is being designed that has two components that will require machining on a CNC milling machine. Component A takes 4.4 minutes and Component B takes 6.1 minutes. The machine is estimated to run at 90% efficiency and 85% reliability. Set up a spreadsheet to calculate the number of milling machines required to produce 250 parts per day if the machines are expected to be operated for 7.5 hours during an 8-hour shift. Calculate the number of CNC machines required under the following conditions: a. Each CNC machine is operated for 1 shift b. Each CNC machine is operated for 2 shifts C. All CNC machines operate for 1 shift and don't have any idle time. Your solution to (c) will require running the machines overtime to meet the demand. d. Calculate the number of hours of overtime per machine (using the number of machines in part (c)) that would be needed to meet the demand. Each machine will be leased for a cost of $1100/day and operators are paid $30/hour for an 8-hour shift, and $40/hour for each hour of overtime. e. Determine the cost of each option (1 shift, 2 shifts, 1 shift + overtime) f. Identify which option you would recommend and explain why