Question: 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

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. 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%.

3. What is the number of fishing boats when the profits is zero and we halve the intrinsic growth rate r due to pollution of the oceans?

4. 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?

Incorrect ouestion 2 Question 3 0 / 0.5 pts Biologists have estimate that the carrying capacity of blue whales is 1,000,000 and the natural growth rate is 2% per year. WHat is a sustainable annual harvest level of blue whales? 980,000 look at the maximum sustainable yield section of the chapter F5 - @ fx C =+$B$2*$B$3*5*$B$4* (1-$B$3*5/$B$5) D E F G H A B I J K L M N P e 30000000 10,000 0.004 100,000 0.08 ######## Effort 20000000 10000000 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 Revenue Costs 0 0 0 13800000 1000000 2 7200000 2000000 3 10200000 3000000 4 12800000 4000000 5 15000000 5000000 6 16800000 6000000 7 18200000 7000000 8 19200000 8000000 9 19800000 9000000 10 20000000 10000000 11 19800000 11000000 12 19200000 12000000 13 18200000 13000000 14 16800000 14000000 15 15000000 15000000 16 12800000 16000000 17 10200000 17000000 18 7200000 18000000 19 3800000 19000000 20 0 20000000 21 -4200000 21000000 22 -8800000 22000000 23 -1. 4E+07 23000000 24 -1.9E+07 24000000 25 -2. 5E+07 25000000 -10000000 Revenue Costs -20000000 -30000000 Incorrect ouestion 2 Question 3 0 / 0.5 pts Biologists have estimate that the carrying capacity of blue whales is 1,000,000 and the natural growth rate is 2% per year. WHat is a sustainable annual harvest level of blue whales? 980,000 look at the maximum sustainable yield section of the chapter F5 - @ fx C =+$B$2*$B$3*5*$B$4* (1-$B$3*5/$B$5) D E F G H A B I J K L M N P e 30000000 10,000 0.004 100,000 0.08 ######## Effort 20000000 10000000 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 Revenue Costs 0 0 0 13800000 1000000 2 7200000 2000000 3 10200000 3000000 4 12800000 4000000 5 15000000 5000000 6 16800000 6000000 7 18200000 7000000 8 19200000 8000000 9 19800000 9000000 10 20000000 10000000 11 19800000 11000000 12 19200000 12000000 13 18200000 13000000 14 16800000 14000000 15 15000000 15000000 16 12800000 16000000 17 10200000 17000000 18 7200000 18000000 19 3800000 19000000 20 0 20000000 21 -4200000 21000000 22 -8800000 22000000 23 -1. 4E+07 23000000 24 -1.9E+07 24000000 25 -2. 5E+07 25000000 -10000000 Revenue Costs -20000000 -30000000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

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. What is the number of fishing boats when the profits is zero and we...

D Question 1 0.5 pts Which of the following is correct about the open access situation of competitive fishers. O Price fluctuations have no influence on the strategy of the fishers. O New fishers...

Question 2 0.5 pts Provided is the Excel file Exampleprofit(3).xIsx for the Tuna example of Chapter 7 (Figure 7.4). Use this Excel model to define what is the number of fishing boats when the profits...

customers, suppliers, and communities in as serious takes place in the firm's business model thow to a way as they track its financial performance. make money). - The triple-bottom-line framework is...

Using the template provided please! Part 2: Create Data Tibl These two variables should be numbers that you enter into the spreadsheet. When it is complete you should be able to change either of the...

Week 6 Data Assignment: Creating a Spreadsheet Model to Calculate Profit Objective: In this exercise you will design a spreadsheet model to calculate profit for a small copier company. You will build...

Objective: In this exercise you will design a spreadsheet model to calculate profit for a small copier company. You will build on that model by using data tables to evaluate several options for the...

Use the data and calculations above to create a data table below that will be used to graph of costs, profits and volume. ost-Volume-Profit: Break-Even Analysis Using Excel Completing this activity...

Week 1 Data Assignment: Creating a Spreadsheet Model to Calculate Profit Objective : You will design a spreadsheet model to calculate profit for a small copier company. You will build on that model...

Supply Chain Management at Beautiful Bags It was June 2014. Vince Sheehy, senior director of merchandise management at Beautiful Bags (BB), was about to place a large order for the upcoming winter...

How effective are antilock brakes, which pump very rapidly rather than lock and thus avoid skids? As a test, a car buyer organized an experiment. He hit the brakes and, using a stopwatch, recorded...

For the production line in the previous problem, assume that a single AGV train consisting of a tractor and multiple trailers are used to make deliveries rather than separate vehicles. Time required...

Formula 0 . 5 points If you inherit $ 5 3 , 0 0 0 and want to double it in 7 years, using the Rule of 7 2 , at what annual rate of return will you need to invest the money? Round your answer to the...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Influences on Nonverbal Communication?

3. Examine the language you use in computer-mediated-communication. Are there subtle ways in which you and your communication partners negotiate influence and create connectedness? Are any language...

2. Describe the similarities and differences you find in the language you use and the language a close friend or family member of the opposite sex uses over the course of a single conversation. What...