File Home Insert Page Layout Formulas Data Review Review View Help Tell me what you want to do Arial - 12 A A Wapter Paste X Cut Copy - Format Painter Cipboard BIU. Merge Center Font Alignment Numbe A23 X fo II. Ending June 30 records for June 30 for ABC Company 31 A B D E 23 II. Ending June 30 records for June 30 for ABC Company 249 Revenue 1,800,000 25 Raw Materials Purchased in Month 130,000 26 Direct Labor Cost 55,000 27 Advertising Expense 25,000 28 Rent on Factory 42,000 29 Sales Commissions 70,000 30 Maintenance Expense on factory Equip 20,000 Supplies for the Factory 3,500 32 Depreciation on Factory Equipment 35,000 33 Indirect labor Cost 50,600 34 Utilities Expense for Factory 14,000 35 Depreciation on Sales Office Cars 22.000 36 37 Raw Mati WIP Finished Goods 38 Beginning Inventory 10.000 20,000 40,000 39 Ending Inventory 14,000 15,000 60,000 40 41 Prepare the Cost of Goods Manufactured and Cost of goods sold for the month below 42 43 44 45 46 47 48 49 50 51 Sheet1 Sheet2 Sheet3 Ede Type here to search o TT Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Arial General X Cut Copy - te Format Paste Clipboard Wrap Text Merge & Center B IU SA 10 Font Alignment Numb: X fo II. Ending June 30 records for June 30 for ABC Company B D F F Create an Income Statement for the month (Simple format, include period costs) 1 2 3 -5 38 57 BB 29 90 91 92 93 94 95 96 III. Manufacturing Overhead Costs estimated 97 98 Direct Labor Hours estimated Sheet1 Sheet2 Sheets Et 800,000 100.000 Type here to search O