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: 766eb49b9a16515f2024ced4bda61565ca31c8ad.xls, Tab: Exercise E8-8, Page 1 of 2, 06/07/2009, Name: Date: Instructor: Course: Exercise E8-8 Customer Profitability Analysis Order processing (per order) $5.00 $8.50 Customer service call (per call) $10.00 $2,000.00 In addition to these costs, product costs amount to 90 percent of sales. In the prior year, Delta had the following experience with one of it's customers, Johnson Brands: Sales $53,800 Number of orders 200 Percent of orders marked rush 60% Calls to customer service 140 Required: Calculate the profitability of the Johnson Brands account. Sales Amount Less: Title Formula Title Formula Title Formula Title Formula Title Formula Formula Profitability of Johnson Brands account Formula Managerial Accounting , Second Edition by James Jiambalvo Solving Managerial Accounting Problems Using Microsoft Excel for Windows Templates by Rex A Schildhouse Using CRM (customer relationship management) software., Delta Products has determined the following Using CRM (customer relationship management) software....
View Full Document