Following is partial operating information for TWD Corp for the year ended December $2025$

Operating information for the year ended December $31,2025.$

Accounts Amount $($$s$)$

Depreciation of manufacturing equipment $120,000$

Depreciation of office equipment $60,000$

Direct manufacturing labor $150,000$

Direct Materials Control $(01/01/2025)50,000$

Direct Materials Control $(12/31/2025)30,000$

Direct materials purchased $340,000$

Finished Goods Inventory Control $(01/01/2025)55,000$

Finished Goods Inventory Control $(12/31/2025)45,000$

General office expenses $100,000$

Indirect manufacturing labor $25,000$

Plant safety costs $80,000$

Manufacturing plant utilities $95,000$

Marketing and distribution costs $64,500$

Miscellaneous manufacturing plant overhead $50,000$

Property taxes on manufacturing plant building $20,000$

Sales Commision $75,000$

Sales Revenue $2,150,000$

Salespersons' company vehicle costs $18,000$

Work$-$In$-$Process Inventory Control $(01/01/2025)135,000$

Work$-$In$-$Process Inventory Control $(12/31/2025)125,000$

Task $1$: Generate Summary $/$Support schedules

Use direct references $($linking$)$ to cells in the Data worksheet to create a summary schedules for:

$$ Direct Materials Used in Production

$$ Manufacturing Overhead Costs

$$ Selling General and Administrative expenses

Task $2$: Complete the Cost of Goods Manufactured Schedule

Use the "vlookup" formula to obtain the values for the direct manufacturing labor, beginning and ending WIP balances from the Data Worksheet.

Task $3$: Complete the Cost of Goods Sold Schedule

Use the $$vlookup$$ formula to obtain the values for the beginning and ending Finished Goods Inventory from the Data Worksheet

Task $4$: Generate an Income Statement

Generate an Income Statement for TWD for the year ending $12/31/2025$

Task $5$: Recreate T$-$Accounts

Use the information you have generated in Tasks $1-4$ to construct the T$-$Accounts for: Direct Materials Control, WIP Control, and FGI Control.