Prepare answers in an Excel workbook 1. Preparing a schedule of cost of goods manufactured Knight Corp., a lamp manufacturer, provided the following information for the year ended December 31, 2014. Inventories: Beginning Ending Raw Materials $ 56,000 $ 23,000 Work-in-Process 103,000 63,000 Finished Goods 41,000 48,000 Other information: Depreciation, plant building and equipment $ 16,000 Raw materials purchases 159,000 Insurance on plant 22,000 Sales salaries 46,000 Repairs and maintenance—plant 8,000 Indirect labor 32,000 Direct labor 122,000 Administrative expenses 59,000 Requirements 1. Use the information to prepare a schedule of cost of goods manufactured. 2. What is the unit product cost if Knight manufactured 2,160 lamps for the year? Learning Objective 4 Learning Objective 4 1. COGM: $432,000 2. Computing cost of goods manufactured and cost of goods sold Use the following information for a manufacturer to compute cost of goods manufactured and cost of goods sold: Inventories: Beginning Ending Raw Materials $ 29,000 $ 32,000 Work-in-Process 44,000 37,000 Finished Goods 19,000 24,000 Other information: Purchases of materials $ 77,000 Direct labor 87,000 Manufacturing overhead 45,000 COGM: $213,000 3. Problem P18-42 is the first problem in a sequence of problems for Davis Consulting, Inc. This company was also used for the Continuing Problems in the financial accounting chapters as the business evolved from a service company to a merchandising company. However, it is not necessary to complete those problems prior to completing P18-42. P18-42 Davis Consulting, Inc. is going to manufacture billing software. During its first month of manufacturing, Davis incurred the following manufacturing costs: Inventories: Beginning Ending Raw Materials $ 10,800 $ 10,300 Work-in-Process 0 21,000 Finished Goods 0 31,500 Other information: Raw materials purchases $ 19,000 Plant janitorial services 700 Sales salaries expense 5,000 Delivery expense 1,700 Sales revenue 750,000 Utilities for plant 10,000 Rent on plant 13,000 Customer service hotline costs 18,000 Direct labor 190,000 Prepare a schedule of cost of goods manufactured for Davis for the month ended January 31, 2016.