In: Accounting
XYZ Company recorded the following information related to their inventory accounts for 2020: January 1, 2020 December 31, 2020 Direct materials 31,000 50,000 Work in process 38,000 41,000 Finished goods 22,000 34,000 The following information was taken from XYZ Company's accounting records for 2020: Sales revenue ........................................... $630,000 Direct materials purchased .............................. ? Depreciation, factory equipment ......................... 34,000 Prime costs ............................................. 250,000 Utilities (60% for factory; 40% for office building) .... 20,000 Sales commissions ....................................... 71,000 Indirect materials ...................................... ? Depreciation, office equipment .......................... 30,000 Rent, factory building .................................. 56,000 Net income .............................................. 10,000 Direct labor ............................................ ? Advertising ............................................. 68,000 Production supervisor's salary .......................... 74,000 Additional information: 1. Direct labor comprised 35% of the conversion costs for 2020. 2. The actual overhead cost for 2020 was equal to the overhead applied to production. Thus there was no overhead variance for 2020. Calculate XYZ Company's indirect materials cost for 2020.
The missing figures have to be found out by | |||
preparing, Schedules of cost of production and | |||
cost of goods sold and income statement by | |||
connecting the available data in the three | |||
statements. | |||
SCHEDULE OF COST OF PRODUCTION | |||
Beginning inventory of WIP | $ 38,000 | ||
Direct materials: | |||
Beginning inventory of direct materials | $ 31,000 | ||
Purchase of direct materials [188000-31000] | $ 1,57,000 | ||
Direct materials available for use [138000+50000] | $ 1,88,000 | ||
Ending inventory of direct materials | $ 50,000 | ||
Direct material cost [250000-112000] | $ 1,38,000 | ||
Direct labor [208000*35%/65%] | $ 1,12,000 | ||
Prime costs | $ 2,50,000 | ||
Overhead: | |||
Indirect materials [208000-74000-56000-12000-34000] | $ 32,000 | ||
Depreciation, factory equipment | $ 34,000 | ||
Utilities [20000*60%] | $ 12,000 | ||
Rent, factory building | $ 56,000 | ||
Production supervisor's salary | $ 74,000 | ||
Total overhead [458000-250000] | $ 2,08,000 | ||
Manufacturing cost incurred during the period [496000-38000] | $ 4,58,000 | ||
Total manufacturing costs [455000+41000] | $ 4,96,000 | ||
Ending WIP inventory | $ 41,000 | ||
Cost of goods manufactured [from Schedule of COGS] | $ 4,55,000 | ||
SCHEDULE OF COST OF GOODS SOLD | |||
Beginning finished goods inventory | $ 22,000 | ||
Cost of goods manufactured [477000-22000] | $ 4,55,000 | ||
Cost of goods sold available for sale [443000+34000] | $ 4,77,000 | ||
Ending finished goods inventory | $ 34,000 | ||
Cost of goods sold [From income statement] | $ 4,43,000 | ||
INCOME STATEMENT | |||
Sales revenue | $ 6,30,000 | ||
Cost of goods sold [630000-187000] | $ 4,43,000 | ||
Gross profit [10000+177000] | $ 1,87,000 | ||
Operating expenses: | |||
Sales commissions | $ 71,000 | ||
Advertising | $ 68,000 | ||
Utilities [20000*40%] | $ 8,000 | ||
Depreciation-Office equipment | $ 30,000 | ||
Total operating expenses | $ 1,77,000 | ||
Net income | $ 10,000 | ||
Note: | |||
Indirect materials is assumed to be purchased and used | |||
immediately. No stock is kept. That is, direct materials | |||
do not include indirect materials. |