need help setting up problem 7.31 using excel

* S7.28 Wolfgang Kersten Mfg. intends to increase capacity through the addition of new equipment. Two vendors have presented proposals. The fixed costs for proposal X are $150,000, and for proposal Y,$170,000. The variable cost for X is $120.00, and for Y,$100.00. The revenue generated by each unit is $200.00. a) What is the break-even point in units for proposal X ? b) What is the break-even point in units for proposal Y ? PX - S7.29 You are given the data in Problem S7.28: a) What is the break-even point in dollars for proposal X ? b) What is the break-even point in dollars for proposal Y ? P 57.30 Given the data in Problem S7.28, at what volume(units) of output would the two alternatives yield the same profit (loss)? Px - 57.31 Use the same data in Problem S7.28: a) If the expected volume is 28,500 units, which alternative should be chosen? b) If the expected volume is 15,000 units, which alternative should be chosen? Px