Varney Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services Department (CCS) costs to profit centers. The following table lists the types of services and cost drivers for each service. The table also includes the budgeted cost and quantity for each service for August. One of the profit centers for Varney Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM: REQUIRED: Compute the ratio of liabilities to stockholders' equity for each year. Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Select the corresponding units in the dropdowns in cells D26:D29. Transfer amounts to CNOWv2 for grading. Compute the allocation of CCS's services to COMM for August. Varney Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services Department (CCS) costs to profit centers. The following table lists the types of services and cost drivers for each service. The table also includes the budgeted cost and quantity for each service for August. One of the profit centers for Varney Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM: REQUIRED: Compute the ratio of liabilities to stockholders' equity for each year. Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Select the corresponding units in the dropdowns in cells D26:D29. Transfer amounts to CNOWv2 for grading. Compute the allocation of CCS's services to COMM for August