URGENT HELP REQUIRED

Kindly solve this question on EXCEL & simplify this as much as possible. i want step by step solution so i can easily understand. Thank you soo much in advance. I'll surely appreciate your work & gives u thumbs up!

$ 9 27 6 355 Revenues Q.8 Income statement and schedule of cost of goods manufactured. The following items (in millions) pertain to Calendar Corporation: For Specific Date For Year 2020 Work-in-process inventory. Jan. 1. 2020 S18 Plant utilities Direct materials inventory, Dec. 31, 2020 8 Indirect manufacturing labor Finished goods inventory, Dec. 31. 2020 11 Depreciation plant and equipment Accounts payable, Dec. 31, 2020 24 Accounts receivable, Jan. 1. 2020 52 Miscellaneous manufacturing overhead 15 Work-in-process inventory, Dec 31, 2020 Marketing, distribution, and customer-service costs 94 Finished goods inventory, Jan 1, 2020 47 Direct materials purchased 84 Accounts receivable, Dec 31, 2020 38 Direct manufacturing labor 42 Accounts payable, Jan. 1, 2020 Plant supplies used Direct materials inventory, Jan. 1, 2020 32 Property taxes on plant Required: a) Prepare an income statement and a supporting schedule of cost of goods sold. b) Calculate total prime costs and total conversion costs. c) Calculate total Inventoriable costs and period costs, 3 49