In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage (or the difference between the total payments made each year and the total amount of mortgage principal paid each year).

a. The formula should first check if the value in cell H4 (the balance remaining on the loan each year) is greater than 0.

b. If the value in cell H4 is greater than 0, the formula should return the value in J4 subtracted from the value in cell D5 multiplied by 12. Use a relative cell reference to cell J4 and an absolute cell reference to cell D5. (Hint: Use 12*$D$5-J4 as the is_true argument value in the formula.)

c. If the value in cell H4 is not greater than 0, the formula should return a value of 0.

During the year, the delph company had no beginning or ending inventories and it started, completed, and sold only two jobs—job d-75 and job c-100. it provided the following information related to those two jobs: job d-75: molding fabrication total direct materials cost $ 375,000 $ 325,000 $ 700,000 direct labor cost $ 200,000 $ 160,000 $ 360,000 machine-hours 15,000 5,000 20,000 job c-100: molding fabrication total direct materials cost $ 300,000 $ 250,000 $ 550,000 direct labor cost $ 175,000 $ 225,000 $ 400,000 machine-hours 5,000 25,000 30,000delph had no overapplied or underapplied manufacturing overhead during the year. assume delph uses a plantwide overhead rate based on machine-hours.1-a. compute the predetermined plantwide overhead rate.1-b. compute the total manufacturing costs assigned to job d-70 and job c-200.1-c. if delph establishes bid prices that are 150% of total manufacturing costs, what bid price would it have established for job d-70 and job c-200? 1-d. what is delph's cost of goods sold for the year? assume delph uses departmental overhead rates based on machine-hours.2-a. compute the predetermined departmental overhead rates.2-b. compute the total manufacturing costs assigned to job d-70 and job c-200.2-c. if delph establishes bid prices that are 150% of total manufacturing costs, what bid price would it have established for job d-70 and job c-200? 2-d. what is delph's cost of goods sold for the year?