This picture has instructions for what do for this assignment.

Complete Exercise 10-36 and 10-37 in Excel, using Excel functionality - no points will be given for just typing in numbers that should be formulas. 10-37. Activity-Based Costing of Suppliers ( LO 10-3, 4) Refer to the data in Exercise 10-36. Required Assume all else remains the same. What percentage of metal from Chopin Yards that requires further processing would make Rex Metal Fabricators indifferent between buying from Chopin Yards and Joe Company? 10-38. Activity-Based Costing of Suppliers ( LO 10-3, 4) Rex Metal Fabricators (RMF) buys scrap metal and produces components for buildings and other structures. The purchase contracts specify an average quality level of 90 percent. That is, 90 percent of the metal must be ready for use without further processing. Metal that is not ready can be treated at extra cost by RMF, and this is more cost-effective than scrapping the metal and purchasing additional amounts. The cost of treating the metal requiring further processing is $80 per ton. RMF uses two suppliers: Chopin Yards and Joe Company. During the past year, the purchasing quality data were as follows: Required Assume that the average quality, measured by the percentage of metal purchases requiring further processing, and prices from the two companies will continue as in the past. What is the effective price for metal from the two companies when quality is considered