Information Estimated Estimated Indirect Allocation Quantity of Activity Activity Costs Base Allocation Base Applications development $ 3,420,000 New applications 9 new applications Content production 2,890,000 Lines of code 17 million lines Testing 432,000 Testing hours 2,400 testing hours 6,742,000 Total indirect costs Whittle is planning to develop the following new applications: X-Pagesoftware for developing personal webpages X-Secure-commercial security and firewall software X-Page requires 520,000 lines of code and 160 hours of testing, while X-Secure requires 5.2 million lines of code and 960 hours of testing. Whittle expects to produce and sell 25,000 units of X-Page and 17 units of X-Secure. Print Done i 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. Whittle's original single-allocation-based cost system allocated indirect costs to products at $130 per programmer hour. X-Page requires 6,000 programmer hours, while X-Secure requires 9,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 Whittle's ABC system is likely to pass the cost-benefit test? Print Done Whittle develops software for internet applications. The market is very competitive, and Whittle's competitors continue to introduce new products at low prices. Whittle offers a wide variety of softwarefrom simple programs that enable new users to create personal webpages to complex commercial search engines. Like most software companies, Whittle's raw material costs are insignificant Whittle 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.) Requirements Requirement 1. Compute the cost allocation rate for each activity Determine the formula and then compute the cost allocation rate for each activity. (Round your answers to the nearest cent.) Activity overhead rate Appl. Dev. application Content prod. line Testing /hour Requirement 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.) (Round the cost per unit to the nearest cent.) X-Page X-Secure Applications development Content production Testing Total costs Number of units Per unit cost Requirement 3. Whittle's original single-allocation-based costing system allocated indirect costs to products at $130 per programmer hour. X-Page requires 6,000 programmer hours, while X-Secure requires 9,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. First, compute the total indirect costs allocated to X-Page and X-Secure under the original single-allocation-based system. Select the formula and then enter the amounts and calculate the indirect cost allocated. Indirect cost Product allocated X-Page X-Secure X Now compute the indirect cost per unit for each product under the original single-allocation-based system. Begin with X-Page and then compute X-Secure. (Round the cost per unit to the nearest cent.) X-Page X-Secure Total indirect costs allocated Number of units Per unit cost Requirement 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. The original system X-Page and X-Secure. The original system allocated overhead to X-Secure than to X-Page. However, X-Secure required times as many lines of code and times as much testing as X-Page. The ABC system this difference and allocates V of the content production and testing costs to X-Secure. Requirement 5. What are the clues that Whittle's ABC system is likely to pass the cost-benefit test? Whittle's different software applications use Whittle has costs Whittle produces Whittle is in Whittle has