Suppose that a surgical ward has gathered the following information for four nursing activities and two types of patients for the current pariod: Required: 1. Determine the total nursing costs assigned to each patient category. 2. Output is measured in patient days. Assuming that the normal patient category uses 8,000 patient days and the internsive patient category uses 6,40 patient days, calculate the nursing cost per patient doy for each type of patient. Round your answers to the nearest cent. Normal per patient day Intensive per patient day Normal per patient day Intensive per patient day 3. Conceptual Connection: The supervisor of the surgical ward has suggested that patient days is the only driver needed to assign nursing costs to each type of patient. Calculate the charge per patient day using this approach. Round your answer to the nearest cent. per patient day 4. Refer to the four data analytic types in Exhibit 22. Select which data analytic types apply for Requirements one through three (more than one type may apply). Requirement 1 's calculation is in nature as it simply describes what is happening. The same is for Requirement 2, Requirement 3, however, uses both analytic types. 5. Assume that the accounting department is preparing a budget for the coming year. The activity rate for each activity is expected to increase by 10%, but the quantity of the activity drivers and patient days is expected to remain the same as the current period. a. Using ABC, repeat Requirements 1 and 2 , and describe the data analytic type(s) being used. b. Describe how Excel simplifies this calculation, including examples of equations that would be used. Using Excel with established equations require only that the activity rates be updated. The calculations be automatically produced