AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 19.03.2015, 17:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,644 / 848 (80) +++++++
Регистрация: 28.10.2006
DynamicsAxSCM: Classifying costs using the Costing sheet functionality
Источник: http://blogs.msdn.com/b/dynamicsaxsc...tionality.aspx
==============

This short blog post explains in detail how to use the costing sheet functionality to classify and aggregate costs.

Scenario

Let's start with a simple example: assume that our company produces jewelry. The company procures raw materials: gold, silver, platinum and precious stones, and converts them into beautiful necklaces, rings, and earrings.

Ken, the cost controller is given the task to assess how the trend of raising precious metal prices is going to affect the cost of a particular finished good. To do this, he navigates to details of BOM calculation (Inventory management / Costing versions / Item price / Complete).



Unfortunately, the detailed view doesn't provide any aggregation level. Ken is troubled: in order to figure out the exact cost of consumed precious metals, he has no other choice than copying the data to Excel and running calculation there… or has he?

Setting up the costing sheet to aggregate costs

This is where the costing sheet becomes handy. Ken can use the costing sheet setup form (Inventory management / Setup / Costing / Costing sheets) to define aggregation of his costs.

Let’s help Ken and create a new node of type Price. Nodes of type Price instruct the costing sheet in which context a given structure will be used. Ken wants to classify his manufacturing costs, so let’s change the type to “Cost of goods manufactured”.



Now we can add nodes underneath it. Let’s add a node of type Total and name it "Direct materials" and another two total nodes right beneath for "Precious metals" and "Precious stones". Also let’s create a “Direct labor” total node underneath the “Cost of goods manufactured”. The result should look like the following:



Now we can start adding cost groups to our structure. We can do that in two ways - either by creating a new node of type cost group underneath the Total node or by simply dragging the cost group from the “Cost groups” fast tab to the node where we want to place them. Let's drag and drop cost groups Gold, Silver, Platinum to the Precious metals node, “Diamond” and “Ruby” to the "Precious stones", "Labor" to the "Direct labor". As it is a best practice to have all cost groups mapped in the costing sheet let’s add the “Produced” cost group to “Cost of goods manufactured”. Now let’s simply validate and save our structure. The result should be following:



Revisiting results

Now, when we navigate back to the details of BOM calculation on the costing sheet tab, we can see the detailed classification of our costs. First of all, we can see that $1550 are coming from the direct materials consumption. Furthermore, out of those $1550, $400 come from precious metals usage, while the rest is coming from the usage of precious stones.



Ken can now easily understand the structure of costs. After a quick glance at the costing sheet, he knows that precious metals contribute to less than 25% of the total cost of the finished good. He can now make a meaningful assessment of consequences of rising precious metals prices.

Two words about the “Header” and “Total”

You may have wondered what the settings “Header” and “Total” on the costing sheet node do.



The “Header” checkbox controls whether the header row should be displayed on the “Costing sheet” tab. Respectively, the “Total” tab controls if the total row should be displayed for a given node. In the following example, the header and total settings have been modified for the “Precious stones” group.



What’s next?

In the upcoming posts, we will cover how to use costing sheet to define and calculate indirect costs. Stay tuned.






Источник: http://blogs.msdn.com/b/dynamicsaxsc...tionality.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
DynamicsAxSCM: Inventory batch merge functionality available in CU7 Blog bot DAX Blogs 4 21.01.2014 13:29
DynamicsAxSCM: New Item Tracing functionality in Microsoft Dynamics AX R2 CU6 Blog bot DAX Blogs 0 14.08.2013 04:12
Microsoft Dynamics AX 2009 White Paper: BOM Calculation Using Costing Sheet Vadik DAX: База знаний и проекты 0 15.06.2012 07:03
DynamicsAxSCM: Sales and purchase prices in relation to the item price setup in Microsoft Dynamics AX 2009 Blog bot DAX Blogs 0 11.02.2010 09:05
DynamicsAxSCM: WMS in Microsoft Dynamics AX 2009. Outbound Process Setup Blog bot DAX Blogs 0 27.04.2009 03:23

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 22:58.