these are all clear photos. i split them up so its easier to read.

Open recovered workbooks? Your recent changes were saved. Do you want to continuo X1 M N P K 0 H C D ACC 214.Lab #8 Chapter 21 Assignment From the direct res and univerlates the direct laborate and www.defined vows Show eaches absolute Use te forte Pochi B's fonction des interview Far (F) or Unite (U) notre formulate the variance Foru As for the Punned for the budget 10,000 10.000 Standard 0.75 $10.25 Actu 0.85 5965 Direct thor: #of hours per Raper hour Fleed Costs Planned Cous oporto Proper 2 11.50 Actual 17 51.55 Planned 311.600 Actual $12.500 DIMM Variance Dividing ACTUAL Flexible Budget (Standard) Start Query AU AQ Used X Sandard Price To Stundard Price per Lb To ACTUAL COM Dihar Veiding UNI Flexible Budget (Standard) Standard Santander To To Pod Manufacturing the ACTUAL ) Bed Flat Coated on played volume App od to Work process Applied to stw volume vo Ch. 21 Worksheet ACTUAL Cost Actual Quantity Used X Actual Price perth Direct Materials Variance Dividing Data Actuarity Used Standard Price per the Tot Flexible Budget Standard) Sundwd Gurity Standard Price perth Tool Actu Cost Price Var DT VIN ACTUAL Cost Director Variance Dividing Data Actual Quantity Used Standard Rate per How Flexible Budget (Standard) Standard Our Actus Quantity Used X Actual Rate por Hour Standard Rate per How Tot Total Actual Cost Total Rat Variance Efficiency Varice Feed Manufacturing Overhead ACTUAL Fixed Cost Flexible Budget (Budgeted Fred Cost based on planned volume Applied to Work in Process Aplied based on actualme Volume Controle Verge Name ACC 214 - Lab #8 - Chapter 21 Assignment From the following data, use Excel to calculate the direct materials price and quantity variances, the direct labor rate and usage variances and the feed overhead spending and volume variances. Show each variance as an absolute value. (Use fx for abs.value) For each variance use Excel's "F" function (click on "x") in to identify the variance as Favorable (F) or Unfavorable (U) boxes require a formula requires formula to identify the variance as For U Data for problem: Actual Volume for the year in units Planned Volume for the year (static budget) in units 10,600 10,000 Direct Labor #of hours per unit Rate per hour Standard 0.75 $10.25 Actual 0.95 $9.65 Direct Materials: #of pounds per unit Price per pound Standard 2 $1.50 Actual 1.7 $1.65 Fbxad Costs: Planned Costs Planned $11,800 Actual $12,500 ACTUAL Cost Direct Materials Variance Dividing Data Actual Quantity Used Actual Quantity Used Actual Price per Lb Flexible Budget (Standard) Standard Quantity Standard Price per lb. Standard Price per Lb. Total Actual Cost Total Total Price Variance Quantity Variance Director Variance Dividing Data Flexible Budget (Standard) ACTUAL Cost Actual Quantity Used Au Qulity Used hai viet Quay Standard Rate Hou per Hour Stunded Ralper Hour Tool Acta Cost Flund Manufacturing Overhead Flexible Budget (Buded Fured Costed on planned volume) Applied to Work in Process Aplied based on cu volume ACTUAL Fred Cost Volume Control Varian Open recovered workbooks? Your recent changes were saved. Do you want to continuo X1 M N P K 0 H C D ACC 214.Lab #8 Chapter 21 Assignment From the direct res and univerlates the direct laborate and www.defined vows Show eaches absolute Use te forte Pochi B's fonction des interview Far (F) or Unite (U) notre formulate the variance Foru As for the Punned for the budget 10,000 10.000 Standard 0.75 $10.25 Actu 0.85 5965 Direct thor: #of hours per Raper hour Fleed Costs Planned Cous oporto Proper 2 11.50 Actual 17 51.55 Planned 311.600 Actual $12.500 DIMM Variance Dividing ACTUAL Flexible Budget (Standard) Start Query AU AQ Used X Sandard Price To Stundard Price per Lb To ACTUAL COM Dihar Veiding UNI Flexible Budget (Standard) Standard Santander To To Pod Manufacturing the ACTUAL ) Bed Flat Coated on played volume App od to Work process Applied to stw volume vo Ch. 21 Worksheet ACTUAL Cost Actual Quantity Used X Actual Price perth Direct Materials Variance Dividing Data Actuarity Used Standard Price per the Tot Flexible Budget Standard) Sundwd Gurity Standard Price perth Tool Actu Cost Price Var DT VIN ACTUAL Cost Director Variance Dividing Data Actual Quantity Used Standard Rate per How Flexible Budget (Standard) Standard Our Actus Quantity Used X Actual Rate por Hour Standard Rate per How Tot Total Actual Cost Total Rat Variance Efficiency Varice Feed Manufacturing Overhead ACTUAL Fixed Cost Flexible Budget (Budgeted Fred Cost based on planned volume Applied to Work in Process Aplied based on actualme Volume Controle Verge Name ACC 214 - Lab #8 - Chapter 21 Assignment From the following data, use Excel to calculate the direct materials price and quantity variances, the direct labor rate and usage variances and the feed overhead spending and volume variances. Show each variance as an absolute value. (Use fx for abs.value) For each variance use Excel's "F" function (click on "x") in to identify the variance as Favorable (F) or Unfavorable (U) boxes require a formula requires formula to identify the variance as For U Data for problem: Actual Volume for the year in units Planned Volume for the year (static budget) in units 10,600 10,000 Direct Labor #of hours per unit Rate per hour Standard 0.75 $10.25 Actual 0.95 $9.65 Direct Materials: #of pounds per unit Price per pound Standard 2 $1.50 Actual 1.7 $1.65 Fbxad Costs: Planned Costs Planned $11,800 Actual $12,500 ACTUAL Cost Direct Materials Variance Dividing Data Actual Quantity Used Actual Quantity Used Actual Price per Lb Flexible Budget (Standard) Standard Quantity Standard Price per lb. Standard Price per Lb. Total Actual Cost Total Total Price Variance Quantity Variance Director Variance Dividing Data Flexible Budget (Standard) ACTUAL Cost Actual Quantity Used Au Qulity Used hai viet Quay Standard Rate Hou per Hour Stunded Ralper Hour Tool Acta Cost Flund Manufacturing Overhead Flexible Budget (Buded Fured Costed on planned volume) Applied to Work in Process Aplied based on cu volume ACTUAL Fred Cost Volume Control Varian