In Excel

Instructions:

a. b.

Prepare the January 31 entry to record the factory labor costs for the month of January. Prepare the January 31 entry to assign factory labor to production.

A B D E F H 1 1 E2.1 Additional Question 2. 3 Total factory labor costs related to factory workers for Larkin Company during the month of January are $90,000. Of the total accumulated cost of factory labor, 85% is related to 5 direct labor and 15% is attributable to indirect labor. 4 6 7 Instructions a. Prepare the January 31 entry to record the factory labor costs for the month of January. 8 9 10 b. Prepare the January 31 entry to assign factory labor to production. 11 12 NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), 13 into the yellow shaded input cells. 14 15 16 17 18 Additional Question 19 Assume that factory wages and employer's payroll taxes changed to $78,000 and $9,360 20 respectively. Also assume that 80% of total labor costs is related to direct labor. Revise the 21 journal entries to reflect these changes. 22 23 24 25 a. Jan. 31 26 27 28 29 b. Jan. 31 30 31 32 33 34 35