Using the information above, please:

1. Create the 2017 Manufacturing Statement

2. Calculate the 2017 Cost of Goods Sold

3. Create a partial 2017 General Ledger and include the following T-accounts:

-Raw Materials Inventory

-Work In Process Inventory

-Finished Goods Inventory

-Cost of Goods Sold

4. Calculate the total for each T-account (do not link the total)

Please use Excel links and formulas for amounts whenever possible! Thank you!

Accounts Balance 2017 Schedule of Cost of Goods Manufacture 2 Advertising expense 3 Depreciation expense-Office equipment 4 Depreciation expense-Selling equipment 7,800 10,500 32,600 137,800 7,900 35,000 5 Depreciation expense Factory equipment 6 Factory supervisiorn 7 Factory supplies used 8 Factory utilities 9 10 Raw materials, December 31, 2016 11 Raw materials, December 31, 2017 12 Work in process, December 31, 2016 13 Work in process, December 31, 2017 14 Finished goods, December 31, 2016 15 Finished goods, December 31, 2017 16 Direct labor 17 Income taxes expense 18 Indirect labor 19 Miscellaneous production costs 20 Office salaries expense 21 Raw materials purchases 22 Rent expense-Office space 23 Rent expense-Selling space 24 Rent expense-Factory building 25 Maintenance expense-Factory equipment 26 Salaries expense 27 Sales Inventories Close Full Screen 158,700 187,000 15,500 21,600 166,200 144,700 686,400 251,600 58,700 9,200 75,000 985,000 28,000 28,500 77,700 39,000 392,200 4,465,2000 2017 Cost of Goods Sold