Activity - Baseds Product Costing Suppose that a surgical ward has gathered the following information for four nursing activities and two types of patients for the current period: Required: 1. Determine the total nuasing costs assigned to each potient category, 2. Outpot is measured in potient days. Assiaming that then normal patient categoiv uses 6,000 pabent days and the intensive patient category uses 6,400 jatient ilays. calculate the nursing cost per patient day for each type of pabent. Mound your answers to the nearest cent. Normal per potient day Intenswe 1 per notient day 2. Output is measured in patient days. Assuming that the normal patient category uses 8,000 patient days and the intensive patient category uses 6,400 pstient days. calculate the nursing cost per patient day for each type of patient. Round your answers to the nearest cent. Normal per patient day Intensive per patient day 3. Conceptuat Connection: The supervisor of the surgical ward has sugpested that patent days is the only drver needed to assign narsing costs to each type of patient. Calculate the charge per patent day using this approach. Round your answer to the nearest cent. per patient day 4. Refer to the four data analytuc types in Eatibit 22. Select which data analytic types apply for Requirements one thaugh three (more than one type may apply) Requitement 1 's calculation is in nature as it simply describes what is happening The same is for Requirement 2. Requirement hawever, uses both analytic types: 5. Assume that the accounting department is preparing a bodget for the coming vear the activity rate for each activity is expected to increase by 10%, but the cuanty of the actovity drivers and potent days is expected to remain the same as the current period. a. Using ABC, repeat Requirements 1 and 2 , and describe the data analyoc type(s) being used. b. Describe how Excel mimplifies this calculation, including examples of equations that would be used. tring txcel with established equation: require only that the activity rates be updated. The calculations then be automatically produced