i need to solve every single question.

Excel Assignment 2 Helene Grimaud Corp has been asked to produce pianos for a local music academy. For the year, Grimaud estimates $1,000,000 in overhead costs to be allocated across 4,000 machine hours. Please use the following business events to create: 1. Journal Entries 2. A Cost of Goods Manufactured Schedule 3. A Cost of Goods Sold Schedule 4. An Operating Income Statement (Stop at Operating Income) Be sure to correct for any over or underapplied overhead. There is no need to show T-Accounts. A. $40,000 in materials are purchased on account B. $35,000 of materials were taken from inventory for use in production C. Direct labor for the project was $85,000. Indirect labor was $40,000 and non-factory salaries were $20,000. All salaries are paid in cash. D. Advertising expenses were $10,000 and were paid in cash. E. Depreciation was $70,000. 60% was related to factory assets and the rest was for non-factory assets. F. Total rental payments were $30,000 in cash. 20% was related to factory space and the other 80% is for non- factory buildings. G. Utility expenses were $12,000 and were paid in cash. $3,500 came from the factory and the rest was from administrative, non-production buildings H. Manufacturing overhead is applied to jobs. The pianos took 300 machine hours to produce. I. $210,000 worth of product is moved into finished goods inventory. J. Goods are sold for $580,000 on account. Cost of goods sold is $190,000 according to the job cost sheets. Beginning Balances Raw Materials $22,000 Works in Process $18,000 Finished Goods $9,000