SOLVED
How to use Alteryx in Cost Management
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
krish1952
5 - Atom
‎08-21-2021
07:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Accounting Softwares and ERP provide financial information but the cost information provided is insufficient to work out the Cost of a Product. Thanks to Alteryx, I could develop a workflow to generate costing report from Financial Information and other related information as required for costing. Has anyone attempted it or if anyone is interested I can share. I also need feedback to improve the workflow since I did it with basic understanding of Alteryx.
Solved! Go to Solution.
Labels:
1 REPLY 1
‎08-28-2021
05:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have tested out a workflow on Cost Management in Alteryx. I used the basic features and would like to improve further. It is working wonders and can be used in any Industry including the Healthcare.
- Input Data- Detailed Profit & Loss Account
- Input Data- Primary Allocation of Expenses
- Data Cleansing- to make the data compatible for allocation
- JoinÂ- Combine the two input files
- Formula- Apply formula to allocate the Profit & Loss Account to Cost Centers
- Out Data- Output Data of Expenses by Cost Centers
- Input Data - Convert the Output Data of Expenses by Cost Centers into Input Data
- Input Data - Secondary Allocation Rules to allocate expenses to Products/Services
- Join – Combine both the input files
- Formula- Apply formula to allocate the expenses by Cost Centers to Products/Services.
- Output Data- Generate Cost Statements by Product/Services.
