good day , kindly provide the answers with clear solutions preferrably in excell. thankyou . cost accounting

Problem 9 The EDSA Corporation manufactures a product in two departments. Materials are added in cach department, increasing the numbor of units manufactured. A summary of the cost for tho company's first month of operations (January) is as follows: 202203.31 17:23 P Materials Labor Factory Overhead Dopartment1 180,000 78,000 15,600 Department 2 135,000 82,800 41,400 The production supervisor reports that 60,000 units wore put into production in Department 1. Of this quantity, 15,000, a normal number, were lost in production; and 36,000 were completed and transferred to Department 2. For the balance in process at the end of the month, all materials had been added, but only one third of the labor and factory overhead had been applied. In Department 2, 9,000 units of materials were purchased outside and added to the units received from Department 1; 39,000 were completed and transferred to finished goods inventory. The remainder were in process at the end of the month, with all Bierials adjut, but only 40% coniplcle for labor and factory overhead. Required: Cost of production report