I need all formulas used in excel clearly displayed.

Part 1: The following data refers to Syntax Corporation for the year 20x2 Sales Revenue $2,105,000 Indirect material used Raw materials Inventory, 12/31/X1 89,000 Depreciation on factory equipment Purchases of raw material in 20x2 731,000 Insurance on factory and equipment Raw-material inventory, 12.21/X2 59,000 Utilities for factory Direct labor cost incurred 474,000 Work-in-process inventory, 12/31/x1 Selling and administrative expenses 269,000 Work-in-process inventory, 12.31/X2 Indirect labor cost incurred 150,000 Finished goods inventory, 12/31/x1 Property taxes on factory 90,000 Finished goods inventory, 12/31/X2 Depreciation on factory building 125,000 Applied manufacturing overhead Income tax expense 25,000 45,000 60,000 40,000 70,000 -0- 40,000 35,000 40,000 577,500 Required: Build a calculating Excel spreadsheet to report the following annual documents: a. Syntax's schedule of cost of goods manufactured for 20x2. b. Syntax's schedule of cost of goods sold for 20x2. The company closes under-applied or over-applied overhead into cost of goods sold. C. Syntax's income statement for 20x2. d. After the annual audit by Syntax's external auditor, the following data changed: sales revenue was $2,115,000, applied manufacturing overhead was $580,000, and utilities amounted to $78,000. Your Excel spreadsheet should allow this updated data to be entered and then recalculate all the annual reporting documents