please enter answers in an excel spreadsheet

Irresistable Art produces collectible pieces of art. The company's Raw Materials Inventory account includes the costs of both direct and indirect materials. Account balances for the company at the beginning and ending of Julv 2022 follow: During the month, the company purchased P656,000 of raw material; direct material used during the period amounted to P504,000. Factory payroll costs for July were P788,000 of which 75 percent was related to direct labor. Overhead charges for depreciation, insurance, utilities, and maintenance totaled P600,000 for July. 4) Prepare a schedule of cost of goods manufactured. (5 points) 9) Prepare a schedule of cost of goods sold. (5 points) PROBLEM C Prepare journal entries for the following transactions were incurred by Dimasi Industries during January 2022: 14) Issued P800,000 of direct material to production. 15) Paid 40,000 hours of direct labor at P18 per hour. 16) Accrued 15,500 hours of supervisors and factory janitorial staff at P15 per hour. 17) Recorded P102,100 of depreciation on factory assets. 18) Accrued P32,800 of repairs and maintenance for factory machinery. 19) Issued P25,400 of indirect material to production. 20) Completed goods costing P1,749,300 and transferred them to finished goods