what am i doing worng here?

Iternal ata 13 apply Refresh AI U Sort Filter Stocks Geograd Edit Links fx =$D$7/($D$4-F5) Advanced Text to Columns What Analy X B D E E 150,000 A Robert's Clinic Annual Fixed Operating Costs Variable Cost per Patient Price Billed per Visit # patients seen annually 48 $ $ 98 2,600 F G H Data Table 1 Recalculation of profit/loss Mervan: point to the cell 140,000 -1.96353 profit/loss 145,000 -1.89645 150,000 -1.8332 155,000 -1.77402 160,000 -1.77856 MIA00025561 165,000 -1.66644 Enter appropria 170,000 -1.6174 In cells 7 throug 175,000 -1.57117 fixed cost $ Total annual cost Total annual revenues Profit/loss Break even point 274,800 254,800 20,000 3,000.00 MIRA: Enter formulas for Total cost and revenues in cells B14, C14. Copy the formulas. + Tour revenue Data Table 2 Break even pol patients seen annually Total cost 2,600 2,620 2,640 2,660 3 2.680 9 2,700 40 42 44 46 40 OOOO Mervant point to the formula for + goal seks 7 goal seek2 goal seekt Break even point analysis What to complete Ready ass 1 Insert Draw Page Layout Formulas Data Review View Developer Tell me Char Connections Properties Refresh All Edit Links x fx Sede og Text to a . de Group Ungro Reply Advanced AL Sort Filter Columns What Analysis D E B C abert's Clinic mnual Fixed Operating Costs ariable Cost per Patient Price Billed per Visit patients seen annually $ $ $ 150,000 48 98 2,600 Total annual cost $ 274.800 Total annual revenues 5 254.800 Profit/loss 5 20,000 Break even point 3,000.00 MERA: Enter formulas for Total cost and revenues in cel 314, C14. Copy the formulas patients seen To . annually Total cost revenue 4 2,600 274 254.800 5 2.620 275,750 256,760 2.640 276,720 258,720 2.650 277.580 280.680 16 2,650 278,640 202.540 2,700 279.500 264.000 F G H Data Table 1 Recalculation of profit/loss with annual Mirvan point to the cell with form for 140,000 profos Sed c 145,000 patien 150,000 735.000 160,000 165.000 MEAD002556134RA: Enter appropriate formula 170,000 in through DIO 175,000 fed cost Data Table 2 Break even point recalculated when 17 40 42 46 C A 11 3 $ 4 % 5 6 7 8 Q E R T Y Connections $42 y car Get External Data th M MfG Ungroup HP Sub Anys Toile Data Analysis 2. Selver those So her Tecto Cone Maced What Anal D38 fx A B D E F H 1 K 17 18 19 20 21 22 23 24 25 20 27 25 20 30 31 32 33 34 35 36 37 38 30 40 2,660 2,680 2,700 2.720 2,740 2,780 2,780 2.800 2.820 2,840 2,560 2,850 2,900 2.920 2.940 2,950 2.980 3.000 3,020 3.040 3,000 3,080 3.100 277,680 278,640 279,800 280,560 281,520 282.480 283,440 284,400 285,360 288,320 287 280 288, 240 289,200 290.160 291,120 292.080 293.040 204,000 294.960 295920 295,880 297,840 298,800 260,680 282,640 284,600 266,500 268,520 270 480 272,440 274,400 276.360 278,320 280.280 282,240 284.200 286,160 288,120 290,00 292,040 294,000 295,960 297.920 299,850 301840 303.800 42 0 HE 44 0 point to the om for 46 0 48 50 52 a 54 0 56 0 58 0 var cost Data Table Break even point recalculated when price billed per visit and variat variable cost 40 44 45 46 47 40 94.00 0 0 0 0 0 95.00 0 0 0 0 0 0 28.00 0 0 0 O S 87.00 0 0 5 98.00 0 0 0 $ 99.00 0 O 0 0 0 $ O 0 0 0 100.00 0 0 0 0 0 0 0 101.00 price charged per visit 4 MIRA www ona A 29 ODE Ooid 44 0 point to the cell with 46 formula for BE 48 50 ol 52 0 54 0 56 0 58 0 var cost Data Table 3 Break even point recalculated when price billed per visit and variable operating costs vary variable cost 43 44 45 46 47 48 49 50 51 $ 94.00 0 0 $ 95.00 0 0 0 $ 96.00 $ 97.00 0 0 $ 98.00 0 $ 99.00 0 O $ 100.00 0 0 S 101.00 0 price charged per visit OOOOOOOO OOOOOOOOO OOOOOOOOO OOOOOOO OOOOOOOO o o o o o o o o 5 goals gosok Complete Break even point analysis w A 29 Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Con m Connections ci Analysis Tools 1. AY 26. Prete Cro Ungroup 99 Sub Gel Extra but Reh Seks Se 52 Avanced Tetto Columns What Analysis Data Analysis 2 Sale Das XX D E Q 1 2. 5 150,000 3 $ 48 4 5 08 5 2,800 6 7 5 274.800 8 5 254 800 $ 20.000 10 3,000.00 11 12 mulas for Total cost and Tis 314, C14. Copy the G H J K L M N 0 P Data Table 1 Recalculation of profit/loss with annual fixed operating costs ranging from 140,000 to 175,000 by $5,000 THE Do te the cell with form for 140.000 ked costs vary but variable costs and price billed per visit stay constant 145,000 patients - 2600 150,000 735,000 160,000 165,000 MLA0002666134RA Enter appropriate formes 170,000 Inces through to 175,000 fixed cost Data Table 2 Break even point recalculated when variable costs vary from 540 to 558 13 14 54.800 15 56,780 16 58,720 17 30.580 18 52.640 19 54,600 Wat 40 42 44 46 o 01 ol WER point RE goals + 29 Iternal ata 13 apply Refresh AI U Sort Filter Stocks Geograd Edit Links fx =$D$7/($D$4-F5) Advanced Text to Columns What Analy X B D E E 150,000 A Robert's Clinic Annual Fixed Operating Costs Variable Cost per Patient Price Billed per Visit # patients seen annually 48 $ $ 98 2,600 F G H Data Table 1 Recalculation of profit/loss Mervan: point to the cell 140,000 -1.96353 profit/loss 145,000 -1.89645 150,000 -1.8332 155,000 -1.77402 160,000 -1.77856 MIA00025561 165,000 -1.66644 Enter appropria 170,000 -1.6174 In cells 7 throug 175,000 -1.57117 fixed cost $ Total annual cost Total annual revenues Profit/loss Break even point 274,800 254,800 20,000 3,000.00 MIRA: Enter formulas for Total cost and revenues in cells B14, C14. Copy the formulas. + Tour revenue Data Table 2 Break even pol patients seen annually Total cost 2,600 2,620 2,640 2,660 3 2.680 9 2,700 40 42 44 46 40 OOOO Mervant point to the formula for + goal seks 7 goal seek2 goal seekt Break even point analysis What to complete Ready ass 1 Insert Draw Page Layout Formulas Data Review View Developer Tell me Char Connections Properties Refresh All Edit Links x fx Sede og Text to a . de Group Ungro Reply Advanced AL Sort Filter Columns What Analysis D E B C abert's Clinic mnual Fixed Operating Costs ariable Cost per Patient Price Billed per Visit patients seen annually $ $ $ 150,000 48 98 2,600 Total annual cost $ 274.800 Total annual revenues 5 254.800 Profit/loss 5 20,000 Break even point 3,000.00 MERA: Enter formulas for Total cost and revenues in cel 314, C14. Copy the formulas patients seen To . annually Total cost revenue 4 2,600 274 254.800 5 2.620 275,750 256,760 2.640 276,720 258,720 2.650 277.580 280.680 16 2,650 278,640 202.540 2,700 279.500 264.000 F G H Data Table 1 Recalculation of profit/loss with annual Mirvan point to the cell with form for 140,000 profos Sed c 145,000 patien 150,000 735.000 160,000 165.000 MEAD002556134RA: Enter appropriate formula 170,000 in through DIO 175,000 fed cost Data Table 2 Break even point recalculated when 17 40 42 46 C A 11 3 $ 4 % 5 6 7 8 Q E R T Y Connections $42 y car Get External Data th M MfG Ungroup HP Sub Anys Toile Data Analysis 2. Selver those So her Tecto Cone Maced What Anal D38 fx A B D E F H 1 K 17 18 19 20 21 22 23 24 25 20 27 25 20 30 31 32 33 34 35 36 37 38 30 40 2,660 2,680 2,700 2.720 2,740 2,780 2,780 2.800 2.820 2,840 2,560 2,850 2,900 2.920 2.940 2,950 2.980 3.000 3,020 3.040 3,000 3,080 3.100 277,680 278,640 279,800 280,560 281,520 282.480 283,440 284,400 285,360 288,320 287 280 288, 240 289,200 290.160 291,120 292.080 293.040 204,000 294.960 295920 295,880 297,840 298,800 260,680 282,640 284,600 266,500 268,520 270 480 272,440 274,400 276.360 278,320 280.280 282,240 284.200 286,160 288,120 290,00 292,040 294,000 295,960 297.920 299,850 301840 303.800 42 0 HE 44 0 point to the om for 46 0 48 50 52 a 54 0 56 0 58 0 var cost Data Table Break even point recalculated when price billed per visit and variat variable cost 40 44 45 46 47 40 94.00 0 0 0 0 0 95.00 0 0 0 0 0 0 28.00 0 0 0 O S 87.00 0 0 5 98.00 0 0 0 $ 99.00 0 O 0 0 0 $ O 0 0 0 100.00 0 0 0 0 0 0 0 101.00 price charged per visit 4 MIRA www ona A 29 ODE Ooid 44 0 point to the cell with 46 formula for BE 48 50 ol 52 0 54 0 56 0 58 0 var cost Data Table 3 Break even point recalculated when price billed per visit and variable operating costs vary variable cost 43 44 45 46 47 48 49 50 51 $ 94.00 0 0 $ 95.00 0 0 0 $ 96.00 $ 97.00 0 0 $ 98.00 0 $ 99.00 0 O $ 100.00 0 0 S 101.00 0 price charged per visit OOOOOOOO OOOOOOOOO OOOOOOOOO OOOOOOO OOOOOOOO o o o o o o o o 5 goals gosok Complete Break even point analysis w A 29 Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Con m Connections ci Analysis Tools 1. AY 26. Prete Cro Ungroup 99 Sub Gel Extra but Reh Seks Se 52 Avanced Tetto Columns What Analysis Data Analysis 2 Sale Das XX D E Q 1 2. 5 150,000 3 $ 48 4 5 08 5 2,800 6 7 5 274.800 8 5 254 800 $ 20.000 10 3,000.00 11 12 mulas for Total cost and Tis 314, C14. Copy the G H J K L M N 0 P Data Table 1 Recalculation of profit/loss with annual fixed operating costs ranging from 140,000 to 175,000 by $5,000 THE Do te the cell with form for 140.000 ked costs vary but variable costs and price billed per visit stay constant 145,000 patients - 2600 150,000 735,000 160,000 165,000 MLA0002666134RA Enter appropriate formes 170,000 Inces through to 175,000 fixed cost Data Table 2 Break even point recalculated when variable costs vary from 540 to 558 13 14 54.800 15 56,780 16 58,720 17 30.580 18 52.640 19 54,600 Wat 40 42 44 46 o 01 ol WER point RE goals + 29