Multi-Factor Analysis Model for Improving Profit Management Using Excel in Shellfish Farming Projects

By using a farm’s data in Yantai City and the theory of Cost-Volume-Profit analysis and the financial management methods, this paper construct a multi-factor analysis model for improving profit management using Excel 2007 in Shellfish farming projects and describes the procedures to construct a multi-factor analysis model. The model can quickly calculate the profit, improve the level of profit management, find out the breakeven point and enhance the decision-making efficiency of businesses etc. It is also a thought of the application to offer suggestions for government decisions and economic decisions for corporations as a simple analysis tool. While effort has been exerted to construct a four-variable model, some equally important variables may not be discussed sufficiently due to limitation of the paper’s space and the authors’ knowledge. All variables can be listed in EXCEL 2007 and can be associated in a logical way to manage the profit of shellfish farming projects more efficiently and more practically.