Please complete in microsoft excel.

1.) Kahanaoi Corporation is a manufacturer that uses job-order costing. The company closes out any overapplied or underapplied overhead to Cost of Goods Sold at the end of the year. The company has supplied the following data for the just completed year: Required: a. What is the journal entry to record raw materials used in production? b. What is the ending balance in Raw Materials? c. What is the journal entry to record the direct and indirect labor costs incurred during the year? d. What is the total amount of manufacturing overhead applied to production during the year? e. What is the total manufacturing cost added to Work in Process during the year? f. What is the journal entry to record the transfer of completed goods from Work in Process to Finished Goods? g. What is the ending balance in Work in Process? h. Is manufacturing overhead overapplied or underapplied for the year? By how much? i. What is the cost of goods available for sale during the year? j. What is the journal entry to record the unadjusted cost of goods sold? k. What is the adjusted cost of goods sold for the year? 1. What is the gross margin for the year? m. What is the net operating income for the year