The Plated Elf Company produces meal kits. Each week, it ships thousands of meal kits. Each meal kit includes a variety of foods (direct materials). Company managers have the following investigation rules for direct materials price variances: (Click the icon to view the investigation rules for direct materials price variances.) The controller prepared a report using Excel to calculate the direct material price variances and price variance percentages. A sample from that Excel report appears below. Variances greater than 15% are a high priority for investigation. Variances between 5% and 15% should still be investigated. Variances less than 5% will not be investigated. \begin{tabular}{|l|l|r|r|rr|rr|lr|lr|r|r|r|r|} \hline 12 & Ginger & S-12113 & 4,062 & $ & 3.03 & $ & 2.47 & $ & 12,308 & $ & 10,033 & $ & 2,275 & 22.7% & High Priority \\ \hline 13 & Curry Powder & S-26325 & 31,250 & $ & 1.84 & $ & 2.00 & $ & 57,500 & $ & 62,500 & $ & 5,000 & 8.0% & Investigate \\ \hline 14 & Olive Oil & S-97150 & 3,906 & $ & 32.90 & $ & 35.00 & $ & 128,507 & $ & 136,710 & $ & 8,203 & 6.0% & Investigate \\ \hline 15 & Sea Salt & S-53967 & 31,250 & $ & 7.68 & $ & 8.00 & $ & 240,000 & $ & 250,000 & $ & 1,000 & 4.0% & No Action \\ \hline \end{tabular} What steps would be performed in Cell J2 to designate whether the variance percentage would be classified as High Priority, Investigate, or No Action? A. Select Cell J2. Click on the Formulas tab on the ribbon, then click the drop-down arrow below Logical and select IF. Fill in the Logic test and value boxes as follows: Logical test 12>.15 Value if true - High Priority Value if false - No Action Repeat for Investigate and No Action. B. Select Cell J2. Click on the Formulas tab on the ribbon, then click the drop-down arrow below Logical and select IFS. Fill in the Logic test and value boxes as follows: Logical test 112>=.15 Value if true 1 - Investigate Logical test 212>=.05 Value if true2 - No Action Logical test 312<.05 value if true3 high priority c. select cell j2. click on the formulas tab ribbon then drop-down arrow below logical and and. fill in logic test boxes as follows:>.15 Logical 212>=.05 Logical 312<.05 d. select cell j2. click on the formulas tab ribbon then drop-down arrow below logical and ifs. fill in logic test value boxes as follows:>.15 Value if true1 - High Priority Logical test 212>=.05 Value if true2 -Investigate Logical test 312<.05 value if true3 action the plated elf company produces meal kits. each week it ships thousands of kit includes a variety foods materials managers have following investigation rules for direct price variances: icon to view variances. controller prepared report using excel calculate material variances and variance percentages. sample from that appears below. greater than are high priority investigation. between should still be investigated. less will not ginger s-12113 curry powder s-26325 investigate olive oil s-97150 sea salt s-53967 no what steps would performed in cell j2 designate whether percentage classified as or a. select j2. click on formulas tab ribbon then drop-down arrow below logical if. fill logic test boxes follows:>.15 Value if true - High Priority Value if false - No Action Repeat for Investigate and No Action. B. Select Cell J2. Click on the Formulas tab on the ribbon, then click the drop-down arrow below Logical and select IFS. Fill in the Logic test and value boxes as follows: Logical test 112>=.15 Value if true 1 - Investigate Logical test 212>=.05 Value if true2 - No Action Logical test 312<.05 value if true3 high priority c. select cell j2. click on the formulas tab ribbon then drop-down arrow below logical and and. fill in logic test boxes as follows:>.15 Logical 212>=.05 Logical 312<.05 d. select cell j2. click on the formulas tab ribbon then drop-down arrow below logical and ifs. fill in logic test value boxes as follows:>.15 Value if true1 - High Priority Logical test 212>=.05 Value if true2 -Investigate Logical test 312<.05 value if true3 action>
