The Spend report enables you to visualize Quoted versus the Unquoted Spend from RFQ(s).
Use the Reports dropdown in the top navigation bar to access the Spend report page. In the Create A Report left side bar, select the RFQ(s) that you wish to view for its Spend. The filter field can help you narrow your selections. Then click on Show Report to generate the results.
You can review the data using the different display view tabs of by Category, Custom Region and Supplier. You can export the data as available.
Report Parameters
The fields of Ref Unit Cost and Ref Quota have to exist with data in the RFQ, as this report is using the "Ref Pricing" to calculate the Unquoted (where a Price hasn’t been given by the supplier yet). The Ref Unit Cost is not calculated by the system, rather it comes through "Ref Pricing", so it needs to exist in a "Contract Price" uploaded as Unit Cost.
- Quoted Spend = sum(Ref A2A Spend)= sum(REF. Unit Cost *REF QUOTA/100 *QTY), if lines have a Price1 (thus quoted by supplier).
- Unquoted Spend = sum(Ref A2A Spend)= sum(REF. Unit Cost * REF QUOTA/100 *QTY), for lines in RFQ without a Price1 (unquoted by supplier).
- Coverage % = (Quoted Spend/Unquoted Spend)*100.