N2 A B C D E F G H K M N O 1 Year 10 Boats 20 Boats 11 Boats 12 Boats 13 Boats 14 Boats 15 Boats 16 Boats 17 Boats 18 Boats 19 Boats 2 1940 90000000 90000000 90000000 90000000 90000000 90000000 90000000 90000000 90000000 90000000 3 1941 96000000 94800000 93600000 92400000 91200000 90000000 88800000 87600000 86400000 85200000 4 1942 103200000 100560000 97920000 95280000 92640000 90000000 87360000 84720000 82080000 79440000 5 1943 111840000 107472000 103104000 98736000 94368000 90000000 85632000 81264000 76896000 72528000 6 1944 122208000 115766400 109324800 102883200 96441600 90000000 83558400 77116800 70675200 64233600 7 1945 134649600 125719680 116789760 107859840 98929920 90000000 81070080 72140160 63210240 54280320 8 1946 149579520 137663616 125747/12 113831808 101915904 90000000 78084096 66168192 54252288 42336384 9 1947 167495424 151996340 136497255 120998170 105499085 90000000 74500916 59001831 43502746 28003661 10 1948 188994509 169195608 149396706 129597804 109798902 90000000 70201100 50402198 30603296 10804394 11 1949 214793411 202793411 189834730 164876048 139917365 114958683 90000000 65041320 40082638 15123956 9834728 12 1950 245752094 231352094 214601676 183451258 152300838 121150420 90000000 58849584 27699166 -3451253 34601674 13 1951 282902513 265622513 244322012 205741510 167161006 128580504 90000000 51419501 12839000 -25741504 64322009 + 14 1952 327483016 306747016 279986415 232489812 184993208 137496605 90000000 42503402 4993200 52489805 99986411 15 1953 380979620 356096420 322783698 264587775 206391850 148195926 90000000 31804083 -26391840 84587766 142783694 16 1954 445175544 415315704 374140438 303105330 232070220 161035112 90000000 18964900 52070208 123105320 194140433 17 1955 522210653 486378845 435768526 349326396 262884264 176442135 90000000 3557880 82884250 169326384 255768520 18 1956 614652784 571654614 509722232 404791676 299861117 194930562 90000000 -14930544 -119861100 224791661 329722224 19 1957 725583341 673985537 598466679 471350012 344233341 217116675 90000000 -37116653 164233320 291349994 418466669 20 1958 858700010 796782645 704960015 551220015 397480010 243740010 90000000 63739984 -217479984 371219993 524960003 21 1959 1018440012 944139174 832752018 647064018 461376012 275688012 90000000 95687981 281375981 467063992 652752004 22 1960 1210128015 1120967009 986102422 762076822 538051215 314025615 90000000 -134025578 -358051178 -582076791 806102405 23 1961 1440153618 1333160411 1170122907 900092187 630061458 360030738 90000000 -180030694 450061414 -720092150 -990122886 24 1962 1716184342 1587792494 1390947489 1065710625 740473750 415236886 90000000 -235236833 -560473697 -885710580 -1210947464 25 1963 2047421211 1893350993 1655936987 1264452750 872968500 481484264 90000000 -301484200 692968437 1084452696 -1475936957 26 1964 2444905454 2260021192 1973924385 1502943300 1031962200 560981117 90000000 -380981040 -851962125 1322943236 -1793924349 27 1965 2921886545 2700025431 2355509262 1789131960 1222754640 656377341 90000000 -476377248 -1042754550 -1609131884 -2175509219 28 29 Sheet 116 1954 445175544 415315704 374140438 303105334 17 1955 522210653 486378845 435768526 349326396 262884264 176442135 90000000 3557880 -82884250 18 1956 614652784 571654614 509722232 404791676 299861117 194930562 90000000 -14930544 -119861100 19 1957 725583341 673985537 598466679 471350012 344233341 217116675 90000000 -37116653 -164233320 20 1958 858700010 796782645 704960015 551220015 397480010 243740010 90000000 -63739984 -217479984 21 1959 1018440012 944139174 832752018 647064018 461376012 275688012 90000000 -95687981 -281375981 22 1960 1210128015 1120967009 986102422 762076822 538051215 314025615 90000000 -134025578 -358051178 23 1961 1440153618 1333160411 1170122907 900092187 630061458 360030738 90000000 -180030694 -450061414 24 1962 1716184342 1587792494 1390947489 1065710625 740473750 415236886 90000000 -235236833 -560473697 25 1963 2047421211 1893350993 1655936987 1264452750 872968500 481484264 90000000 -301484200 -692968437 26 1964 2444905454 2260021192 1973924385 1502943300 1031962200 560981117 90000000 -380981040 -851962125 27 1965 2921886545 2700025431 2355509262 1789131960 1222754640 656377341 90000000 -476377248 -1042754550 28 29 30 31 Element 4 9999 32 Element 5 9999 33 Element 7 15 34 35 36 37 38 39 40 41 42 Sheet 1Your data includes just one data point, reported in cell B2. This is the sardine stock in Monterey Bay at the end of 1940. Below is a short description of the variables you will be using for Project 5: Column A Year Column B Sardine stock at the end of the year With 10 boats shing in the bay Column C Sardine stock at the end of the year with 20 boats shing in the bay 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 3.2 x 2 . 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