Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table gives sales, product cost, and cost-to-serve data for a company that makes three product lines: A, B, and C. The company has

image text in transcribed

image text in transcribed

image text in transcribed

The following table gives sales, product cost, and cost-to-serve data for a company that makes three product lines: A, B, and C. The company has two customer types. Click the icon to view the sales and product cost information.) The cost to serve all customers is $11,600 and is allocated to customer types based on the number of manager visits to customer locations for pre- and post-sales support. Read the requirements. Requirement 1. Complete the following table to determine the gross profit margin percentage of sales for each product. (Round the percentages to the nearest tenth percent, X.X%.) Product A Product B Product C Total Sales Cost of sales Gross profit margin Gross profit margin % of sales % % % % Enter any number in the edit fields and then click Check Answer. Clear All 6 parts remaining Int i Data Table Product A Product B Product C Sales $ 4,600 $ 5,700 $ 28,000 Cost of sales 4,100 4,600 13,000 Customer Type 1 Customer Type 2 Total Product A Sales $ 1,600 $ 3,000 $ 4,600 Product B Sales 1,000 4,700 5,700 Product C Sales 17,000 11,000 28,000 Manager Visits 6 14 20 Print Done i Requirements X 1. Determine the gross profit margin percentage of sales for each product. Which product is the most profitable? 2. Determine the gross profit margin and the gross profit margin percentage of sales for each customer type. 3. Determine the cost-to-serve percentage of sales for each customer type. 4. Determine the operating income and operating income percentage of sales for each customer type. 5. Which customer is the most profitable based the following profitability measures: a. Gross margin b. Gross margin percentage of sales c. Operating income d. Operating income percentage of sales Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

More Books

Students also viewed these Accounting questions