Could you please create an Excel spreadsheet to complete the problems?

1. Make a Data Section and input the account names and the amounts (from the data given in the problem).

2. Make the statements required in the problem (Cost of Goods Manufactured, Cost of Goods Sold, Income Statement).

3. Answer the questions in Problem 3-51 that are based on your schedules created in Problem 3-50.

W Problem 3-50 Schedule of Cost of Goods Manufactured and Sold; Income Statement ( LO 3-5, (51 3-6) The following data refer to Huron Corporation for the year 20x2. Sales revenue $2.105,000 Indirect material used $ 45,000 Raw-material Depreciation on inventory, 12/31/x1 89.000 factory equipment 60,000 Purchases of raw Insurance on factory material in 20x2 731,000 and equipment 40,000 Raw-material inventory, 12/31/x2 59,000 Utilities for factory 70,000 Direct-labor cost Work-in-process incurred 474,000 inventory, 12/31/x1 -0- Selling and administrative Work-in-process expenses 269,000 inventory, 12/31/x2 40,000 Indirect labor cost Finished-goods incurred 150,000 inventory, 12/31/x1 35,000 Property taxes on Finished-goods factory 90,000 inventory, 12/31/x2 40,000 Depreciation on Applied manufacturing factory building 125,000 overhead 577,500 Income tax expense 25,000 Required: . Prepare Huron's schedule of cost of goods manufactured for 20x2. . Prepare the company's schedule of cost of goods sold for 20x2. The company closes overapplied or underapplied overhead into Cost of Goods Sold. . Prepare the company's income statement for 20x2. . 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. B Problem 3-51 Interpreting the Schedule of Cost of Goods Manufactured ( LO 3-2,(13-6) Refer to the schedule of cost of goods manufactured prepared for Huron Corporation in the preceding problem. Required: 1. How much of the manufacturing costs incurred during 20x2 remained associated with work-in-process inventory on December 31, 20x2? . Suppose the company had increased its production in 20x2 by 20 percent. Would the direct-material cost shown on the schedule have been larger or the same? Why? . Answer the same question as in requirement 2 for depreciation on the factory building. . Suppose only half of the $60,000 in depreciation on equipment had been related to factory machinery, and the other half was related to selling and administrative equipment. How would this have changed the schedule of cost of goods manufactured