Computing COGM and COGS Acronyms: The following cost information are gathered from Drusilla Inc. for the month ended June 30: BWIP Beginning Work-in-process inventory Costs of direct materials used in production process $1,250,000 EWIP Ending Work-in-process inventory Direct labor costs 1,100,000 BFG Beginning Finished Goods inventory Total costs of factory overhead 520,000 EFG Ending Finished Goods inventory Work-in-process inventory, June 1 418,000 Work-in-process inventory, June 30 375,000 Finished goods inventory, June 1 148,000 Finished goods inventory, June 30 137,000 Selling expenses 150,000 Adminsitrative expenses 80,000 Required: Determine the following: a. Costs of goods manufactured b. COGS c. Period costs Use the formats below to organize your data and compute your answer. Use Excel Formula. Solution a. COGM = BWIP + Manufacturing costs incurred - EWIP Work-in-process inventory, June 1 Manufacturing costs incurred: Costs of direct materials used in production process Direct labor costs Total costs of factory overhead Total manufacturing costs in process Work-in-process inventory, June 30 COGM Solution b. COGS = BFG + COGM - EFG BFG Plus COGM Equals Costs of goods available for sale (COGAS) Less EFG equals Costs of goods sold Solution c. Period costs = Selling costs + administrative costs Computing COGM and COGS Compute the missing items from the COGM data for January and February: January February Beginning WIP 155000 ? Manufacturing costs incurred in the period 1325000 ? Total Manufacturing costs in the process ? 1520000 Ending WIP 165000 ? COGM ? 1395000 Fill your answers in the table below: January February Beginning WIP Manufacturing costs incurred in the period Total Manufacturing costs in the process Ending WIP COGM EX.15-16: Statement of Costs of Goods Manufactured (COGM) and Costs of Goods Sold (COGS) Cost data for Sanusky Manufacturing Company for the month ended January 31 are as follows: Inventories January 1 January 31 Materials (RM) $180,000 $145,500 Work in process (WIP) 334,600 290,700 Finished Goods (FG) 675,000 715,000 Direct labor $2,260,000 Materials purchased during January 1,375,000 Factory overhead incurred during January: Indirect labor 115,000 Machinery deprecistion 90,000 Heat, light and power 55,000 Supplies 18,500 Property taxes 10,000 Miscellaneous costs 33,100 Required: 1. Prpare a COGM Statement for Janurary. 2. Determine the COGS for January. Use the formats below to organize your data and compute your answer. Use Excel Formula. Solution: 1 Sanusky Manufacturing Company Statement of Cost of Goods Manufactured For the Month Ended January 31 RM/FOH Costs added COGM Beginning WIP Direct materials Beginning RM RM purchased Costs of RM available for use less Ending RM Cost of RM used Direct labor Factory overhead (FOH) Indirect labor Machinery deprecistion Heat, light and power Supplies Property taxes Miscellaneous costs Total costs of FOH Total manufacturing costs incurred in period Total manufacturing costs in the process Less Ending WIP Cost of Goods Manufactured (COGM) Solution: 2 Beginning Finished Goods inventory Plus COGM Equals Costs of goods available for sale Less Ending Finished Goods inventory COGS PR 15-5A: Statement of Costs of Goods Manufactured (COGM) and Income Statement for a manufacturing Company B. COGS The following information is available for Robstown Corporation for 20YY: A. COGM Statement Robstown Corporation Robstown Corporation Statement of Cost of Goods Sold Inventories January 1 December 31 Statement of Cost of Goods Manufactured For the Year Ended December 31, 20YY Raw Materials (RM) $44,250 $31,700 For the Year Ended December 31, 20YY $ Work in process (WIP) $63,900 $80,000 RM/FOH Coss added COGM Finished Goods (FG) $101,200 $99,800 Other Expenses Advertising expense $400,000 Depreciation expense - office equipment $30,000 Depreciation expense - factory equipment $80,000 C. Income Stement Direct labor $1,100,000 Robstown Corporation Heat, light and power - factory $53,300 IncomeStatement Indirect labor $115,000 For the Year Ended December 31, 20YY Material purchased $556,600 $ $ $ Office salaries expense $318,000 Property taxes - factory $40,000 Property taxes - office building $25,000 Rent expense - factory $27,000 Sales $3,850,000 Sales salaries expense $200,000 Supplies - factory $9,500 Miscellaneous costs -factory $11,400 Required: Prepare the following for Robstown for the year ended December 31, 20YY. A. COGM Statement B. COGS C. Income statement.