Note: Please provide in excel format (horizontal)

Reddy Company commenced operations in 2012. The company provided the following information for the year ended December 31, 2012.

Required: 1) Prepare a schedule of cost of goods manufactured and sold for the year ended December 31, 2012. 2) Prepare an income statement for the year ended December 31, 2012.

Administrative costs Depreciation on factory equipment Indirect materials Marketing and distribution costs Salaries for factory supervisors Wages for production workers Raw materials used Sales revenue Selling costs Utilities for production facilities Ending work in process inventory Ending finished goods invento $15,000 6,000 1,000 12,000 10,000 13,000 19,000 98,000 9,000 4,000 20,000 10,000