Autent %* Excellerplignment, CNT). Protected in File Home insert Draw Page Layout Formulas Data Review View Help Quichols FOLLCHED VW Be careful files from the more con contain viruses. Une you need to det e to vay in Protected View Enable Iding xo CD GHKLMNL01 1 E1-12 Prepare a cost of goods man actured schedule and a partial income statement 2 Cepeda Corporation has the following cost records for June 2017 Indirect factory labor $4,500 Factory ilities $400 Direct materials used 20,000 Depreciation factory equipment 1.400 Work in process, 6/1/17 3,000 Direct labor 40,000 Work in process, 6/30/17 3,800 Maintenance, factory equipment 1,800 Finished goods, 6/1/17 5,000 Indirect materials 2,200 Finished goods, 6/30/17 7,500 Factory manager's salary 3,000 10 Instructions 11 (a) Prepare a cost of goods manufactured schedule for June 2017 12 (1) Prepare an income statement through gross profit for June 2017 assuming sales revenue is 13 $92,100 14 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" Value CEPEDA CORPORATION Cost of Goods Manufactured Schedule For the Month Ended June 30 2017 Work in process, June 1 Direct materials used Direct labor Manufacturing overhead Indirect later Wabu E14 E1-12 E1-16 PIHAPI SA CD1 Value Owe x2 te Type here to search DELL File Home Insert Draw Page Layout Formulas Data Review View Help Quick PROTECTED VIEW Be careful files from the Internet can contain Viruses. Unless you need to edit,'s safer to stay in Protected view e r 17 4 K 19 : x FGH CEPEDA CORPORATION Cost of Goods Manufactured Schedule For the Month Ended June 30, 2017 Work in process, June 1 Value Direct materials used Value Direct labor Value Manufacturing overhead Indirect labor Value Factory manager's salary Value Indirect materials Value Maintenance, factory equipment Value Depreciation, factory equipment Value Factory utilities Value Total manufacturing overhead Total manufacturing costs Total cost of work in process Less: Work in process, June 30 Cost of goods manufactured ES 38 (b) (Partial) CEPEDA CORPORATION Income Statement (partial) For the Month Ended June 30, 2017 Sales Revenue Cost of goods sold Lininhadadrimanntant 1 E1-4 E1-12 E1-16 P1-4A P1.5A CD1 Value Type here to search Total manufacturing costs Total cost of work in process Less: Work in process, June 30 Cost of goods manufactured Value 38 (b) Value CEPEDA CORPORATION Income Statement (partial) For the Month Ended June 30, 2017 Sales Revenue Cost of goods sold Finished goods inventory, June 1 Cost of goods manufactured (from (a) above] Cost of goods available for sale Less: Finished goods inventory, June 30 Cost of goods sold Gross profit Value Value ? Value After you have completed E1-12, consider the following additional question. Assume the following balances changed: beginning work in process $4,200, direct labor $39,000, and indirect materials $2,700. Show the impact of these changes on the cost of goods manufactured schedule. E1-4 E1-12 E1-16 P1-4A PI-SACD1 O Type here to search