Home › Discussions › Questions & Answers › Granular Item Cost Review for Make and Buy Items

Granular Item Cost Review for Make and Buy Items

Avatar photoCustomer Questions & Answers 7 replies

We need a detailed cost report showing costs for both buy and make items. Ideally, it should let us compare the detail cost structure between two different cost types (e.g., Frozen vs. Pending).

7 replies

  • Support Enginatics

    The CAC Item Cost & Routing report is what you need. It shows detailed item costs for buy and make items and allows comparison of any two cost types, providing a row-by-row comparison in detail.

  • Avatar photoCustomer

    How can I restrict the output just to items that are configured to be rolled up, and exclude items where costs are manually maintained?

  • Support Enginatics

    Use the ‘Based on Rollup’ optional parameter. Enter ‘Yes’ to get the rolled up items, or ‘No’ to retrieve non-rolled-up (manually maintained) items. You can also filter by ‘Make or Buy’ status.

  • Avatar photoCustomer

    If I am auditing specific cost components, such as ‘Lot’ costs or ‘Total Value’ basis types, can I filter for those?

  • Support Enginatics

    Yes, you can use the optional ‘Basis Type’ parameter to filter for specific basis types such as Item, Lot, Res Units, Res Value, or Ttl Value. Note that a bug fix was applied to this report to remove the ‘Cost Type 2’ parameter, relying instead on the Multiple Value functionality for the ‘Cost Type’ parameter for comparisons.

  • Avatar photoCustomer

    Which parameter is mandatory for defining the cost type being reported?

  • Support Enginatics

    The ‘Cost Type’ parameter is mandatory and accepts one or more cost types you wish to report.

  • You must be logged in to reply to this post.