can you guys helped with this question and write it in an excel its due at 11;59 before that would be greatly appriciated

InventoriesRaw materials, beginning$38,000Work in process, beginning12,400Finished goods, beginning8,750Cost of goods manufactured95,290Cost of goods sold83,200(not considering over- or underapplied overhead)Sales100,000Overhead applied80%of direct material costCosts incurred for the periodRaw materials purchases$18,460Direct materials used43,250Direct labor used22,800Factory overhead (actual)Indirect materials used9,300Indirect labor used16,400Other overhead costs4,3001. Complete the T-accounts for each of the three inventory accounts using the data provided in the above table.Raw Materials InventoryRaw materials, ending0Work in Process InventoryWork in process, ending0Finished Goods InventoryFinished goods, ending02. Compute overapplied or underapplied overhead.Overapplied overhead$0