In: Accounting
Crimson Tide Company uses a job-order costing system. At Crimson Tide, overhead costs are applied to jobs on the basis of machine-hours.
For the current year, Crimson Tide estimated that its machines would work for a total of 26,000 machine-hours. Tide also estimated for the current year that it would incur $124,800 in manufacturing overhead cost.
The following transactions occurred during the year:
a. Raw materials requisitioned for use in production, $300,000 (80% direct and 20% indirect).
b. The following costs were incurred for employee services:
| Direct labor | $ | 171,000 | |
| Indirect labor | $ | 29,000 | |
| Sales commissions | $ | 21,000 | |
| Administrative salaries | $ | 36,000 | |
|
|
|||
c. Total insurance costs were $21,000 Note: Of the total insurance cost, 90% relates to factory operations, and 10% relates to selling and administrative activities.
d. In the factory only, heat, power, and water costs incurred in the factory totalled $60,000.
e. Total depreciation recorded for the year was $71,000 Note: Of the total depreciation recorded 85% relates to factory operations, and 15% relates to selling and administrative activities.
f. Advertising costs incurred was $61,000.
g. According to their job cost sheets, goods that cost $491,000 to manufacture were transferred to the finished goods warehouse.
h. Sales for the year totaled $722,000. The total cost to manufacture these goods according to their job cost sheets was $486,000.
i. The company actually used 51,000 machine-hours during the year.
Required:
1. Determine the underapplied or overapplied overhead for the year. (Round predetermined overhead rate to 2 decimal places.).
2. Prepare an income statement for the year. (Hint: No calculations are required to determine the cost of goods sold before any adjustment for underapplied or overapplied overhead.) (Round predetermined overhead rate to 2 decimal places.)
| Predetermined Overhead Rate=Estimated total manufacturing overhead cost/Estimated total amount of allocation base | |||||
| 1) | |||||
| Estimated total manufacturing overhead cost | $ 1,24,800.00 | ||||
| Estimated total amount of allocation base | 26000 | ||||
| Predetermined Overhead rate=($124800/26000) | $ 4.80 | ||||
| Machine hours actually worked during the year | 51000 | ||||
| Manufacturing Overhead=(51000*$4.8) | $ 2,44,800.00 | ||||
| a) | WIP=($300000*80%) | 240000 | |||
| Manufacturing Overhead=($300000*20%) | 60000 | ||||
| To Raw Material | 300000 | ||||
| b) | WIP | 171000 | |||
| Manufacturing Overhead | 29000 | ||||
| Sales Commission | 21000 | ||||
| Administerative Salaries | 36000 | ||||
| To Salaries & Wages Payable | 257000 | ||||
| c) | Manufacturing Overhead($21000*90%) | 18900 | |||
| Insurance Expenses=($21000*10%) | 2100 | ||||
| To Prepaid Insurance | 21000 | ||||
| d) | Manufacturing Overhead | 60000 | |||
| To Cash | 60000 | ||||
| e) | Manufacturing Overhead($71000*85%) | 60350 | |||
| Depreciation Expense=($71000*15%) | 10650 | ||||
| To Accumulated Depreciation | 71000 | ||||
| f) | Advertisement Expenses | 61000 | |||
| To Accounts Payable | 61000 | ||||
| g) | Finished Goods | 491000 | |||
| To WIP | 491000 | ||||
| h) | Accounts Receivable | 722000 | |||
| To Sales | 722000 | ||||
| h) | Cost of goods sold | 486000 | |||
| To Finished Goods | 486000 | ||||
| (i) | WIP | 244800 | |||
| To Manufacturing Overhead | 244800 | ||||
| (i) | Manufacturing Overhead($244800-$228250) | 16550 | |||
| To Cost of goods sold | 16550 | ||||
| Manufacturing Overhead | |||||
| Particular | Amt | Particular | Amt | ||
| To Raw Material | $ 60,000.00 | By WIP(Predetermined Overhead) | $ 2,44,800.00 | ||
| To Salary & Wages Payable | $ 29,000.00 | ||||
| To Prepaid Insurance | $ 18,900.00 | ||||
| To Cash | $ 60,000.00 | ||||
| To Accumulated Depreciation | $ 60,350.00 | ||||
| To Balance (Overapplied Overhead) | $ 16,550.00 | ||||
| $ 2,44,800.00 | $ 2,44,800.00 | ||||
| Crimson Tide Company | |||||
| 2) | Income statement | ||||
| Sales | $ 7,22,000.00 | ||||
| Cost of goods sold($486000-$16550) | $ 4,69,450.00 | ||||
| Gross Margin | $ 2,52,550.00 | ||||
| Selling & Administerative Expenses | |||||
| Sales Commission Expense | $ 21,000.00 | ||||
| Administerative Salaries Expense | $ 36,000.00 | ||||
| Advertisement Expense | $ 61,000.00 | ||||
| Depreciation Expense | $ 10,650.00 | ||||
| Insurance Expense | $ 2,100.00 | ||||
| Total Selling & Administerative Expenses | $ 1,30,750.00 | ||||
| Net Income | $ 1,21,800.00 | ||||