The following data refer to Huron Corporation for the year 20x2.

Required:
1. Prepare Huron’s schedule of cost of goods manufactured for 20x2.
2. Prepare the company’s schedule of cost of goods sold for 20x2. The company closes overapplied or underapplied overhead into Cost of Goods Sold.
3. Prepare the company’s income statement for 20x2.
4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements.
Show how the solution will change if the following data change: sales revenue was $2,115,000, applied manufacturing overhead was $580,000, and utilities amounted to $78,000.

Transcribed Image Text:

Sales revenue Raw-material inventory, 12/31/x1 Purchases of raw material in 20x2 Raw-material inventory, 12/31/x2 Direct-labor cost incurred.............. Selling and administrative expenses Indirect labor cost incurred Property taxes on factory Depreciation on factory building Income tax expense $2,105,000 89,000 731,000 59,000 474,000 269,000 150,000 90,000 125,000 25,000 Indirect material used Depreciation on factory equipment Insurance on factory and equipment. Utilities for factory. Work-in-process inventory, 12/31/x1 Work-in-process inventory, 12/31/x2 Finished-goods inventory, 12/31/x1 Finished-goods inventory, 12/31/x2 Applied manufacturing overhead $ 45,000 60,000 40,000 70,000 -0- 40,000 35,000 40,000 577,500