please provide step by step answer using excel and provide formula

. Consider a team of N=4 engineers and make the following assumptions: An engineer works for 8hrs per day. An engineer needs 15min per day to communicate with another engineer of the same team. (He/she needs to spend this time communicating with each other engineer of the team.) When engineers concentrate on work, their efficiency (i.e. actual work done vs. time spend, including interruptions, personal needs, corporate tasks, administrative tasks, etc) is 75% Based on the above, a. 2pt. For N=4 compute the "Productive hours of an engineer per day" and "Hours of productive time of the team per day" aka "Team Productivity (TP)" b. 8pt. Compute the "Team Productivity (TP)" for team sizes N=3, 5, 6, 7, ..., 15, and plot TP versus team size N. (You must use an Excel spreadsheet and create the plot based on your table. Make sure that you include the numbers and the plot to your answer. Zero credit if not) C. 5pt. Consider the same 12 engineers organized as follows: i. 4 teams of 3 engineers ii. 3 teams of 4 engineers iii. 2 teams of 6 engineers iv. 1 team of 12 engineers For each of the above, compute the Group Productivity (GP) of the group of 12 engineers, i.e. times . What is your conclusion? d. 5pt. Change the communication time, instead of 15min to 5min and then to 30min. Create the respective TP plots as in (b) for 5min, 15min and 30min. Include the respective snapshots as your answer. What are your conclusions of the graphs