complete solution at whole excel table please:

Predetermined Overhead Rate (POHR):

The following information is for Maligaya Metals Corporation for the year just ended 2020

Budgeted direct labor cost: 87,500 hours at $20 per hour.

Actual direct labor cost: 89,000 hours at $21 per hour.

Budgeted manufacturing overhead: $1,200,000

Budgeted Seling and Administrative Expenses: $400,000

Actual Manufacturing Overhead: Depreciation.....$220,000

Property Taxes......$25,000

Indirect Labor.....$75,000

Supervisor's salaries.....$220,000

Utilities.....$54,000

Insurance......$23,000

Rent......$300,000

Indirect Material (see below).....$79,000

Indirect Material:

Beginning Inventory, Jan. 1......$49,000 Purchases during the year.....$105,000

Ending Inventory, Dec. 31.....$60,000

Required:

A.) Calculate the Predetermined Overhead Rate

B.) Calculate the overapplied/underapplied overhead for the year

C.) Prepare a Journal Entry to close out the Manufacturing Overhead account into the Cost of Goods Sold.