Please include your clear solutions using Ms excel (excel format). Kindly read the instructions in the picture below. Thank you?

INSTRUCTIONS: KINDLY INCLUDE YOUR CLEAR SOLUTIONS IN EACH QUESTION USING MS EXCEL AND UPLOAD LINK IF ITS OKAY. BUT IF NOT, YOU CAN SEND YOUR EXCEL SCREENSHOT. THANK YOU 8. Refer to Alford, Brooks, and Fitch Companies. Within the relevant range, if sales go up by $1 for each firm, which firm will experience the greatest increase in profit? Alford, Brooks, and Fitch Companies Below are income statements that apply to three companies: Alford, Brooks, and Fitch: Alford Co. Brooks Co. Fitch Co. Sales $100 $100 $100 Variable costs (10) (20) (30) Contribution margin $ 90 $ 80 $ 70 Fixed costs (30) (20) (10) Profit before taxes $ 60 $ 60 $ 60 a. Alpha Company b. Beta Company c. Fitch Company d. can't be determined from the information given9. Refer to Ford Company. How many units would Ford Company need to sell to earn a profit before taxes of $15,000? Ford Company The following information relates to financial projections of Ford Company: Projected sales 75,000 units Projected variable costs $3.00 per unit Projected fixed costs $60,000 per year Projected unit sales price $8.00 0 a. 9,375 b. 12,000 c. 15,000 d. 37,500 10. Refer to Ford Company. If Ford Company achieves its projections, what will be its degree of operating leverage? a. 6.25 b. 1.19 c. 1.68 d. 3.0011. Refer to Mark Smith Company. What was the company's margin of safety? Mark Smith Company Below is an income statement for Mark Smith Company: Sales $400, 000 Variable costs (200 , 000) Contribution margin $200, 000 Fixed costs (125, 000) Profit before taxes $ 75, 000 a. $ 37,500 b. $ 75,000 c. $125,000 d. $150,000 12. Refer to Mark Smith Company. What is the company's degree of operating leverage (DOL)? a. 2.67 b. 3.2 c. 5.33 d. 10.67 13. How much will be contributed to profit before taxes by the 1,001st unit sold? The following information pertains to Mercury Company's cost-volume-profit relationships: Break-even point in units sold 1, 000 Variable costs per unit $500 Total fixed costs $150, 000 a. $650 b. $500 c. $150 d. $014. How much will be contributed to profit before taxes by the 1,501s unit sold? The following information pertains to Apollo Company's cost-volume-profit relationships: Break-even point in units sold 1, 500 Variable costs per unit $700 Total fixed costs $225, 000 a. $850 b. $700 c. $150 d. $0 15. Information concerning Clarkson Corporation's Product A follows: Assuming that Clarkson increased sales of Product A by 20 percent, what should the profit from Product A be? Information concerning Clarkson Corporation's Product A follows: Sales $300, 000 Variable costs 240,000 Fixed costs 40,000 a. $20,000 b. $24,000 c. $32,000 d. $80,000