how di you do this

3 A B C D $ 150,000 Robert's Clinic Annual Fixed Operating Costs Variable Cost per Patient Price Billed per Visit # patients seen annually $ 48 $ 98 2,600 $ $ Total annual cost 3 Total annual revenues e Profit/loss o Break even point 1 12 274,800 254,800 20,000 3,000.00 69 MIRA: Enter formulas for Total cost and revenues in cells B14, c14. Copy the formulas. # patients seen Total Break even point recalculated when variable costs vary from $40 to 558 40 42 NEvans 44 point to the all with 46 Formula for BE 48 50 52 54 56 58 var cost Data Table 3 Break even point recalculated when price billed per visit and variable operating costs vary variable cost 43 45 46 47 48 94.00 0 $ 95.00 0 $ 96.00 $ 97.00 $ 98.00 $ 99.00 $ 100.00 $ 101.00 0 price charged per visit 51 OOO OOOOOOOO SOOOOOOOO OOOOOOO OOOOOOOO OOOOOOOOO OOOOOOOO OOOO OOOOOOOOO 3 A B C D $ 150,000 Robert's Clinic Annual Fixed Operating Costs Variable Cost per Patient Price Billed per Visit # patients seen annually $ 48 $ 98 2,600 $ $ Total annual cost 3 Total annual revenues e Profit/loss o Break even point 1 12 274,800 254,800 20,000 3,000.00 69 MIRA: Enter formulas for Total cost and revenues in cells B14, c14. Copy the formulas. # patients seen Total Break even point recalculated when variable costs vary from $40 to 558 40 42 NEvans 44 point to the all with 46 Formula for BE 48 50 52 54 56 58 var cost Data Table 3 Break even point recalculated when price billed per visit and variable operating costs vary variable cost 43 45 46 47 48 94.00 0 $ 95.00 0 $ 96.00 $ 97.00 $ 98.00 $ 99.00 $ 100.00 $ 101.00 0 price charged per visit 51 OOO OOOOOOOO SOOOOOOOO OOOOOOO OOOOOOOO OOOOOOOOO OOOOOOOO OOOO OOOOOOOOO