Please refer to the Excel template for the variance analysis spreadsheet. You are to complete the variances listed for direct materials, direct labor, variable overhead, and fixed overhead. All information necessary is listed in the problem areas, above the variance calculation area. If any errors are discovered, consider the Excel data correct. Direct Labor is based on DLHs, Variable Overhead is based on machine hours (MH). All per unit rates are taken to 3 decimal places. Actual/Standard Direct Materials Direct Labor Variable MO Fixed MO Production Units Actual 52,550 52,550 52,550 52,550 Standard DM units per finished unit Standard 4.250 Standard DM unit price Standard $7.425 0.255 Standard DLH's per finished unit Standard $14.890 Standard Standard DLH rate Standard VOH MH's per finished unit 3.500 Standard Standard VOH POR rate per MH $26.095 Standard 8.250 Standard FOH MH's per finished unit Standard S6.750 Standard FOH POR rate per MH Standard od & used Actual DM units purchased & used Actual 220,990 Actual DM unit price Actual $7.400 Actual DLHS Actual 14,080 Actual Actual DLH rate $14.910 181,460 Actual VOH MHS Actual Actual VOH POR per MH Actual $26.200 Actual FOH cost Actual $2,935,900 $3,108,667 Budget FOH cost Actual MPY Quan MOV Varance Quantity Total Vince VOREV FOR SPEND FOW VOLUME su Account Credit Arrent Dret Amount Labor rate variance Variance Quantity Quantity Total Variance Total Variance | BU Labor efficiency variance Total Variance Total labor yarance Total Actual Total Standard Total Variance F/U Debit Account Credit Account Debit Amount Credit Amount Payroll Payable Total /E Production units: Standards: Std. MH Hours Std. Rate VOM Actuals: Act. MH Hours Act. Rate VOM VOH spending variance Variance Quantity Total Variance AH SH VOH efficiency variance Variance Rate Total Variance Total VOH variance Total Actual Total Standard Total Variance Debit Account Credit Account Debit Amount Credit Amount WIP I VOH Control Total / Standards: Standards: Std. M Hours | Std. Rate Actuals Actual FOH Budget FOH FOH FOH spending variance Actual FOH Budgeted FOH Total Variance F/U FOH volume varianc Budgeted FOH Applied FOH Total Variance Flu Total FOH variance Total Actual Total Standard Total Variance F/U Debit Account Credit Account Debit Amount Credit Amount WIP FOH Control Total /