Excel Honlework 1 P1-4A Prepare a cost of goods manufactured schedule, a partial income statement, and a partial balance sheet 4 The following data were taken from the records of Clarkson Company for the fiscal year ended June 30, 2020. Raw Materials Inventory, 7/1/19 Raw Materials Inventory, 6/30/20 Finished Goods Inventory, 7/1/19 Finished Goods Inventory, 6/30/20 Work in Process Inventory, 7/1/19 Work in Process Inventory, 6/30/20 Direct Labor Indirect Labor Accounts Receivable Factory Insurance $48,000 39,600 96,000 75,900 19,800 18,600 139,250 24,460 27,000 4,600 Factory Machinery Depreciation Factory Utilities Office Utilities Expense Sales Revenue Sales Discounts Plant Manager's Salary Factory Property Taxes Factory Repairs Raw Materials Purchases Cash $16,000 27,600 8,650 534,000 4,200 58,000 9,600 1,400 96,400 32,000 17 Instructions 18 (a) Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials) 19 (6) Prepare an income statement through gross profit 20(C) Prepare the current assets section of the balance sheet at June 30, 2020. 21 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 25 (a) Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials.) Value CLARKSON COMPANY Cost of Goods Manufactured Schedule For the Year Ended June 30, 2020 Work in process inventory, July 1, 2019 Direct materials Raw materials inventory, July 1, 2019 Value Raw materials purchases Value Total raw materials available for use Less: Raw materials inventory, June 30, 2020 Value Direct materials used Direct labor Manufacturing overhead Plant manager's salary Value Sheet1 Excel Honlework 1 2 P1-4A Prepare a cost of goods manufactured schedule, a partial income statement, and a partial balance sheet 4 The following data were taken from the records of Clarkson Company for the fiscal year ended June 30, 2020. Raw Materials Inventory 7/1/19 Raw Materials Inventory, 6/30/20 Finished Goods Inventory, 7/1/19 Finished Goods Inventory, 6/30/20 Work in Process Inventory, 7/1/19 Work in Process Inventory, 6/30/20 Direct Labor Indirect Labor Accounts Receivable Factory Insurance $48,000 39,600 96,000 75,900 19,800 18,600 139,250 24,460 27,000 4,600 Factory Machinery Depreciation Factory Utilities Office Utilities Expense Sales Revenue Sales Discounts Plant Manager's Salary Factory Property Taxes Factory Repairs Raw Materials Purchases Cash $16,000 27,600 8,650 534,000 4,200 58,000 9,600 1,400 96,400 32,000 17 Instructions 18 (a) Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials) 19 (b) Prepare an income statement through gross profit 20 (c) Prepare the current assets section of the balance sheet at June 30, 2020. 21 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 25 (a) Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials.) Value CLARKSON COMPANY Cost of Goods Manufactured Schedule For the Year Ended June 30, 2020 Work in process inventory, July 1, 2019 Direct materials Raw materials inventory, July 1, 2019 Value Raw materials purchases Value Total raw materials available for use Less: Raw materials inventory, June 30, 2020 Value Direct materials used Direct labor Manufacturing overhead Plant manager's salary Value 38 Value Sheet1 Search ove . Eacel Homework 1. Protected View Excel Home mert Draw Page Layout Formulas Data Review View Help Power Pivot PROTECTED VIEW Be careful som the Internet can contain viruset. Unless you need to edit, it's safe to stay in Protected View Enable Editing - Excel Homework 1 (a) Prepare a cost of goods manufactured schedule Assume al raw materials used were direct materials) 31 CLARKSON COMPANY Cost of Goods Manufactured Schedule For the Year Ended June 30, 2020 Work in process inventory, July 1, 2019 Direct materials Raw materials inventory, July 1, 2019 Value Raw materials purchases Total raw materials available for use Less Raw matonas inventory, June 30, 2020 Direct materials used Dired labor Mandaduring overhead Plant manager's salary Factory cities Indirect labor Fadory machinery depreciation Factory property taxes Factory wrance Fadory repairs Total manufacturing overhead Total manufacturing cards Total cost of work in process Les Work in process, June 30 Cost of goods manufactured 5 ) Prepare an income statement through gross profit CLARKSON COMPANY Partial income Statement For the Year Linded June 30, 2020 Sales discounts Fshed goochy 1, 2019 Opeh Enable y PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's ale to stay in Protecle view fx Excel Homework 1 D H (b) Prepare an income statement through gross profit Value Value CLARKSON COMPANY (Partial) Income Statement For the Year Ended June 30, 2020 Sales Revenues Sales Revenue Less Sales discounts Net Sales Cost of goods sold Finished goods inventory, July 1, 2019 Cost of goods manufactured Cost of goods available for sale Less: Finished goods inventory, June 30, 2020 Cost of goods sold Gross profit Value Value Value 71 (c) Prepare the current assets section of the balance sheet at June 30, 2020 CLARKSON COMPANY (Partial) Balance Sheet June 30, 2020 Assets Value Current assets Cash Accounts Receivable Inventories Finished goods Work in process Raw materials Total current assets Value Value Value Type here to search