Project 2-4Chapters 8-13) Patterson, Inc. has provided details of its actual cos
ID: 2412643 • Letter: P
Question
Project 2-4Chapters 8-13) Patterson, Inc. has provided details of its actual cost data for the month. The Controlter has asked you to t compute the bac vanances and e variances on unit costs Use the information included in the Excel Simulation and the Excel functions descibed beow to co the task Cell Reference. Allows you to refer to data from another cell in the worksheet From the Excesmuat on beowrnatar* oH" entered, the formula would output the result from cell D4, or 2 75 in this example Bosic Meth functions: Allows you to use the basic math symbois to perform mathematical functions You can use the following keys iplus sign to ado), (minus sign to subtract). (asterisk sign to mutiply), and/orward slash to drvide) From the Excel Smulation berow a blank cel -F4 G5 was entered, the formula would add the values from those cells and output the resuit or 14.70 im ths esampe t usng the other math symbols the resuit would output an appropniate answer for its function SUM tunction: Allows you to refer to multiple cells and adds all the values. You can add Individual cell references or ranges to ut function. From the Excel Simulation b two separate cells, or 5.45 in this example. Simsarty, If in a blank ces -SUMD4 D5 was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formusia, and the resuit would be 5.45 in thes elow, Iif in a blank cel SUMID4,D5) was entered, the formula would output the result of aaing those . ABS function: Allows you to return the absolute value of a number or calculation You can reference any cell to or surround another formula with the ABS function, to return the tinal resuit as an absolute value From the Excel Simulation below, if in a display its absolute value bianik ceil you entered AB(F7-G8) Excel wias frst calculate the subtraction of F7-G8 that results in -0 20. Then, the ABS portion of the formula returns the absolute value of the subtraction result, which would be o.20 in this example IF function: Allows you to test a condition and return a specitic value is the resuit is true and different value if the resuit is false The syntax of the IF function is iFiftest conditior value It true vatue t falser and specific considerations need to be made when using this function Therese.conditor, argument is an evaluation ofthe status of a cell, such as if the vake of a cell sgreater than, less than, or equal to another number or cell The ?ue_r_true and vaue trase arguments wll return any specinc result for each option. such as another ces reference. a value, or text. Throughout the entare equation, it text is being used in the test concion, vave it true or vaue t fase ar the text itself should be entered in quotations so that Excel wi recognize the text as a "string of text instead of another function From the Excei Simulation below, if in a blank cell FiF13-20, Total Cost Per Unit is good Total Cost Per Unit is bad) was entered, the formula would output the resuit of the vatue t true since the lest.condition would be resut as true, or in thes case the text Total Cost Per Unitis good Excel processes the IF function by separating it out into separate parts. First the test condition- Excel thinks, tind cell F13 and etermine it the value is greater than 20. Once Excel determines if the result of that test condition is TRUE or FALSE, It will return the guments then Basic Variance Analysis and the Impact of Variances on Unit Costs-Excell HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW EW Sign in Formatting Table Styles Stles eszExplanation / Answer
Standard Cost Variances Direct Material Variances: Standard Quantity Allowed for Actual Output at Standard Price $ 89,100.00 Total standard cost $ 89,100.00 Actual Quantity of Input, at Standard Price $ 111,375.00 Total actual cost $ 109,350.00 Actual Quantity of Input, at Actual Price $ 109,350.00 Total variance $ (20,250.00) Unfavorable Material price variance $ 2,025 Favorable Material quantity variance $ (22,275) Unfavorable Total material variance $ (20,250) Unfavorable Direct Labor Variances: Standard Hours Allowed for Actual Output at Standard Rate $ 145,800.00 Total standard cost $ 145,800.00 Actual Hours of Input, at Standard Rate $ 121,500.00 Total actual cost $ 148,500.00 Actual Hours of Input, at Actual Rate $ 148,500.00 Total variance $ (2,700.00) Unfavorable Labor rate variance $ (27,000.00) Unfavorable Labor efficiency variance $ 24,300.00 Favorable Total labor variance $ 2,700.00 Favorable Variable Manufacturing Overhead Variances: Standard Hours Allowed for Actual Output at Standard Rate $ 56,700.00 Total standard cost $ 56,700.00 Actual Hours of Input, at Standard Rate $ 47,250.00 Total actual cost $ 47,925.00 Actual Hours of Input, at Actual Rate $ 47,925.00 Total variance $ 8,775.00 Favorable Variable overhead spending variance $ (675.00) Unfavorable Variable overhead efficiency variance $ 9,450.00 Favorable Total variance $ (8,775.00) Unfavorable STANDARD COST ACTUAL COST Direct Material Variances: Material price variance $ 2,025 Favorable Material quantity variance $ (22,275) Unfavorable (20,250) Unfavorable 89,100 109,350 Direct Labor Variances: Labor rate variance $ (27,000.00) Unfavorable Labor efficiency variance $ 24,300.00 Favorable (2,700) Unfavorable 145,800 148,500 Variable Manufacturing Overhead Variances: Variable overhead spending variance $ (675.00) Unfavorable Variable overhead efficiency variance $ 9,450.00 Favorable 8,775 Favorable 56700 47925 Excess of Actual over Standar Cost Per Unit @ 1.05 14175/13500 = 1.05 per unit (14,175) Unfavorable 291,600 305,775 (14,175)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.