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 to service Jerry, Incorporated and Kate Company. 2. Compare the profitability of these two customers. correct

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 to service Jerry, Incorporated and Kate Company. 2. Compare the profitability of these two customers. correct

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter18: The Management Of Accounts Receivable And Inventories

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

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?
Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.
The up towner has sales of $913,400 costs of goods sold of $579,300 inventory of $123,900 and accounts receivable of $78,900. How many days, on average, does it take the firm to sell its inventory assuming that all sales are on credit?
Omega Company has the following two customers: Woodruff Ensley Sales $900,000 $800,000 Cost of Goods Sold 360,000 160,000 Other expenses excluding sales commissions 640,000 130,000 If the company pays a 4% sales commission based on customer profit, this will encourage a salespersons' efforts to sell to:
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.
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?
Nerrod Company sells its products at $840 per unit, net 30. The firm's gross margin ratio is 40 percent. The firm has estimated the following operating costs: Activity Cost Driver and Rate Sales calls $ 570 per visit Order processing $ 185 per order Deliveries $ 80 per order + $0.50 per mile Sales returns $ 95 per return and $6.4 restocking per unit returned Nerrod Company has gathered the following data pertaining to activities it performed for two of its customers: XBT NINTO Number of orders 27 2 Number of parts per order 670 2,170 Sales returns: Number of returns 4 10 Number of units returned 40 50 Number of sales calls 14 10 Miles per delivery 10 20 Shipping terms FOB, Factory FOB, Destination What is Nerrod's total customer unit-level cost applicable to XBT as a customer?
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?
Flair ranks the individual customers in the Ma and Pa single-store distribution market on the basis of monthly operating income. The cumulative operating income of the top 20% of customers is $58,120. Best Drugs reports operating losses of $23,670 for the bottom 40% of its customers. Make four recommendations that you think Best Drugs should consider in light of this new customer-profitability information.
FRANCORP is a large retailer of automobiles floor mats. An income statement for the most recent quarter is presented below: Sales $927,500Less Cost of Goods Sold 275,000Gross Marign 652,500Less Operating Expenses:Selling Expenses 205,500Administrative Expenses 280,000 485,500Net Income 167,000 The liners sell, on average, for $350 each. The department's variable selling expenses are $35 per liner sold. The remaining selling expenses are fixed. The administrative expenses are 35% variable and 65% fixed. The company purchases its floor mats from a supplier at a cost of $125 per mat. Cost of Goods Sold is 50% variable. Determine the total fixed costs. a) $350,750b) $432, 250c) $410,000d) $315,700
FRANCORP is a large retailer of automobiles floor mats. An income statement for the most recent quarter is presented below: Sales $927,500Less Cost of Goods Sold 275,000Gross Marign 652,500Less Operating Expenses:Selling Expenses 205,500Administrative Expenses 280,000 485,500Net Income 167,000 The liners sell, on average, for $350 each. The department's variable selling expenses are $35 per liner sold. The remaining selling expenses are fixed. The administrative expenses are 35% variable and 65% fixed. The company purchases its floor mats from a supplier at a cost of $125 per mat. Cost of Goods Sold is 50% variable. Determine the contribution margin ratio (round to 3 decimal places if applicable). a)…
FRANCORP is a large retailer of automobiles floor mats. An income statement for the most recent quarter is presented below: Sales $927,500Less Cost of Goods Sold 275,000Gross Marign 652,500Less Operating Expenses:Selling Expenses 205,500Administrative Expenses 280,000 485,500Net Income 167,000 The liners sell, on average, for $350 each. The department's variable selling expenses are $35 per liner sold. The remaining selling expenses are fixed. The administrative expenses are 35% variable and 65% fixed. The company purchases its floor mats from a supplier at a cost of $125 per mat. Cost of Goods Sold is 50% variable. Determine the total variable cost per unit. a) $123.87b) $137.81c) $145.08d) $153.99