Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Economics Methods And Techniques

Authors: Chandra Kant Singh

1st Edition

9353147018, 9789353147013

More Books

Students also viewed these Economics questions