Fishery Harvest Lab

EN100_Lab4_Offshorefishharvest_Spreadsheet.xlsx

Home >Environmental science homework help >Fishery Harvest Lab

Worksheet

			Boat Size	Fish Capacity	Purchase Price	Operating cost per season
Carrying Capacity	131072		Small	3500	$12,500.00	$6,000.00
			Large	7500	$25,500.00	$15,500.00
Value per Fish	$5.00
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
SEASON 1
	St. Pop	131072	1.000	end pop	127572
Account Balance	$7,000.00		Harvest	Qty	Number of Fish
Operating Costs	$6,000.00		Small Ships	1	3500
Balance To Sea	$1,000.00		Large Ships	0	0
Balance after catch	$18,500.00			Value of Catch	$17,500.00
Balance after purchase	$18,500.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 2
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$18,500.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$12,500.00			Value of Catch	$17,500.00
Balance After Catch	$30,000.00
Balance after purchase	$30,000.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 3
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$30,000.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$24,000.00			Value of Catch	$17,500.00
Balance After Catch	$41,500.00
Balance after purchase	$41,500.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 4
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$41,500.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$35,500.00			Value of Catch	$17,500.00
Balance After Catch	$53,000.00
Balance after purchase	$53,000.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 5
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$53,000.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$47,000.00			Value of Catch	$17,500.00
Balance After Catch	$64,500.00
Balance after purchase	$64,500.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 6
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$64,500.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$58,500.00			Value of Catch	$17,500.00
Balance After Catch	$76,000.00
Balance after purchase	$76,000.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 7
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$76,000.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$70,000.00			Value of Catch	$17,500.00
Balance After Catch	$87,500.00
Balance after purchase	$87,500.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 8
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$87,500.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$81,500.00			Value of Catch	$17,500.00
Balance After Catch	$99,000.00
Balance after purchase	$99,000.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 9
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$99,000.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$93,000.00			Value of Catch	$17,500.00
Balance After Catch	$110,500.00
Balance after purchase	$110,500.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 10
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$110,500.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$104,500.00			Value of Catch	$17,500.00
Balance After Catch	$122,000.00
Balance after purchase	$122,000.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 11
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$122,000.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$116,000.00			Value of Catch	$17,500.00
Balance After Catch	$133,500.00
Balance after purchase	$133,500.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 12
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$133,500.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$127,500.00			Value of Catch	$17,500.00
Balance After Catch	$145,000.00
Balance after purchase	$145,000.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 13
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$145,000.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$139,000.00			Value of Catch	$17,500.00
Balance After Catch	$156,500.00
Balance after purchase	$156,500.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 14
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$156,500.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$150,500.00			Value of Catch	$17,500.00
Balance After Catch	$168,000.00
Balance after purchase	$168,000.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 15
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$168,000.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$162,000.00			Value of Catch	$17,500.00
Balance After Catch	$179,500.00
Balance after purchase	$179,500.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00
SEASON 16
	St. Pop	131072	1.000	end pop	127572
Fleet	Qty	Op. Cost
Small Ships	1	$6,000.00
Large Ships	0	$0.00
Total		$6,000.00
			Harvest	Qty	Number of Fish
Account Balance	$179,500.00		Small Ships	1	3500
Operating Cost	$6,000.00		Large Ships	0	0
Balance to Sea	$173,500.00			Value of Catch	$17,500.00
Balance After Catch	$191,000.00
Balance after purchase	$191,000.00
			Purchase	Qty	Cost
			Small Ships		$0.00
			Large Ships		$0.00
					$0.00

Accounting

Season	Fleet Value	Number of Fish Caught	Harvest Value	Profit	Population Size (beg)	Population Size (end)
1	$12,500.00	3,500	$17,500.00	$18,500.00	131072.00	127572.00
2	$12,500.00	3,500	$17,500.00	$30,000.00	131072.00	127572.00
3	$12,500.00	3,500	$17,500.00	$41,500.00	131072.00	127572.00
4	$12,500.00	3,500	$17,500.00	$53,000.00	131072.00	127572.00
5	$12,500.00	3,500	$17,500.00	$64,500.00	131072.00	127572.00
6	$12,500.00	3,500	$17,500.00	$76,000.00	131072.00	127572.00
7	$12,500.00	3,500	$17,500.00	$87,500.00	131072.00	127572.00
8	$12,500.00	3,500	$17,500.00	$99,000.00	131072.00	127572.00
9	$12,500.00	3,500	$17,500.00	$110,500.00	131072.00	127572.00
10	$12,500.00	3,500	$17,500.00	$122,000.00	131072.00	127572.00
11	$12,500.00	3,500	$17,500.00	$133,500.00	131072.00	127572.00
12	$12,500.00	3,500	$17,500.00	$145,000.00	131072.00	127572.00
13	$12,500.00	3,500	$17,500.00	$156,500.00	131072.00	127572.00
14	$12,500.00	3,500	$17,500.00	$168,000.00	131072.00	127572.00
15	$12,500.00	3,500	$17,500.00	$179,500.00	131072.00	127572.00
16	$12,500.00	3,500	$17,500.00	$191,000.00	131072.00	127572.00

Harvest Progress

Fish Harvest Progress

Fleet Value 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 Harvest Value 17500 17500 17500 17500 17500 17500 17500 17500 17500 17500 17500 17500 17500 17500 17500 17500 Profit 18500 30000 41500 53000 64500 76000 87500 99000 110500 122000 133500 145000 156500 168000 179500 191000

Season

Value (US dollars)

Fish Harvest

Fish Catch Per Season

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500

Season

Numer of Fish Caught

Fish Population Size

Fish Population at Beginning and End of Each Season

Pop. Size beginning of season 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 131072 131072 131072 131072 131072 131072 131072 131072 131072 131072 131072 131072 131072 131072 131072 131072 Pop. Size end of season 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 127572 127572 127572 127572 127572 127572 127572 127572 127572 127572 127572 127572 127572 127572 127572 127572

Season

Number of Fish in Populaiton