Chapter 09: Applying Excel: Excel Worksheet (Part 1 of 2)

For example, in cell D21 enter the formula "= D14". Notes: if you do, you will overwrite these formulas. - After entering formulas in all of the cells that contained question marks, verify that the amounts match the numbers in the example in the text. answers, find the errors in your worksheet and correct them. \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|l|}{ Chapter 9: Applying Excel } \\ \hline \multicolumn{5}{|l|}{ Data........... } \\ \hline \multicolumn{5}{|l|}{ Exhibit 9-9: Standard Cost Card } \\ \hline Inputs & \multicolumn{2}{|c|}{ Standard Quantity } & \multicolumn{2}{|c|}{ Standard Price } \\ \hline Direct materials. & 3.0 & pounds & $4.00 & per pound \\ \hline Direct labor & 0.50 & hours & $22.00 & per hour \\ \hline Variable m anufacturing overhead & 0.50 & hours & $6.00 & per hour \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Actual results: } \\ \hline Actual output & 2,000 & units & & \\ \hline \multirow[t]{2}{*}{ Actual variable manufacturing overhead cost } & \multicolumn{2}{|l|}{$7,140} & & \\ \hline & \multicolumn{2}{|c|}{ Actual Quantity } & \multicolumn{2}{|c|}{ Actual price } \\ \hline Actual dire d m aterials cost & 6,500 & pounds & $3.80 & per pound \\ \hline Actual dire d labor cost & 1,050 & hours & $21.60 & per hour \\ \hline \multicolumn{5}{|l|}{ Enter a formula into each of the cells marked with a ? below } \\ \hline \multicolumn{5}{|l|}{ Main Example: Chapter 9 } \\ \hline \multirow{2}{*}{\multicolumn{5}{|c|}{ Exhibit 9-12: Standard Cos t Variance Analys is -Direct Materials }} \\ \hline & & & & \\ \hline Actual Quantity of Input, at Actual P rice & 6,500 & pounds & $3.80 & per pound = \\ \hline Actual Quantity of Input, at Standard Price & 6,500 & pounds & $4.00 & per pound = \\ \hline Standard Quantity Allowed for the Actual Output, at Standard Price & 6,000 & pounds & $4.00 & per pound = \\ \hline \multicolumn{5}{|l|}{ D irect materials variances: } \\ \hline Materials price variance & $1,300 & F & & \\ \hline Materials quantity variance & $2,000 & u & & \\ \hline Materials spending variance & $700 & F & & \\ \hline \multicolumn{5}{|l|}{ Exhibit 9-13: Standard Cos t Variance Analys is - Direct Labor } \\ \hline Actual H ours of Input, at Adual Rate & 1,050 & hours x & $21.60 & per hour = \\ \hline Actual H ours of Input, at Standard Rate & 1,050 & hours x & $22.00 & per hour = \\ \hline Standard Hours Allowed for the Actual Output, at Standard Rate & 1,000 & hours x & $22.00 & per hour = \\ \hline \multicolumn{5}{|l|}{ Direct lab or varia nces: } \\ \hline Labor rate variance & $420 & F & & \\ \hline Labor efficiency variance & $1,100 & 0 & & \\ \hline Labor spending variance & $680 & F & & \\ \hline \multicolumn{5}{|c|}{ Exhibit 9-14: Standard Cos t Variance Analys is - Variable Manufacturing Overhead } \\ \hline Actual H ours of finput, at Adual Rate & & hours x & & per hour = \\ \hline Actual H ours of Input, at Standard Rate. & & hours x & & per hour = \\ \hline Standard Hours Allowed for the Actual Output, at Standard Rate & & hours x & & per hour = \\ \hline \multicolumn{5}{|l|}{ Variable overhead variances: } \\ \hline Variable overhead rate variance & $0 & & & \\ \hline Variable overhead efficiency variance & $0 & & & \\ \hline Variable overthead spending variance & $0 & & & \\ \hline \end{tabular}