Job Costing Problem
Hoover Inc. uses a job-order coding system. The company s inventory balances on February 1, the start of its fiscal year, were as follows:
Raw Materials Inventory |
$69,325 |
Work in Process Inventory |
$55,100 |
Finished Goods Inventory |
$81,256 |
During the year, the following transactions were completed:
1.
Raw materials were purchased on account, $215,221.
2.
Raw materials were issued from the storeroom for use in production, $198,000 (70% direct and 30% indirect).
3.
Employee salaries and wages were accrued as follows: direct labor, $243,300; indirect labor, $98,750; and selling and administrative salaries, $72,340.
4.
Utility costs were incurred in the factory, $79,233.
5.
Advertising costs were incurred. $110,600.
6.
Prepaid insurance expired during the year, $35,000 (80% related to factory operations, and 20% related to selling and administrative activities).
7.
Depreciation was recorded, $192,100 (75% related to factory assets, and 25% related to selling and administrative assets).
8.
Manufacturing overhead was applied to jobs at the rate of 160% of direct labor cost.
9.
Goods that cost $720,200 to manufacture according to their job cost sheets were transferred to the finished goods warehouse.
10.
Sales for the year totaled $1,293,300 and were all on account. The total cost to manufacture these goods according to their job cost sheets was $725,825.
Submit an Excel document which each tab labeled by item number in good form that demonstrates the following:
1.
Prepare the journal entries to record the transactions for the year.
2.
Prepare the T-accounts for raw materials inventory, work in process inventory, finished goods inventory, manufacturing overhead, and cost of goods sold. Don t forget to enter the beginning balances in the inventory accounts.
3.
Is manufacturing overhead underapplied or overapplied for the year Prepare a journal entry to close this balance to cost of goods sold.
Production Data
Maple, Inc. manufactures syrup that goes through three processing stages prior to completion. Information on work in the first department, Blending, is given below for August:
Production data: |
||
Pounds in process, August 1; materials 100% complete; conversion 70% complete |
3,000 |
|
Pounds started into production during August |
85,000 |
|
Pounds completed and transferred out |
? |
|
Pounds in process, August 31; materials 80% complete; conversion 30% complete |
6,000 |
|
Cost data: |
||
Work in process inventory, August 1: |
$900 |
|
Conversion cost |
$5,900 |
|
Cost added during May: |
$151,000 |
|
Conversion cost |
$161,700 |
The company uses the weighted-average method.
Submit an Excel document which each tab labeled by item number in good form that demonstrates the following:
1.
Compute the equivalent units of production.
2.
Compute the costs per equivalent unit for the month.
3.
Determine the cost of ending work in process inventory and of the units transferred out to the next department.
4.
Prepare a cost reconciliation schedule for the month.