Please solve with excel formula if possible

Problem Question 2: Job Costing Ria Inc. is a manufacturer that uses a job order cost system. The following data summarize the operations related to production for February,, the first month of operations: Requisitioned materials for production are as follows: 600 sq.ft. for Job 101 at $12 per sq.ft. 500 sq.ft. for Job 102 at $16 per sq.ft Accumulated direct labor costs as follows: 800 hours of direct labor on Job 101 at $15 per hour 600 hours of direct labor on Job 102 at $18 per hour Ria estimates that total factory overhead costs will be $600,000 for the year. Direct labour hours are estimated to be 40,000 which is used as the overhad allocation base. The company had two completed jobs at the end of January: Jobs 101 and Job 102 Data on the accumulated direct labor hours and units produced for these jobs are as follows: Direct labor hours Job 101 Job 102 Units produced 800 700 600 500 $15.00 per hour Required: A Using the information provided, determine i) The pre-determined factory overhead rate: ii) The amount of factory overhead applied to: Job 101: $9,600 Job 102: $9,600 B Prepare the Job Cost Sheets for Job 101 and 102. Calculate the unit costs for Job 101 and 102. Cost components dm dl applied foh total cost Job 101 Job 102 $7,200 $8,000 12,000 10,800 9,600 9,600 28,800 28,400 B Prepare the Job Cost Sheets for Job 101 and 102. Calculate the unit costs for Job 101 and 102. Cost components dm dl applied foh total cost unit cost units produced Job 101 Job 102 $7,200 $8,000 12,000 10,800 9,600 9,600 28,800 28,400 41 $700.00 $500.00 57 Prepare the journal entries for the total requisition of direct materials and the assignment of direct labor and the allocation of factory overhead during January. Wages are not yet paid. Accounts Debit Credit WIP inventory 15,200 Raw materials inventory 15,200 Total requisition of Direct materials WIP inventory 22,800 Wages payable 22,800 Assignment of direct labor WIP inventory 19,200 Manufacturing overhead 19,200 Allocation of MOH D. Journalize the completion of the Job 101 and 102. Credit Accounts Debit Finished goods inventory 57,200 WIP inventory Completion of Job 101 and 102 57,200 E. Journalize the sale of Job 102 at a selling price of $82 per unit on account. Accounts Debit COGS Finished goods inventory Recording sales Credit 28,800 28,800 19,200 Manufacturing overhead Allocation of MOH D. Journalize the completion of the Job 101 and 102. Accounts Debit Credit Finished goods inventory 57,200 WIP inventory 57,200 Completion of Job 101 and 102 E. Journalize the sale of Job 102 at a selling price of $82 per unit on account. Credit 28,800 Accounts Debit COGS 28,800 Finished goods inventory Recording sales Cash 65,600 Sales Delivery of Job 102 to customer 65,600 Problem Question 2: Job Costing Ria Inc. is a manufacturer that uses a job order cost system. The following data summarize the operations related to production for February,, the first month of operations: Requisitioned materials for production are as follows: 600 sq.ft. for Job 101 at $12 per sq.ft. 500 sq.ft. for Job 102 at $16 per sq.ft Accumulated direct labor costs as follows: 800 hours of direct labor on Job 101 at $15 per hour 600 hours of direct labor on Job 102 at $18 per hour Ria estimates that total factory overhead costs will be $600,000 for the year. Direct labour hours are estimated to be 40,000 which is used as the overhad allocation base. The company had two completed jobs at the end of January: Jobs 101 and Job 102 Data on the accumulated direct labor hours and units produced for these jobs are as follows: Direct labor hours Job 101 Job 102 Units produced 800 700 600 500 $15.00 per hour Required: A Using the information provided, determine i) The pre-determined factory overhead rate: ii) The amount of factory overhead applied to: Job 101: $9,600 Job 102: $9,600 B Prepare the Job Cost Sheets for Job 101 and 102. Calculate the unit costs for Job 101 and 102. Cost components dm dl applied foh total cost Job 101 Job 102 $7,200 $8,000 12,000 10,800 9,600 9,600 28,800 28,400 B Prepare the Job Cost Sheets for Job 101 and 102. Calculate the unit costs for Job 101 and 102. Cost components dm dl applied foh total cost unit cost units produced Job 101 Job 102 $7,200 $8,000 12,000 10,800 9,600 9,600 28,800 28,400 41 $700.00 $500.00 57 Prepare the journal entries for the total requisition of direct materials and the assignment of direct labor and the allocation of factory overhead during January. Wages are not yet paid. Accounts Debit Credit WIP inventory 15,200 Raw materials inventory 15,200 Total requisition of Direct materials WIP inventory 22,800 Wages payable 22,800 Assignment of direct labor WIP inventory 19,200 Manufacturing overhead 19,200 Allocation of MOH D. Journalize the completion of the Job 101 and 102. Credit Accounts Debit Finished goods inventory 57,200 WIP inventory Completion of Job 101 and 102 57,200 E. Journalize the sale of Job 102 at a selling price of $82 per unit on account. Accounts Debit COGS Finished goods inventory Recording sales Credit 28,800 28,800 19,200 Manufacturing overhead Allocation of MOH D. Journalize the completion of the Job 101 and 102. Accounts Debit Credit Finished goods inventory 57,200 WIP inventory 57,200 Completion of Job 101 and 102 E. Journalize the sale of Job 102 at a selling price of $82 per unit on account. Credit 28,800 Accounts Debit COGS 28,800 Finished goods inventory Recording sales Cash 65,600 Sales Delivery of Job 102 to customer 65,600