Read the following information about the company.

Use the information above to answer 1-3. You MUST show the formulas and calculations as they will be transferred to excel and use cell references.

Glass Company makes glass orders based on the customer specifications, so the company uses job costing to track costs. 1. The company uses direct labor hours as the cost driver for manufacturing overhead application. The company estimated the following manufacturing overhead costs for the yea $787,500 The company estimated the following usage of direct-labor hours for the year 225,000 2. Beginning Work-in-process, March 1 (Job 57) $80,000 3. Beginning Finished Goods, March 1 (Job 55) $150,000 2. Labor Information for March: Direct-labor hours: Job 57 Job 58 Job 59 Labor costs in factory: Direct-labor wages Indirect-labor wages Supervisory salaries 7,000 8,000 5,000 $420,000 $25,000 $30,000 $20,000 $220,000 3. Material Information for March: Raw Materials, Inventory, March 1 Purchase or raw material Direct materials requisitioned: Job 57 Job 58 Job 59 $80,000 $75,000 $51,000 4. Other costs incurred in March: Factory Utilities Sales offices Utilities Administrative offices Utilities Factory equipment repair and maintenance costs Depreciation on factory equipment Manufacturing supplies purchased and used $7,000 $4,000 $3,000 $6,000 $2,000 $5,000 5. During March the following jobs were completed: Job 57 Job 59 6. During March the following jobs were sold for the following amounts: Job 55 Job 59 $200,000 $250,000 1. Develop the predetermined overhead rate. 2. Complete the job cost sheets provided below for the month of March: Job 57 Job 58 Job 59 Beginning Balance Current costs: Direct materials Direct Labor Applied overhead Total Hint: You need to calculate the hourly rate and then compute direct labor cost per job. 3. Determine the ending Work-In-Process Inventory at the end of March and provide the Job number of the job(s) still in Work-in-process at the end of March and the determine total cost of ending work in process for March