Referring to the graphic, the TV Family represents an MPSConfig planning BOM. No supply is available.
What will be the quantity of the planned order created for the TV family?

• A. 1000
• B. 600
• C. 200
• D. 800

You want to identify the buyer responsible for the component part in a worksheet based on the BillofMaterial table. Additionally, you want to have the option of inviting that buyer to a collaboration, messaging that buyer, and sharing a scenario with them.
Which set of column expressions and configuration changes will enable this capability?

• A. Create a column with an expression of Responsibility($Role_Buyers, Component.Name). On the Column Formatting tab, Check the "Display as image" checkbox and select an appropriate image.
• B. Create a column with an expression of Responsibility($Role_Buyers, Component). On the Column Formatting tab, Check the "Display as user name" checkbox.
• C. Create a column with an expression of Responsibility($Role_Buyers, Component). On the Column Formatting tab, Check the "Display as image" checkbox and select an appropriate image.
• D. Create a column with an expression of Responsibility($Role_Buyers, Component.Name). On the Column Formatting tab, Check the "Display as user name" checkbox.

You are creating a metric worksheet to calculate the number of late orders for a specified time period. The metric worksheet will be based on the IndependentDemand table and it has two columns: DueDate and Count.
The expression for Count is 1. The worksheet's filter expression is: DaysLate > 0 and Order.Type = 'Actual'.
In this situation, what is the column sequence and grouping properties for the metric worksheet?

• A. Column sequence:
  DueDate
  Count
  Grouping Function:
  DueDate = Group By
  Count = Sum
• B. Column sequence:
  Count
  DueDate
  Grouping Function:
  Count = Group By
  DueDate = Min
• C. Column sequence:
  DueDate
  Count
  Grouping Function:
  DueDate = Group By
  Count = Group By
• D. Column sequence:
  DueDate
  Count
  Grouping Function:
  DueDate = Group By
  Count = Associate

You have a worksheet based on the IndependentDemand table that includes columns for key fields plus multi-scenario columns for Quantity and EffectiveDemand. You want to highlight the Quantity fields where the value in the comparison scenario is different from the corresponding value in the workbook's baseline scenario. You want your worksheet to be able to highlight differences in several scenarios.
How would you achieve this highlighting?

• A. Define the Quantity column to show Actual value, and define an additional hidden column, Quantity0, as !Quantity#0 using "Calculate using grouped results in the previous row or other results"; then define conditional formatting where the Quantity column is not equal to Quantity0.
• B. Define the Quantity column to show Difference, select the scenario comparison filtering option to show Only records with different comparison values, then define conditional formatting for the Quantity column when the respective value is not equal to 0.
• C. Define the Quantity column to show Actual value; add a hidden multi-scenario column, QuantityDelta, to show Difference; then define conditional formatting for the Quantity column when their QuantityDelta field is not 0.
• D. Add a hidden multi-scenario column, RecordID, as show Differences; then define conditional formatting for the Quantity column where RecordID is not equal to 0.