Please answer using excel formulas

Chapter 6 Lab, PA 6-6, page 295 Answer Data needed to calculate Answer Given Data: Product A Product B Total Sales Variable costs Contribution Margin Product A $28,000 $11,400 $16,600 Product B $43,000 $19,800 $23,200 Sales Mix % Units Sold 780 1820 Sales Variable Cost Contribution Margin Units Fixed Cost Var. Cost ratio CM ratio 1 Unit CM 1 Target Profit $63,200 Fixed Costs $35,200 Breakeven Sales 2 Unit Sales Price BE Sales Unit 2 Target Profit Sales 5 4 6 Degree of Operating Leverage (Use Original data)