Patterson, Inc. has provided details of its actual cost data for the month. The
ID: 2571910 • Letter: P
Question
Patterson, Inc. has provided details of its actual cost data for the month. The Controller has asked you to compute the basic variances and the impact of those variances on unit costs. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, -D4" was entered, the formula would output the result from cell D4, or 2.75 in this example. ing keys: +(plus sign to add), (minus sign to " ic11.isaj. Iin,"il low, if in a blank cell"-F4+ SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel . elow, if in a blank cell "-SUM(D4,D5)" was entered, the formula w ing those two separate cells, or 5.45 in this exa enteredt adding those cells, ex t they are expressed as a range in the formula, a nd the resul would be 5.45 in this example ABS function: Allows you to return the absolute value of a number or calculation. You can reference any cell to display its absolute value, or surround another formula with , to return the final result as an ab value. From the Excel Sin ow, if in a blank cell you entered ABS(F7-G8)" Excel will first ca on of F7-G8 that results in -0.20 e formula returns the absolut e value of the subtraction result, whi be 0.20 in this exampleExplanation / Answer
Direct material
1)
Standard quantity allowed for actual output at standard price =SQ×SP
SQ=2.4 ×13500=32400
SP=2.75
=32400×2.75=89100
2)
Actual quantity of input at standard price
=AQ×SP
AQ=3×31500=94500
SP=2.75
=94500×2.75=259875
3)
Actual quantity at actual price
AQ = 3×31500=94500
AP= 2.70
=94500×2.70=255150
*) Material Quantity varience = SQ-AQ×SP=
=32400-40500×2.75= 22275 U
*)Material price varience =SP-AP×AQ
=2.75-2.70×40500= 2025 F
Direct labour
1)
Standard Hours allowed for actual output at standard price = SH×SR
SH=.6×13500=8100
SR= 18
=8100×18=145800
2)
Actual hours of input at standard rate =AH×SR
AH=.5×13500=6750
SR=18
=6750×18=121500
3)
Actual hours of input at actual rate=AH×AR
=.5×13500=6750
AR=22
=6750×22=148500
*) Direct labour rate varience = SR-AR×AH
=18-22×6750= 27000 U
*)Direct labour efficiency varience =SH-AH×SR
=8100-6750×18=24300 F
Variable manufacturing Overhead
1)
Standard hours allowed for actual output at standard rate = SH×SR
SH=.6×13500=8100
SR=7
=8100×7=56700
2)
Actual hours of input at standard rate = AH ×SR
AH=13500×.5=6750
SR=7
=6750×7=47250
3)
Actual hours of input at actual rate = AH×AR
AH= 8100×7.10=57510
*) Variable overhead efficiency varience = SH -AH×SR
=8100×6750×7=9450 F
*)Variable overhead rate varience =SR-AR×AH
=7-7.10×6750= 675 U
**)
Material Quantity varience = (22275)
Material price varience = 2025
Labour rate varience = (27000)
Labour efficiency varience = 24300
Variable efficiency varience= 9450
variable rate varience = (675)
exess of actual over STD = 14175
*)Excess of actual cost over standard cost per unit = 14175÷13500=1.05