In: Accounting
I need to Prepare entries for a job order, cost system, and cost of goods manufactured schedule, but my numbers aren't matching up. Please answer both parts of the question.
Case Inc. is a construction company specializing in custom patios. The patios are constructed of concrete, brick, fiberglass, and lumber, depending upon customer preference. On June 1, 2017, the general ledger for Case Inc. contains the following data.
|
Customer Job | Beginning Bal | Materials Requisition slips | Time tickets D | Overhead D*1.25 | Total | Completed | Ending WIP |
Rodgers | $1,320 | 800 | $850 | $1,063 | $4,033 | $4,033 | |
Koss | 2000 | 800 | $1,000 | $3,800 | $3,800 | ||
Stevens | 2015 | 500 | 360 | $450 | $3,325 | $3,325 | |
Linton | 2205 | 1300 | 1,200 | $1,500 | $6,205 | $6,205 | |
Rodgers | 300 | 390 | $488 | $1,178 | $1,178 | ||
$5,540 | $4,900 | $3,600 | $4,500 | $18,540 | $14,740 | $3,800 | |
Accounts Title | Dr | Cr | |||||
a1 | Raw Malerials Inventory | $4,900 | |||||
Accounts Payable | $4,900 | ||||||
Factory labor | $4,800 | ||||||
Cash | $4,800 | ||||||
Manufacturing Overhead | 1300 | ||||||
Accumulated Depreciation- Equipment | 900 | ||||||
Accounts Payable | 400 | ||||||
(a)(2) | |||||||
Work in Process Inventory | 4900 | ||||||
Manufacturing Overhead | 1500 | ||||||
Raw Malerials Inventory | 6400 | ||||||
Work in Process Inventory | 3600 | ||||||
Manufacturing Overhead | 1200 | ||||||
Factory Labor | 4800 | ||||||
Work in Process Inventory (3600*1.25) | 4500 | ||||||
Manufacturing Overhead | 4500 | ||||||
(a)(3) | |||||||
Finished Goods Inventory | $14,740 | ||||||
Work in Process Inventory | $14,740 | ||||||
( | |||||||
Cash | 18900 | ||||||
Sales | 18900 | ||||||
Cost of Goods Sold | $14,740 | ||||||
Finished Goods Inventory | $14,740 | ||||||
(b) | |||||||
Work in Process Inventory | |||||||
1-Jun | Balance | 5540 | June | Completed work | $14,740 | ||
Direct Materials | $4,900 | ||||||
Direct labor | $3,600 | ||||||
Overhead applied | $4,500 | ||||||
30-Jun | Balance | $3,800 | |||||
(see from job cost sheet) | |||||||
(c ) | |||||||
6/30 balance in Work in Process Inventory | |||||||
Unfinished Job (Koss) | |||||||
Direct materials | 2000 | ||||||
Direct labor | 800 | ||||||
Manufacturing overhead | 1000 | ||||||
3800 | |||||||
(d) | |||||||
CASE INC. | |||||||
Cost of Goods Manufactured Schedule | |||||||
For the Month Ended June 30, 2017 | |||||||
Work in process, June 1 | 5540 | ||||||
Direct materials used | $4,900 | ||||||
Direct labor | $3,600 | ||||||
Manufacturing overhead applied | $4,500 | ||||||
Total manufacturing costs | $13,000 | ||||||
Total cost of work in process | $18,540 | ||||||
Less: Work in process, June 30 | 3800 | ||||||
Cost of goods manufactured | $14,740 | ||||||
Changes | |||||||
Customer Job | Beginning Bal | Materials Requisition slips | Time tickets D | Overhead D*1.5 | Total | Completed | Ending WIP |
Rodgers | $1,320 | 800 | $850 | $1,275 | $4,245 | $4,245 | |
Koss | 2000 | 800 | $1,200 | $4,000 | $4,000 | ||
Stevens | 2015 | 500 | 360 | $540 | $3,415 | $3,415 | |
Linton | 2205 | 1300 | 1,200 | $1,800 | $6,505 | $6,505 | |
Rodgers | 300 | 390 | $585 | $1,275 | $1,275 | ||
$5,540 | $4,900 | $3,600 | $5,400 | $19,440 | $15,440 | $4,000 | |
a1 | Dr | Cr | |||||
Raw Malerials Inventory | $6,800 | ||||||
Accounts Payable | $6,800 | ||||||
Factory labor (3600+1400) | $5,000 | ||||||
Cash | $5,000 | ||||||
Manufacturing Overhead | 1300 | ||||||
Accumulated Depreciation- Equipment | 900 | ||||||
Accounts Payable | 400 | ||||||
(a)(2) | |||||||
Work in Process Inventory | 4900 | ||||||
Manufacturing Overhead | 1500 | ||||||
Raw Malerials Inventory | 6400 | ||||||
Work in Process Inventory | 3600 | ||||||
Manufacturing Overhead | 1400 | ||||||
Factory Labor | 5000 | ||||||
Work in Process Inventory (3600*1.5) | 5400 | ||||||
Manufacturing Overhead | 5400 | ||||||
(a)(3) | |||||||
Finished Goods Inventory | $15,440 | ||||||
Work in Process Inventory | $15,440 | ||||||
Cash | 22000 | ||||||
Sales | 22000 | ||||||
Cost of Goods Sold | $15,440 | ||||||
Finished Goods Inventory | $15,440 | ||||||
(b) | |||||||
Work in Process Inventory | |||||||
1-Jun | Balance | 5540 | June | Completed work | $15,440 | ||
Direct Materials | 4900 | ||||||
Direct labor | 3600 | ||||||
Overhead applied | $5,400 | ||||||
30-Jun | Balance | $4,000 | |||||
(see from job cost sheet) | |||||||
(c ) | |||||||
6/30 balance in Work in Process Inventory | |||||||
Unfinished Job (Koss) | |||||||
Direct materials | 2000 | ||||||
Direct labor | 800 | ||||||
Manufacturing overhead | $1,200 | ||||||
4000 | |||||||
(d) | |||||||
CASE INC. | |||||||
Cost of Goods Manufactured Schedule | |||||||
For the Month Ended June 30, 2017 | |||||||
Work in process, June 1 | 5540 | ||||||
Direct materials used | $4,900 | ||||||
Direct labor | $3,600 | ||||||
Manufacturing overhead applied | $5,400 | ||||||
Total manufacturing costs | $13,900 | ||||||
Total cost of work in process | $19,440 | ||||||
Less: Work in process, June 30 | 4000 | ||||||
Cost of goods manufactured | $15,440 |