Question: Insert formulas using the cell numbers A5 to G1 to fill out the following excel assigment. Standards for one of Patterson, Inc.'s products is shown

Insert formulas using the cell numbers A5 to G1 to fill out the following excel assigment.
Insert formulas using the cell numbers A5 to G1 to fill out
the following excel assigment. Standards for one of Patterson, Inc.'s products is
shown below, along with actual cost data for the month: Direct materials:

Standards for one of Patterson, Inc.'s products is shown below, along with actual cost data for the month: Direct materials: Standard Actual 7 Direct labor: B. Standard 9 Actual 10 Variable overhead: 11 Standard 12 Actual 13 Total cost per unit 14 Excess of actual cost over standard cost per unit 15 16 Actual production for the month 13,500 units Variable overhead is assigned to products based on direct labor hours. There was no beginning or ending inventory of materials for the month. Required: Using formulas, compute the following. Input all numbers as positive amounts. (Hint: This can be done using the ABS function). (Use cells A5 to 616 from the given information to complete this question. All formulas must return positive values. For each variance, select eithe "Favorable" or "Unfavorable". fx. Accessibility tab summary: Financial information for Patterson Incorporated, is presented in cells A4 to 614 and rows 16 to \begin{tabular}{|l|l|l|} \hline 25 & \multicolumn{1}{|c|}{ A } \\ \hline 26 & Standard Cost Variance Anolysis - Direct Materials \\ \hline 27 & Standard Quantity Allowed for Actual Output at Standard Price \\ \hline 28 & Actual Quantity of Input, at Standard Price \\ \hline 29 & Actual Quantity of Input, at Actual Price \\ \hline 30 & & \\ \hline \end{tabular} Materials quantity variance Materials price variance. Standard Cost Variance Analysis - Direct Labor Standard Hours Allowed for Actual Output at Standard Rate Actual Hours of Input, at Standard Rate Actual Hours of Input, at Actual Rate Labor efficiency variance Labor rate variance Standard Cost Variance Analysis - Variable Manufacturing Overhead Standard Hours Allowed for Actual Output at Standard Rate Actual Hours of input, at Standard Rate Actual Hours of Input, at Actual Rate Variable overhead efficiency variance Variable overhead rate variance Using formulas, compute the amount of the unit cost difference that is traceable to each of the variances computed above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!