Question: I have a project and this is the set up:We will model the sardine stock at the end of each year in a simplified way.

I have a project and this is the set up:We will model the sardine stock at the end of each year in a simplified way. Key elements: each boat catches exactly 1,000,000 fish per year the sardine stock growth rate from one year to the next is 1.2 time the number of sardines left at the end of the fishing season (within each year the annual cycle is fishing followed by spawning). To provide some insight, consider the following simplified example: the sardine stock at the end of year 1 is 10 there are 2 boats that catch 2 sardines each then the number of sardines at the end of year 2 will be: (10-2*2)*1.2=6*1.2=7.2, which we will report rounded to 7 we will also assume that it is impossible for the stock of sardines to rise above the 1940 size (year 1 stock) or below 0(no negative amount of sardines) going back to our simple example, this means our equation (model) is a bit more complicated:MAX(MIN(((10-2*2)*1.2),10),0) The MIN function insures that we dont get a number below zero The MAX function insures that we dont get a value higher than the initial one (10 in this simplified case but not in the Project 6.xlsx) You will, of course, need to translate all of this into cell notation to accommodate changes as you move down columns, or across rows The image shows the dataThis is the question:Now imagine that the price of sardines rises in 1949 causing 10 new boats to start fishing for sardines in Monterey Bay starting in 1950.Using the sardine stock with 10 boats at the end of the 1949 as your starting point, find the sardine stock at the end of each year from 1950-1965 with 20 boats fishing.
\table[[Year,10 Boats,20 boats],[1940,80000000,],[1941,,],[1942,,],[1943,,],[1944,,],[1945,,],[1946,,],[1947,,],[1948,,],[1949,,],[1950,,],[1951,,],[1952,,],[1953,,],[1954,,],[1955,,],[1956,,],[1957,,],[1958,,],[1959,,],[1960,,],[1961,,],[1962,,],[1963,,],[1964,,],[1965,,]]
I have a project and this is the set up:We will

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 Programming Questions!