Please compute using excel!

Cost-Volume-Profit Relationships Mc Graw Hill conne PROBLEM 5-19 Break-Even Analysis; Pricing LO5-1, LO5-4, LO5-5 Last year Minden Company introduced a new product and sold 15,000 units of it at a price of $70 per unit. The product's variable expenses are $40 per unit and its fixed expenses are $540,000 per year. Required: 1. What was this product's net operating income (loss) last year? 2. What is the product's break-even point in unit sales and dollar sales? 3. Assume the company has conducted a marketing study that estimates it can increase annual sales of this product by 5,000 units for each $2 reduction in its selling price. If the company will only consider price reductions in increments of $2 (e.g., $68, $66, etc.), what is the maxi- mum annual profit that it can earn on this product? What sales volume and selling price per unit generate the maximum profit? 4. What would be the break-even point in unit sales and in dollar sales using the selling price that you determined in requirement 3? Why is this break-even point different from the break-even point that you computed in requirement 2? PROBLEM 5-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales L05-1, LO5-3, L05-4, LO5-5, LO5-6, LO5-8 Northwor res basketballs. The company has a ball that sells for $25. direct labor workers