Requisitions

The data model includes information on purchase requisitions such as Requisitions, Requisition Items, Approved Requisitions, Pending Requisitions, and Requisition History. Measures encompass Item Expected and Actual Prices in local and target currencies, Expected and Actual Total Costs in local and target currencies, as well as Quantity. This model enables analysis of requisition costs, currency effects, and approval statuses across different views.

Benefits of This Data Model

• Streamlined Purchase Requisition Analysis: Facilitates detailed analysis of requisition costs, quantities, and approval statuses across various dimensions and views.
• Enhanced Currency Impact Assessment: Enables thorough examination of currency effects on expected and actual prices and total costs in both local and target currencies.
• Improved Requisition Tracking: Provides historical data tracking the evolution of requisitions over time, aiding in understanding trends and patterns.
• Efficient Supplier Performance Evaluation: Allows for assessing supplier performance based on requisition details such as item codes, descriptions, and statuses.
• Comprehensive Project Cost Monitoring: Supports monitoring project-related costs by analyzing requisition information linked to specific project codes and descriptions.

Key Performance Indicators (KPIs)

• Quantity: The number of items requested in a requisition.
• Item HC Expected Price: The expected unit price of an item in the requisition in the local currency.
• Item TC Expected Price: The expected unit price of an item in the requisition in a target currency.
• Item HC Actual Price: The actual unit price of an item in the requisition in the local currency.
• Item TC Actual Price: The actual unit price of an item in the requisition in a target currency.
• HC Expected Total: The total expected cost of the requisition in the local currency based on expected prices.
• TC Expected Total: The total expected cost of the requisition in the target currency based on expected prices.
• HC Actual Total: The total actual cost of the requisition in the local currency based on actual prices.
• TC Actual Total: The total actual cost of the requisition in the target currency based on actual prices.

Available Visualizations

View Name	Description
Requisitions	General information about all purchase requisitions in the system.
Requisition Items	Detailed list of items requested in each purchase requisition.
Approved Requisitions	List of requisitions that have been approved by designated personnel.
Pending Requisitions	Requisitions that are awaiting approval or processing.
Requisition History	Historical data showing the evolution of requisitions over time.