Pig Farm Cost Accounting Spreadsheet, fairly comprehensive in content

Rising feed ingredient prices, sharply increasing labor costs, and long-term disease problems have made the pig farming industry a highly risky business. Using an easy-to-use spreadsheet tool to monitor production costs at any time is a management method every operator should master. This spreadsheet was written by Huang Wuguang, a senior veterinarian at the internship farm of Yongzhou Vocational Technical College, and others. It has been tested through several years of year-end accounting and should be fairly accurate. This table estimates costs in three layers, namely the master table --> sub-tables --> detailed tables. Please first understand its general outline. Since the production processes, compensation methods, production levels, etc. of various farms may all differ, the existing data in the table is for reference only. Please change it according to actual conditions. For ease of modification, all cells in the table that contain references or formulas use a yellow background, while other data remains in the state of black text on a white background. That is, under normal circumstances do not change yellow-background cells; simply change white-background cells according to actual conditions. The table is as follows: [attach]24825[/attach] Some explanations: ① This table sets the pig farm's products as three types: piglets, nursery pigs, and finishing pigs. If only piglets or finishing pigs are sold, there is no problem of allocating common costs to each product. If multiple products are sold as above, it may be necessary to estimate the allocation ratio of various expenses. ② In this table, two kinds of feed are used in the nursery stage, pelleted feed and mash feed. The mash feed is calculated according to the feed conversion ratio. Of course, the length of the nursery period must be considered. Please calculate the feed conversion ratio based on historical statistical data. The same applies if only one kind of feed is used. ③ The light bulb fee refers to the infrared lamps used for heating in the farrowing house or nursery. In this table, the breeding contract has already stipulated compensation based on the number of pigs sent to market. If compensation is not based on the number of pigs, it can also be placed under one of the common cost items. Some other expenses, if they cannot be precisely attributed to one pig, can also be placed under common costs, such as health care fees. In addition: by the way, we deliberated for a long time before writing out this table, and some calculations are also fairly complex. Although the layers are clear, some tables reference each other. If you want to modify the formulas, please first understand the whole sequence of connections. The table concentrates the experience and wisdom of several people, but after all it has considerable limitations and inappropriate points. Please be sure to reply to me with your experience using it or suggestions so that it can be improved.[ This post was last edited by hhh333 on 2008-2-16 20:10 ]
--------------------------------------
Don't know how it is yet, download and take a look
--------------------------------------
When I have time I'll optimize it for you with VBA and make the interface prettier.
--------------------------------------
After processing by the person above, it will certainly be even better
--------------------------------------
Downloaded it, wonder how the content is? Thanks to the original poster for providing it!
--------------------------------------
The summarized cost calculation is worth learning.
--------------------------------------
There is also a "light bulb fee" item in Table 1.2. I wonder what it refers to?
--------------------------------------
Light bulb fee, could it refer to infrared light bulbs
--------------------------------------
Downloaded it to take a look first, the original poster worked hard~~
--------------------------------------
Downloading to study and learn, thanks to the original poster for providing it
--------------------------------------
Downloaded it to study, giving a bit of support......
--------------------------------------
ding, replying to study and learn, accumulating knowledge, thanks to the original poster