Updating Planned Costs From the PQL—Exercises

IMPORTANT
It is extremely important that you set up and work within your own site to maintain your data integrity. If you work within any other site, you will compromise your own exercise data as well as the data of other students. Predictable exercise results require that your data be isolated in your own site.

Required Data

Working with RFQ in Project

Purpose: The purpose of this exercise is to familiarize you with the data that must be in place before you can do the exercises below.

  1. Create request for quotations (RFQ) from items in the project quotation list (PQL). You need two RFQs for the following exercise.
  2. Handle one of the RFQs by registering supplier quotations. Approve the quotation and create a supplier blanket for a purchase part or a purchase order for a no-part.
  3. For the remaining RFQ, register supplier quotations with different prices but do not approve the quotation.

General exercise for Working with Requests for Quotations in Project

Main Exercise

Purpose: The purpose of this exercise is to show you how retrieve a supplier price to the project quotation list. This supplier price is based either on the best available supplier price or it is updated automatically when the blanket or order quotation is approved. Based on the PQL supplier price, update the miscellaneous demand’s expected supplier price and its planned cost.

Windows:
Project/Quotation List
Project/Demand/Misc. Parts
Project/Demand/Misc. No Parts
Agreement Quotation
Order Quotation

Updating Miscellaneous Demand Planned Cost from the PQL

  1. Open the Project window and query for your project.
  2. Click the Quotation List tab.
  3. For the PQL items that have a connected RFQ number, note the connected purchase parts or no-parts.
  4. Click the Demand/Misc. Parts tab for purchased parts or for no-parts click the Demand/Misc. No Parts tab.
  5. Select the project demand row, right-click and select Cost Elements, to open the Planned Cost/Hours per Cost Element dialog.
    Note the values for planned costs per cost element.

Note: Do the following steps to retrieve the best available supplier price to the PQL.

  1. Click the Quotation List tab again.
  2. Find the PQL record where the Request for Quotation Approved check box is not selected. This indicates that the RFQ is not yet approved, and quotations are still being received from suppliers.
  3. Select this row, right-click and then click Get Best Supplier Price. Note the values in the Supplier Price and Total Price fields. (Note that this function will not be enabled if the order quotation has already been approved.)
  4. For a purchase part, open the Agreement Quotation window. Alternatively for a no-part, open the Order Quotation window. Query for your RFQ number.
  5. In the Request No list in the header, select the different suppliers and note each quotation.
  6. Verify that the lowest supplier price has been retrieved to the PQL, and that the total price in the PQL shows this supplier price multiplied with the quantity.
  7. Find the PQL record where the Request for Quotation Approved check box is selected. This indicates that the RFQ is approved.
  8. Note that the value in the Supplier Price and Total Price fields are automatically updated base on the approved supplier price.

Note: Update the miscellaneous demand’s expected supplier price. Update the planned cost of the miscellaneous demand based on the expected supplier price.

  1. Click the Demand/Misc. Parts tab or Demand/Misc. No Parts tab again.
  2. Select a PQL record, right-click and click Get Supplier Price.
  3. Note that the value from the Supplier Price field in the Quotation List tab for this purchase part or no-part is retrieved to this tab's Expected Supplier Price field.

Note: The values are not saved in the Expected Supplier Price field. It is assumed that you will update the miscellaneous demand's planned cost immediately if you accept the expected supplier price.

  1. Right-click and then click Update Planned Cost. 
  2. A message appears asking if you would like to update the planned cost from the PQL. Click Yes.
  3. Select the project demand row, right-click and select Cost Elements, to open the Planned Cost/Hours per Cost Element dialog.
    Verify that the values for planned costs have been updated based on the value in the Expected Supplier Price field.