Chapter 9 Form Chapter 9: Applying Excel Data FLEXIBLE BUDGET ANALYSIS IS ALWAYS ON ACTUAL OUTPUT BASIS Exhibit 9-8: Standard Cost Card InputsStandard Quantity Standard Price Spending Variance Direct...

Excel Assignment


Chapter 9 Form Chapter 9: Applying Excel DataFLEXIBLE BUDGET ANALYSIS IS ALWAYS ON ACTUAL OUTPUT BASIS Exhibit 9-8: Standard Cost Card InputsStandard QuantityStandard PriceSpending Variance Direct materials3.0pounds$4.00per pound Direct labor0.50hours$22.00per hourActual output x actual quantitytimesActual price per unit Variable manufacturing overhead0.50hours$6.00per hour compared to Actual results: Actual output2,000unitsActual output x standard quantitytimesStandard price per unit Actual variable manufacturing overhead cost$7,140 Actual QuantityActual price Actual direct materials cost6,500pounds$3.80per poundPrice Variance Actual direct labor cost1,050hours$21.60per hour Actual output x actual quantitytimesActual price per unit Enter a formula into each of the cells marked with a ? below Main Example: Chapter 9Actual output x actual quantitytimesStandard price per unit Exhibit 9-11: Standard Cost Variance Analysis–Direct Materials Actual Quantity of Input, at Actual Price?pounds × ?per pound =?Quantity Variance Actual Quantity of Input, at Standard Price?pounds × ?per pound =? Standard Quantity Allowed for the Actual Output, at Standard Price?pounds × ?per pound =?Actual output x actual quantitytimesStandard price per unit Direct materials variances: Materials price variance?Actual output x standard quantitytimesStandard price per unit Materials quantity variance? Materials spending variance? Exhibit 9-12: Standard Cost Variance Analysis–Direct Labor Actual Hours of Input, at Actual Rate?hours × ?per hour =? Actual Hours of Input, at Standard Rate?hours × ?per hour =? Standard Hours Allowed for the Actual Output, at Standard Rate?hours × ?per hour =? Direct labor variances: Labor rate variance? Labor efficiency variance? Labor spending variance? Exhibit 9-13: Standard Cost Variance Analysis–Variable Manufacturing Overhead Actual Hours of Input, at Actual Rate?hours × ?per hour =? Actual Hours of Input, at Standard Rate?hours × ?per hour =? Standard Hours Allowed for the Actual Output, at Standard Rate?hours × ?per hour =? Variable overhead variances: Variable overhead rate variance? Variable overhead efficiency variance? Variable overhead spending variance?