Application Problem 1 - Process Cost - Average Cost Flow

Original Data:

Department #1 has 3,000 units of product on beginning inventory, 45% complete to labor and overhead with $9,000 of material costs, $4,547 of labor costs, and $8,950 of overhead costs incurred.Department #1 started enough material to make 47,000 units of product.This material cost a total of $141,000.There was $171,453 of labor charged into Department #1 during the period.Overhead is applied at $5 per machine hour and there were 51,010 machine hours incurred.

There were 40,000 units of product finished in this department and transferred to Department 2.There are 10,000 units still in process in Department #1, 100% complete to materials and 40% complete to labor and overhead.

Test Data:

In Department #2, there is additional material added which cost a total of $83,000 this period.The labor charged to this department was $81,850 representing 10,000 hours and overhead is applied in this department at $16.50 per direct labor hour.Transferred to finished goods were 33,000 units.There were 12,000 units on ending inventory and they are 60% of the way through the department.The material in this department is added at the beginning of the process.Inspection occurs at halfway through the department.

Department #2 had 5,000 units on beginning inventory, 80% complete to labor and overhead with $64,100 transfer-in costs, $11,500 materials cost, $8,600 labor costs, and $15,900 overhead costs incurred.

Required:

Prepare, a complete production report for each department using Average cost flow

a.Three worksheets

a.Data worksheet all information given above

b.Department 1 worksheet - all numbers pulled from data worksheet

c.Department 2 worksheet - all numbers pulled from data worksheet - except one number needed from department 1