Please answer Q8 in an excel format! Thank you for the help!

Operation Work Center Setup Time Run Time Notebook assembly 100 2 hours 10 minutes Pad production 200 3 hours 5 minutes Cover production 300 2 hours 9 minutes Determine the weekly capacity requirements in each of the work centers. For the two scheduled receipts, assume that the setup is complete, and that in each case they are half complete. 8. The following input-output data were gathered at the end of week 8 for a work center: Week 1 2 3 4 5 6 7 8 60 Planned input Actual input Planned output Actual output 60 68 65 60 60 70 65 62 60 75 65 63 70 65 63 60 68 65 64 60 60 65 65 60 55 65 63 60 55 65 60 Beginning backlog 50 hours a. Complete the input/output document. b. What was the planned objective? c. Was it met? d. What recommendations would you make? 9. A company with three product lines has estimated its weekly capacity requirements for three work centers as follows. Product Line A B Work Center 100 200 300 35 hours 25 hours 46 hours 28 hours 37 hours 35 hours 12 hours 56 hours 33 hours a. How many workers and duplicate machines) are needed in each work center if they are to work 40 hours per week? b. What is the difference if the firm decides to work two shifts (80 hours per week)