From production systems design it is important to determine if a manufacturing cell can meet throughput. One way to do this is to calculate a Takt time and compare the total processing time for each workstation in the cell to the Takt time. - To calculate Takt time the following equation is used: - Takt time = Total time available to product parts per week / Parts to be made per week - Total Processing time for a workstation is equal to the sum of all Tasks assigned to that Workstation. - Throughput is met when each workstation in a cell has a total processing time less than the Takt time. Tasks - Create a program that will verify if a cell meets desired throughput. 1. Ask the user to input the total weekly throughput (parts to be made in a week). 2. Analyze the information on the cell which is given in a spreadsheet. The spreadsheet for the cell information will follow the same pattern. Row 1 lists the workstation number (the number of workstations will vary but will always be 2 or more). Rows 2-6 will list task times for up to 5 tasks. Each workstation will be assigned between 1 and 5 tasks. All times are given in minutes. The worksheets Cell1 and Cell2 are given as examples for reference. 3. Provide the user with feedback by telling them the following: - The Takt time. - Whether the cell meets throughput. - If throughput is not met, which Workstation/Workstations cause the failure. Your feedback may either be in the form of a single message box or in a well-formatted table on the spreadsheet from which the program was run. (The one with the workstation data). Overall, the cell will work 5 days a week, 7.5 hours a day. Grading - Your Program will be run multiple times. Each time a new Cell worksheet will be copied into your submitted workbook that follows the format outlined above. From this worksheet your program named "Main" will be run. A single throughput will be entered as parts per week. Your grade will be based on the information provided to the user