Question
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
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) o 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 or below 0 o 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)
You will, of course, need to translate all of this into cell notation to accommodate changes as you move down columns, or across rows (1) We begin assuming that there are 10 boats fishing in Monterey Bay. Use the model described above the calculate the number of sardines in the bay at the end of each year, assuming that you start with the number of sardines existing at the end of 1940 given to you in your data set. Make this calculation for all years from 1941-1965. These formulas and values must be in cells B3-B27. (2) Now imagine that the
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started