Question

Certain item descriptions and amounts are missing from the monthly schedule of cost of goods manufactured and income statement of Elly Manufacturing Company. B (Click the icon to view the schedule of cost of goods manufactured.) 2 (Click the icon to view the income statement.) Data Table i Data Table Elly Manufacturing Company Elly Manufacturing Company June 30, 2018 June 30, 2018 $ x $ 27,000 Net Sales Revenue Cost of Goods Sold: Beginning Beginning Direct $ 110,000 Beginning Direct Materials Purchases of Direct Materials $ x 56,000 84,000 (20,000) Ending Direct Materials Cost of Goods Ending Cost of Goods Sold Gross Profit 232,000 Direct $x Direct 258,000 44,000 Manufacturing Overhead Expenses: Selling Expenses Administrative Expenses 180,000 Total 98,000 __ _ Costs _ Costs Total Total 160,000 Ending (25.000) _Income

Answer 1

Elly Manfacturing Company Schedule of Cost of Goods Manfactured Month Ended June 30, 2018 Elly Manfacturing Company Income Statement Month Ended June 30, 2018 $ 27,000.00 $ 490,000.00 $ 28,000.00 $ 56,000.00 $ 84,000.00 $ (20,000.00) $ 110,000.00 $ 182,000.00 $ 292,000.00 $ (60,000.00) Beginning Work in process inventory Direct Materials used: Beginning Direct Materials Purchase of Direct materials Direct Materials avaialble for use Ending Direct materials Direct Materials used Direct Labour Manfacturing overhead Total Manfacturing costs Incurred during the month Total Manfacturing costs To Account for Ending Work in process inventory Cost of goods manfactured $ 64,000.00 $ 72,000.00 $ 44,000.00 Net sales revenue Cost of goods sold : Beginning Finished Goods inventory Cost of goods manfactured Cost of goods available for sale Ending Finished goods inventory Cost of goods sold Gross profit Selling and administrative expense : Selling expense Administrative expense Total Selling and administrative expense Operating Income $ 232,000.00 $ 258,000.00 $ 98,000.00 $ 62,000.00 $ 180,000.00 $ 207,000.00 $ (25,000.00) $ 182,000.00 $ 160,000.00 $ 98,000.00

- X Insert Function FCDDF000 [Last saved by user] - Microsoft Excel Home Insert Page Layout Formulas Data Review View A a Define Name X-Trace Precedents Show Formulas Calculate Now Use in Formula Trace Dependents Error Checking AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Watch Calculation Calculate Sheet - Used - Time Reference Trig Functions Manager Create from Selection Remove Arrows" Evaluate Formula Window Options Function Library Defined Names Formula Auditing Calculation fic Direct Materials used: B C D Elly Manfacturing Company Elly Manfacturing Company Schedule of Cost of Goods Manfactured Income Statement Month Ended June 30, 2018 Month Ended June 30, 2018 27000 =H12+H11 =B9-B8 56000 84000 -20000 110000 =D17 =SUM(G7:68) =H11-69 5 Beginning Work in process inventory 6 Direct Materials used: 7 Beginning Direct Materials 8 Purchase of Direct materials 9 Direct Materials avaialble for use 10 Ending Direct materials 11 Direct Materials used 12 Direct Labour 13 Manfacturing overhead 14 Total Manfacturing costs Incurred during the month 15 Total Manfacturing costs To Account for 16 Ending Work in process inventory 17 Cost of goods manfactured Net sales revenue Cost of goods sold : Beginning Finished Goods inventory Cost of goods manfactured Cost of goods available for sale Ending Finished goods inventory Cost of goods sold Gross profit Selling and administrative expense : Selling expense Administrative expense Total Selling and administrative expense Operating Income 232000 258000 =B9+B10 =D14-C11-C13 44000 - 180000 =D14+D5 -25000 =SUM(D15:016) 98000 =H16-614 160000 =H12-H16 22 Sheet126 Sheet127 Sheet129 Sheet130 Sheet131 Sheet133 Sheet132 Sheet134 Sheet135 Februar I Ready Search the web and your PC O e OO 100% U w 2:55 PM E ^ to a 1x 213/2020 FA 9