Answer:
A | B | C | D | E | |
1 | Job 306 | Job 307 | Job 308 | April Total | |
2 | From March | ||||
3 | Direct Materials | 31,000 | 40,000 | 71,000 | |
4 | Direct Labor | 22,000 | 19,000 | 41,000 | |
5 | Applied Overhead | 11,000 | 9,500 | 20,500 | |
6 | Beginning goods in process | 64,000 | 68,500 | - | 132,500 |
7 | For April | ||||
8 | Direct Materials | 135,000 | 220,000 | 110,000 | 465,000 |
9 | Direct Labor | 101,000 | 152,000 | 102,000 | 355,000 |
10 | Applied Overhead | 50,500 | 76,000 | 51,000 | 177,500 |
11 | Total Costs Added in April | 286,500 | 448,000 | 263,000 | 997,500 |
12 | Total Costs (April 30) | 350,500 | 516,500 | 263,000 | 1,130,000 |
13 | Status on April 30 | Finished (sold) | Finished (Unsold) | In process | |
14 | April 30 Cost included in: | Cost of Goods Sold | Finished Good Inventory | Work in Process Inventory |
Actual Overhead = 58,000 + 27,000 + 39,000 + 24,000 + 52,000
= 200,000
Overhead Applied = 355,000 * 50% = 177,500
Actual Overhead > Overhead Applied , So overhead is Under Applied.
Underapplied Overhead = 200,000 - 177,500
= 22,500
Underapplied Overhead is Adjusted to Cost of Goods Sold.
A | B | |
16 | 4a) | |
17 | Sale of Job 306 | 675,000 |
18 | Less : Cost of Goods Sold (350,500 + 22,500 ) | 373,000 |
19 | Gross Profit (=B17+B18) | 302,000 |
20 | 4b) | |
21 | ||
22 | Inventories | Amount ($) |
23 | Raw Materials (84,000 + 550,000 - 58,000 - 465,000 ) | 111,000 |
24 | Work in Process | 263,000 |
25 | Finished Goods | 516,500 |
26 | Total Inventories (=B23+B24+B25) | 890,500 |
A | B | C | D | E | |
1 | Job 306 | Job 307 | Job 308 | April Total | |
2 | From March | ||||
3 | Direct Materials | 31,000 | 40,000 | = B3+C3 | |
4 | Direct Labor | 22,000 | 19,000 | = B3+C3 | |
5 | Applied Overhead | 11,000 | 9,500 | = B3+C3 | |
6 | Beginning goods in process | 64,000 | 68,500 | - | = B3+C3 |
7 | For April | ||||
8 | Direct Materials | 135,000 | 220,000 | 110,000 | =B8+C8+D8 |
9 | Direct Labor | 101,000 | 152,000 | 102,000 | =B9+C9+D9 |
10 | Applied Overhead | =B9 * 50% | =C9 * 50% | =D9 * 50% | =B10+C10+D10 |
11 | Total Costs Added in April | =B8+B9+B10 | =C8+C9+C10 | =D8+D9+D10 | =B11+C11+D11 |
12 | Total Costs (April 30) | =B6+B11 | =C6+C11 | =D6+D11 | =E6+E11 |
13 | Status on April 30 | Finished (sold) | Finished (Unsold) | In process | |
14 | April 30 Cost included in: | Cost of Goods Sold | Finished Good Inventory | Work in Process Inventory |
Required information (The following information applies to the questions displayed below. Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $88,000. Raw materials purchases in April are $530,000, and factory payroll cost in April is $388,000. Overhead costs incurred in April are: indirect materials, $54,000; indirect labor, $30,000; factory rent, $31,000; factory utilities, $19,000; and factory equipment depreciation, $56,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $630,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.) Marcelino Co.'s March 31 inventory of raw materials is $90,000. Raw materials purchases in April are $510,000, and factory payroll cost in April is $381,000. Overhead costs incurred in April are: indirect materials, $53,000; indirect labor, $25,000; factory rent, $36,000; factory utilities, $24,000, and factory equipment depreciation, $55,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $655,000 cash in April. Costs of...
[The following information applies to the questions displayed below.) Marcelino Co.'s March 31 inventory of raw materials is $87,000. Raw materials purchases in April are $520,000, and factory payroll cost in April is $365,000. Overhead costs incurred in April are: indirect materials, $51,000; indirect labor, $26,000; factory rent, $39,000; factory utilities, $21,000; and factory equipment depreciation, $56,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $675,000 cash in April. Costs of the three...
Required information (The following information applies to the questions displayed below.) Marcelino Co.'s March 31 inventory of raw materials is $86,000. Raw materials purchases in April are $540,000, and factory payroll cost in April is $378,000. Overhead costs incurred in April are: indirect materials, $59,000; indirect labor, $24,000; factory rent, $32,000; factory utilities, $22,000; and factory equipment depreciation, $52,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $670,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $80,000. Raw materials purchases in April are $560,000, and factory payroll cost in April is $376,000. Overhead costs incurred in April are: indirect materials, $55,000; indirect labor, $21,000; factory rent, $38,000; factory utilities, $24,000; and factory equipment depreciation, $59,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $640,000 cash in April. Costs of...
Required information (The following information applies to the questions displayed below) Marcelino Co's March 31 inventory of raw materials is $89,000. Raw materials purchases in April are $590,000, and factory payroll cost in April is $377,000. Overhead costs incurred in April are: indirect materials, $51,000; indirect labor, $26,000; factory rent, $34,000; factory utilities, $21,000; and factory equipment depreciation, $59,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $665,000 cash in April . Costs...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $85,000. Raw materials purchases in April are $580,000, and factory payroll cost in April is $385,000. Overhead costs incurred in April are: indirect materials, $59,000; indirect labor, $28,000; factory rent, $33,000; factory utilities, $21,000; and factory equipment depreciation, $52,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $635,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $82,000. Raw materials purchases in April are $580,000, and factory payroll cost in April is $386,000. Overhead costs incurred in April are: indirect materials, $54,000; indirect labor, $24,000; factory rent, $34,000; factory utilities, $22,000; and factory equipment depreciation, $59,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $675,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $84,000. Raw materials purchases in April are $520,000, and factory payroll cost in April is $388,000. Overhead costs incurred in April are: indirect materials, $56,000; indirect labor, $28,000; factory rent, $37,000; factory utilities, $24,000; and factory equipment depreciation, $61,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $680,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.) Marcelino Co's March 31 inventory of raw materials is $89,000. Raw materials purchases in April are $590,000, and factory payroll cost in April is $377,000. Overhead costs incurred in April are: indirect materials, $51,000; indirect labor, $26,000; factory rent, $34,000; factory utilities, $21,000; and factory equipment depreciation, $59,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $665,000 cash in April. Costs of...