Help with question 2 about the job cost sheets

A Part 1: Relates to Module 18 and I have support videes in the Module 18 Resources in the applicable weekly folder. The scenario to this part is below and the requirements folow where you wil answer the questions pertaining to this part. The sconario to this part is below and the requirements folow where you wil answer the questions pertaining to this part. Glass Company makes glass onders based on the customer specifications, so the company uses job costing to track costs 1. The company uses dirsct labor hours as the cost driver far manufacturing avericad appication. The company estimated the folowing manufacturing averhead costs for the year. The company estimated the folowing usage of direct-labor hours for the year. 2. Beginning Work-in-process, March 1 (Job 55) \begin{tabular}{|r|r|r|} \hline$240,000 & & \\ \hline 150,000 & & \\ \hline$20,000 & & \\ \hline \end{tabular} 3. Beginning Finkshed Goods, March 1 (Job 57) 2. Labor Information for March: Direct-labor hours: 3. Material Information for March: Raw Materials. Inventory, March 1 Purchase or rew material Direct materials requisitioned: Job 55 Job 59 4. Other costs incurred in March: FactoryUlilitiesSalesofficesUlilitesAdministrativeofficesUilitiesFactoryoquipmentmpairandmaintenancecostsDepreciationonfactoryequipmentManufacturingsupplespurchasedandused$1,700$1,000$2,000$1,900$3,100$2,200 5. During March the following jobs were completed: Job 55 Job 58 6. During March the following jobs were sold for the following amounts: Job 57 Job 58 $90,000 $210,000 Required: You need to use cell references to provide answers and calculations. There are 9 questions in Part 1. 1. Develop the predetermined overhead rate. 2. Complete the job cost sheets provided below for the month of Mareh: Beginning Balance Current costs: Direct materials Direct Labor Hint You need to calculate the hourly rate and then compute direct labor cost per job. Applied overhead