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. Number of orders Units per order Sales returns: Number of returns Total units returned Number of sales calls Jerry, Incorporated 5 Kate Company 30 1,000 200 2 40 12 5 175 4 Colleen sells its products at $200 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 Order processing Deliveries Sales returns Sales salary Required: Cost Driver and Rate $1,000 per visit 300 per order 500 per order 100 per return and $5 per unit returned 100,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. 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, Incorporated and Kate Company Jerry, Incorporated Kate Company Customer unit level costs: Customer batch level costs: Customer sustaining costs: Total < Required 1 Required 2 > 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 5 30 1,000 200 2 40 12 5 175 4 Colleen sells its products at $200 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 Order processing Deliveries Sales returns Sales salary Required: Cost Driver and Rate $1,000 per visit 300 per order 500 per order 100 per return and $5 per unit returned 100,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. 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%).) Net sales Operating income (loss) Operating margin (loss) Jerry, Incorporated % Kate Company % < Required 1 Required 2 > 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 5 Kate Company 30 1,000 200 2 40 12 5 175 4 Colleen sells its products at $200 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 Order processing Deliveries Sales returns Sales salary Required: Cost Driver and Rate $1,000 per visit 300 per order 500 per order 100 per return and $5 per unit returned 100,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. 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, Incorporated and Kate Company Jerry, Incorporated Kate Company Customer unit level costs: Customer batch level costs: Customer sustaining costs: Total < Required 1 Required 2 > 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 5 30 1,000 200 2 40 12 5 175 4 Colleen sells its products at $200 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 Order processing Deliveries Sales returns Sales salary Required: Cost Driver and Rate $1,000 per visit 300 per order 500 per order 100 per return and $5 per unit returned 100,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. 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%).) Net sales Operating income (loss) Operating margin (loss) Jerry, Incorporated % Kate Company % < Required 1 Required 2 >
Expert 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 accounting questions
-
What are the garnishes & accompaniment for apricot bavarois, creme caramel, tiramisu parfait?
-
Climate-change concerns are resulting in investment in fuels that dont produce greenhouse gases. Although solar and wind power garner a lot of attention, nuclear power from uranium is also a...
-
Distinguish among lingual, palatine, and pharyngeal tonsils.
-
For the following exercises, evaluate or solve, assuming that the function f is one-to-one. If f(6) = 7, find f 1 (7).
-
10.A company contracted with a marketing firm to construct software and create a business website. A quote was requested and accepted. Sometime later, the business asked for updates and revisions but...
-
1. Describe the situation at Lehman Brothers from an ethics perspective. Whats your opinion of what happened here? 2. What was the culture at Lehman Brothers like? How did this culture contribute to...
-
How Safe Are You? Assume one of your favorite activities is mountain climbing. When you go mountain climbing, you have several safety devices to keep you from falling. You notice that attached to one...
-
: Q2) A club has 20 member a) In how many different ways could the club choose a president and a vice president? b) In how many different ways could the club choose two co-presidents? c) In how...
-
What pivotal biological roles does histidine play, elucidating its critical significance within cellular processes, considering its biochemical properties and interactions within biological systems?
-
Each category of expenditure is assigned a category and all costs for that type are accounted for in that area, describes what kind of budget?
-
Automobile repairs of $10,000 were made for customers; $7,500 of repairs was paid in cash and $2,500 of repairs will be paid in the future by customers. What impact does this have on the accounting...
-
Over the past 3 years, Justin purchased 1000 shares of Apple Inc. Their purchases are summarized below: Number of Shares Price per Share 200 $38 500 $68 300 $46 Apple's share price has grown to $105...
-
8. TTT and CCT diagrams of a eutectoid steel (0.76 C) are provided below. Use the diagrams to answer the following questions. Temperature (C) Temperature (C) 800 700 600 500 400 300 200 100 800 700...
-
Create your own situation that could be modeled with a binomial probability. make sure that it relates to something in the area of psychology! P(X = x | , ) Where: n = number of observations (the...
-
Define cultural intelligence. Cite the books or journal articles you found in Capella's library. Explain why cultural intelligence is important for HR practitioners and other organizational managers.
-
a. Project A costs $5,000 and will generate annual after-tax net cash inflows of $1,800 for five years. What is the payback period? b. Project B costs $5,000 and will generate after-tax net cash...
-
Johnston Adhesives Company makes three widely used industrial adhesives: A101, A204, and B216. Sales and production information for each of the three adhesives are shown in the following table. Most...
-
Pablo Company calculates the cost for an equivalent unit of production using process costing. Data for June Work-in-process inventory, June 1: 30,000 units Direct materials: 100%...
-
What challenges is Lidl likely to face in the coming years?
-
Give some examples of things we might learn about the likely behaviour and performance of businesses in an industry by knowing something about the industrial concentration of that industry.
-
Consider a country other than the UK and investigate the changes in its industrial structure. Are the changes similar to or different from those in the UK?
Study smarter with the SolutionInn App