This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: FileName: 6146ac33e59024cc79f19a72f2b51c41577e34a7.xls, Tab: Exercise E6-6, Page 1 of 2, 06/07/2009, 07:18:01 Name: Date: Instructor: Course: Exercise E6-6, Cost Allocation Process Salaries (fixed) $60,000 Employee benefits (fixed) 15,000 Depreciation of copy machines (fixed) 15,000 Utilities (fixed) 2,000 Paper (variable, $0.01 per copy) 50,000 Toner (variable, $0.01 per copy) 50,000 Required: Total fixed costs to be allocated = Title Amount Title Amount Title Amount Title Amount Total: Formula Fixed costs allocated to Sales Formula Title Formula Title Formula Title Formula Title Formula Title Formula Managerial Accounting , Second Edition by James Jiambalvo Solving Managerial Accounting Problems Using Microsoft Excel for Windows Templates by Rex A Schildhouse Apex Company's Copy Department, which does almost all of the photocopying for the Sales Department and the Administrative Department, budgets the following costs for the year, based on the expected activity of 5,000,000 copies: The costs are assigned to two cost pools, one for fixed costs and one for variable costs. The costs are then assigned to the The costs are assigned to two cost pools, one for fixed costs and one for variable costs....
View Full Document