Home lat | Casha 31 Ace 14 Insert Page Layout A 3 BIU.L. :X . Forms Duits Review View -AK - - FEZ E General 5 % . . MIS . under e . t ... 23 Den 1 Name 3 ACC 214 - Lab #8 - Chapter 21 Assignment 5 From the following data use Excel to calculate the direct material price and quantity wariances, the direct laborate and usage 6 variances and the fined overhead spending and volume variances. Show each wariance about o u t for 7 For each variance une Excel's function click on into identify the variances Favorable For Unfavorable ) boxes require a formula requires formula todentify the variance as For U 11 Data for problem 12 Actual Volume for the year in units 13 Planned Volume for the year (static budget) in units Direct Labor: of hours per Rate per hour 15 Direct Materials: # of pounds per unit Price per pound Actual Fixed Costs: Planned Costs $11. 9 5.0 24 ACTUAL Cost Direct Materials Varance Dividing Duca Flexible Budget (Standard 27 Actual Quantity Used Actus Quantity Used 16.020 Standard Quantity 29 Actual Price per Lb Standard Price per lb. Standard Price per 150 Total Actual 14. Try favorable Direct Labor MacBook Air 2 CMBNM Command option command 10 A Wrap Tout General M62 x fx A B 31 Total Actual Cont C $29,733.00 D E Total F G $4.000.00 HIJ Total K $31,800.00 L M N 32 33 Price Variance $2.703.00 Quantly Variance (54,77000) favourable adverse Direct Labor Variance Diding Data Flexible Budget (Standard) 18,020 Actual Quantity Used 18,020 Standard Quantity 35 ACTUAL Cost 38 Actual Quantity Used 40 Actual Rate per Hour Total Actual Cost Standard Rate per Hour $1025 Standard Rate per Hour $17,119.00 Total Total Rate Variance Efficiency Variance Fixed Manufacturing Overhead ACTUAL Fixed Cost Flexible Budget (Budgeted Fored Cost based on planned volume) $11,500 Applied to Work in Process Applied based on actual volume $1225 $12.500 Volume Controllable Variance $900 adverce MacBook Air esc Home lat | Casha 31 Ace 14 Insert Page Layout A 3 BIU.L. :X . Forms Duits Review View -AK - - FEZ E General 5 % . . MIS . under e . t ... 23 Den 1 Name 3 ACC 214 - Lab #8 - Chapter 21 Assignment 5 From the following data use Excel to calculate the direct material price and quantity wariances, the direct laborate and usage 6 variances and the fined overhead spending and volume variances. Show each wariance about o u t for 7 For each variance une Excel's function click on into identify the variances Favorable For Unfavorable ) boxes require a formula requires formula todentify the variance as For U 11 Data for problem 12 Actual Volume for the year in units 13 Planned Volume for the year (static budget) in units Direct Labor: of hours per Rate per hour 15 Direct Materials: # of pounds per unit Price per pound Actual Fixed Costs: Planned Costs $11. 9 5.0 24 ACTUAL Cost Direct Materials Varance Dividing Duca Flexible Budget (Standard 27 Actual Quantity Used Actus Quantity Used 16.020 Standard Quantity 29 Actual Price per Lb Standard Price per lb. Standard Price per 150 Total Actual 14. Try favorable Direct Labor MacBook Air 2 CMBNM Command option command 10 A Wrap Tout General M62 x fx A B 31 Total Actual Cont C $29,733.00 D E Total F G $4.000.00 HIJ Total K $31,800.00 L M N 32 33 Price Variance $2.703.00 Quantly Variance (54,77000) favourable adverse Direct Labor Variance Diding Data Flexible Budget (Standard) 18,020 Actual Quantity Used 18,020 Standard Quantity 35 ACTUAL Cost 38 Actual Quantity Used 40 Actual Rate per Hour Total Actual Cost Standard Rate per Hour $1025 Standard Rate per Hour $17,119.00 Total Total Rate Variance Efficiency Variance Fixed Manufacturing Overhead ACTUAL Fixed Cost Flexible Budget (Budgeted Fored Cost based on planned volume) $11,500 Applied to Work in Process Applied based on actual volume $1225 $12.500 Volume Controllable Variance $900 adverce MacBook Air esc