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 AG’s 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.

 

Transcribed Image Text:

Planned Quantities: Direct Materials: bags for packaging (large) boxes for packaging (large) nuts oats wheat Total Direct Materials Direct Labor Variable Overhead Total Standard Cost Actual Production Results: Direct Materials bags for packaging (large) boxes for packaging (large) nuts oats wheat Total Direct Materials Direct Labor Variable Overhead Total Standard Cost Standard Costs € 0.12 € 0.28 € 1.82 per kg. €0.92 per Kg €0.99 per kg €12.00 per hour € 9.00 per DLH 158,400 boxes Quantity per box 1 each 1 each 0.40 Kg 0.30 Kg 0.30 Kg 151,200 boxes Quantity per case 144 144 57.60 43.20 43.20 0.33 0.33 Standard Quantity [1] 1,100 cases Standard Cost per case € 17.28 € 40.32 € 104.83 € 39.74 € 42.77 € 244.94 materials € 4.00 labor £300 VOH € 251.94 per case 1,050 cases Standard Cost [1] € 0.00 Total Quantities for the Month 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 Total Cost for the Month € 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 Actual Cost € 16,654.00 € 42,336.00 € 112,000.00 €41,804.80 €44,906.40 € 257,701.20 € 4,284.00 € 3,240.00 € 265,225.20 actual cost JERR Moesli Nat Nut SS-FOT 55-11 200 all 50% t 20% nu 1how/bag 500g The Standard Cost Variances Price/Spend- ing Variances U/F 121. 131, 14] Efficiency Variances U/F 151, 161, 171 Check Figure (Total Variance) € 0.00 0.00 € € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 €0.00 Check Figure (Actual-Std.) € 16,654.00 € 42,336.00 € 112,000.00 €41,804.80 € 44,906.40 € 257,701.20 € 4,284.00 € 3,240.00 € 265,225.201 Planned Quantities: Direct Materials: bags for packaging (large) boxes for packaging (large) nuts oats wheat Total Direct Materials Direct Labor Variable Overhead Total Standard Cost Actual Production Results: Direct Materials bags for packaging (large) boxes for packaging (large) nuts oats wheat Total Direct Materials Direct Labor Variable Overhead Total Standard Cost Standard Costs € 0.12 € 0.28 € 1.82 per kg. €0.92 per Kg €0.99 per kg €12.00 per hour € 9.00 per DLH 158,400 boxes Quantity per box 1 each 1 each 0.40 Kg 0.30 Kg 0.30 Kg 151,200 boxes Quantity per case 144 144 57.60 43.20 43.20 0.33 0.33 Standard Quantity [1] 1,100 cases Standard Cost per case € 17.28 € 40.32 € 104.83 € 39.74 € 42.77 € 244.94 materials € 4.00 labor £300 VOH € 251.94 per case 1,050 cases Standard Cost [1] € 0.00 Total Quantities for the Month 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 Total Cost for the Month € 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 Actual Cost € 16,654.00 € 42,336.00 € 112,000.00 €41,804.80 €44,906.40 € 257,701.20 € 4,284.00 € 3,240.00 € 265,225.20 actual cost JERR Moesli Nat Nut SS-FOT 55-11 200 all 50% t 20% nu 1how/bag 500g The Standard Cost Variances Price/Spend- ing Variances U/F 121. 131, 14] Efficiency Variances U/F 151, 161, 171 Check Figure (Total Variance) € 0.00 0.00 € € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 €0.00 Check Figure (Actual-Std.) € 16,654.00 € 42,336.00 € 112,000.00 €41,804.80 € 44,906.40 € 257,701.20 € 4,284.00 € 3,240.00 € 265,225.201