Colleen Company has gathered the following data pertaining to activities it performed for two of its...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. Kate Co. 6 1,000 Number of orders Units per order Sales returns: Number of returns Total units returned Number of sales calls Activity Sales calls Order processing Deliveries 4 30 9 Sales returns Sales salary 30 340 Colleen sells its products at $180 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: 6 160 3 Cost Driver and Rate 800 per visit 240 per order 450 per order 300 per return and $6 per unit returned 103,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 Company to service Jerry, Inc. and Kate Co. 2. Compare the profitability of these two customers. Complete this question by entering your answers in the tabs below. Required 1 Required 2 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, Inc. and Kate Co. Jerry Inc. Customer unit level costs: Customer batch level costs: Customer sustaining costs: Total $ $ 180 $ 7,200 7,380 $ Kate Co. Required 1 960 2,400 3,360 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compare the profitability of these two customers. (Loss amounts should be indicated by a minus sign. Round operating margin (loss) to 2 decimal places (i.e. .2134 should be entered as 21.34%).) Jerry Inc. Kate Co. Net sales Operating income (loss) Operating margin (loss) $ 60 $ 0 0 % $ $ < Required 1 0 0 % Required 2 > Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. Kate Co. 6 1,000 Number of orders Units per order Sales returns: Number of returns Total units returned Number of sales calls Activity Sales calls Order processing Deliveries 4 30 9 Sales returns Sales salary 30 340 Colleen sells its products at $180 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: 6 160 3 Cost Driver and Rate 800 per visit 240 per order 450 per order 300 per return and $6 per unit returned 103,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 Company to service Jerry, Inc. and Kate Co. 2. Compare the profitability of these two customers. Complete this question by entering your answers in the tabs below. Required 1 Required 2 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, Inc. and Kate Co. Jerry Inc. Customer unit level costs: Customer batch level costs: Customer sustaining costs: Total $ $ 180 $ 7,200 7,380 $ Kate Co. Required 1 960 2,400 3,360 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compare the profitability of these two customers. (Loss amounts should be indicated by a minus sign. Round operating margin (loss) to 2 decimal places (i.e. .2134 should be entered as 21.34%).) Jerry Inc. Kate Co. Net sales Operating income (loss) Operating margin (loss) $ 60 $ 0 0 % $ $ < Required 1 0 0 % Required 2 >
Expert Answer:
Answer rating: 100% (QA)
1 2 Customer unit level costs Sales returns 30 6 160 6 Customer ... View the full answer
Related Book For
Cost Management A Strategic Emphasis
ISBN: 978-0078025532
6th edition
Authors: Edward Blocher, David Stout, Paul Juras, Gary Cokins
Posted Date:
Students also viewed these general management questions
-
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Colleen sells its products at $200 per unit. The firm's gross margin ratio is...
-
Doreen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry Inc. Donald Co. Number of orders 5 30 Units per order 1,000 200 Sales...
-
Nerrod Company sells its products at $900 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...
-
Make a presentation about marketing: Your Companys marketing department promotes the products and interacts with the customers, sales force, and supply chain. They are also in charge of forecasting...
-
Petro-Chem, Inc., is a small company that acquires high-grade crude oil from low volume production wells owned by individuals and small partnerships. The crude oil is processed in a single refinery...
-
Find the directional derivative of V = rz2 cos along the direction A= 2 - and evaluate it at (1, / 2, 2).
-
If you invest money for five years, which will be larger? a. an investment that earns simple interest b. an investment that earns compound interest c. The investments will be the same. d. It depends...
-
Examine the systems given below. Which system is more reliable, a or b? c or d? Now calculate the reliability of each system. Were your perceptions correct? If it costs $1000 for each 90% reliable...
-
'Which value of EN satisfies 3 k= 2046 ? ~ . Given a , = 3 " " - 6 . ( 5 ) " and ba : 8 . ( 5 ) det
-
Imagine that Creamy Ice is a large manufacturer of tasty ice cream and other frozen dessert products and has been in business for decades. Further imagine that the organization's manufacturing...
-
Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2,950,000. The fixed asset will be depreciated straight-line to zero over...
-
We must recognize that health care is not a commodity. Those with more resources should not be able to purchase services while those with less do without. Health care is a social good that should be...
-
What would it mean if the poverty income threshold level of the United States were applied to Mexico?
-
Why does the health of the economy affect the number of people living in poverty?
-
What is a Lorenz curve? What would the curve look like if income were equally distributed? Could the curve ever bow upward above the line of income equality?
-
What is the moral hazard problem in banning insurance companies from denying coverage due to preexisting conditions?
-
Identify the factors in the following expression Answer 2x y
-
An example of prescriptive analytics is when an action is recommended based on previously observed actions. For example, an analysis might help determine procedures to follow when new accounts are...
-
UR Safe Systems installs home security systems. Two of its systems, the ICU 100 and the ICU 900 have these characteristics: Required 1. What are the current profit margins on both systems? 2. UR...
-
In 2011-2013, Brazil's economy was flourishing in many dimensions, except for a significant and worsening trade deficit with China in 2011-2012. The root of the problem was that the value of the...
-
The management of office printing, duplicating, filing, and overall document storage is one of the most significant overhead costs in many companies, especially companies with large and complex...
-
Summary of payroll procedures Soprano Construction Company uses the job order cost system. In recording payroll transactions, the following accounts are used: Cash Wages Payable FICA Tax Payable...
-
Accounting for bonus, vacation pay, and holiday pay The factory payroll for the week is $200,000, consisting of $140,000 earned by 100 direct laborers and $60,000 earned by 30 indirect laborers. The...
-
What are the advantages and disadvantages of the scattergraph method as compared to the high-low method?
Study smarter with the SolutionInn App