please complete the excel portion

b. c. Three Rivers Inc. Value-Added/Non-Value-Added Activity Analysis \begin{tabular}{l|l|l|l} \multicolumn{1}{c|}{ Category } & \multicolumn{1}{c|}{ Amount } & \multicolumn{1}{c|}{ Percent } \\ \hline Value-added & & \\ Non-value-added & & \\ Total & & \\ \cline { 2 - 3 } & & \\ \hline \end{tabular} d. [Key essay answer here] purchasing policy requires that the purchasing agents place each quarter's purchasing requirements out for bid. This is because the Purchasing Department is evaluated solely by its ability to get the lowest purchase prices. The lowest cost bidder receives the order for the next quarter (90 days). To make its motorcycles, J. Burns requires 3,600 frames per quarter. J. Burns received two frame bids for the third quarter, as follows: - Midnight Frames, Inc.: \$401 per frame. Delivery schedule: 40 frames per working day (90 days in the quarter). - Iron Fist Frames Inc.: $400 per frame. Delivery schedule: 3,600 ( 40 frames 90 days) frames at the beginning of July to last for three months. J. Burns accepted Iron Fist Frames Inc.'s bid because it was the low-cost bid. INSTRUCTIONS 1. Comment on J. Burns's purchasing policy. 2. What are the additional (hidden) costs, beyond price, of Iron Fist Frames Inc.'s bid? Why weren't these costs considered? 1. Comment on J. Burns's purchasing policy. 2. What are the additional (hidden) costs, beyond price, of Iron Fist Frames Inc.'s bid? Why weren't these costs considered? 3. Considering only inventory financing costs, what is the additional cost per frame of Iron Fist Frames Inc.'s bid if the annual cost of money is 8% ? (Hint: Determine the average value of frame inventory held for the quarter and multiply by the quarterly interest charge, then divide by the number of frames.) b. a. a. [Key essay answer here] Obj. 1,3 provides cable TV and Internet service to the local community. The activities and activity costs of Three Rivers are identified as folle 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. c. Prepare a value-addedon-value-added analysis. d. Interpret the information in (b) and (c). b. c. Three Rivers Inc. Value-Added/Non-Value-Added Activity Analysis \begin{tabular}{l|l|l|l} \multicolumn{1}{c|}{ Category } & \multicolumn{1}{c|}{ Amount } & \multicolumn{1}{c|}{ Percent } \\ \hline Value-added & & \\ Non-value-added & & \\ Total & & \\ \cline { 2 - 3 } & & \\ \hline \end{tabular} d. [Key essay answer here] purchasing policy requires that the purchasing agents place each quarter's purchasing requirements out for bid. This is because the Purchasing Department is evaluated solely by its ability to get the lowest purchase prices. The lowest cost bidder receives the order for the next quarter (90 days). To make its motorcycles, J. Burns requires 3,600 frames per quarter. J. Burns received two frame bids for the third quarter, as follows: - Midnight Frames, Inc.: \$401 per frame. Delivery schedule: 40 frames per working day (90 days in the quarter). - Iron Fist Frames Inc.: $400 per frame. Delivery schedule: 3,600 ( 40 frames 90 days) frames at the beginning of July to last for three months. J. Burns accepted Iron Fist Frames Inc.'s bid because it was the low-cost bid. INSTRUCTIONS 1. Comment on J. Burns's purchasing policy. 2. What are the additional (hidden) costs, beyond price, of Iron Fist Frames Inc.'s bid? Why weren't these costs considered? 1. Comment on J. Burns's purchasing policy. 2. What are the additional (hidden) costs, beyond price, of Iron Fist Frames Inc.'s bid? Why weren't these costs considered? 3. Considering only inventory financing costs, what is the additional cost per frame of Iron Fist Frames Inc.'s bid if the annual cost of money is 8% ? (Hint: Determine the average value of frame inventory held for the quarter and multiply by the quarterly interest charge, then divide by the number of frames.) b. a. a. [Key essay answer here] Obj. 1,3 provides cable TV and Internet service to the local community. The activities and activity costs of Three Rivers are identified as folle 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. c. Prepare a value-addedon-value-added analysis. d. Interpret the information in (b) and (c)