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 = Associate
• B. Column sequence:
  DueDate
  Count
  Grouping Function:
  DueDate = Group By
  Count = Sum
• C. Column sequence:
  DueDate
  Count
  Grouping Function:
  DueDate = Group By
  Count = Group By
• D. Column sequence:
  Count
  DueDate
  Grouping Function:
  Count = Group By
  DueDate = Min

You need to create an expression that displays the number of the calendar week from the beginning of the year, for example, 01 January 2017 to 07 January 2017 = week 1. The calendar is based on a January to December fiscal year. The Calendar table has the values shown in the graphic.
Which expression would display the number of the calendar week?

• A. (today + 0 Week) + 1
• B. (today + 0 Week)
• C. (today - (today + 0 Year) Week) +1
• D. (today - (today + 0 Year) Week)

You are asked to transform PlannedOrder data into new ScheduledReceipt records, assuming just one PartSource per part and no maximum quantity. You need to filter the PlannedOrder records to ensure you do not try to create any ScheduledReceipt records which already exist. The workbook includes a worksheet, LKPScheduledReceipt, on existing converted ScheduledReceipts and follows Kinaxis best practices.
In this situation, which filter expression will follow KInaixs best practices and provide the best performance to include PlannedOrder records that do not match existing ScheduledReceipt records?

• A. NOT IsNull ( Lookup ({Part.Name, Part.Site.Value, DueDate}, LKPScheduledReceipt!, Null(Mfg::ScheduledReceipt), Exact, LKPScheduledReceipt!Self ))
• B. ( Lookup({Part.Name,Part.Site.Value, DueDate}, LKPScheduledReceipt!, "N", LKPScheduledReceipt!Exists) = "N" )
• C. NOT {Part, DueDate} IN LKPScheduledReceipt!
• D. NOT {Part.Name, Part.Site.Value, DueDate} IN LKPScheduledReceipt!

You have a crosstab, bucketed worksheet that shows forecast records. There are forecast records on the first workday of every month for 18 months from the Planning Date. The bucket settings are set for 52 Weeks from the Planning Date. You want to improve performance for this worksheet, but still display it as a crosstab worksheet. You also want to display one year's worth of forecast records.
How would you accomplish this task?

• A. Change the bucket settings to display 18 Months from the Planning Date and add an expression to filter out records that are beyond the one year horizon.
• B. Turn off grouping settings for this worksheet and add an expression to filter out records that are beyond the one year horizon.
• C. Turn off the bucket settings for this worksheet and add an expression to filter out records that are beyond the one year horizon.
• D. Change the bucket settings to display 365 Everyday from the Planning Date.

Referring to the Supply and Demands shown in the graphic, and taking priorities into consideration, which scheduled receipts (SR) will be allotted to Demand 2?

• A. SR3 (Qty 200) and SR2 (Qty 100)
• B. SR2 (Qty 200) and SR1 (Qty 100)
• C. SR2 (Qty 200) and SR3 (Qty 100)
• D. SR1 (Qty 200) and SR2 (Qty 100)