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,Incorporated6KateCompany381,000420450131485Colleen 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 callsOrder processingDeliveriesSales returnsSales salaryRequired:Cost Driver and Rate$800 per visit180 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 1 Required 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%).)Net salesOperating income (loss)Operating margin (loss)Jerry,IncorporatedKate Company

Operating Income -An accounting indicator known as operating income, or income from operations,…

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 140 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 Cost Driver and Rate $800 per visit 180 per order 410 per order 270 per return and $3 per unit returned

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 140 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 Cost Driver and Rate $800 per visit 180 per order 410 per order 270 per return and $3 per unit returned

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 Number of sales calls Jerry, Incorporated Kate Company 6 30 1,000 420 4 5 50 13 140 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 Cost Driver and Rate $800 per visit Order processing Deliveries Sales returns Sales salary Required: 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…
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. 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. 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,…
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.
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.
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
The following is select account information for August Sundries. Sales: $850,360; Sales Returns and Allowances: $148,550; COGS: $300,840; Operating Expenses: $45,770; Sales Discounts: $231,820. If August Sundries uses a multi-step income statement format, what is their gross margin?
The following is select account information for Sunrise Motors. Sales: $256,400; Sales Returns and Allowances: $34,890; COGS: $120,470; Sales Discounts: $44,760. Given this information, what is the Gross Profit Margin Ratio for Sunrise Motors? (Round to the nearest whole percentage.)
Company C Industries has sales of $6,100, cost of goods sold of $4,100, accounts receivable of $800, and inventory of $600. Approximately how many days does it take the firm to collect payments on sales?
The Happy Auto Shop has the following annual information: Gross Sales, $700,000; Net Sales, $696,000; Gross Profit, $448,000. What are the shop’s returns and allowances and cost of goods sold? Give an overall detailed response.