ERP Scope of Oracle FICO Module

Controling (CO) Module - Reporting
Reports	Compliance	Remarks
Report will be generated  periodically and Periodic Report will contain material consumption (qty and value), cost of good manufactured, purchase price variances, utilization variances, material write-off and write-in, changes in WIP and small differences if any		Variances are necessary for control purpose. Utilization variances should cover- 4 variances method or at least 3 variances method. Besides Materials Price Variance, we will need Usage Variance, Mix Variance and Yeild Variance, Labor Rate, Efficiency, Mix and Yeild Variances
Material wise consumption comparison between actual and standard – Qty and value (periodic consumption report, batch wise consumption - for a single batch or multiple batch)
Material valuation report, WIP report, Process loss report (Batch wise)		Need automatic accumulation and allocation of Normal and Abnormal Process Loss in the Cost of Production Report
Product wise Bottom Line Price (BLP) calculation
Product /Product group wise CM analysis and profitability analysis		We will need Sales Value, Sales Price, Sales Mix, Sales Quantity, Sales Margin Price, Margin Volume(Qty+Yeild) Variances
Country/Sales team wise CM analysis/profitability analysis for export/local sales		Product-wise/Segment-wise/Regional Profitability Analysis
Product wise sales comparison (Qty and Value)
Budget/Actual of expenditure - GL account wise, cost center wise, cost element wise (current period, same period of last year)		YTD Std. & YTD Actual with last year comparison required
Actual/Actual of expenditure - GL account wise, cost center wise, cost element wise (with last months, same month of last year showing percentage of sales of each GL items)
Reports are required for a single cost element or a group of cost elements incurred at a single responsibility center or a group of responsibility center
Reports should provide Actual cost, Budget cost, variance, total up-to the period and balance budget, and if any		A report on Cost of Quality (Preventive/Appraisal/External Failure and Internal Failure Costs) and Value added and Non-value Added Cost of Plant's manufaturing with a comparable avenue. Again, a report on actual potency with diclared potency on materials
Periodical Material purchase report (component wise actual purchase cost, component wise cost comparison between Actual & Planned, Active and Excipients separately)
Periodic ending inventories report (inventory valuation report: top 10 inventory values, top 10 price changes last period, actual prices, actual prices for material in all currencies, cost components of actual prices, valuation prices and inventory values in current year		Ending inventory in Toll manufaturing premises  should be incorporated. In addition, an ending inventory report on Engineering Spare parts and Gift Items in each period to be required.
Inventory age analysis report (raw material, packing material and intermediaries) will  contain PR,PO,GRN, Retest date, Expiry date, Quantity and value
Age analysis report of FG items will contain details on the Batch number, Mfg date, Expiry date, Quantity and Value; and finished goods)		Should include short dated and expired items in depots as well
Report on slow moving/non moving items	Additional	Should include short dated and expired items