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 fish per year the sardine stock growth rate from one year to the next is 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 is there are boats that catch sardines each then the number of sardines at the end of year will be: which we will report rounded to we will also assume that it is impossible for the stock of sardines to rise above the size year stock or below no negative amount of sardines going back to our simple example, this means our equation model is a bit more complicated:MAXMIN 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 in this simplified case but not in the Project 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 causing new boats to start fishing for sardines in Monterey Bay starting in Using the sardine stock with boats at the end of the as your starting point, find the sardine stock at the end of each year from with boats fishing.
tableYear Boats, boats
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
