please complete the excel portion

Quality Cost Clasquificetion VANYA \begin{tabular}{l} VANYA \\ \begin{tabular}{|c|c|} \hline \multicolumn{1}{|c|}{ Value- } & Non-Value- \\ Added \end{tabular} \\ \begin{tabular}{|l|l|} \hline & Added \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \\ \hline \end{tabular} \\ \hline \end{tabular} Three Rlvers ine. Cost of Quality Repert Three Rlvers Inc. Value-AddedNon-Valus-Added Acthilty Analyals \begin{tabular}{l|l|l|l|} \multicolumn{1}{c|}{ Catezery } & Ameunt & Percent \\ \hline Value-added & & \\ Non-value-added & & \\ Total & & \\ \hline \end{tabular} [Kcy essoy anwwer here] Obj. 1,3 Inc. provides cable TV and Internet service to the local community. The activities and activity costs of are identified as follow 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)