1. Use this Excel model to determine what is the number of fishing boats when the profits is zero and we halve the price for fish.
2. What is the number of fishing boats when the profits is zero and we double the costs factor c due to extra requirements for the boats.
3. Use this Excel model to define what is the number of fishing boats when the profits is zero and we increase the carrying capacity with 25%.

AutoSave OFF Exampleprofit(4) ~ Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 AA D Wrap Text v General Insert v Ex Delete Paste BI UV A Merge & Center v v % " Conditional Format Cell Sort & Find & Analyze Sensitivity = Formatting as Table Styles Format Filter Select Data G29 X V fx =+$B$6*E29 A B D F G H K L M N 0 P Q R U V W X Z AA 10,000 0.004 Revenue Costs 30000000 100,000 0.08 Effort 3800000 1000000 1,000,000 2 7200000 2000000 20000000 3 10200000 3000000 4 12800000 4000000 15000000 5000000 6 16800000 6000000 10000000 7 18200000 7000000 8 19200000 800000 9 19800000 900000 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 10 20000000 1000000 11 19800000 11000000 12 19200000 12000000 -1000000 0 13 18200000 1300000 Revenue 14 16800000 14000000 15 15000000 1500000 -2000000 0 Costs 16 12800000 16000000 17 10200000 17000000 18 7200000 1800000 -3000000 0 19 3800000 19000000 20 0 2000000 21 -4200000 21000000 22 -8800000 22000000 23 -1.4E+07 2300000 24 -1.9E+07 24000000 25 -2.5E+07 25000000 43 Sheet1 Sheet2 Sheet3 + Ready + 100%