To ensure that neither worksheet is taking advantage of cached results, which could skew performance comparisons, you should close the workbook and any library workbooks it depends on. By reopening the workbook after this, you force RapidResponse to reload the data and recalculate the worksheets from scratch, ensuring that you are capturing performance results without the influence of previously cached data.

References Kinaxis RapidResponse performance tuning guidance suggests that to accurately test the performance impact of changes, all cached data should be cleared. This can be achieved by closing and reopening the workbooks, as indicated in the Kinaxis RapidResponse resources on performance management.

To provide a worksheet based on the CRPOperation table that reports the destination location and to view all valid work centers that feed a given stock location:

Statement B: Create a reference field on the CRPOperation table to the Location table. This approach establishes a direct relationship between operations and their respective locations, enabling efficient reporting and querying capabilities for the secondary requirement of viewing work centers related to a stock location.

Creating a reference field on the CRPOperation table to the Location table (B) is the most efficient way to report destination location while allowing visibility of all valid work centers that feed a given stock location.

References:

Kinaxis RapidResponse Author Level 3 training emphasizes the importance of efficient data modeling and reference creation for performance optimization 1 .

The Kinaxis RapidResponse documentation suggests that creating direct references between tables ensures better performance than creating additional lookup tables or worksheets 2 3 .

The AvailableRule control table is used to define how available dates for supply and demand are calculated in Kinaxis RapidResponse. This includes the rules for when supplies are considered available for meeting demand and vice versa, such as lead times, transit times, and other considerations that might affect when a part can realistically be expected to be available.

References The function of the AvailableRule control table and its impact on the calculation of available dates for supplies and demands is outlined in Kinaxis RapidResponse configuration settings for supply chain planning processes.

In the WhereConsumed table, the PegPart represents the item driving the need for the component. In this case, the independent demand for AAA requires components BBB and DDD to be produced. The DriverPart is the direct parent in the Bill of Material (BOM) for DDD, which is BBB. The NeedQuantity is calculated by multiplying the demand for AAA by the quantity per of BBB (100 units * 4) and then by the quantity per of DDD (400 units * 4), resulting in a NeedQuantity of 1600 for DDD.

References This answer follows the logic of BOM explosion and the principles of MRP (Material Requirements Planning) that can be found in the Kinaxis RapidResponse documentation, which outlines how to calculate the required quantities of each item in the BOM based on the independent demand.

The script is performing a data import operation into a worksheet that is configured to allow importing data for the purpose of inserting records, as shown in the worksheet properties exhibit. The JSON object in the console output would reflect the result of this import operation. The object details the number of records deleted, modified, and inserted. Since the worksheet is set up only to allow insertion, and the script is importing data for insertion, the "inserted" key would have a value of 1, and "deleted" and "modified" would have a value of 0, indicating a successful insert without any deletions or modifications.

References Kinaxis RapidResponse documentation for data importing and console operations would support this behavior, outlining how the importData method interacts with worksheet configurations.

Developing a cross scenario data change allows for controlled updates from child to parent scenarios, aligning with company policy on not adjusting lead times in shared scenarios.

To evaluate the impact of converting planned orders to scheduled receipts and then push changes to the parent scenario, while adhering to company policy that prohibits adjustments to lead times in shared scenarios:

Statement B: Develop a cross scenario data change. This will allow users to make their changes in their scenarios and then push these changes to the parent scenario. This method ensures that changes are captured and transferred correctly while adhering to the company’s policy regarding lead times.

References:

Scenario planning

Scenario planning capabilities in Kinaxis RapidResponse allow for testing changes in private scenarios before pushing them to shared ones 1 .

Change management

The Engineering Change Management application in RapidResponse supports evaluating the effect of changes and determining the optimal time for implementation, which can be adapted for evaluating the impact of converting planned orders 2 .

Kinaxis documentation suggests using scenarios to track changes and push them to parent scenarios without affecting system performance 3 .

Best practices in Kinaxis RapidResponse include maintaining the integrity of shared scenarios by not altering critical parameters like lead times 4 5 .

A. Enabling the Bucket data by date checkbox and setting the Bucket Size to Day and the Number of Buckets to 730 would directly create a view that organizes daily historical data into daily buckets spanning the last two years (since there are 365 days in a year, multiplied by 2).

C. Creating calendar interval, start date, and end date variables using the CalendarDate table allows for the configuration of a custom time range in the worksheet. These variables can be referenced to display historical data for the desired period.

B is not correct because adjusting the Anchor date by 1 year would only provide data for the last year, not two. D is not correct because it suggests a method of filtering data by date without bucketing, which does not align with the requirement to show historical data in daily buckets.

References:

Kinaxis RapidResponse documentation on bucketing data by date.

Kinaxis support resources on configuring worksheets with date variables and bucketing.

The OrderGenerationRule of 'AfterPTF' with a LeadTime of 2 days and a PlanningTimeFence (PTF) of 2 means that planned orders will be generated for demands occurring after the planning time fence period, considering the lead time for production. Table II shows negative balances past the planning time fence (06-01 and 06-02 are within the planning time fence), indicating planned orders are created after these dates to cover upcoming demands. Therefore, planned orders appear on 06-04 and 06-05, taking into account the 2-day lead time post the planning time fence.

References This follows Kinaxis RapidResponse rules for order generation where the PlanningTimeFence and LeadTime dictate when planned orders are created in response to demand, as detailed in the Kinaxis documentation on planning strategies.

This setup allows for flexible data visibility based on user permissions. By creating a profile variable that contains the allowed countries for each user, you can then apply a filter expression to the worksheet that evaluates this variable. If a user is permitted to see all countries (indicated by an asterisk '*'), the expression returns TRUE, otherwise, it checks if the demand's country is in the user's permitted list.

References:

Kinaxis RapidResponse documentation on configuring data visibility through profile variables and worksheet filters.

Kinaxis training materials on setting up user permissions and responsibility definitions.

The DaysSupplyRule set to ByPeriod with a PeriodSupplyInterval of a Week means that the planned orders will be generated to cover demands within each supply interval (week) separately. For the first week, the total demand is 25+15+30=70, but the order quantity is rounded up to the nearest multiple of the Days of Supply number, which is 2. Therefore, the order quantity is 80. For the second week, the demand is 40+20+15=75, which matches the Days of Supply number, hence no rounding is needed, and the order quantity is 75.

References This answer is based on the Kinaxis RapidResponse concepts for demand and supply planning where Days of Supply calculations determine the size and timing of planned orders, considering the rules set for supply intervals and calendars.