Requisitions

The data model encompasses requisition details, including order quantity, open quantity, min/max receipt quantities, markup percentage, estimated costs at headcount and total levels, and the completion date. Views like Requisitions, Approved_Requisitions, Pending_Requisitions, Rejected_Requisitions, and Expedited_Requisitions offer insights into the status and progression of purchase requests, catering to different department needs and highlighting urgent requisitions.

Benefits of This Data Model

• Enhanced Purchase Request Insights: The data model provides detailed requisition information including order quantity, open quantity, min/max receipt quantities, and estimated costs at various levels, allowing for a comprehensive view of purchase requests.
• Streamlined Approval Tracking: Through views like Approved_Requisitions, Pending_Requisitions, and Rejected_Requisitions, the model enables efficient tracking and management of purchase request statuses, facilitating better decision-making and workflow optimization.
• Quick Identification of Urgent Requests: The Expedited_Requisitions view highlights urgent purchase requests needing immediate attention, ensuring timely processing and minimizing delays in critical purchases.
• Holistic Financial Analysis: With dimensions such as Account Code, Account Name, and Subaccount Code, the data model supports in-depth financial analysis and cost breakdowns related to requisitions, aiding in better budgeting and resource allocation decisions.

Key Performance Indicators (KPIs)

• Markup: The percentage markup applied to the total cost of a requisition item.
• Min Receipt: The minimum quantity of items to be received for a requisition.
• Max Receipt: The maximum quantity of items that can be received for a requisition.
• Complete on: The date when the requisition is expected to be completed.
• Order Quantity: The total quantity of items ordered in a requisition.
• Open Quantity: The remaining quantity of items yet to be received or completed.
• Estimated HC Ext. Cost: Estimated total cost of the requisition at the headcount level.
• Estimated TC Ext. Cost: Estimated total cost of the requisition at the total cost level.

Available Visualizations

View Name	Description
Requisitions	Provides a list of all purchase requests made by different departments.
Approved_Requisitions	Displays purchase requests that have been approved and are ready for processing.
Pending_Requisitions	Shows purchase requests awaiting approval or processing by the relevant authorities.
Rejected_Requisitions	Lists purchase requests that have been rejected due to various reasons.
Expedited_Requisitions	Highlights urgent purchase requests that require immediate attention and processing.