Please answer using excel formulas. I don't know excel well so I need excel formulas for the credit.

PA6-6 Multiproduct CVP, Analyzing Break-Even Point, Target Profit, Degree of Operating Leverage O LO 6-5, 6-6 Pin Cushion Company produces two models of sewing basket. Information about Pin Cushion's products is given below: Page 295 Product A Product B Sales revenue $28,000 $43,000 Less: Variable costs 11,400 19,800 Contribution margin $16,600 $23,200 Total units sold 780 1,820 Pin Cushion's fixed costs total $35,200. Required: 1. Determine Pin Cushion's weighted-average unit contribution margin and weighted-average contribution margin ratio. 2. Calculate Pin Cushion's break-even units and break-even sales revenue. 3. Calculate the number of units of each product that must be sold to break even. 4. Calculate the total sales necessary for Pin Cushion to earn a profit of $63,200. 5. Calculate the sales revenue generated from each product line if Pin Cushion earns its target profit of $63,200. 6. Using the original information, calculate Pin Cushion's degree of operating leverage. C D F. G H - J K A B 1 Chapter 6 Lab, PA 6-6, page 295 2 E Answer Data needed to calculate Answer 3 4 5 6 Given Data: 7 Product A Product B Total Product A $28,000 $11,400 $16,600 Product B $43,000 $19,800 $23,200 Sales Mix % 780 1820 Sales Variable Cost Contribution Margin Units Fixed Cost Var. Cost ratio CM ratio Unit CM 1 1 $63,200 $35,200 Breakeven Sales 2 8 Sales 9 Variable costs 10 Contribution Margin 11 12 Units Sold 13 14 Target Profit 15 16 Fixed Costs 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Unit Sales Price BE Sales Unit 3 2 Target Profit Sales 5 4 A B C D E F G 31 6 Degree of Operating Leverage (Use Original data) 32 33 34 35 36 37 38 20