PLEASE USE EXCEL AND SHOW ALL THE FORMULAS USED- EXPLAIN WITH DETAIL INFORMATION. THANK YOU

1. Break-even analysis To be profitable, a firm has recover its costs. These costs include both its fixed and its variable costs. One way that a firm evaluates at what stage it would recover the invested costs is to calculate how many units or how much in dollar sales is necessary for the firm to earn a profit. Consider the case of Dynamic Defenses Corporation: Dynamic Defenses Corporation is considering a project that will have fixed costs of $12,000,000. The product will be sold for $32.50 per unit, and will incur a variable cost of $10.75 per unit. Given Dynamic Defenses's cost structure, it will have to sell 551,724 units to break even on this project(QBE) Dynamic Defenses Corporation's marketing sales director doesn't think that the market for the firm's goods is big enough to sell enough units to make the company's target operating profit of $15,000,000. In fact, she believes that the firm will be able to sell only about 175,000 units. However, she also thinks the demand for Dynamic Defenses Corporation's product is relatively inelastic, so the firm can increase the sale price. Assuming that the firm can sell 175,000 units, what price must it set to meet the CFO's EBIT goal of $15,000,000? O $165.04 O $206.30 O $173.29 O $189.80 What affects the firm's operating break-even point? Several factors affect a firm's operating break-even point. Based on the scenarios described in the following table, indicate whether these factors would increase, decrease, or leave unchanged a firm's break-even quantity-assuming that only the listed factor changes and all other relevant factors remain constant