Instructions:

Use Excel formulas and links to cells in order to answer the following questions.

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. (We are concerned only with production variances at this point.) Place your calculations in the column titled Price/Spending Variances. a. Indicate whether the variance is unfavorable or favorable.

3. Calculate the labor rate variance. a. Indicate whether the variance is unfavorable or favorable.

4. Calculate the variable overhead rate variance. a. Indicate whether the variance is unfavorable or favorable.

5. Calculate the materials quantity variances for each of the components that go into a box of Nut muesli. Place your calculations in the column title Efficiency Variances. a. Indicate whether the variance is unfavorable or favorable.

6. Calculate the labor efficiency variance. a. Indicate whether the variance is unfavorable or favorable.

7. Calculate the variable overhead efficiency variance. a. Indicate whether the variance is unfavorable or favorable.

Planned Quantities: 158 400 boxes 1,100 cases Standard Costs Quantity per box Quantity per case Standard Cost per Case Total Quantities for the Month Total Cost for the Month ERR Mue Nat 144 Direct Materials bags for packaging Large) boxes for packaging large) nuts oats wheat Total Direct Materials Direct Labor Variable Overhead Total Standard Cost 0.12 0.28 1.82 per kg 0.92 per kg 0.99 per kg 1 each 1 each 0.40 kg 0.30 KG 0.30 kg 144 57.60 43.20 43.20 song 158 400 K 158,400 kg 63,360 kg 47,520 kg 47,520 kg 17.28 40.32 104.83 39.74 42.77 244.94 materials 4.00 Labor 3.00 VOH 251.94 per case 1ks 19,008.00 44,352.00 115,315.20 43,718.40 47.044.80 269,438.40 4,400.00 3,300.00 277,138.40 planned cost Nul SS 101 SS-11 20% what 90% 20. ww/ag re 12.00 per hour 9.00 per DLH 0.33 0.33 367 hours 367 DLH Actual Production Results: 151 200 boxes 1,050 cases Standard Quantity (1) Standard Cost (1) Actual Quantity Standard Cost Variances Price/Spend- Efficiency ing Variances U/F /F Variances 121.131.14) 151.161.171 Check Figure (Total Variance) Check Figure (Actual - Std.) Actual Cost U/E Direct Materials: bags for packaging (Large) boxes for packaging largel nuts oats wheat Total Direct Materials Direct Labor Variable Overhead Total Standard Cost 151,400 each 151 200 each 60.400 ke 45,440 kg 45,360 kg 16,654.00 42,336.00 112,000.00 41 804.80 44.906.40 257,701.20 4,284.00 3240.00 265,225.20 actual cost 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16,654.00 42,336.00 112,000.00 41 804.80 44.906 49 257,701.20 4,284.00 3240.00 265,225.20 0.00 360 hours 360 hours Planned Quantities: 158 400 boxes 1,100 cases Standard Costs Quantity per box Quantity per case Standard Cost per Case Total Quantities for the Month Total Cost for the Month ERR Mue Nat 144 Direct Materials bags for packaging Large) boxes for packaging large) nuts oats wheat Total Direct Materials Direct Labor Variable Overhead Total Standard Cost 0.12 0.28 1.82 per kg 0.92 per kg 0.99 per kg 1 each 1 each 0.40 kg 0.30 KG 0.30 kg 144 57.60 43.20 43.20 song 158 400 K 158,400 kg 63,360 kg 47,520 kg 47,520 kg 17.28 40.32 104.83 39.74 42.77 244.94 materials 4.00 Labor 3.00 VOH 251.94 per case 1ks 19,008.00 44,352.00 115,315.20 43,718.40 47.044.80 269,438.40 4,400.00 3,300.00 277,138.40 planned cost Nul SS 101 SS-11 20% what 90% 20. ww/ag re 12.00 per hour 9.00 per DLH 0.33 0.33 367 hours 367 DLH Actual Production Results: 151 200 boxes 1,050 cases Standard Quantity (1) Standard Cost (1) Actual Quantity Standard Cost Variances Price/Spend- Efficiency ing Variances U/F /F Variances 121.131.14) 151.161.171 Check Figure (Total Variance) Check Figure (Actual - Std.) Actual Cost U/E Direct Materials: bags for packaging (Large) boxes for packaging largel nuts oats wheat Total Direct Materials Direct Labor Variable Overhead Total Standard Cost 151,400 each 151 200 each 60.400 ke 45,440 kg 45,360 kg 16,654.00 42,336.00 112,000.00 41 804.80 44.906.40 257,701.20 4,284.00 3240.00 265,225.20 actual cost 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16,654.00 42,336.00 112,000.00 41 804.80 44.906 49 257,701.20 4,284.00 3240.00 265,225.20 0.00 360 hours 360 hours