USA: +1 (725) 712-1730 
Sign in
Home l Chapter 10 Excel Varla x C Se ation.com/hm.tpx 364188640301 15026848 1 Standards for one of Patterson, Inc.’s products is shown below, along with actual cost data for the month: $6.60 4 Standard s Actual 6 Direct labor: 2.4 yards @ 3 yards@ $2.75 per yard $2.70 per yard $8.10 Standard 0.6 hours@ 8 Actual 9 Variable overhead: $18.00 per hour $22.00 per hour 10.80 0.5 hours e 11.00 o Standard0.6 hours$7.00 per hour 4.20 0.5 hours e 3.55 $21.60 $22.65 $1.05 $7.10 per hour 11 Actual 12 13 Total cost per unit 14 15 Excess of actual cost over standard cost per unit 16 13,500 units based on direct labor hours. There 18 Variable overhead is assigned to 9 was no beginning or ending inventory of materials for the month. 21 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 F 22 references (formulas) for cells 053-D60. Enter an F or U to indlicate the correct variance Sheeti 。īype here to search Doe畚@@
Expert Answer
| SQ allowed for actual output at SP A | 89100 | ||||
| (Actual output*SQ per output required*SR) | |||||
| (13500*2.4*2.75) | |||||
| AQ of input at SP B | 111375 | ||||
| (13500*3*2.75) | |||||
| AQ of input at actual price C | 109350 | ||||
| (13500*3*2.7) | |||||
| Material Price variance | 2025 | F | |||
| (Actual Quantity purchased*Actual price)-(Actual Qty purchased*Standard price) | |||||
| C-B 109350-111375 | |||||
| Material Quantity Variance | 22275 | U | |||
| AQ of input at SP – SQ allowed at SP | |||||
| 111375-89100 | |||||
| SH allowed for actual output at SP A | 145800 | ||||
| (Actual output*SH per output required*SR) | |||||
| (13500*.6*18) | |||||
| AH of input at SP B | 121500 | ||||
| (13500*.5*18) | |||||
| AH of input at actual price C | 148500 | ||||
| (13500*.5*22) | |||||
| Labor rate variance | 27000 | U | |||
| (AH*AR)-(AH*SR) | |||||
| 148500-121500 | |||||
| Labor efficiency variance | 24300 | F | |||
| AH of input at SP – SH allowed at SP | |||||
| 121500-145800 | |||||
| Variable overhead | |||||
| SH allowed for actual output at SP A | 56700 | ||||
| (Actual output*SH per output required*SR) | |||||
| (13500*.6*7) | |||||
| AH of input at SP B | 47250 | ||||
| (13500*.5*7) | |||||
| AH of input at actual price C | 47925 | ||||
| (13500*.5*7.1) | |||||
| Variable overhead rate variance | 675 | U | |||
| (AH*AR)-(AH*SR) | |||||
| 47925-47250 | |||||
| Variable overhead efficiency variance | 9450 | F | |||
| AH of input at SP – SH allowed at SP | |||||
| 47250-56700 | |||||
| Material | explantion variance/no. of units produced | ||||
| Quantity variance | 1.65 | U | 22275/13500 | ||
| Price variance | 0.15 | F | 1.5 | U | 2025/13500 |
| Labor | |||||
| Efficiency | 1.8 | F | 24300/13500 | ||
| Rate variance | 2 | U | 0.2 | U | 27000/13500 |
| Variable overhead | |||||
| Efficiency | 0.7 | F | 9450/13500 | ||
| Rate variance | 0.05 | U | 0.65 | F | 675/13500 |
| Excess of actal over std cost | 1.05 | 1.05 | U | ||
