Cost Per Unit is goodExcel processes the y put Excel thinks, find cell F13 and determine if the value is greater than 20. Once Excel determines if the result of that test condition is TRUE or FALSE, it will return the value_it_true or value_Ilalse. 5- .- FILE HOME Pa Basic Variance Analysis and the impact of Variances on Unit Costs - Excel ? Do PAGE LAYOUT FORMULAS DATA REVIEW VIEW U * A Alignment Number Conditional Format as Call Cells Editing Formatting Table Styles Styles Standards for one of Patterson, Inc.'s products is shown below, along with actual aste BIU- - lipboard Standards for one of Patterson, Inc.'s products is shown below, along with actual cost data for the month $6.60 $2.75 per yard 52.70 per yard 58.10 Direct materials: - Standard 2.4 yards - Actual 3 yards Direct labor: Standard 0.6 hours Actual 0.5 hours Variable overhead: 0 Standard 0 .5 hours 1 Actual 0.5 hours 10.80 $18.00 per hour $22.00 per hour 11.00 $7.00 per hour $7.10 per hour 4.20 3.55 3 Total cost per unit $21.60 $22.65 5 Excess of actual cost over standard cost per unit $1.05 -7 Actual production for the month 13,500 units 3 Variable overhead is assigned to products based on direct labor hours. There 19 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 For U. Write it statements for variance cells F30 to 747. Use cell 2 references (formulas) for cells 53.060. Enter an For U to indicate the correct variance in cells 4 to 562 + ... Sheet1 READY Attempt(s) - 100% Prey 1 of 1 Next EXCO - - HOME - INSERT Basic Variance Analysis and the impact of Variances on Unit Cose PAGE LAYOUT FORMULAS REVIEW FILE Calibri TR11 Calls Editing Paste BI US Alignment Number her A Conditional Formatas Cell Formatting - Table Styles Styles Standards for one of Patterson, Inc.'s products is shown below, along with 25 Standard Cost Variance Analysis - Direct Materials 26 Standard Quantity Allowed for Actual Output at Standard Price 27 Actual Quantity of input, at Standard Price 28 Actual Quantity of Input, at Actual Price 30 Materials quantity variance Materials price variance 33 Standard Cost Variance Analysis - Direct Labor 34 Standard Hours Allowed for Actual Output at Standard Rate 35 Actual Hours of Input, at Standard Rate 36 Actual Hours of input, at Actual Rate 39 Labor efficiency variance Labor rate variance 41 Standard Cost Variance Analysis - Variable Manufacturing Overhead 42 Standard Hours Allowed for Actual Output at Standard Rate 43 Actual Hours of Input, at Standard Rate 44 Actual Hours of Input, at Actual Rate 46 Variable overhead efficiency variance 47 Variable overhead rate variance . ... Sheet1 READY Attempts) Prev 1 of 1 !! Next ce -A- Alignment Number Conditional Format as Cell Formatting Table Styles % Standards for one of Patterson, Inc.'s products is shown below Variable overhead efficiency variance Variable overhead rate variance 49 Using formulas, compute the amount of the unit cost difference 50 that is traceable to each of the variances computed above. 52 Materials: 53 Quantity variance 54 Price variance 55 Labor: 56 Efficiency variance 57 Rate variance 58 Variable overhead: 59 Efficiency variance Rate variance Excess of actual over standard cost per unit Sheet1 READY Attempt(s) Prev 1 of 1 !!! Next