Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show me the proper excel formulas for the ones needed. especially for the ones that you have to put in favorable or unfavorable. i

please show me the proper excel formulas for the ones needed. especially for the ones that you have to put in favorable or unfavorable. i have posted and checked many times and nothing is correct. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
A1 fr Standards for one of Patterson, Inc.'s products is shown below, along with actual \begin{tabular}{|l|l|l|l|llllll|} A & B & C & D & E & F & G & H & I \end{tabular} Standards for one of Patterson, Inc.'s products is shown below, along with actual cost data for the month: Direct materials: 455789StandardActualDirectlabor:StandardActualVariableoverhead: \begin{tabular}{lllll|} 10 & Standard & 0.6 hours @ & $7.00 per hour & 4.20 \\ 11 & Actual & 0.5 hours @ & $7.10 per hour & 3.55 \\ \hline \end{tabular} Total cost per unit $21.60$22.65 Excess of actual cost over standard cost per unit $1.05 Actual production for the month 13,500 units Variable overhead is assigned to products based on direct labor hours. There A1 18 Variable overhead is assigned to products based on direct labor hours. There 9 was no beginning or ending inventory of materials for the month. Using formulas, compute the following. Input all numbers as positive amounts. Indicate whether the variances are F or U. Write if statements for variance cells F30 to F47. Use cell 22 references (formulas) for cells D53 - D60. Enter an F or U to indicate the correct variance in cells F54 to F62. Standard Cost Variance Analysis - Direct Materials Standard Quantity Allowed for Actual Output at Standard Price Actual Quantity of Input, at Standard Price $89,100 Actual Quantity of Input, at Actual Price 111,375 109,350 Materials quantity variance $$22,2752,025 \begin{tabular}{|l|l|r|} \hline 29 & & $3 \\ 30 & Materials quantity variance \\ \hline 31 & Materials price variance \\ \hline 32 & & 22,275 \\ 33 & Standard Cost Variance Analysis - Direct Labor \\ \hline 34 & Standard Hours Allowed for Actual Output at Standard Rate \\ \hline 35 & Actual Hours of Input, at Standard Rate \\ \hline 36 & Actual Hours of Input, at Actual Rate \\ \hline 37 & \\ \hline 38 & Labor efficiency variance \\ \hline 39 & Labor rate variance \\ \hline 40 & & \\ \hline 41 & Standard Cost Variance Analysis - Variable Manufacturing Overhead \\ \hline 42 & Standard Hours Allowed for Actual Output at Standard Rate \\ \hline 43 & Actual Hours of Input, at Standard Rate \\ \hline 44 & Actual Hours of Input, at Actual Rate \\ \hline 45 & & \\ \hline 46 & Variable overhead efficiency variance \\ \hline 47 & Variable overhead rate variance \\ \hline 48 & \\ \hline 49 & Using formulas, compute the amount of the unit cost difference \\ \hline 50 & that is traceable to each of the variances computed above. \\ \hline \end{tabular} 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. Materials: Quantity variance Price variance Labor: Efficiency variance Rate variance Variable overhead: Efficiency variance Rate variance Excess of actual over standard cost per unit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Ethics

Authors: Ronald F. Duska, Brenda Shay Duska, Kenneth Wm. Kury

3rd Edition

1119118786, 9781119118787

More Books

Students also viewed these Accounting questions

Question

Identify ways to increase your selfesteem.

Answered: 1 week ago