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 Free Spirit Industries Inc.: Free Spirit Industries Inc. is considering a project that will have fixed costs of $10,000,000. The product will be sold for $41.50 per unit, and will incur a variable cost of $12.80 per unit. Given Free Spirit's cost structure, it will have to sell units to break even on this project (QBE) 337,913 308,430 348,432 Free Spirit's marketing and sales director doesn't th even. In fact, she believes that the firm will be able to selr omy about 150,000 units. However, she also thinks that the demand for Free Spirit's product is relatively inelastic (so the firm can increase the sales price without significantly decreasing the volume of product sold). Assuming that the firm can sell 150,000 units, what price must it set to break even? irm's market is big enough for the firm to break $95.36 per unit $87.42 per unit O $75.50 per unit O $79.47 per unit 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