Data table Requirements 1. For each year, 2019 and 2020 , calculate the following: a. Percentage of defective units shipped b. Customer complaints as a percentage of units shipped c. Percentage of units reworked during production d. Manufacturing cycle time as a percentage of total time from order to delivery 2. Referring to the information computed in requirement 1 , explain whether Global Cell Phones' quality and timeliness have improved. Requirement 1. For each year, 2019 and 2020 , calculate: a. Percentage of defective units shipped Select the formula you will use to calculate the percentage. Then enter the amounts in the formula and calculate the percentage for both 2019 and 2020 . (Round the percent to two decimal places, X.XX% ) b. Customer complaints as a percentage of units shipped Select the formula you will use to calculate the percentage. Then enter the amounts in the formula and calculate the percentage for both 2019 and 2020 . (Round the percent to two decimal places, X.XX% ) c. Percentage of units reworked during production Select the formula you will use to calculate the percentage. Then enter the amounts in the formula and calculate the percentage for both 2019 and 2020 . (Round the percent to two decimal places, X.XX% ) d. Manufacturing cycle time as a percentage of total time from order to delivery Select the formula you will use to calculate the percentage. Then enter the amounts in the formula and calculate the percentage for both 2019 and 2020 . (Round the percent to two decimal places, X.XX% ) Requirement 2. Referring to the information computed in requirement 1, explain whether Global Cell Phones' quality and timeliness have improved. (Enter percentage points to two decimal places, X.XX.) The percentage of defects has by quality of the cell phones being produced and shipped. The number of customer complaints has by for future sales. The percentage of units reworked has The they are shipped. percentage point(s). This indicates in the in the percentage point(s) which has implications inspection quality, which catches defects before Finally, the average time from order placement to order delivery has So customers are receiving their orders