25-1B

Answer a and b in excel format please

P25-1B Lopez Corporation manufactures a single product. The standard cost per unit of product is as follows. Direct materials-2 pounds of plastic at S5 per pound S10 Direct labor-2 hours at $12 per hour Variable manufacturing overhead Fixed manufacturing overhead Total standard cost per unit 24 $48 The master manufacturing overhead budget for the month based on normal productive capacity of 20,000 direct labor hours (10,000 units) shows total variable costs of $80,000 ($4 per labor hour) and total fixed costs of $60,000 (S3 per labor hour). Normal productive capacity is 20,000 direct labor hours. Overhead is applied on the basis of direct labor hours. Actual costs for November in producing 9,700 units were as follows. Direct materials (20,000 pounds) S 98,000 239,120 79,100 59,000 S475,220 Direct labor (19,600 hours) Variable overhead Fixed overhead Total manufacturing costs The purchasing department normally buys the quantities of raw materials that are expected to be used in production each month. Raw materials inventories, therefore, can be ignored. Instructions (a) Compute all of the materials and labor variances (b) Compute the total overhead variance