can you solve requirement 3 and 4 correctly and Step-by-step.

thanks.

Preferred Snacks produces snack mixes for the gourmet and natural foods market. (Click the icon to view the budgeted quantities and budgeted prices of direct materials.) In the current period, Preferred Snacks made 180 batches of Tempting Trail Mix with the following actual quantity, cost, and mix of inputs: (Click the icon to view the actual quantity, cost, and mix of inputs.) Read the requirements Data table Its most popular product is Tempting Trail Mix, a mixture of peanuts, dried cranberries, and chocolate pieces. For each batch, the budgeted quantities and budgeted prices are as follows: Quantity per Batch Price per Cup Peanuts 60 cups 2 Dried cranberries 30 cups 3 Chocolate pieces 10 cups 4 Print Done $ $ $ - X Data table Small changes to the standard mix of direct material quantities do not significantly affect the overall end product. In addition, not all ingredients added to production end up in the finished product, as some are rejected during inspection. Actual Quantity Actual Cost Actual Mix Peanuts 12,505 cups S 23,760 61% Dried cranberries 5,330 cups 17,109 26% 2,255 cups 8,88 11% Chocolate pieces 20,500 cups 49,754 100% Total actual Print $ Done X S. es - Requirements 1. What is the budgeted cost of direct materials for the 180 batches? 2. Calculate the total direct materials efficiency variance. 3. Calculate the total direct materials mix and yield variances. 4. How do the variances calculated in requirement 3 relate to those calculated in requirement 2? What do the variances calculated in requirement 3 tell you about the 180 batches produced this period? Are the variances large enough to investigate? Print Done X Requirement 1. What is the budgeted cost of direct materials for the 180 batches? Begin by calculating the total budgeted number of cups and the budgeted cost of direct materials for one batch. Quantity for Total Cost for One Batch Price of Input One Batch Peanuts 60 cups $ 2 per cup $ 120 30 cups $ 3 per cup 90 Dried cranberries Chocolate pieces $ 4 per cup 40 10 cups 100 $ 250 Total cups Now select the formula and enter the amounts to calculate the budgeted cost of direct materials for 180 batches. Budgeted cost per batch = Budgeted cost of 180 batches Number of batches 180 $ 250 = $ 45,000 Requirement 2. Calculate the total direct materials efficiency variance. Select the formula and enter the amounts to calculate the total direct materials efficiency variance. Identify each variance as either factorable (F) or unfavorable (U). (Enter any quantity amounts as the number of cups. Act. = Actual, Budg. = Budgeted, Cran. = Cranberries, Effic. = Efficiency, Qty. = Quantity, Var. = Variance.) ( Act. qty of inputs used Budg. price of input Effic. var. Budg. qty of input of allowed) 10,800 Peanuts ( | x $ 2 = $ 3,410 U 12,505 5,330 Cran. ( 5,400 $ 3 = $ 210 F Chocolate ( 2,255 1,800 $ 1,820 U $ 4 = $ 5,020 Total U | Requirement 3. Calculate the total direct materials mix and yield variances. Begin by selecting the formula and entering the amounts to calculate the total direct materials mix variance. Identify each variance as either factorable (F) or unfavorable (U). (Enter any percentages in decimal format to two decimal places, O.XX. Abbreviations used: A$ of DM input = Actual price of direct materials input, ADM mix % = Actual direct materials input mix percentage, ATQ inputs used= Actual total quantity of all direct materials inputs used, B$ of DM input = Budgeted price of direct materials input, BDM mix % = Budgeted direct materials input mix percentage, BTQ inputs allowed = Budgeted total quantity of all direct materials inputs allowed for actual output, Mix var. = Direct materials mix variance for each input.) ) = Mix var. Peanuts ( Cran. ( Chocolate ( Total ) X XA$ of DM input X ADM mix % X (ATQ inputs used I B$ of DM input ti BDM mix % BTQ inputs allowed ect of 31 B ials n amo %=F al qu A$ of DM input ADM mix % ATQ inputs used B$ of DM input BDM mix % BTQ inputs allowed ) x X of inp A$ of DM input 10,80 ADM mix % 5,40 1,80 ATQ inputs used B$ of DM input yield v BDM mix % calcula rect m BTQ inputs allowed f all dir ])x ])x ])x ])x X X X X pric var Q actu A$ of DM input ADM mix % ATQ inputs used B$ of DM input BDM mix % BTQ inputs allowed = Mix