please post formulas used

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Summer 2022 Product #1: Sales price per unit Variable costs per unit product cost shipping & handling sales commission Total variable cost per unit Monthly volume Product #2: Sales price per unit Variable costs per unit product cost shipping & handling sales commission Total variable cost per unit Monthly volume Fixed costs per month: Work Contract Trade Show entry fees 26 Total fixed costs per month Target profit per month Expected change in volume (%) A 285888588 ASSUMPTIONS Ready Launch-it 10 1 2 1 4 200 Treat-time 30 D 17 8 3 18 100 1000 500 1500 8000 5% Getting Started - Read 1st Accessibility: Investigate O O 1st E Product #1 Unit CM CM % Breakeven point: -in units -in sales revenue Target profit volume: -in units in sales revenue Launch-it $ $ Product # 2 Treat-time Unit CM CM % Breakeven point: -in units -in sales revenue S Target profit volume: -in units in sales revenue $ Business & Directions F 6 60% 250 2,500.00 1583 15,833.33 12 40% 125 3,750.00 792 23,750.00 31 G IS O5056 M 889 Sa Cc W Mu Sal ML Sal 5 H Less: Fixed Costs Operating Income WACM % CM/Unit Sales mix (# sold of each) Contribution margin WACM/unit Multiproduct Breakeven point: -in units Sales revenue at breakeven Multiproduct Target profit point: -in units Sales revenue at target profit Margin of Safety (in $) Margin of Safety % Operating Leverage Factor SMETAN Expected % change in operating income (%) Calculation of Weighted average CM per unit Product #1 6 Product #1 Product #1 Product #2 Product #2 Product #2 12 K Total Total Total 1500 900 48% 18