Sample Spreadsheets

Round: Unregulated

Team Spreadsheets

Team 1

Year T1 Lobsters Caught T1 Traps T1 Boats T1 Cash (at season opening) T1 Success T1 Profit (after maintenance costs)
1 7500 200 1 5,000 0.25 3400
2 30000 400 1 12400 0.5 25300
3 45000 600 1 41700 0.5 17200
4 37500 1000 2 41900 0.25 18125
5 90000 1200 2 64025 0.5 34400
6 135000 1800 3 85425 0.5 119100
7 165000 2200 4 187525 0.5 103150
8 225000 3000 5 281675 0.5 142250
9 0 0 0 0 0 0

Team 2

Year T2 Lobsters Caught T2 Traps T2 Boats T2 Cash (at season opening) T2 Success T2 Profit (after maintenance costs)
1 3000 200 1 5,000 0.1 -1100
2 15000 200 1 3900 0.5 10900
3 67500 600 1 22800 0.75 28450
4 52500 700 2 28250 0.5 30275
5 45000 1200 2 68525 0.25 11900
6 45000 1200 2 80425 0.25 34400
7 67500 1800 3 101825 0.25 34725
8 180000 2400 4 123550 0.5 113800
9 0 0 0 0 0 0

Team 3

Year T3 Lobsters Caught T3 Traps T3 Boats T3 Cash (at season opening) T3 Success T3 Profit (after maintenance costs)
1 7500 200 1 5,000 0.25 3400
2 11250 300 1 10400 0.25 6850
3 22500 600 1 23250 0.25 5950
4 22500 600 1 29200 0.25 11575
5 45000 600 1 40775 0.5 17200
6 22500 600 1 57975 0.25 17200
7 45000 1200 2 62175 0.25 23150
8 90000 1200 2 85325 0.5 56900
9 0 0 0 0 0 0

Team 4

Year T4 Lobsters Caught T4 Traps T4 Boats T4 Cash (at season opening) T4 Success T4 Profit (after maintenance costs)
1 3000 200 1 5,000 0.1 -1100
2 33750 300 1 5900 0.75 29350
3 45000 600 1 41250 0.5 17200
4 22500 600 1 58450 0.25 11575
5 12000 800 2 49025 0.1 -3400
6 60000 800 2 45625 0.5 50600
7 45000 1200 2 104225 0.25 23150
8 202500 1800 3 114375 0.75 135975
9 0 0 0 0 0 0

Class Spreadsheet

Year r = growth rate Environ-ment Market Lobsters Caught Lobster Population Start Lobster Population End
1 0.1 1 1 21000 1000000 979000
2 0.1 1 1 90000 1076900 986900
3 0.1 1 0.5 180000 1085590 905590
4 0.1 1 0.75 135000 996149 861149
5 0 0 0.5 192000 947264 755264
6 0 0 1 262500 755264 492764
7 0.1 1 0.75 322500 492764 170264
8 0.1 1 0.75 697500 187290 0
9 0 0 0 0 0 0

Round: Regulated

Team Spreadsheets

Team 1

Year T1 Lobsters Caught T1 Traps T1 Boats T1 Cash (at season opening) T1 Success T1 Profit (after maintenance)
1 22500 200 1 5,000 0.75 7150
2 28200 600 1 20150 0.75 22900
3 22432 1000 2 26050 0.5 6824
4 11828 1200 2 36874 0.25 -7643
5 4646 1200 2 29231 0.1 -9438
6 24350 1200 2 19792 0.5 1575
7 12630 1200 2 21367 0.25 -4285
8 36741 1200 2 17082 0.75 26141
9 12300 1200 2 43224 0.25 -1375

Team 2

Year T2 Lobsters Caught T2 Traps T2 Boats T2 Cash (at season opening) T2 Success T2 Profit (after maintenance)
1 15000 200 1 5,000 0.5 3400
2 9400 300 1 10400 0.5 5000
3 11216 500 1 19400 0.5 3412
4 17742 600 1 24812 0.75 -865
5 17423 600 1 23947 0.75 -944
6 12175 600 1 23003 0.5 788
7 12630 600 1 23791 0.5 1015
8 12247 600 1 24806 0.5 6947
9 12300 600 1 31753 0.5 3925

Team 3

Year T3 Lobsters Caught T3 Traps T3 Boats T3 Cash (at season opening) T3 Success T3 Profit (after maintenance)
1 15000 200 1 5,000 0.5 3400
2 3133 200 1 8400 0.25 -967
3 22500 300 1 9433 0.5 12475
4 6000 400 1 23908 0.1 -3200
5 22500 600 1 24708 0.25 325
6 22500 600 1 25033 0.25 5950
7 45000 600 1 30983 0.5 17200
8 60000 800 2 27183 0.5 50600
9 90000 1200 2 85783 0.5 56900

Team 4

Year T4 Lobsters Caught T4 Traps T4 Boats T4 Cash (at season opening) T4 Success T4 Profit (after maintenance)
1 7500 200 1 5000 0.25 -1450
2 6267 400 1 7550 0.25 867
3 4486 400 1 8417 0.25 -2035
4 7885 400 1 6381 0.5 -3429
5 11616 400 1 2953 0.75 -2496
6 12175 400 1 457 0.75 688
7 1684 400 1 1144 0.1 -4558
8 8165 400 1 -3414 0.5 2765
9 0 0 0 0 0 0

Class Spreadsheet

Year r = growth rate Environment Market Lobsters Caught Lobster Population Start Lobster Population End
1 0.1 1 0.5 60000 1000000 940000
2 0.1 1 1 47000 1034000 987000
3 0.1 1 0.75 60634 1085700 1025066
4 0.1 1 0.25 43454 1127573 1084118
5 0.1 1 0.25 56185 1192530 1136345
6 0.1 1 0.5 71200 1249979 1178779
7 0.1 1 0.5 71944 1296657 1224713
8 0.1 1 1 117153 1347185 1230031
9 0.2 2 0.75 114601 1353034 1238434

Go to the top

PROGRAM 3 LESSON PLANS | CLASSROOM | PROGRAM 3 | HOME