Homework: Homework #5 Score: 0.36 of 1 pt 1 of 10 (9 complete) FAM12-A2 (book/static) The following table gives sales, product cost, and cost-to-serve data for a company that makes three product lines: A, B, and C. (Click the icon to view the sales and product cost information.) The cost to serve all customers is $12,000 and is allocated to customer types based on the number of manager visits to custome Read the requirements. Requirement 1. Complete the following table to determine the gross profit margin percentage of sales for each product. (Roundt Product A Product B Product C Total Sales $ 5,000 $ 6,000 $ 25,000 $ 36,000 Cost of sales 4,500 4,800 15,000 24,300 $ Gross profit margin 500 $ 1,200 $ 10,000 $ 11,700 10 20 Gross profit margin % of sales 32.5 % 40 % % % Which product is the most profitable? Product is the most profitable. Requirement 2. Determine the gross profit margin and the gross profit margin percentage of sales for each customer type. Begin by type 2 (Uso percentages rounded to the nearest tenth percent, XX%, in your calculations of gross profit margin. Round dollar amour XX%) Customer Type 1 Product Product B Product C Total Enter any number in the edit fields, then click Check Answer Clear All 4 parts remaining 80 F2 The following table gives sales, product cost, and cost-to-serve data for a company that makes three product lines: A, B, ant (Click the icon to view the sales and product cost information.) The cost to serve all customers is $12,000 and is allocated to customer types based on the number of manager visits to cust Read the requirements Cost of sales 4,500 4,800 15,000 24,300 Gross profit margin $ 500 $ 1,200 $10,000 $ 11,700 10 20 40 32.5 Gross profit margin % of sales % % % Which product is the most profitable? Product is the most profitable. Requirement 2. Determine the gross profit margin and the gross profit margin percentage of sales for each customer type. Begi type 2. (Use percentages rounded to the nearest tenth percent. XX%, in your calculations of gross profit margin. Round dollar ar XX%) Customer Type 1 Product Product Product C Total Sales Gross profit margin Gross profit margin % of sales Enter any number in the edit fields, then click Check Answer parts remaining Clear All esc F2 A # 3 $ 4 2 % 5 & 7 6 E R T 1 of 10 (9 complete) ve data for a company that makes three product lines: A, B, and C. The company has two customer types ation.) o customer types based on the number of manager visits to customer locations for pre- and post-sales sup i Data Table Product A Product B Product C Sales $ 6,000 $ 25,000 Cost of sales 15,000 Total ne erd $ 5,000 4,500 Customer Type 1 $ 500 1.000 13,000 4 4,800 Customer Type 2 $ 4,500 5,000 $ 5,000 customer typ dollar and pc Product A Sales Product B Sales Product Sales Manager Visits 6,000 ype 12,000 25,000 B 16 20 Print Done ck Answer Clear All 3 (A
