Chapter 5 Homework Assignment eBook Activity-Based Product Costing Print Item Suppose that a surgical ward has gathered the following information for four nursing activities and two types of patients for the current period: Patient Patient Category Category Driver Normal Intensive Activity Rate Treating patients Treatments 6,900 8,000 $4.00 Providing hygienic care > Responding to requests Monitoring patients Required: Hygienic hours Requests 5,800 19,600 5.00 32,000 80,000 2.00 Monitoring hours 6,000 72,000 3.00 1. Determine the total nursing costs assigned to each patient category. Costs Assigned Normal Intensive $ $ 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 patient days, calculate the nursing cost per patient day for each type of patient. Round your answers to the nearest cent. Normal $ per patient day Check My Work 3 more Check My Work uses remaining. Previous Next Chapter 5 Homework Assignment Intensive eBook Print Item 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 patient days, calculate the nursing cost per patient day for each type of patient. Round your answers to the nearest cent. Normal Intensive per patient day 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 2-2. 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 analytic types. for Requirement 2. Requirement 3, however, uses both 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 then be automatically produced