a las 8. 1 ACC 216 Home Wet Drew Page Last Format Dan Review View IL . KL 1 Name 3 ACC 214 - Lab #8 Chapter 21 Assignment 5 From the following data use Excel to calculate the direct materials price and quantity variances, the direct laborate and usage 6 variances and the fixed overhead spending and volume variances Show each variance as an absolute valu Use for sale 7 For each verance E u nction click on ") in todently the variance as favorable For Unfavorable ) bones require a omul requires formula to identify the variance as Foru 11 Data for problem 12 Actual Volume for the year in units 13 Planned Volume for the year a 10.600 10.000 Standard budget in units of hours per unit Standard Actual 15 Direct Materials of pounds per unit Price per pound $1.65 Fixed Costs: Planned Costs Planned $11,500 Actual $12.500 24 ACTUAL Cost Direct Materials Variance Dividing Data Flexible Budget (Standard 27 Actual Quantity Used Actual Quantity Used Standard Quantity 21,200 29 Actual Price per LD Standard Price per lb. Standard Price per Lb. 51.50 31 Total Actual Cost 531 800.00 Direct Labor 35 ACTUAL Cost S * AU - HIJ K L M N Direct Materials Varance Dividing Data Flowe Budget Standard) 24 ACTUAL Cost Standard Quantity 21.200 Actual Quantity Used 27 Actual Quantity Used Standard Price per Standard Price per 29 Ach Price per Toul $31,800.00 31 Total Actual Cost Total Quanty Vane Pro Varan Direct Labor Varance Dividing Data Flexible Budget (standard) 35 ACTUAL Cost 38 Actual antity Used Actual Quantity Used Standard Ouently Standard Rane per Hour Standard Rate per Hour 40 Actual Rate per Hour Total Total 42 Total Actual Cost E ncy vanance Rate Varance Fred Manufacturing Overhead Applied to Work in Process Flexible Budget Budgeted Food Cost based on planned wome) ACTUAL Fixed Cost Volume Variance Controlable Vanance Home Dr Page Layout Forms Buss e 35 ACTUAL Cost Direct Labor Varance Oviding Data 38 Actual Quantity Used Actual Quantity Used 40 Actual Rate per Hour Standard Raper Hour Sundada per How 42 Total Actual Cost Rate Variance 47 ACTUAL Fed Cost Flexible Budget Budited Fixed Costed on planned volume) Apson Process Controllable Variance 2393398