The Pig Farm Cost Accounting Spreadsheet, which is considered complete by itself

The rising price of feed raw materials, the sharp rise in labor costs and the long-term troubles of diseases have made the pig industry a risky industry. Using easy-to-use spreadsheet tools to monitor production costs at any time is a management method that every operator should master. This spreadsheet is compiled by Huang Wuguang, senior veterinarian of Yongzhou Vocational and Technical College. After several years of year-end accounting, it should be more accurate. The estimation of the cost in this table is divided into three levels, namely, general table-- > sub-table-- > detailed table. Please find out its general outline first. As the production process, payment method and production level of each farm may be different, the existing data in the table are for reference only. Please change it according to the actual situation. In order to change conveniently, all the cells with references or formulas in the table use a yellow background, and other data still keep the black word on a white background, that is, in general, do not change the cells with a yellow background, as long as you change the cells with a white background according to the actual situation. The table is as follows: [attach] 24825 [/ attach] some explanations: ① this form sets three products for pig farms: piglets, nursery pigs, and fat pigs. If only piglets or fat pigs are sold, there is no problem of sharing public fees among products, and if there are multiple products for sale, it may be necessary to estimate various cost-sharing ratios. ② in the conservation phase of the use of two kinds of feed, pellet and powder, powder is calculated according to the material ratio, of course, to consider the length of the maintenance period, please calculate the feed ratio according to the statistical data over the years, if only one material is used. ③ bulb fee refers to the infrared lamp used in the delivery room or conservation for heating. The feeding contract in this form has stipulated that the number of pigs will be paid according to the number of pigs. If it is not covered by the number of pigs, it can also be included in the public fee. Other expenses, if not accurate to a pig, can also be put into public expenses, such as health care expenses. In addition: by the way, we have been brewing this form for a long time before we write it. Some calculations are quite complicated. Although the levels are clear, some forms are quoted from each other. If you want to modify the formula, please find out the context first. The table focuses on the experience and wisdom of several people, but after all, there are great limitations and inadequacies. Please be sure to reply your experience or suggestions to me for improvement. [this post was finally edited by hhh333 at 20:10 on 2008-2-16]-- I don't know yet, download it and have a look-- I'm free to optimize it with VBA to make the interface a little more beautiful. -- after processing upstairs, it will certainly be better-- downloaded, I don't know what the content is? Thank you for providing!-- the induced calculation cost is worth learning.-- there is also a "light bulb fee" in Table 1.2. I don't know what it means. -- Light bulb fee Can you point to the infrared light bulb-- come down and have a look first, the landlord has worked hard. Thank you for your offer-- study and support.-- ding, reply to study, accumulate knowledge, thank you.