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
-
Generational differences will have a negative impact in the workplace True False
-
describe the relationship betwe themselves don't and income. (b) Among men who have no income, find the percentages for marital status. Do the same for men who have an income of $100,000 and over....
-
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...
-
Explain how a lymphatic obstruction leads to edema.
-
The band gap in gallium arsenide is 140 kJ/mol. What is the maximum wavelength of light needed to excite an electron to move from the valence band to the conduction band?
-
What are five methods of resolving consumer complaints?
-
Southland Corporation's decision to produce a new line of recreational products resulted in the need to construct either a small plant or a large plant. The best selection of plant size depends on...
-
ppleaseanswer both A & B Acua Leather Goods. DeMagistris Fashion Company, based in New York City, imports leather coats from Acua Leather Goods, a reliable and longtime supplier, based in Buenos...
-
You are responsible for the audit of inventory for Honey Best Grocery Wholesales, Inc., a closely held grocery wholesaler that sells to independent grocery stores. Inventory is by far the largest...
-
An ice cream shop tracks the orders for different flavors and styles of ice cream to stock the best inventory. The two-way frequency table summarizes the orders for the last week. Hand-dipped Soft...
-
Simplify the following trigonometric expression by following the indicated direction. cos 0 1 + sin Multiply by 1 - sin 0 1 + sin 0
-
What are two emerging technology developed outside of the US?
-
Compare and contrast the understanding of leadership inside and outside of the military. Provide an example to illustrate at least one contrasting assertion.
-
At the core of systems thinking is a written picture of what is going on, through the use of "loops"casual, balancing, and reinforcing. How might these "loops" help your client organization see new...
-
If you were to put yourself in a brand marketer's shoes, how would you utilize storytelling and data to meet consumers' expectations?
-
How much you should invest today and in 8 years you'll be paid $10000 back for this investment. The annual interest rate is 9%. A.) Blank 1: compounded yearly. B) Blank 2: compounded monthly. B)...
-
Time Travel Publishing was recently organized. The company issued common stock to an attorney who provided legal services worth $25,000 to help organize the corporation. Time Travel also issued...
-
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%...
-
A lessee is evaluating whether a lease term is a major part of the remaining life of an asset in order to determine the proper lease classification. The lessee leases office space through a lease...
-
On January 1, 2020, Lessee Company leases a vehicle with a fair value of \(\$ 30,000\) from Lessor Company for 3 years, with no renewal options. The estimated life of the vehicle is 6 years and...
-
For each of the following four separate finance lease scenarios, determine the lease payment that the lessee should use to determine the appropriate lease classification. a. Lease payments are \(\$...
Study smarter with the SolutionInn App