Question

Margin Analysis & Cannibalization

for a college class

Raul Ortega has just inherited "Ortega's Stop and Shop," a small convenience store on the south side of Chicago. The store is small, even by convenience store standards, with an interior of 15' wide and 30 deep (plus a small amount of storage space in the back). Raul inherited the store from Uncle Jose, who passed away unexpectedly and did not have any children. Since Raul was his favorite nephew, Jose re- wrote his will to leave the store to Raul in hopes that he would keep it going. Raul worked in Ortega's during the summers when he was in high school and college, but he mostly just ran the cash register, re-stocked shelves, cleaned, and listened to Uncle Jose talk about the store, the neighborhood, and life. But now that Raul suddenly owns the store, he has many decisions to make that he has never made before. One of the biggest decisions is ordering products from suppliers. Raul has spent his nights going through what Uncle Jose had been ordering, and he has figured out the following: 1. Beer and wine are bought through two local distributors, and the store has a gross margin of 40% on these items. 2. Uncle Jose was buying all his soft drinks and bottled water from local Coke and Pepsi distributors - these distributors also handle less popular but noteworthy brands such as 7-Up, Dr. Pepper, Deja Blue, Aquafina, etc. The gross margin on bottled soft drinks is 50%. Uncle Jose also had fountain service through the Coke distributor, who supplies the fountain drink equipmer free-fountain drinks have a gross margin of 80%. 3. The food, tobacco, and other non-perishable items are all purchased at a cash-and-carry wholesaler that's also on the south side. Raul plans to look at this mix of items going forward, as he's guessing that some of the items don't sell as well as others; however, for now, he'll keep this product mix where it currently is until he has time to adjust it. The gross margin on these • items is 40%. One of five sections of the cooler was set aside by Uncle Jose for selling soft drinks and juice drinks that are popular in Mexico. This section includes many brands unfamiliar to US consumers, such as Sidral Mundet. Jarritos, Jumex, and Goya. In looking at the sales records, Raul notices that these brands have been declining in sales for several years, until they now collectively account for only 10% of the sales that are generated by the Coke and Pepsi bottled products sold in the store. In 2019, Ortega's Stop and Shop sold $3,000 of Mexican soft drinks/juices (40% gross margin) that occupied one cooler section, compared to $20,000 of Coke and Pepsi distributed product that also occupy one cooler unit. Raul thinks the reason for the decline of these Mexican brands is the changing demographics of the neighborhood surrounding Ortega's. When it opened in 1981, the neighborhood surrounding Ortega's was around 50% Mexican-American, 40% African-American, and the remaining 10% being white. The most recent census data indicates the neighborhood is more diverse, including individuals that are African-American (down to 25%), Cuban (10%), Haitian (5%), Somali (5%), Mexican (down to 20%), and an increase in whites (35%), which signals coming gentrification for the neighborhood.

Answer 1

statement showing margin analysis and cannibilazation

its is told cold drinks have 50% margin and so in cannibalization there will be loss of cold drink sale so margin analysis is explained belowso 4 product which to be sold so that there is maximum profit arrives

Brand Selling Price per unit ($) Cost unit per case Cost per unit Margin per unit Margin % Estimated demand Total profit Cannibalization % Cannibalization qty Price of other products($) margin (50%) Profit Loss Net profit/loss (a) (b) 120 30 1.75 0.5 0.45 15 9 23.75 1 Monster Xycience Nos Red bull kickstarte! bang Amp rockstart 2.99 21.50/case (12 cans) 3.49 36/case (12) 2.99 41.50(24) 3.49 50.20/case (24) 2.39 14.04/case(12) 2.99 22/case (12) 2.99 28/case (12) 2.49 32/case (24 1.79 3.00 1.73 2.09 1.17 1.83 2.33 1.33 1.20 0.49 1.26 1.40 1.22 1.16 0.66 1.16 40.08 14.04 42.17 40.07 51.05 38.68 21.96 46.45 143.80 14.70 75.65 132.84 146.40 69.40 13.13 34.70 0.875 0.25 0.225 0.5 0.75 0.125 0.7 0.875 36.75 0.75 2.025 11.875 54 1.125 7 10.5 107.05 13.95 73.63 120.97 92.40 68.28 6.13 24.20 120 60 15 50 40 9 10 12 1.5 0.25 1.4 1.75 30 Formula used cost unit per case/total qty selling price-cost margin/selli ng price estimated demand *margin per unit estimated demand * cannibalization % price of other products * margin % cannibaliz ation qty (a)column - (b) column *margin

Brand	net profit arrived from table of margin analysis above	maximum profit ranking
Monster	107.05	2
Xycience	13.95	7
Nos	73.63	4
Red bull	120.97	1
kickstarter	92.40	3
bang	68.28	5
Amp	6.13	8
rockstart	24.20	6

so all the drinks which has ranking of 1 to 4 should be sold to get maximum profit

i.e red bull with $120.97 ,Monster with $ 107.05 ,Kickstarter with $ 92.40 and Nos with $ 73.63