Cara Menghitung MSY (Maximum Sustainable Yield) dengan Microsoft Excel

Summary

This video guides viewers on how to calculate Maximum Sustainable Yield (MSY) for fishery resources using Microsoft Excel. It explains the concept of MSY as the maximum amount of a resource that can be harvested without depleting its population. The video walks through creating a graph with fishing effort and catch data, using linear regression to predict sustainable catch, and finding the optimal fishing effort for sustainable yield. The video also demonstrates how to use Excel's Solver tool to accurately determine the MSY, offering practical steps for sustainable fishery management.

Takeaways

• 😀 The Maximum Sustainable Yield (MSY), or Potensi Lestari Sumberdaya Ikan in Indonesian, refers to the maximum amount of fish that can be harvested from a fishery while ensuring the population remains sustainable.
• 😀 MSY is essential in fisheries management as it helps determine the optimal amount of fish that can be captured without depleting the population.
• 😀 The MSY curve is an inverted hyperbola that shows the relationship between fishing effort (x-axis) and the amount of catch (y-axis), with a peak representing the optimal sustainable yield.
• 😀 The MSY curve can be divided into three main zones: underutilization, optimal utilization, and overfishing.
• 😀 Underutilization is characterized by low fishing effort and abundant fish stock, which means there are still more fish to be caught.
• 😀 The optimal utilization zone is where fishing effort is balanced with sustainable fish catch, and the fish population remains stable.
• 😀 Overfishing occurs when fishing effort increases beyond the sustainable limit, leading to a depletion of fish stocks.
• 😀 To calculate MSY, data such as fishing effort and catch quantity are used, typically visualized through graphs created in Excel.
• 😀 The Excel method involves creating a linear equation that relates the fishing effort (upaya) to the catch per unit of effort (CPU) and predicting future catch based on this relationship.
• 😀 The MSY graph helps identify the point at which the effort and the catch are balanced, thus ensuring sustainability, using methods like interpolation or optimization software for more precise calculations.
• 😀 In conclusion, MSY is critical for managing fish stocks and ensuring that fisheries remain sustainable in the long run, with tools like Excel aiding in precise calculation and visualization.

Q & A

What is Maximum Sustainable Yield (MSY) in the context of fisheries?

Maximum Sustainable Yield (MSY) refers to the maximum amount of a fishery resource that can be harvested without negatively affecting its long-term viability. It ensures the resource remains renewable and does not deplete the population, allowing for sustainable fishing over time.

What does the graph of Maximum Sustainable Yield (MSY) typically look like?

The MSY graph is typically hyperbolic, where the x-axis represents fishing effort (number of boats, days, etc.), and the y-axis represents the total catch. The curve shows three phases: under-utilization (plenty of fish but low fishing effort), optimal yield (maximum catch with sustainable effort), and overfishing (increased effort leading to decreasing fish stocks).

What does the term 'under-utilization' mean in the context of MSY?

'Under-utilization' refers to the situation where fishing effort is too low to fully exploit the available fish stocks, leading to abundant fish populations. This occurs when the number of fishing vessels or the time spent fishing is minimal.

What is the 'Zone of Optimal Yield' in the MSY graph?

The 'Zone of Optimal Yield' is the range on the MSY graph where fishing effort is balanced with fish population growth. In this zone, the catch is maximized without depleting the fish stock, ensuring sustainability and optimal harvesting.

What happens in the 'overfishing' phase of the MSY curve?

In the 'overfishing' phase, fishing efforts exceed the sustainable capacity of the fishery. As a result, the fish population declines, and the total catch decreases despite increased effort, leading to the depletion of fish stocks.

How do you calculate MSY using Microsoft Excel?

To calculate MSY in Excel, you first input data for fishing effort and catch. You then create a linear equation based on the relationship between fishing effort and catch. Next, you use Excel's graphing and formula tools to predict the catch at various levels of effort and find the optimal sustainable effort.

What does 'CPU' stand for in the MSY calculation process?

CPU stands for 'Catch Per Unit of Effort'. It represents the average catch for each unit of fishing effort and is used to assess the relationship between fishing effort and the fish catch in order to create the MSY model.

How can you determine the MSY point on the graph using Excel?

To determine the MSY point, you need to plot a graph comparing fishing effort and predicted catch. The MSY point is located at the highest point of the curve where the catch is maximized. This can be found by adjusting the fishing effort values and analyzing the corresponding catch predictions in Excel.

What does the term 'upaya' mean in the context of the script?

'Upaya' refers to the fishing effort, which is typically measured in terms of the number of boats or the amount of time spent fishing in a given area. It plays a crucial role in determining the sustainability of the fishery.

Why is it important to find the optimal fishing effort level?

Finding the optimal fishing effort is critical to ensuring that fish stocks are not depleted. It helps maintain a balance between economic gain from fishing and the long-term health of the fish population. This balance ensures that fisheries remain viable and sustainable for future generations.