please use excel and show formulas to solve problem Thanks!

1. Leatherlike Manufacturing Company makes an artificial leather-like product for the fashion accessory market. The material is made in sheets and has the appearance of a thin rug. Each sheet is 36 inches wide and 100 feet long and is wound into a roll. The quality manager has requested that 200 rolls be inspected. Twenty-six non-conformances were found. a. Calculate the nonconformances per unit (NPU) and the throughput yield (TY). b. If the production process consists of three steps, with step 1 having a TY of 92 percent; step 2; 86 percent, and step 3, 93 percent what is the rolled throughput yield (RTY), and the proportion nonconforming? a. NPU = Number of nonconformances foundumber of units inspected = TY = e-NPU = Thus, % will be free from nonconformances. b. The RTY for the three steps in the process would be: RTY=