Milk Milk – a product of prime necessity of strategic importance in the consumer basket. Milk consumption in Russia has traditionally been at a high level (for example, in 1990 it amounted to 385 kg / pers.). However, with early 90-ies, this figure has consistently declined. In 2008, the aggregate amount of milk production in Russia amounted to 32.5 million tons. This is 0,2% more than in the previous year. In the list of largest companies are leading the two dairy plants holdings – Wimm-Bill-Dann and Unimilk. The biggest player in Russia’s dairy market – Wimm-Bill-Dann. The company has 27 manufacturing facilities in 22 regions of Russia and CIS, sales offices in 26 cities in Russia and CIS countries.
“Flagship” company Wimm-Bill-Dann is “Lianozovsky Dairy Factory – the largest dairy company in Europe with a capacity of processing 1500 tons of milk per day. Second place in terms of production owned subsidiary of Tsaritsyn Dairy Factory. Taken together, Wimm-Bill-Dann owns at least 30% of the dairy market in Russia. Unimilk – a young and rapidly growing company founded in 2002 Nowadays, the holding together more than a dozen top companies, which today is a major player in the local markets. Especially should be made “Petmol, which is included in the the top three in terms of production of dairy products (not just milk) in Russia.
Rate this result in the context of the components you can use the report “Statement on parties in warehouses. ” This report generates data in the currency of the administrative account (set in Tools-> Settings-account> Configuring Accounting-> currencies). Sheet 1 to work correctly reporting period for which he formed should be selected so that all operations of receipt of the goods and additional costs fall into it. Customize this Report (Indicators group rows, grouping columns, selection), as shown in the header table to evaluate the distribution of each additional unit of consumption goods purchased and to obtain the total cost of the party in the context of the nomenclature. By moving this information into MS Excel, and dividing the last column (cost) on the penultimate (Number) that the unit cost of goods purchased, taking into account additional costs allocated for the purchase. Page 2 Determination of the minimum discount prices purchased goods and the formation of the selling price of the goods, taking into account the company adopted a trade margin. So, using the standard report template configuration and MS Excel, we determined the unit cost of purchased goods. Now our task is to compare these figures with the established system of accounting prices.
With the report “Analysis of prices” can bring the price registered in the system by a certain date. Page 3 Move Data in this report to MS Excel and using the VLOOKUP () can be quickly substituted accounting prices in the table with the calculated costs and to compare them. Page 4 Download MS Excel file with this example, you need the formulas and calculations, You can follow this link: Control sebestoimosti.rar Since purchasing the operation may be widespread, and exercises with MS Excel formulas can take considerable time, our experts have finalized a standard report “Statement by parties in warehouses,” under the task.