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 1.2 X ? . 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 - savames end of year 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 price of sardines rises in 1949 causing 10 new boats to start fishing for sardines in Monterey Bay starting in 1950. Use a formula to enter the sardine stock at the end of 1949 with 10 boats in cell C1 1 as your starting point for the 20 Boats column.(6) Now imagine that you were in charge of managing the sardine stock in Monterey Bay and could choose the number of boats that could fish for sardines starting in 1950. If you goal is to maintain the stock at the 1940-level forever, while at the same time allowing the maximum possible number of boats to fish, how many boats would you allow? Note that you can only allow whole boats for entire years, not fractions of boats or parts of fishing seasons. To figure this out, you must create an 11 Boats column in column E, a 12 Boats column in column F, and so on out to a 19 boats column in column M. You must have formulas and numbers in all cells from El1 (the stock at the end of 1949 with 10 boats fishing through M27. . All columns (E through M) must be named using the following format: o 1 1 Boats, 12 Boats,....,19 Boats (Autograder is case sensitive so Boats must be capitalized exactly as shown)B E F H K Year 10 Boats 20 Boats 11 Boats 12 Boats 13 Boats 14 Boats 15 Boats 16 Boats 17 Boats 18 Boats 19 Boats 1940 90000000 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