Spread Sheet- Accounting Equation method: | ||||||||||||||||||
Overhead allocation rate = 558000/372000 = 1.5 per DLC | ||||||||||||||||||
Date | Assets | = | Liabilities + | Shareholders' Equity | ||||||||||||||
Cash + | Acc Rec. + | FG + | WIP + | Mat. + | Fac Sup + | Fac O/h + | Prep F. Ins. + | PPE | = | AP + | Bond P + | Loan + | Acc. Dep.+ | Com Sto + | APIC + | RE | Details | |
OB | 21000 | 65000 | 103000 | 31000 | 19000 | 6000 | 264000 | = | 69000 | 150000 | 70000 | 50000 | 110000 | 60000 | ||||
1-Jul | 45000 | 3000 | = | 48000 | ||||||||||||||
2 | 50000 | = | 50000 | |||||||||||||||
3 | -1500 | = | -1500 | dividend | ||||||||||||||
3 | 52000 | -52000 | = | |||||||||||||||
5-Fact utilities | -10230 | 10230 | = | |||||||||||||||
15-janitorial | 4500 | = | 4500 | |||||||||||||||
16 | -1000 | 1000 | = | |||||||||||||||
20-R&D payable | 6000 | = | 6000 | |||||||||||||||
22-other Fac o/h | -12500 | 12500 | = | |||||||||||||||
23-selling exp. | = | 6150 | -6150 | Selling exp. | ||||||||||||||
28-dividend | -1500 | = | -1500 | dividend | ||||||||||||||
25-salary payable | 30000 | 15000 | = | 45000 | ||||||||||||||
27-restructuring exp. | = | 15000 | -15000 | admin exp. | ||||||||||||||
27-admin exp. | = | 7100 | -7100 | admin exp. | ||||||||||||||
28 | 1750 | -1750 | = | |||||||||||||||
28 | -45000 | = | -45000 | |||||||||||||||
30 | 21120 | = | 26400 | -5280 | Admin exp. | |||||||||||||
30-O/h allocation | 45000 | -45000 | = | |||||||||||||||
31-FG | 95000 | -95000 | = | |||||||||||||||
31-Sale | 374000 | = | 374000 | Sales | ||||||||||||||
31-COGS | -185000 | = | -185000 | COGS | ||||||||||||||
31 | -158000 | = | -158000 | |||||||||||||||
31 | 320000 | -320000 | = | |||||||||||||||
31-Interest payable | = | 400 | -400 | Interest exp. | ||||||||||||||
31-under allocated to COGS | -27100 | = | -27100 | COGS | ||||||||||||||
TOTAL | 162270 | 119000 | 13000 | 63000 | 12000 | 2000 | 0 | 4250 | 264000 | = | -1850 | 150000 | 50000 | 96400 | 50000 | 110000 | 184970 | |
G TOTAL | 639520 | = | 639520 |
Income Statement | |
Amount $ | |
Sales | 374000 |
Less:COGS | 212100 |
Gross Profit | 161900 |
Less:Admin exp. | 27380 |
Income before selling exp. | 134520 |
Less:Selling exp. | 6150 |
Income before interest | 128370 |
Less:interest exp. | 400 |
Income before taxes | 127970 |
Less:Taxes - 21% | 26874 |
Net Income | 101096 |
Add: OB of Retained Earnings | 60000 |
Less:Dividend paid | 3000 |
CB of Retained Earnings | 158096 |
Balance Sheet: | |
Assets | Amount $ |
Cash | 162270 |
Acc. Receivable | 119000 |
Inventory-FG | 13000 |
Inventory-WIP | 63000 |
Inventory-Material | 12000 |
Inventory-supplies | 2000 |
Prepaid Fac Insurance | 4250 |
Current Assets | 375520 |
PPE | 264000 |
Less: Acc. Depreciation | 96400 |
Total Assets | 543120 |
Liabilities & Stockholders' Equity | Amount $ |
Accounts Payable | -2250 |
Tax payable | 26874 |
Interest payable | 400 |
Current Liabilities | 25024 |
Long term liabilities: | |
bond payable | 150000 |
Loans | 50000 |
Total Liabilities | 225024 |
Stockholders' Equity: | |
Common Stock | 50000 |
APIC | 110000 |
Retained Earnings | 158096 |
Total Liabilities & SH. Eq. | 543120 |
Curtis Products manufactures garden tools. It uses a job costing system that allocates factory overhead on...
Curtis Products manufactures garden tools. It uses a job costing system that allocates factory overhead on the basis of direct labor-costs. Budgeted factory overhead for the year 2019 was $558,000, and management budgeted $372,000 in direct labor costs. The company’s tax rate is 21% (Round income tax to the nearest dollar). The trial balance of Curtis Products, Inc. on June 30, 2019 is as follows: Cash……………………………………………… $21,000 Accounts Receivable…………………………….. 65,000 Finished Goods………………………………….. 103,000 Work in Process…………………………………. ...
Curtis Products manufactures garden tools. It uses a job costing system that allocates factory overhead on the basis of direct labor-costs. Budgeted factory overhead for the year 2019 was $558,000, and management budgeted $372,000 in direct labor costs. The company’s tax rate is 21% (Round income tax to the nearest dollar). The trial balance of Curtis Products, Inc. on June 30, 2019 is as follows: Cash……………………………………………… $21,000 Accounts Receivable…………………………….. 65,000 Finished Goods………………………………….. 103,000 Work in Process…………………………………. 31,000 Materials ………………………………………… 19,000...
Curtis Products manufactures garden tools. It uses a job costing system that allocates factory overhead on the basis of direct labor-costs. Budgeted factory overhead for the year 2019 was $558,000, and management budgeted $372,000 in direct labor costs. The company’s tax rate is 21% (Round income tax to the nearest dollar).\ The trial balance of Curtis Products, Inc. on June 30, 2019 is as follows: Cash……………………………………………… $21,000 Accounts Receivable…………………………….. 65,000 Finished Goods………………………………….. 103,000 Work in Process…………………………………. ...
Hamilton Company manufactures custom cabinets. It uses a job costing system with overhead allocated based on machine hours. Budgeted factory overhead for the year 2019 was $1,232,500, and management also budgeted 85,000 machine hours for the year. The company’s tax rate is 21% (Round taxes to the nearest dollar). Below is Hamilton Company’s trial balance at the beginning of October 2019. Hamilton Company manufactures custom cabinets. It uses a job costing system with overhead allocated based on machine hours. Budgeted...
Haughton Company uses a job costing system for its production costs and a predetermined factory overhead rate based on direct labor costs to apply factory overhead to all jobs. During the month of July, the firm processed three jobs: X13, X14, and X15, of which X13 was started in June. July 1 Inventories Direct Materials Work-in-Process Finished Goods $ 36,500 41,000 Cost of Goods Sold Direct materials purchased in July 55,000 Materials issued to production: X13 x14 x15 16,380 24,220...
Haughton Company uses a job costing system for its production costs and a predetermined factory overhead rate based on direct labor costs to apply factory overhead to all jobs. During the month of July, the firm processed three jobs: X13, X14, and X15, of which X13 was started in June. July 1 July 31 $ 37,600 43,200 0 $ 2 66,000 ? ? 0 17,700 33,020 14,550 Inventories Direct Materials Work-in-Process Finished Goods Cost of Goods Sold Direct materials purchased...
Application of Overhead; Schedule of Cost of Goods Manufactured Haughton Company uses a job costing system for its production costs and a predetermined factory overhead rate based on direct labor costs to apply factory overhead to all jobs. During the month of July, the firm processed three jobs: X13, X14, and X15, of which X13 was started in June. Inventories July 1 July 31 Direct materials Work in process Finished goods 36,500 41,000 Cost of Goods Sold, July Direct materials...
Application of Overhead; Schedule of Cost of Goods Manufactured Haughton Company uses a job costing system for its production costs and a predetermined factory overhead rate based on direct labor costs to apply factory overhead to all jobs. During the month of July, the firm processed three jobs: X13, X14, and X15, of which X13 was started in June. Inventories July 1 July 31 Direct materials Work in process Finished goods 36,500 41,000 Cost of Goods Sold, July Direct materials...
The company uses a job-order costing system that applies manufacturing overhead cost to jobs on the basis of direct labor-hours. Its predetermined overhead rate was based on a cost formula that estimated $342,000 of manufacturing overhead for an estimated allocation base of 950 direct labor-hours. The following transactions took place during the year: 1. Raw materials purchased on account, $210,000. 2. Raw materials used in production (all direct materials), $195,000. 3. Utility bills incurred on account, $61,000 (95% related to...