This post shares Fusion SCM Analytics sample content as part of Oracle Fusion Data Intelligence (FDI), a family of prebuilt, cloud-native analytics applications for Oracle Fusion Cloud Applications. These sample artifacts are intended to demonstrate potential use cases, accelerate implementation efforts, and provide examples of how customers can extend and customize FDI content to meet their business needs. To explore additional reusable sample content, visit the FDI Content Library.
Content Description: AI-enabled Manufacturing Costs Overview workbook empowers Cost Accountants to explore and understand input, output, component, resource, scrap, WIP, and variance costs using natural-language questions.
Application: Fusion SCM Analytics
Fusion Module: Cost Management
Target Persona: Cost Accountant
Subject Areas: SCM – Work Order Costing, SCM - Manufacturing Costs Overview - LSA
Business Use Case/Questions:
Manufacturing Cost Flow
- Show the Fiscal Period trend in Input Cost, Output Cost, and WIP Balance for Cost Organization US Operations over the last six Fiscal Periods.
- Show Input Cost and Output Cost for Item AS4751200 in Fiscal Year 2018.
- Show WIP Balance by Fiscal Period for Manufacturing Organization Name Atlanta over the last six Fiscal Periods.
- Which Top 5 Items have the highest Input Cost for Cost Organization US Operations in Fiscal Year 2018?
- Show Output Cost by Work Center for Work Order WO-002-1000.
- Show Input Cost by Business Unit for Fiscal Quarter 2016Q2.
Scrap and Variance
- Show Scrap Cost - Expensed and Scrap Cost - Absorbed in Inventory by Fiscal Period for Manufacturing Organization Name Atlanta over the last six Fiscal Periods.
- Show Variance Cost by Cost Element for Item AS4751200 in Fiscal Year 2018.
- Which Top 5 Work Orders have the highest Variance Cost for Cost Organization US Operations in Fiscal Year 2018?
- Show Scrap Cost - Expensed by Work Center for Category Miscellaneous in Fiscal Year 2018.
- Show Scrap Cost - Absorbed in Inventory by Work Area for Cost Book Financial over the last four Fiscal Quarters.
- Which Bottom 5 Items have the lowest Variance Cost for Manufacturing Organization Name Atlanta in Fiscal Quarter 2016Q2?
Work Order Cost Analysis
- Show Total Work Orders Count by Type for Cost Organization US Operations in Fiscal Year 2018.
- Show WIP Balance and Variance Cost for Work Order WO-002-1000 during Fiscal Period 04-16.
- Which Top 10 Work Orders have the highest Output Cost for Cost Book Financial in Fiscal Year 2018?
- Show Total Work Orders Count by Work Area for Manufacturing Organization Name Atlanta in Fiscal Year 2018.
- Show Input Cost by Work Center for Type Standard over the last six Fiscal Periods.
- List Work Order, Item, Item Description, Item Primary UOM, Input Cost, Output Cost, and WIP Balance for Manufacturing Organization Name Atlanta in Fiscal Quarter 2016Q2.
Item and Organization Analysis
- Show Input Cost by Item and Item Description for Category Miscellaneous in Fiscal Year 2018.
- Which Top 5 Categories have the highest Output Cost for Cost Organization US Operations in Fiscal Year 2018?
- Show WIP Balance by Profit Center Business Unit for Cost Book Financial in Fiscal Quarter 2016Q2.
- Show Component Cost by Manufacturing Organization Name and Manufacturing Organization Code for Catalog Inv_Items in Fiscal Year 2018.
- Show Resource Cost by Business Unit for Functional Area Cost in Fiscal Year 2018.
- List Fiscal Calendar Name, Cost Organization, Cost Book, Primary Book Indicator, and Cost Currency for Fiscal Year 2018.
Pre-Requisites:
- FDI Release: 26.R2
- Offering: Supply Chain Management Analytics
- Functional Area Activation: Work Order Cost
Download: Available in the FDI Content Library.
We’d love to get your feedback and business use cases to help build a more sample FDI content.
