I am struggling with the correct formulas for this problem. Please use excel and show the formulas for part 1. Thank you!!

Ch. 19 Problem: Job Costing Marcelino Co.'s March 31 inventory of raw materials is $88,000. Raw materials purchases in April are $520,000, and factory payroll cost in April is $375,000. Overhead costs incurred in April are: indirect materials, $60,000; indirect labor, $21,000; factory rent, $36,000; factory utilities, $24,000; and factory equipment depreciation, $57,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $640,000 cash in April. Costs of the three jobs worked on in April follow. Job 306 Job 307 Job 308 27,000 22,000 11,000 38,000 16,000 8,000 Balances on March 31 Direct materials Direct labor Applied overhead Costs during April Direct materials Direct labor Applied overhead Status on April 30 140,000 101,000 215,000 152,000 ? Finished (unsold) 105,000 101,000 ? ? Finished (sold) In process Job 308 Part 1: Determine the overhead applied in April and the total costs for each job. Job 306 Job 307 Overhead applied in April Total Costs Part 2: Prepare journal entries for the month of April to record the following transactions. a. Materials purchases (on credit). b. Direct materials used in production. c. Direct labor paid and assigned to Work in Process Inventory. d. Indirect labor paid and assigned to Factory Overhead. e. Overhead costs applied to Work in Process Inventory. f. Actual overhead costs incurred, including indirect materials. (Factory rent and utilities are paid in cash.) g. Transfer of Jobs 306 and 307 to Finished Goods Inventory. h. Cost of goods sold for Job 306. i. Revenue from the sale of Job 306. j. Assignment of any underapplied or overapplied overhead to the cost of Goods Sold account. Item # Account Titles Debit Credit