Please help and show steps

Part 1 -- identify relevant costs Place a " Y " next to any of the following costs that are relevant to the decision. Place an " N " next to any of the following costs not relevant to the decision. Should Mountain Goat buy the shifter? Write an =IF statement to make the decision in cell F54. = IF statement to answer question Part 4 - opportunity cost If the space now being used to produce the shifter would otherwise be idle, then Mountain Goat should continue to make its own shifters and the supplier's offer should be rejected. But, what if the space now being used to make shifters could be used for some other purpose? Assume the space now being used to make shifters could be used to produce a new cross-country bike that would generate a segment margin of $1,000,000 annually