supply chain management

using excel

Chapter 4 Business Processes DIRECTI1. Put your name and the four-digit number provided by your instructor in the space below and hit enter. This will customize the assignment for you. 2. Print out the entire workbook and put your answers in the space provided. Name: *** KEY *** 4-digit number: 1500 Consider the output and machine and machine hour figures shown below. Month Output Mach. Hrs. 1 60 1200 2 54 1100 3 66 1300 4 63 1300 5 57 1150 6 66 1350 7 51 1100 8 64 1100 Problem 1 In the space below, calculate the machine productivity for each month, as well as the average machine productivity for all 8 months. Do any of the months seem "unusual" to you? Explain. Productivity = Outputs / Inputs Month Productivity 1 2 3 4 5 6 7 00 Ave: #DIV/0