Plocek Corporation uses a job-order costing system to assign manufacturing costs to jobs. At the end of the month it closes out any overapplied or underapplied manufacturing overhead to Cost of Goods Sold. Its balance sheet on July 1 appears below:
Plocek Corporation |
Balance Sheet |
July 1 |
Assets: | | |
---|
Cash | | $ 11,000 |
---|
Raw materials | $ 7,000 | |
---|
Work in process | 12,000 | |
---|
Finished goods | 18,000 | 37,000 |
---|
Prepaid expenses | | 27,000 |
---|
Property, plant, and equipment (net) | | 250,000 |
---|
Total assets | | $325,000 |
---|
Liabilities and Stockholders’ Equity: | | |
---|
Accounts payable | | $ 19,000 |
---|
Retained earnings | | 306,000 |
---|
Total liabilities and stockholders’ equity | | $325,000 |
---|
Summaries of the transactions completed during July appear below:
(1) Raw materials purchased on account | $ 71,000 |
---|
(2) Raw materials used in production (direct materials) | $ 56,000 |
---|
(3) Raw materials used in production (indirect materials) | $ 11,000 |
---|
(4) Direct labor paid in cash | $ 90,000 |
---|
(5) Indirect labor paid in cash | $ 23,000 |
---|
(6) Selling and administrative salaries paid in cash | $ 30,000 |
---|
(7) Factory utility costs (on account) | $ 12,000 |
---|
(8) Depreciation on PP&E—manufacturing equipment | $ 6,000 |
---|
(9) Depreciation on PP&E—selling and administration | $ 2,000 |
---|
(10) Advertising expenses paid in cash | $ 14,000 |
---|
(11) Prepaid insurance expired—production | $ 7,200 |
---|
(12) Prepaid insurance expired—selling and administration | $ 1,800 |
---|
(13) Manufacturing overhead applied to production | $ 58,000 |
---|
(14) Cost of goods manufactured | $197,000 |
---|
(15) Cash sales | $269,000 |
---|
(16) Cost of goods sold | $205,000 |
---|
(17) Cash payments to creditors | $ 87,000 |
---|
(18) Overapplied (underapplied) overhead | ? |
---|
Required:
a. Completely fill in the spreadsheet below.
Transactions | Cash | Raw Materials | Work in Process | Finished Goods | Manufacturing Overhead | Prepaid Expenses | PP&E (net) | = | Accounts Payable | Retained Earnings |
---|
Beginning balances, July 1 | | | | | | | | = | | |
(1) Raw materials purchased on account | | | | | | | | = | | |
(2) Raw materials used in production (direct materials) | | | | | | | | = | | |
(3) Raw materials used in production (indirect materials) | | | | | | | | = | | |
(4) Direct labor paid in cash | | | | | | | | = | | |
(5) Indirect labor paid in cash | | | | | | | | = | | |
(6) Selling and administrative salaries paid in cash | | | | | | | | = | | |
(7) Factory utility costs (on account) | | | | | | | | = | | |
(8) Depreciation on PP&E—manufacturing equipment | | | | | | | | = | | |
(9) Depreciation on PP&E—selling and administration | | | | | | | | = | | |
(10) Advertising expenses paid in cash | | | | | | | | = | | |
(11) Manufacturing overhead applied to production | | | | | | | | = | | |
(12) Prepaid insurance expired—production | | | | | | | | | | |
(13) Prepaid insurance expired—selling and administration | | | | | | | | | | |
(14) Cost of goods manufactured | | | | | | | | = | | |
(15) Cash sales | | | | | | | | = | | |
(16) Cost of goods sold | | | | | | | | = | | |
(17) Cash payments to creditors | | | | | | | | | | |
(18) Overapplied (underapplied) overhead | | | | | | | | = | | |
Ending balances at July 31 | | | | | | | | | | |
b. Prepare a Balance Sheet for the company for July 31.
c. Prepare a Schedule of Cost of Goods Manufactured for the company for July.
d. Prepare a Schedule of Cost of Goods Sold for the company for July.
e. Prepare an Income Statement for the company for July.