ACT 570 University Arizona Global Campus Week 5 Accounting Worksheet

Option #1: Value Mobile Nonfinancial Measures

For the past two years, Value Mobile has been working to improve the quality of its phones. Data for 2019 and 2020 follows (in thousands of phones):

Required:

1. For each year, 2019 and 2020, calculate the following:
2. percentage of defective units shipped
3. customer complaints as a percentage of units shipped
4. percentage of units reworked during production
5. manufacturing cycle time as a percentage of total time from order to delivery

Follow the instructions you see on the Data tab of the worksheet (found in Module 5 or by clicking “Next” at the bottom of this page). Show all calculations within the cells of the Excel spreadsheet. This means that you must use formulas and links so that your thought process can be examined. There should be no hard coding of solutions.