The Focus Company does not maintain backup documents for its computer files. In June, some of the current data were lost, and you have been asked to help reconstruct the data. The following beginning balances are known: Direct materials inventory$24,000 Work-in-process inventory 9,000 Finished goods inventory 22,000 Manufacturing overhead control 33,000 Accounts payable 12,000 Reviewing old documents and interviewing selected employees have generated the following additional information:The production superintendent's job cost sheets indicated that materials of $5,200 were included in the June 30 Work-in-Process Inventory. Also, 300 direct labor-hours had been paid at $12.00 per hour for the jobs in process on June 30.The Accounts Payable account is only for direct

Question

material purchases. The clerk remembers clearly that the balance in the Accounts Payable on June 30 was $16,000. An analysis of canceled checks indicated payments of $80,000 were made to suppliers during June.Payroll records indicate that 5,200 direct labor-hours were recorded for June. It was verified that there were no variations in pay rates among employees during June.Records at the warehouse indicate that the Finished Goods Inventory totaled $32,000 on June 30.Another record kept manually indicates that the Cost of Goods Sold in June totaled $168,000.The predetermined overhead rate was based on an estimated 60,000 direct labor-hours for the year and an estimated $360,000 in manufacturing overhead costs.Required:(a) Compute the Cost of Goods Manufactured.(b) Compute the ending Work-in-Process Inventory balance.(c) Compute the ending Direct Materials Inventory balance.

What will be an ideal response?

Answer 1

Overhead rate = $360,000/60,000 = $6/hr.

(a)
COGM: (Beg. FG) $22,000 + COGM - (COGS) $168,000 = (End. FG) $32,000; COGM = $178,000.

(b)
Ending WIP: $5,200 (DM) + (300 × $12) (DL) + (300 × $6) (MOH) = $10,600.

(c)
Ending DM: Beg. + Purchases - Used = Ending DM.
AP: $12,000 + Purchases - $80,000 = $16,000: Purchases = $84,000.
WIP: $9,000 + DM used + (5,200 × $12) + (5,200 × $6) - $178,000 = $10,600: DM used = $86,000.
Ending DM: $24,000 + $84,000 - $86,000 = $22,000.