Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Power Corporation sells a line of power tools to home improvement chains, generating a cost of goods sold equal to 50% of net sales. The

Power Corporation sells a line of power tools to home improvement chains, generating a cost of goods sold equal to 50% of net sales. The selected data that follow relate to the period just ended for the company's three largest customers: Weekend Project, Tool Mart, and Fix-It City.

Power's management recently attended a seminar and learned that customers with excessive requests and demands can have a significant, negative impact on corporate profitability.

Gross sales volume:

Dollars $ 1,960,000 $ 4,820,000 $ 5,000,800

Number of Orders 50 183 133

Type of order:

Regular 36 139 114

Rush 14 44 19

Sales returns:

Dollars $ 104,000 $ 394,000 $ 244,000

Number of returns 7 24 12

Total customer-related costs $ 249,000 $ 899,000 $ 448,000

Required:

For each of the three chains, compute: (For Requirement 1, 3-4, round your answers to 2 decimal places. Round "Average order size" to the nearest whole number.)

1. Total customer-related costs as a percentage of gross margin.

2. The average order size (ignoring sales returns).

3. The ratio of regular orders to rush orders.

4. The number of sales returns as a percentage of the number of total orders.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Managers Using Microsoft Excel

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

7th Edition

978-0133061819, 133061817, 978-0133130805

Students also viewed these Accounting questions