70.2K

Verified Solution

Link Copied!

Reposted: I need help with the excel with formulas for this problem 5-65; Managerial Accounting creating value in dynamic business environment 11th edition. I need to submit this homework by this afternoon by 6pm. Thank you.

Problem 5-65 Customer-Profitability Analysis; Activity-Based Costing Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunications industries. At the request of the company vice president of marketing, the cost management staff has recently completed a customer-profitability study. The following activity-based costing information was the basis for the analysis. Cost Driver Rate $1.000 Customer Related Activities Sales active Order taking Special handling Special shipping Cost Driver Base Sales vests Purchase orders Units handled Shipments 500 Cost-driver data for two of Fresno's customers for the most recent year are Customer Related Activities Sales activity Order taking Special handling Special shipping Trace Telecom B visits 15 orders. 800 units handled. 18 shipments Caltex Computer 6 visits 20 orders 600 units handled 20 shipments The following additional information has been compiled for Fresno Fiber Optics for two of its cus tomers, Trace Telecom and Caltex Computer, for the most recent year: Sales revenue Cost of goods sold. General selling costs... General administrative costs Trace Telecom $190,000 80,000 24.000 19.000 Caltex Computer $123,800 62.000 18.000 16,000 Required: 1. Prepare a customer profitability analysis for Trace Telecom and Caltex Computer. (Hiru: Refer to Exhibit 5-13 for guidance.) 2. Build a spreadsheet: Construct an Excel spreadsheet to solve requirement (1) above. Show how the solution will change if the following information changes: Trace Telecom's sales revenue was $185 DOO and Caltex Computer's cost of goods sold was $59.000. Problem 5-65 Customer-Profitability Analysis; Activity-Based Costing Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunications industries. At the request of the company vice president of marketing, the cost management staff has recently completed a customer-profitability study. The following activity-based costing information was the basis for the analysis. Cost Driver Rate $1.000 Customer Related Activities Sales active Order taking Special handling Special shipping Cost Driver Base Sales vests Purchase orders Units handled Shipments 500 Cost-driver data for two of Fresno's customers for the most recent year are Customer Related Activities Sales activity Order taking Special handling Special shipping Trace Telecom B visits 15 orders. 800 units handled. 18 shipments Caltex Computer 6 visits 20 orders 600 units handled 20 shipments The following additional information has been compiled for Fresno Fiber Optics for two of its cus tomers, Trace Telecom and Caltex Computer, for the most recent year: Sales revenue Cost of goods sold. General selling costs... General administrative costs Trace Telecom $190,000 80,000 24.000 19.000 Caltex Computer $123,800 62.000 18.000 16,000 Required: 1. Prepare a customer profitability analysis for Trace Telecom and Caltex Computer. (Hiru: Refer to Exhibit 5-13 for guidance.) 2. Build a spreadsheet: Construct an Excel spreadsheet to solve requirement (1) above. Show how the solution will change if the following information changes: Trace Telecom's sales revenue was $185 DOO and Caltex Computer's cost of goods sold was $59.000

Answer & Explanation Solved by verified expert

See Answer