This file is used with Problem 6C-4, and contains the three worksheet tabs listed below. Simply click on the tab you wish to view. 1. "Working Trial Balance" contains the KCN Working Trial Balance for the year ended December 31, 20X5 (unadjusted) and 20X4 (adjusted). 2. "Financial Statements" contains comparative KCN Financial Statements which are the results of the adjusted working trial balance amounts for 20X5 and 20X4. 3. "Ratios" contains the Financial Statement Ratios calculated from KCN Financial Statements, both for 20X5 and for 20X4. Required: a. Recalculate the 12/31/X5 and 12/31/X4 ratios using Excel on the Ratios schedule. b. Identify financial statement accounts that should be investigated because the related ratios are not what one would expect as compared to the prior-year ratios, industry averages, or your knowledge of th company. c. For each account identified in part b., list potential reasons for the unexpected account balances and related ratios.

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?