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...
-
Sales volume has been dropping at Koinonia Publishing Company. During this time, however, the Shipping Department manager has been under severe financial constraints. The manager knows that most of...
-
Depreciation is nothing but an allocation of the purchase price over different accounting periods. Do you agree with this statement? If so, identify the elements of cost allocations (cost pool, cost...
-
Find a Fourier series representation of the Dirac delta function, \(\delta(x)\), on \([-L, L]\).
-
Account analysis method. Gower, Inc., a manufacturer of plastic products, reports the following manufacturing costs and account analysis classification for the year ended December 31, 2009. Gower,...
-
An investor invests 70% of his wealth in a risky asset with an expected rate of return of 0.15 and a variance of 0.04 and 30% in a T-bill that pays 5%. His portfolio's expected return and standard...
-
Chandra was the sole shareholder of Pet Emporium, which was originally formed as an S corporation. When Pet Emporium terminated its S election on August 31, 2019, Chandra had a stock basis and an...
-
A blast chamber should accurately measure fast pressure dynamics. An explosion creates pressure waves that can fluctuate over as little 0.4 milliseconds, with a magnitude up to 1.2 MPa. a. What is...
-
What's the difference between the ABC, Target Costing,Balanced Score-card Provide your views with giving numerical examples of applying the three systems.
-
Direct Materials (all materials purchased were used): Standard cost: $6.00 per pound of urn. Total actual cost: $5,600. Standard cost allowed for units produced was $6,000. Materials efficiency...
-
On January 1 st , 2019, Jim-N-John Inc. had a Beginning Work-in-Process balance of $20,000 ($10,000 of Direct Materials and $10,000 of Conversion) which consisted of 5,000 units which were 40%...
-
I purchased a new car on April 1 st for $ 2 4 , 0 0 0 and financed the entire amount at 1 2 % . I will make 4 8 monthly payments, with the first payment due on May 1 st . How much interest will I pay...
-
Walmart uses the common low-active price strategy company. They use this approach to focus on offering everyday low prices. The main advantage of this strategy is that it is simple for the company...
-
What is the hypothesis of the given statement? If money grows in trees, then you can be rich. Money grows in trees. You cannot be rich. Money does not grow in trees. You can be rich.
-
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...
-
Unit Conversion. 1 kilogram (kg) is equal to 2.20462 pounds. Convert 200 pounds to kilograms. Round to three decimal places, if necessary.
-
In this exercise, we explore what happens when an item is marked up by a percentage, and then marked down using the same percentage. Wegmans purchases an item for \(\$ 5\) per unit. The markup on the...
-
Unit Conversion. There are 1,000 meters \((\mathrm{m})\) in a kilometer \((\mathrm{km})\), and 100 centimeters \((\mathrm{cm})\) in a meter. Convert \(4 \mathrm{~km}\) to centimeters.
Study smarter with the SolutionInn App