ABCB23Following is partial operating information for TWD Corp for the year ended December 2025ABCDEFGH1JK\table[[2,,],[3,Operating information for the vear ended December 31,2025.,],[4,,Amount ($s)],[5,Accounts,120,000],[6,Depreciation of manufacturing equipment,60,000],[7,Depreciation of office equipment,150,000],[8,Direct manufacturing labor,50,000],[9,Direct Materials Control (01/01/2025),30,000],[10,Direct Materials Control (12/31/2025),340,000],[11,Direct materials purchased,55,000],[12,Finished Goods Inventory Control (01/01/2025),45,000],[13,Finished Goods Inventory Control (12/31/2025),100,000],[14,General office expenses,25,000],[15,Indirect manufacturing labor,80,000],[16,Plant safety costs,95,000],[17,Manufacturing plant utilities,64,500],[18,Marketing and distribution costs,50,000],[19,Miscellaneous manufacturing plant overhead,20,000],[20,Property taxes on manufacturing plant building,75,000],[21,Sales Commision,2,150,000],[22,Sales Revenue,18,000],[23,Salespersons' company vehicle costs,135,000],[24,Work-In-Process Inventory Control (01/01/2025),125,000],[,Work-In-Process Inventory Control (12/31/2025),]]Task 1: Create Summary SchedulesUse direct references (linking) to cells in the Data worksheet to create summary schedules for:a. Direct Materials Used in Productionb. Manufacturing overhead costsc. Selling, general and administrative costsUse cell name to label/name the total of each schedule (you will use these in the next requirements).Make sure you name each schedule as if they were exhibits and format numbers using commas and dollar signs where necessary.1112131415161718192021222324252627ABCDE.FG. HIJkTask 3: Complete the Cost of Goods Sold ScheduleUse the "Vookup" formula to obtain the values for the beginning and ending Finished Goods Inventory from the Data WorksheetUse the names/labels you created in task 2 to link the Cost of Goods Manufactured to the current schedule.Use formulas to generate the subtotalsUse cell formatting to format the schedule in a way that the final schedule resembles the Schedule of COGS in Illustration 2.20 in the textbook.Use cell name to label the Total Cost of Goods Sold amount as "CGS", so you can link/refer to it in the next task(s).Center the schedule titles across columns.M135ABCDEFGH1JLMN0PQTask 4: Create an Income statementUse the "vlookup" function to link the Sales/Revenue information from the Data worksheet.Use the cell names/labels you created in the previous tasks to link the information you need to complete the Income Statement.o Center the Header/Title to the Schedule across columns.M135ABCDEFGH1JLMN0PQTask 4: Create an Income statementUse the "vlookup" function to link the Sales/Revenue information from the Data worksheet.Use the cell names/labels you created in the previous tasks to link the information you need to complete the Income Statement.o Center the Header/Title to the Schedule across columns.A7ABCDEFGH1JKLMN0PTask 5: Recreate T-AccountsUse the information you have generated in the previous tasks to construct the t-accounts for: Direct Materials Control, WIP Control, and FGI Control. Remember the cell names you createdMake use of cell links to complete each t-account; label appropriatelyUse formulas to generate the account balancesCenter the account title across the t-accountUse cell formating to make the accounts resemble those in Illustration 2.18Direct Materials ControlWIP ControlFGI ControlAnswer all parts and show step by step