please complete the remaining excel portion

Three fivers line Cout of Oualty Penort Three Phen ise fwing lowint awem Obj. 1, 3 Three Rivers Inc. provides cable TV and Internet service to the local community. The activities and activity costs of Three Rivers are identified as follows: Details Prepare a Pareto chart of these activities. a. Using the information in Exercise 17, identify the cost of quality classification for each activity and whether the activity is value-added or non-value-added. b. Prepare a cost of quality report. Assume that sales are $3,000,000. Round percentages to one decimal place. Answer: Check Figure: External failure, 20.7% of total cost c. Prepare a value-addedon-value-added analysis. d. = Interpret the information in (b) and (c)