Using the ABC analysis, determine new segment profitability statements. Based on your analysis in questions 1 and
Fantastic news! We've Found the answer you've been seeking!
Question:
Using the ABC analysis, determine new segment profitability statements.
Based on your analysis in questions 1 and 2, what changes would you suggest to General Mills?
What recommendations do you suggest based on ABC analysis?
Transcribed Image Text:
The Business Status Pre-ABC Profit and Loss by Segment Pre-ABC Category Impulse Segment Yogurt Shops Total Sales in cases 1,200,000 300,000 1,500,000 Sales revenue $23,880,000 $5,970,000 $29,850,000 Less: price promotions - $ 3,600,000 - $ 900,000 - $ 4,500,000 Net sales $20,280,000 $5,070,000 $25,350,000 - $13.800.000 $ 6,480,000 - $ 1,380,000 - $ 948,000 $ 4,152,000 - $3.450,000 - $17.250.000 $ 8,100,000 $ 1,725,000 Less: cost of goods sold Gross margin $1,620,000 -$ 345,000 -$ 237,000 Less: merchandising - $ 1,185.000 $ 5,190,000 Less: SG&A Net income $1,038,000 ABC Analysis of Cost of Goods Sold Cost of goods sold is made up of $14,250,000 for ingredients, packaging, and storage and $3,000,000 for pick/pack and shipping. Since the product is the same across segments, the cost to produce should be the same. However, pick/pack and shipping costs vary according to whether or not the order is for a full pallet. Full pallets cost $75 to pick and ship whereas individual orders cost $2.25 per case. There are 75 cases in a pallet and the segments differ in their utilization of full pallets, as shown below. Impulse Segment Yogurt Shops Total Cases in full pallets Individual cases 60,000 240,000 300,000 1,140,000 1,200,000 60,000 300,000 1,200,000 1,500,000 Total cases ABC Analysis of Merchandising Merchandising costs consist mainly of kits costing $500 each. A review of where the kits were sent indicated that a total of 3,450 kits were delivered, 90 of them to shops. ABC Analysis of Selling, General, and Administrative (SG&A) the Since sales representatives service several products, their costs were allocated products based on gross sales dollars. GMI gave diaries to 10% of the sales force in randomly selected markets of the country and asked them to track their time in activity classifications for 60 days. The diaries indicated that sales representatives spent much more time per dollar of sale on yogurt than other products. When SG&A costs were allocated based on time, the total allocation to yogurt jumped from $1,185,000 to $3,900,000. Of their time spent on yogurt, only 1% of the time was spent on the shops. rious The Business Status Pre-ABC Profit and Loss by Segment Pre-ABC Category Impulse Segment Yogurt Shops Total Sales in cases 1,200,000 300,000 1,500,000 Sales revenue $23,880,000 $5,970,000 $29,850,000 Less: price promotions - $ 3,600,000 - $ 900,000 - $ 4,500,000 Net sales $20,280,000 $5,070,000 $25,350,000 - $13.800.000 $ 6,480,000 - $ 1,380,000 - $ 948,000 $ 4,152,000 - $3.450,000 - $17.250.000 $ 8,100,000 $ 1,725,000 Less: cost of goods sold Gross margin $1,620,000 -$ 345,000 -$ 237,000 Less: merchandising - $ 1,185.000 $ 5,190,000 Less: SG&A Net income $1,038,000 ABC Analysis of Cost of Goods Sold Cost of goods sold is made up of $14,250,000 for ingredients, packaging, and storage and $3,000,000 for pick/pack and shipping. Since the product is the same across segments, the cost to produce should be the same. However, pick/pack and shipping costs vary according to whether or not the order is for a full pallet. Full pallets cost $75 to pick and ship whereas individual orders cost $2.25 per case. There are 75 cases in a pallet and the segments differ in their utilization of full pallets, as shown below. Impulse Segment Yogurt Shops Total Cases in full pallets Individual cases 60,000 240,000 300,000 1,140,000 1,200,000 60,000 300,000 1,200,000 1,500,000 Total cases ABC Analysis of Merchandising Merchandising costs consist mainly of kits costing $500 each. A review of where the kits were sent indicated that a total of 3,450 kits were delivered, 90 of them to shops. ABC Analysis of Selling, General, and Administrative (SG&A) the Since sales representatives service several products, their costs were allocated products based on gross sales dollars. GMI gave diaries to 10% of the sales force in randomly selected markets of the country and asked them to track their time in activity classifications for 60 days. The diaries indicated that sales representatives spent much more time per dollar of sale on yogurt than other products. When SG&A costs were allocated based on time, the total allocation to yogurt jumped from $1,185,000 to $3,900,000. Of their time spent on yogurt, only 1% of the time was spent on the shops. rious
Expert Answer:
Answer rating: 100% (QA)
1 General Mills and Colombo Competitive Environment General Mills focuses on high quality and high sales service They had a large sales force already selling to Impulse segment Colombo offered the adv... View the full answer
Related Book For
Financial Accounting Tools for business decision making
ISBN: 978-0470534779
6th Edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
What recommendations would you suggest to A&F as it looks to the future?
-
Based on your answers to questions 1, 2, and 3, what do you believe are the most important value drivers for Life Tech based on their impact on the firm's enterprise and equity values? List these...
-
Cyclops Company manufactures kinetic torches. Based on market research, Cyclops decides on a target cost of $3.5 for its "Omega Red" model. They expect to sell 15000 units of Omega Reds in the next...
-
On November 1, 2021, Sadie's borrows $230,000 from a local bank and signs a note. The note requires interest to be paid annually beginning on August 1, 2022 at 12%. Principal and interest are due in...
-
At the time Cynthia Cooper discovered the accounting fraud, WorldCom did not have a whistleblower hotline process in place. Instead, Cynthia took on significant risks when she stepped over Scott...
-
Consider the system shown in Figure 3-42 An armature-controlled dc servomotor drives a load consisting of the moment of inertia JL. The torque developed by the motor is T. The moment of inertia of...
-
What elements must be proven in order to be successful in a negligence suit? Illustrate your answer with a case (the facts of the case can be hypothetical).
-
Consider the problem of constructing (not solving) crossword puzzles:5 fitting words into a rectangular grid. The grid, which is given as part of the problem, specifics which square are blank and...
-
a. If my car needs $1,200 in repairs today, do I have enough to cover the cost? b. If my job frequently requires me to work late or on weekends, is it worth it to pay additional money for premium...
-
Question A: Stay Safe International manufactures industrial safety equipment at its plant in Evans- ville, Indiana. The company has initiated DRP to coordinate finished goods distribution from the...
-
Problem 3 There are three investments, B1, B2 and B3. All of them have the same expected value and each with two possible payoffs. The payoffs from investment B are independent from payoffs from B2...
-
Which are true about closing resources to guard against a denial of service attack? (Choose two.) A. The NIO.2 Files.lines() method does not require closing a resource when it is used in a stream...
-
Which statements about the following class are correct? (Choose three.) A. Line h1 properly validates security. B. Line h1 presents an unacceptable security risk. C. Line h2 elevates security...
-
Select a good strategy for handling input validation failures? A. Use the assert statement. B. Throw an Error. C. Log an error but allow the user to continue. D. Throw an Exception. E. Shut down the...
-
Which statements about securing confidential information are correct? (Choose three.) A. When writing to System.out, you should not include sensitive information. B. When reading sensitive data from...
-
What statements about the following method are correct? (Choose three.) A. It protects against a denial of service attack. B. It does not protect against denial of service attacks. C. It protects...
-
Watch the video "Operations processes: Inputs, transformation, outputs" and answer the following questions: 1. Describe a transformation process within an organization familiar to you; list all...
-
Global.asax is used for: a. declare application variables O b. all other answers are wrong O c. declare global variables O d. handle application events
-
In January 2012, the management of Sarah Company concludes that it has sufficient cash to purchase some short-term investments in debt and stock securities. During the year, the following...
-
(a) Brandt Company ships merchandise to England Corporation on December 30. The merchandise reaches the buyer on January 5. Indicate the terms of sale that will result in the goods being included in...
-
What do these classes of ratios measure? (a) Liquidity ratios. (b) Profitability ratios. (c) Solvency ratios.
-
Action Quest Games adjusts its accounts annually. The following information is available for the year ended December 31, 2025. 1. Purchased a 1-year insurance policy on June 1 for $1,800 cash. 2....
-
Why is carbon such a special atom?
-
With each pass of a comet about the Sun, the comets mass (a) remains virtually unchanged. (b) actually increases. (c) is appreciably reduced.
Study smarter with the SolutionInn App