Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers.Number of ordersUnits per orderSales returns:Number of returnsTotal units returnedNumber of sales callsJerry,IncorporatedKateCompany6301,0004204550131405Colleen sells its products at $290 per unit. The firm's gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly andno accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30months, the firm has determined the following activity costs:ActivitySales callsCost Driver and Rate$800 per visitOrder processingDeliveriesSales returnsSales salaryRequired:180 per order410 per order270 per return and $3 per unit returned107,000 per month1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level, etc.) and compute the totalcost for Colleen Company to service Jerry, Incorporated and Kate Company.2. Compare the profitability of these two customers.Complete this question by entering your answers in the tabs below.Required 1Required 2Compare the profitability of these two customers. (Loss amounts should be indicated by a minus sign. Round operatingmargin (loss) to 2 decimal places (i.e. 0.2134 should be entered as 21.34%).)

Profitability analysis is a financial analysis method used to evaluate the profitability of a…

Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Incorporated Kate Company Number of orders 6 30 Units per order 1,000 420 Sales returns: Number of returns 4 5 Total units returned 50 13 140 5 Number of sales calls Colleen sells its products at $290 per unit. The firm's gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Sales calls Order processing Deliveries Sales returns Sales salary Required: Cost Driver and Rate $800 per visit 180 per order 410 per order 270 per return and $3 per unit returned 107,000 per month 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level, etc.) and compute the total cost for Colleen Company to service Jerry, Incorporated and Kate Company. 2. Compare the profitability of these two customers.

Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Incorporated Kate Company Number of orders 6 30 Units per order 1,000 420 Sales returns: Number of returns 4 5 Total units returned 50 13 140 5 Number of sales calls Colleen sells its products at $290 per unit. The firm's gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Sales calls Order processing Deliveries Sales returns Sales salary Required: Cost Driver and Rate $800 per visit 180 per order 410 per order 270 per return and $3 per unit returned 107,000 per month 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level, etc.) and compute the total cost for Colleen Company to service Jerry, Incorporated and Kate Company. 2. Compare the profitability of these two customers.

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter6: Merchandising Transactions

Section: Chapter Questions

Problem 19Q: The following is select account information for Sunrise Motors. Sales: $256,400; Sales Returns and...

See similar textbooks

Similar questions

Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Number of orders Units per order Sales returns: Number of returns Total units returned Jerry, Incorporated 6 Kate Company 60 3,000 460 4 50 15 3 190 4 es Number of sales calls Colleen sells its products at $230 per unit. The firm's gross margin ratio is 25%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Sales calls Deliveries Cost Driver and Rate $800 per visit 280 per order. 440 per order Order processing 240 per return and $3 per unit returned 83,000 per month. Sales returns Sales salary Required: 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level, etc.) and compute the total cost for Colleen…
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Number of orders Units per order Sales returns: Number of returns Total units returned Jerry, Incorporated 5 Kate Company 60 2,000 220 3 30 13 5 190 6 Number of sales calls Colleen sells its products at $290 per unit. The firm's gross margin ratio is 25%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Sales calls Deliveries Cost Driver and Rate $1,000 per visit 200 per order 440 per order Order processing 290 per return and $6 per unit returned 99,000 per month Sales returns Sales salary Required: 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level, etc.) and compute the total cost for Colleen Company…
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. Number of orders Units per order Sales returns: Number of returns Total units returned Number of sales calls Activity Sales calls Order processing Deliveries Sales returns Sales salary 3 1,000 1 50 11 olleen sells its products at $190 per un The firm's gross margin ratio is 25%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Kate Co. 60 400 Required 1 Required 2 5 130 3 Cost Driver and Rate $ 600 per visit 270 per order 180 per order 210 per return and $4 per unit returned 95,000 per month Required: 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level, etc.) and compute the total cost for Colleen…
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. Kate Co. Number of orders 6 30 Units per order 2,000 440 Sales returns: Number of returns 4 5 Total units returned 60 180 Number of sales calls 11 3 Colleen sells its products at $180 per unit. The firm’s gross margin ratio is 25%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Cost Driver and Rate Sales calls $ 800 per visit Order processing 420 per order Deliveries 400 per order Sales returns 290 per return and $3 per unit returned Sales salary 114,000 per month Required: 1. Using customers as the cost objects, classify the activity costs…
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Incorporated Kate Company Number of orders 4 50 Units per order 3,000 160 Sales returns: Number of returns 2 5 Total units returned 40 120 Number of sales calls 14 3 Colleen sells its products at $280 per unit. The firm’s gross margin ratio is 25%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Cost Driver and Rate Sales calls $600 per visit Order processing 240 per order Deliveries 480 per order Sales returns 270 per return and $6 per unit returned Sales salary 94,000 per month Required: 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level,…
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Number of orders Units per order Sales returns: Number of returns Total units returned Number of sales calls Jerry, Incorporated 6 Kate Company 38 1,000 420 4 50 13 148 5 Colleen sells its products at $290 per unit. The firm's gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Sales calls Order processing Deliveries Sales returns Sales salary Required: Cost Driver and Rate $800 per visit 180 per order 410 per order 270 per return and $3 per unit returned 107,000 per month 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level, etc.) and compute the total cost for Colleen Company to…
Assume that you have a company. And the management team estimates that 3% of sales will be uncollectible. Give any amount of sales and prepare the journal entry using the percent of sales method.
ssence of Skunk Fragrances, Ltd., sells 6,900 units of its perfume collection each year at a price per unit of $399. All sales are on credit with terms of 2/30, net 50. The discount is taken by 50 percent of the customers. a.What is the amount of the company’s accounts receivable? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)b.In reaction to sales by its main competitor, Sewage Spray, Essence of Skunk is considering a change in its credit policy to terms of 4/30, net 50 to preserve its market share. Will this change in policy increase or decrease accounts receivable?
Saimdang Co. has the following business rules.1. Customers place many orders during the period2. Each sales order consists of one or more line items of inventory3. Customers are billed twice a month for the purchases that they made during the period4. Customers make payments once a month to settle their accountsRequired: Prepare an entity-relationship diagram (must include entities and cardinalities) for eachbusiness rule
Computers and More offers discounts to its customers and allows the customer to return the product if not satisfied. Computers and More had sales of $850,000 and offers the customer a payment term of 3/12 n/30. The company received $15,000 in returned goods. The cost of goods sold for the period after returns was $320,000. Calculate net profit and gross profit.
The Happy Auto Shop has the following annual information: gross sales,$700,000; net sales, $696,000; and gross profit, $448,000. What are theshop’s returns and allowances and cost of goods sold?
Prairie Manufacturing has four possible suppliers, all of which offer different credit terms. Except for the differences in credit terms, their products and services are virtually identical. The credit terms offered by these suppliers are shown in the following table: LOADING... (Note: Assume a 365-day year.) Supplier Credit terms J 2/15 net 40 EOM K 2/20 net 80 EOM L 1/10 net 60 EOM M 3/10 net 100 EOM a. Calculate the approximate cost of giving up the cash discount from each supplier. b. If the firm needs short-term funds, which are currently available from its commercial bank at 10%, and if each of the suppliers is viewed separately, which, if any, of the suppliers' cash discounts should the firm give up? c. Now assume that the firm could stretch by 30 days its accounts payable (net period only) from supplier M. What impact, if any, would that have on your answer in part b relative to this…