Data table McNeil Internet is planning to develop the following new applications: - X-Page - software for developing personal webpages - X-Secure-commercial security and firewall software X-Page requires 660,000 lines of code and 110 hours of testing, while X-Secure requires 9.9 million lines of code and 660 hours of testing. McNeil Internet expects to produce and sell 45,000 units of X-Page and 12 units of X-Secure. Requirements 1. Compute the cost allocation rate for each activity. 2. Use the activity based cost allocation rates to compute the indirect cost of each unit of X-Page and X-Secure. (Hint: Compute the total activity costs allocated to each product line and then compute the cost per unit.) 3. McNeil Internet's original single-allocation-based cost system allocated indirect costs to products at $118 per programmer hour. X-Page requires 16,000 programmer hours, while X-Secure requires 24,000 programmer hours. Compute the total indirect costs allocated to X-Page and X-Secure under the original system. Then, compute the indirect cost per unit for each product. 4. Compare the activity-based costs per unit to the costs from the simpler original system. How have the unit costs changed? Explain why the costs changed as they did. 5. What are the clues that McNeil Internet's ABC system is likely to pass the cost-benefit test? McNeil Internet develops software for internet applications. The market is very competitive, and McNeil Internet's competitors continue to introduce new products at low prices. McNeil Internet offers a wide variety of software-from simple programs that enable new users to create personal webpages to complex commercial search engines. Like most software companies, McNeil Internet's raw material costs are insignificant. McNeil Internet has just hired Nicole Merrell, a recent university graduate in accounting. Merrell asks Software Department Manager Jeff Gire to join her in a pilot activity based costing study. Merrell and Gire identify the following activities, related costs, and cost-allocation bases: (Click the icon to view the information.) Requirement 1. Compute the cost allocation rate for each activity. Determine the formula, then compute the cost allocation rate for each activity. (Round your answers to the nearest cent.)