(Supply Chain) Financial Analysis Report (MRP and Supply Chain Planning Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

(Supply Chain) Financial Analysis Report

The (Supply Chain) Financial Analysis Report displays a costed picture of the DRP or MRP plan. Based on the DRP or MRP plan, this report includes the total material value (in thousands of dollars) of actual and planned purchases, the total labor and overhead value of actual and planned work in process, the total value of the master demand or master production schedule, and ending inventory balances.

You can use this report to help plan the corresponding monetary resources necessary to fulfill the DRP or MRP plan. You can choose how many weeks and months to display in the report. This report also shows the number of inventory turns for each period and the cumulative number of turns from the beginning of the report up to the current period. For the purposes of the report, inventory turnover is defined as the master schedule value divided by the average inventory value.

Note: This report includes any partially completed work in process values in inventory, where work in process value represents money to be spent. Purchasing commitments include: purchase orders, purchase requisitions, and planned orders for purchased items. Work in process commitments include: discrete jobs, repetitive schedules, and planned orders for manufactured items.

This report also shows projected inventory turnover for each period and cumulative, defined as the average inventory value divided by the master schedule value (which approximates cost of sales).

Attention: All calculations include asset items held in nettable expense subinventories. This increases the accuracy of cash forecasting.

Report Submission

In the Submit Requests window, enter Financial Analysis Report in the Name field. Supply Chain Planning users should enter Supply Chain Financial Analysis report in the Name field.

Report Parameters

Plan Name

Select a plan name.

Organization Selection SUPPLY CHAIN PLANNING

Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report costs pertaining to the current organization.

Periods

Choose one of the following time periods:

12 Report the MRP financial plan for 12 periods.

24 Report the MRP financial plan for 24 periods.

36 Report the MRP financial plan for 36 periods.

48 Report the MRP financial plan for 48 periods.

Weeks

Enter the number of weeks. The number of Weeks you choose, together with the number of Periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan.

For example, if you choose 24 as the time Period and 10 as the number of Weeks, 10 of these periods display as weeks, the remaining 14 as months.

Note: The number of weeks that displays in the QuickPick is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle Master Scheduling/MRP and Supply Chain Planning calculates the number of weeks to the end of each period and displays the valid QuickPick options as 1, 5, and 9 weeks.

Cost Type

Select a cost type to print a costed picture of the DRP or MRP plan for the items associated with this cost type.

12	Report the MRP financial plan for 12 periods.
24	Report the MRP financial plan for 24 periods.
36	Report the MRP financial plan for 36 periods.
48	Report the MRP financial plan for 48 periods.