do it in excel please

The following is a list of components required to produce one unit of end item P: P: 2 A's, 3 B's, 3 C's A: 5 M's, 2 R's B: 1 D, 3 N's. C: 1T,4N 's M:1N Determine the number of N's that will be needed to make 60P 's in each of these cases: (A) There are currently 10 P's on hand. (B) On-hand inventory consists of 15 P's, 10A's, 100 N's. The product-structure tree: Figure Sense: What information do I know? How do you compute the number of N 's that will be needed to make 60P 's in the Excel template for both parts of the