Colombo Soft-Serve Frozen YogurtIn 1994, General Mills Incorporated, a $6 billion consumer goods company, acquired Colombo Frozen Yogurt. General Mills Inc. (GMI) believed they could add Colombo frozen yogurt to their existing product lineup to increase net sales with little addition in marketing cost. Frozen yogurt is sold through two distinct segments – independent shops and impulse locations such as cafeterias, colleges, and buffets. Frozen yogurt is the main business for the shops whereas yogurt is incremental to the impulse location's main business. GMI’s large sales force already served the impulse market. The financial results in the first couple of years were mixed. Earnings increased slightly and then dropped each year even though sales volume was relatively flat. In total, merchandising costs dropped, while pricing promotion rates escalated. The GMI sales force focused on the impulse segments and pricing promotions were believed to be driving volume increases. However, volume in the shop segment declined at alarming rates and there was widespread dissatisfaction in the sales organization. While GMI knew sales by segment, they didn’t track costs by segment. Instead, costs were allocated based on sales dollars. The situation was ripe for a clearer look using ABC methods. TODAY’S FROZEN YOGURT MARKET STRUCTURE:  Colombo Yogurt Company began marketing soft-serve frozen yogurt in the early 1980’s, their main distribution was through independent yogurt shops. In the early 90’s, they faced competition from franchise operations such as TCBY and Freshens that replaced many of the independent yogurt shops. And the market changed as Foodservice operators such as cafeterias, colleges, and buffets started to add soft-serve yogurt to their business. By the late 90’s, these Impulse locations accounted for 2/3 of the soft-serve market. In the late ’90s, Shop sales began to increase with the addition of distinctive new products such as smoothies, boosters, and granitas. The Shops make their living from the soft-serve business and must innovate or go out of business (as thousands have done in the last decade). On the other hand, the Impulse locations make their living from other items and the soft-serve trade is only performance topspin. These firms are unwilling to take any risk(new equipment or extra labor) to serve highly differentiated products like smoothies or granitas. THE GMI-COLOMBO MARKETING PLAN:The GMI Foodservice Division markets brands such as Cheerios, Yoplait, Betty Crocker, Gold Medal Flour, Hamburger Helper, Pop-Secret, and Chex Snack to Food Management Firms, Hospitals, and schools. Colombo yogurt was added to this product lineup and the Foodservice salesforce covered both Shop and Impulse locations. Salesforce: Colombo’s salesforce was merged into the Foodservice salesforce. Customers were reassigned to salespeople who already serviced that geographical area. The salespeople varied in their reaction to the product. Some found shops easy to sell to while others avoided the shops despite the possible lost commission. Many spent a lot of time helping their impulse customers understand how to use the machinery. Merchandising Promotions: Colombo traditionally charged the Shops for merchandising that was large scale and eye-popping (neon signs). The Shops used these signs to draw customers inside. GMI chose not to charge for merchandising and to provide the same large-scale merchandising to both Shops and Impulse locations. Shops were very interested in the kits while many Impulse locations didn’t even hang them up. Pricing Promotions: Pricing promotions are a mainstay of GMI’s impulse location approach. GMI’s salesforce generally used these promotion events as an opportunity to visit their accounts and take advantage of the occasion to meet service needs and sell other products that may not be featured.GMI made price promotions available to both segments of the market. While the deals were typically around $5 per case, they averaged $3 per case against all the volume shipped during the year. GMI marketing knew the price was not a major decision factor for Shops and they did not target pricing promotions to them. However, Shops were aware of the promotions and took advantage of them. 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 were found to vary with whether or not the order was 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. See the chart attached in order -Publication number 1, then Publication1 1.Using the ABC analysis, determine new segment profitability statements. Please provide an explanation

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

5- 2 Colombo Soft-Serve Frozen YogurtIn 1994, General Mills Incorporated, a $6 billion consumer goods company, acquired Colombo Frozen Yogurt. General Mills Inc. (GMI) believed they could add Colombo frozen yogurt to their existing product lineup to increase net sales with little addition in marketing cost. Frozen yogurt is sold through two distinct segments – independent shops and impulse locations such as cafeterias, colleges, and buffets. Frozen yogurt is the main business for the shops whereas yogurt is incremental to the impulse location's main business. GMI’s large sales force already served the impulse market. The financial results in the first couple of years were mixed. Earnings increased slightly and then dropped each year even though sales volume was relatively flat. In total, merchandising costs dropped, while pricing promotion rates escalated. The GMI sales force focused on the impulse segments and pricing promotions were believed to be driving volume increases. However, volume in the shop segment declined at alarming rates and there was widespread dissatisfaction in the sales organization. While GMI knew sales by segment, they didn’t track costs by segment. Instead, costs were allocated based on sales dollars. The situation was ripe for a clearer look using ABC methods.

TODAY’S FROZEN YOGURT MARKET STRUCTURE:

 Colombo Yogurt Company began marketing soft-serve frozen yogurt in the early 1980’s, their main distribution was through independent yogurt shops. In the early 90’s, they faced competition from franchise operations such as TCBY and Freshens that replaced many of the independent yogurt shops. And the market changed as Foodservice operators such as cafeterias, colleges, and buffets started to add soft-serve yogurt to their business. By the late 90’s, these Impulse locations accounted for 2/3 of the soft-serve market. In the late ’90s, Shop sales began to increase with the addition of distinctive new products such as smoothies, boosters, and granitas. The Shops make their living from the soft-serve business and must innovate or go out of business (as thousands have done in the last decade). On the other hand, the Impulse locations make their living from other items and the soft-serve trade is only performance topspin. These firms are unwilling to take any risk(new equipment or extra labor) to serve highly differentiated products like smoothies or granitas.

THE GMI-COLOMBO MARKETING PLAN:The GMI Foodservice Division markets brands such as Cheerios, Yoplait, Betty Crocker, Gold Medal Flour, Hamburger Helper, Pop-Secret, and Chex Snack to Food Management Firms, Hospitals, and schools. Colombo yogurt was added to this product lineup and the Foodservice salesforce covered both Shop and Impulse locations. Salesforce: Colombo’s salesforce was merged into the Foodservice salesforce. Customers were reassigned to salespeople who already serviced that geographical area. The salespeople varied in their reaction to the product. Some found shops easy to sell to while others avoided the shops despite the possible lost commission. Many spent a lot of time helping their impulse customers understand how to use the machinery. Merchandising Promotions: Colombo traditionally charged the Shops for merchandising that was large scale and eye-popping (neon signs). The Shops used these signs to draw customers inside. GMI chose not to charge for merchandising and to provide the same large-scale merchandising to both Shops and Impulse locations. Shops were very interested in the kits while many Impulse locations didn’t even hang them up.

Pricing Promotions: Pricing promotions are a mainstay of GMI’s impulse location approach. GMI’s salesforce generally used these promotion events as an opportunity to visit their accounts and take advantage of the occasion to meet service needs and sell other products that may not be featured.GMI made price promotions available to both segments of the market. While the deals were typically around $5 per case, they averaged $3 per case against all the volume shipped during the year. GMI marketing knew the price was not a major decision factor for Shops and they did not target pricing promotions to them. However, Shops were aware of the promotions and took advantage of them.

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 were found to vary with whether or not the order was 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.

See the chart attached in order -Publication number 1, then Publication1

1.Using the ABC analysis, determine new segment profitability statements. Please provide an explanation.

AutoSane O E 9. U 8-
Colombo fraten (1)
P Sench
Natalie Mechell M
Fle
Home
Insert Draw Design Layout References Maings Review
View Help Soda PDF 11 Creator
8 Share PComments
Draks -
Indent
Spacing
Lne Numbes ELet
Margins Orientation Sce Columne
Snd Selection
Hphenation Elte
Ater Op
Postion Wap Bing
Tert Fonard Bach Pane te-
Page Setup
Paragraph
Arange
Chapter 05 - Artnity Bet Cesting ant Casteme Pufahity Anulia
Chapter 5
Activity-Based Costing and Customer Profitability Analysis
5-2 Colombo Soft-Serve Frozen Yogurt
a1994, Geseni Mils lacoeperated, a $6 bilion coarmmer goodi company, aoquiend Coloabo Frooes Yogat. Groeni Mils lac (CMI) belired thery could ad Colembo
Sooen yogart to their esiting product lineup to incrase set sales with inte additicn in maketing cost
Frszen yogurt is sold ferough tro ditinct segments - independent shops and impulse locations such as cafeterias, collegen, and bufen. Frozen yogurt is the main buines far
the skopa wbereas yogat is iaemetal to theimpulse locatices' ma baizen. GMT s lege sales farce alerady sered the impulsemaket
The faancial rets in the firnt couple of yeern we mied. Emings increued tlighty and thes dopped each year even though sien volame vas selatively fat la toti,
mercdankuing costa deopped, vhile pricing peomotioa rates escalated The GMi sies foece foned ca the impulse segments and pricing peomoions were beliered to bediring
voluse incrase. Honere, volar in te shog segment decined at alerming ntes and thee wE videgread dsatstacticn in the sales eganiczatica While GM er sin by
segment, they dida'tack cota bysegnent
lartead costu we alicated bued on sales delaen. The sitatica was ripe fira clerer look wing ABCzetodi.
TODAY'S FROZEN YOGURT MARKET STRUCTURE:
Then Colembo Topat Compasy began makerting soierve Szes yagut is the eety 1900's, theirmain ditibubca wa terough independent yogart sbopa. l the earty 90,
they faced competion Bom fnchise operations uch a TCBY and Fresbena tat oeplaced may of the independent yogut hopa. And themaket changed as Fooduerice
operators sach as cafiteria, clege, and butfes stated to ad sof-serne yogat toder buines. By te late 90', these Impuloe locatices acconted for 23 of te sotere
maket.
ate late 90%, Shop sales began to increase with the adtice of distinctire sen products sach asamooties, boosters, and grantas. The Shops make ter iring foe the sot-
serve buineu and mut insorate or go outof buises (u tounde kare dce in the lat decade). Os the oter kand, the Impule iocatices make theirliring fee oter itens
and the sotere trade is caly perfemance topapin. These fins ere seniling to take anytak (per equipment or entra labor) to serne highly dfrestiated producta like
mooties or granitas.
THE GMI-COLOMBO MARKETING PLAN:
The GMI Fooduerice Deraise makes krand sach a Cheeis, Yeplait, Bety Coder, Gold Medal Flor, Eambrger Helper, Pap Secent and Cher Saack to Food
Management Firms, Hopitals, and schoola. Colembe yogart wE added to this peoduct lineup and the Fooderice sales farce coreed bota Shop and Impulselocatioas.
Page 1 of 5 1066 wonds
1006
11S9 PM
E P Type here to search
327/2021
Transcribed Image Text:AutoSane O E 9. U 8- Colombo fraten (1) P Sench Natalie Mechell M Fle Home Insert Draw Design Layout References Maings Review View Help Soda PDF 11 Creator 8 Share PComments Draks - Indent Spacing Lne Numbes ELet Margins Orientation Sce Columne Snd Selection Hphenation Elte Ater Op Postion Wap Bing Tert Fonard Bach Pane te- Page Setup Paragraph Arange Chapter 05 - Artnity Bet Cesting ant Casteme Pufahity Anulia Chapter 5 Activity-Based Costing and Customer Profitability Analysis 5-2 Colombo Soft-Serve Frozen Yogurt a1994, Geseni Mils lacoeperated, a $6 bilion coarmmer goodi company, aoquiend Coloabo Frooes Yogat. Groeni Mils lac (CMI) belired thery could ad Colembo Sooen yogart to their esiting product lineup to incrase set sales with inte additicn in maketing cost Frszen yogurt is sold ferough tro ditinct segments - independent shops and impulse locations such as cafeterias, collegen, and bufen. Frozen yogurt is the main buines far the skopa wbereas yogat is iaemetal to theimpulse locatices' ma baizen. GMT s lege sales farce alerady sered the impulsemaket The faancial rets in the firnt couple of yeern we mied. Emings increued tlighty and thes dopped each year even though sien volame vas selatively fat la toti, mercdankuing costa deopped, vhile pricing peomotioa rates escalated The GMi sies foece foned ca the impulse segments and pricing peomoions were beliered to bediring voluse incrase. Honere, volar in te shog segment decined at alerming ntes and thee wE videgread dsatstacticn in the sales eganiczatica While GM er sin by segment, they dida'tack cota bysegnent lartead costu we alicated bued on sales delaen. The sitatica was ripe fira clerer look wing ABCzetodi. TODAY'S FROZEN YOGURT MARKET STRUCTURE: Then Colembo Topat Compasy began makerting soierve Szes yagut is the eety 1900's, theirmain ditibubca wa terough independent yogart sbopa. l the earty 90, they faced competion Bom fnchise operations uch a TCBY and Fresbena tat oeplaced may of the independent yogut hopa. And themaket changed as Fooduerice operators sach as cafiteria, clege, and butfes stated to ad sof-serne yogat toder buines. By te late 90', these Impuloe locatices acconted for 23 of te sotere maket. ate late 90%, Shop sales began to increase with the adtice of distinctire sen products sach asamooties, boosters, and grantas. The Shops make ter iring foe the sot- serve buineu and mut insorate or go outof buises (u tounde kare dce in the lat decade). Os the oter kand, the Impule iocatices make theirliring fee oter itens and the sotere trade is caly perfemance topapin. These fins ere seniling to take anytak (per equipment or entra labor) to serne highly dfrestiated producta like mooties or granitas. THE GMI-COLOMBO MARKETING PLAN: The GMI Fooduerice Deraise makes krand sach a Cheeis, Yeplait, Bety Coder, Gold Medal Flor, Eambrger Helper, Pap Secent and Cher Saack to Food Management Firms, Hopitals, and schoola. Colembe yogart wE added to this peoduct lineup and the Fooderice sales farce coreed bota Shop and Impulselocatioas. Page 1 of 5 1066 wonds 1006 11S9 PM E P Type here to search 327/2021
AutoSave
Colombo Frozen (1) - Saved to this PC
P Search
ff
Natalie Mitchell NM
File
Home
Insert
Draw
Design
Layout
References
Mailings
Review
View
Help
Soda PDF 11 Creator
8 Share
P Comments
A AE E Signature Line -
Date & Time
ΠΩ
A Get Add-ins
W
Cover Blank Page
Page v Page Break
SmartArt Chart Screenshot
Add From
Link Bookmark Cross-
Text Quick WordArt Drop
Сар
Table
Pictures Shapes Icons
3D
Wikipedia
Online
Comment
Header Footer
Page
Equation Symbol
O My Add-ins
O Object
Models v
Files
Video
reference
Number v
Box v Parts v
Pages
Tables
Illustrations
Тар
Add-ins
Media
Links
Comments
Header & Footer
Text
Symbols
3...
.I . 5. I.
6...I ...
I... 10... I
11
13 ...I
14 .. I
15
16
17
..I. . . 18..
19
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
$29,850,000
-$ 4,500.000
$25,350,000
- $17,250.000
$ 8,100,000
-$ 1,725,000
-$ 1,185.000
$ 5,190,000
Sales revenue
$23,880,000
-$ 3.600.000
$20,280,000
- $13.800.000
$ 6,480,000
-$ 1,380,000
-$ 948.000
$ 4,152,000
$5,970,000
-$ 900.000
$5,070,000
- $3.450.000
$1,620,000
-$ 345,000
-$ 237.000
$1,038,000
Less: Price Promotions
Net Sales
Less: Cost of Goods Sold
Gross Margin
Less: Merchandising
Less: SG&A
Net income
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 were found to vary with whether or not the order was 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
60,000
1,140,000
Cases in full Pallets
240,000
60,000
300,000
1,200,000
Individual cases
Total cases
1,200,000
300,000
1,500,000
ABC ANALYSIS OF MERCHANDISING:
Merchandising costs consist mainly of kits costing $500 each. A review of where the kits were sent indicated that 3,450 kits were sent out and 90 of them were sent to shops.
ABC ANALYSIS OF SELLING, GENERAL AND ADMINISTRATIVE:
Since sales representatives service several products, their costs are allocated to the various 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 reps spent almost3
times as much time on the yogurt than GMI had estimated. 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.
REQUIRED:
1066 words
D Focus
100%
11:43 PM
P Type here to search
W
3/27/2021
Transcribed Image Text:AutoSave Colombo Frozen (1) - Saved to this PC P Search ff Natalie Mitchell NM File Home Insert Draw Design Layout References Mailings Review View Help Soda PDF 11 Creator 8 Share P Comments A AE E Signature Line - Date & Time ΠΩ A Get Add-ins W Cover Blank Page Page v Page Break SmartArt Chart Screenshot Add From Link Bookmark Cross- Text Quick WordArt Drop Сар Table Pictures Shapes Icons 3D Wikipedia Online Comment Header Footer Page Equation Symbol O My Add-ins O Object Models v Files Video reference Number v Box v Parts v Pages Tables Illustrations Тар Add-ins Media Links Comments Header & Footer Text Symbols 3... .I . 5. I. 6...I ... I... 10... I 11 13 ...I 14 .. I 15 16 17 ..I. . . 18.. 19 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 $29,850,000 -$ 4,500.000 $25,350,000 - $17,250.000 $ 8,100,000 -$ 1,725,000 -$ 1,185.000 $ 5,190,000 Sales revenue $23,880,000 -$ 3.600.000 $20,280,000 - $13.800.000 $ 6,480,000 -$ 1,380,000 -$ 948.000 $ 4,152,000 $5,970,000 -$ 900.000 $5,070,000 - $3.450.000 $1,620,000 -$ 345,000 -$ 237.000 $1,038,000 Less: Price Promotions Net Sales Less: Cost of Goods Sold Gross Margin Less: Merchandising Less: SG&A Net income 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 were found to vary with whether or not the order was 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 60,000 1,140,000 Cases in full Pallets 240,000 60,000 300,000 1,200,000 Individual cases Total cases 1,200,000 300,000 1,500,000 ABC ANALYSIS OF MERCHANDISING: Merchandising costs consist mainly of kits costing $500 each. A review of where the kits were sent indicated that 3,450 kits were sent out and 90 of them were sent to shops. ABC ANALYSIS OF SELLING, GENERAL AND ADMINISTRATIVE: Since sales representatives service several products, their costs are allocated to the various 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 reps spent almost3 times as much time on the yogurt than GMI had estimated. 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. REQUIRED: 1066 words D Focus 100% 11:43 PM P Type here to search W 3/27/2021
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.