Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How would I solve this The following table gives sales, product cost, and cost-to-serve data for a company.' that makes three product lines: A, B,

image text in transcribedimage text in transcribedimage text in transcribed

How would I solve this

image text in transcribedimage text in transcribedimage text in transcribedimage 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. E [Click the icon to View the sales and product cost information.) The cost to serve all customers is $12,915 and is allocated to customer types based on the number of manager visits to customer locations for pri.L and post-sales support. Read the reguiremenls. Requirement 1. Complete the fol owing table to determine the gross prot margin percentage of sales for each product (Round the percentages to the nearest tenth percent, X.X%.) Product A Product B Product 0 Total Sales I Cost of sales I % |_% Gross profit margin Gross profit margin '56 of sales % '3': 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 salesProduct A Product B Product C Sales 4,500 5,600 $ 31,500 Cost of sales 3,900 4,400 16,000 Customer Type 1 Customer Type 2 Total Product A Sales 800 3,700 4,500 Product B Sales 1,400 4,200 5.600 Product C Sales 14,500 17,000 31,500 Manager Visits 12 21Product A Product B Product C Total Sales Cost of sales Gross profit margin Gross profit margin % of sales % % % %

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_2

Step: 3

blur-text-image_3

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

Understanding Financial Accounting

Authors: Christopher D. Burnley

2nd Canadian Edition

1119406927, 978-1119406921

More Books

Students also viewed these Accounting questions

Question

3. How much information do we need to collect?

Answered: 1 week ago

Question

2. What types of information are we collecting?

Answered: 1 week ago

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago