PS. Sep21, 20:20 Mon Act30/13) in class notes - Excel david lee X File Home Insert Page Layout Formulas Dar Review View Help Quickbooks Tel me what you want to do REC - 11 A 2 Custom 60% - Accent Accent Accent Accent Y cut Copy - Format Painter 2 Wrap Text Merge & Center - Paste . $. Accent Conditional Format as Accent Formatting Table Comma Comma foi Currency Clipboard Font Alignment Number Styles CIG 135200 E G H K 1 2 62.400 Sales Acct301130) 1,300,000 3 375,960 - Sales Disc Beg Direct Materials inventory + New Purchase of Direct Materials - Ending Direct Materials inventory Direct Materials used in production 42,640 - Sales Return Net Sales 5 6 7. 80,600 20.020 147,160 375,960 8 + Direct Labour - COGS Gross Profit 10 11 Sales Depreciation, factory Utilities, factory Administrative expense Purchase of raw materials Raw materials, Mar31, 2020 selling expense Raw materials, Mari, 2020 Work-in-process inventory, Mar31 insurance Insurance, factory Direct labour Work-in-process inventory, Marist Indirect labour Finished Goods Inventory, Marist Supplies, factory Finished Goods Inventory, Mar31 Maintenance, factory 12 Operating Expenses 2.00 85.800 62.400 52.000 w 21.840 81.796 93,600 159,120 135,200 7,280 109.200 46,280 13 14 15 16 17 18 19 20 21 22 23 Factory Building + Indirect materials (like lubricant) indirect labour (like factory supervisor salary) Factory, Supplies Factory, Insurance Factory, Property tax Factory, Repair and Maintenance Factory. Utility Factory, Rent for machinery or building Factory, Depreciation for Machinery and Buildings Manufacturing Overhead 3} office, supplies Office, insurance Office, Property Tax office, repair and maintenance Office office, Utility Building Office, rent for equipment or building Office, Depreciation for equipment and building Office, tel Exp Office, ads exp Total Operating Expenses Required: prepare the income statements 24 25 Date First 26 1)*2)+3) Total Manufacturing cost (New W.IP) + Beg W.IP - Ending WIP Cost of Goods Manufactured (New Finished Goods or products) + Beg Finished Goods or products - Ending Finished Goods or Products COGS 27 Last Net Income 28 29 30 31 32 33 Student id Acct30130) Assignment2 David Li's screen 2-Sep20 Assignment Sheet2 Sheets - 100% 42.640 L M N 0 Sales - Sales Disc - Sales Return Net Sales - COGS Gross Profit Operating Expenses Office, supplies Office, insurance Office, Property Tax Office, repair and maintenance Office office, Utility Building Office, rent for equipment or building Office Depreciation for equipment and building Office, tel Exp Office, ads exp Total Operating Expenses + Net Income