Use formulas and links to cells in the worksheet provided in order to calculate the following variances and answer the questions asked. 1. Given the actual level of activity (number of cases of Nut muesli produced), what are the standard costs? In other words, what would be the costs shown in Muesli AGs flexible budget for Nut muesli? 2. Calculate the material price variances for all the components that go into a box of Nut muesli. Place your calculations in the column titled Price/Spending Variances.
Please help me with the above numbers in the attached format with formulae. I 
A 4 5 Direct Materials: 6 bags for packaging (large) 7 boxes for packaging (large) 8 nuts 9 oats 10 wheat 11 Total Direct Materials 12 Direct Labor 13 Variable Overhead Total Standard Cost 14 15 16 Actual Production Results: 17 18 Direct Materials: 19 bags for packaging (large) 20 boxes for packaging (large) 21 nuts 22 oats 23 wheat 24 Total Direct Materials 25 Direct Labor 26 Variable Overhead 27 Total Standard Cost B Stand ard Costs C 10.12 10.28 11.82 per kg 10.92 per kg. 10.99 per kg 112.00 per hour 19.00 per DLH D Quanti ty per box E 1leach Teach 0.40 Kg 0.30 Kg 0.30 Kg 151,200 boxes F Quantity per case 144 144 57.60 43.20 43.20 0.33 0.33 Standard Quantity [1] G Standard Cost per case 117.28 140.32 1104.83 139.74 142.77 1244.94 materials H 14.00 labor 13.00 VOHI 1251.94 per case 1,050 cases Standard Cost [1] 10.00 I Total Quantitie s for the Month J 158,400 Kg 158,400 Kg 63,360 Kg 47,520 Kg 47,520 Kg 367 hours 367 DLH Actual Quantity 151,400 each 151,200 each 60,400 Kg 45,440 Kg 45,360 Kg 360 hours 360 hours K Total Cost for the Month L 119,008.00 144,352,00 1115,315.20 143,718.40 147.044.80 1269,438.40 14,400.00 13.300.00 1277,138.40 planned cost. Actual Cost 116,654.00 142,336,00 1112,000.00 141,804.80 144.906.40 1257,701.20 14,284.00 13.240.00 1265,225.20 actual cost M N ERP Muesli Nut Nut $$-FOT $$-F11 20% wheat 30% 20% nut 1box/1 bag "minimum 500g 1kg 0 P Q R Standard Cost Variances Check Figure Price/Spend- Efficiency ing Variances UIF Variances U/F (Total Variance) [2], [3], [4] [5], [6],[7] 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 S Check Figure (Actual - Std.) 116,654.00 142,336.00 1112,000.00 141,804.80 144.906.40 1257,701.20 14,284.00 13.240.00 1265,225.20 A 4 5 Direct Materials: 6 bags for packaging (large) 7 boxes for packaging (large) 8 nuts 9 oats 10 wheat 11 Total Direct Materials 12 Direct Labor 13 Variable Overhead Total Standard Cost 14 15 16 Actual Production Results: 17 18 Direct Materials: 19 bags for packaging (large) 20 boxes for packaging (large) 21 nuts 22 oats 23 wheat 24 Total Direct Materials 25 Direct Labor 26 Variable Overhead 27 Total Standard Cost B Stand ard Costs C 10.12 10.28 11.82 per kg 10.92 per kg. 10.99 per kg 112.00 per hour 19.00 per DLH D Quanti ty per box E 1leach Teach 0.40 Kg 0.30 Kg 0.30 Kg 151,200 boxes F Quantity per case 144 144 57.60 43.20 43.20 0.33 0.33 Standard Quantity [1] G Standard Cost per case 117.28 140.32 1104.83 139.74 142.77 1244.94 materials H 14.00 labor 13.00 VOHI 1251.94 per case 1,050 cases Standard Cost [1] 10.00 I Total Quantitie s for the Month J 158,400 Kg 158,400 Kg 63,360 Kg 47,520 Kg 47,520 Kg 367 hours 367 DLH Actual Quantity 151,400 each 151,200 each 60,400 Kg 45,440 Kg 45,360 Kg 360 hours 360 hours K Total Cost for the Month L 119,008.00 144,352,00 1115,315.20 143,718.40 147.044.80 1269,438.40 14,400.00 13.300.00 1277,138.40 planned cost. Actual Cost 116,654.00 142,336,00 1112,000.00 141,804.80 144.906.40 1257,701.20 14,284.00 13.240.00 1265,225.20 actual cost M N ERP Muesli Nut Nut $$-FOT $$-F11 20% wheat 30% 20% nut 1box/1 bag "minimum 500g 1kg 0 P Q R Standard Cost Variances Check Figure Price/Spend- Efficiency ing Variances UIF Variances U/F (Total Variance) [2], [3], [4] [5], [6],[7] 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 S Check Figure (Actual - Std.) 116,654.00 142,336.00 1112,000.00 141,804.80 144.906.40 1257,701.20 14,284.00 13.240.00 1265,225.20
