Question

MINICASE Jen and Larry's Frozen Yogurt Company In 2016. Jennifer (Jenl Liu and Carry Mestas founded Jen and Larry's Frozen Yogurt Company, which was based on the idea of applying the microbrew or microbatch strategy to the production and sale of frozen yogurt (The reader may recall that we introduced this yogurt venture in the problems section at the end of Chapter 2.) Jen and Larry began producing small quantities of unique flavors and blends in limited editions. Revenues were $600.000 in 2016 and were estimated to be $1.2 million in 2017 Because Jen and carry were selling premium frozen yogurt containing premium ingredients, each small cup of yogurt sold for $3. and the cost of produong the frozen yogurt averaged $150 per cup. Administrative expenses, including Jen and Larry's salary and expenses for an accountant and two other administrative staff, were estimated at $180,000 in 2017. Marketing expenses, largely in the form of behind-the-counter workers, in-store posters, and advertising in local newspapers, were projected to be $200.000 in 2017 An investment in bricks and mortar was necessary to make and sell the yogurt. Initial specialty equipment and the ren- ovation of an old warehouse building in lower downtown (known as LoDo) occurred at the beginning of 2016. Additional equipment needed to make the amount of yogurt forecasted to be sold in 2017 was purchased at the beginning of 2017 As a result, depreciation expenses were expected to be $50,000 in 2017 Interest expenses were estimated at $15,000 in 2017. The average tax rate was expected to be 25 percent of taxable income. A How many cups of frozen yogurt would have to be sold for the firm to reach its projected revenues of $1.2 million? B. Calculate the dollar amount of EBOAT if Jen and Larry's Frozen Yogurt Company achieves the forecasted $1.2 million in sales for 2017 What would EBDAT be as a percent of revenues? Jen and Carry believe that under a worst case scenario, yogurt revenues would be at the 2016 level of $600.000 even after plans and expenditures were put in place to increase revenues in 2017. What would happen to the venture's EBDAT? D. Jen and also believe that under optimistic conditions, yogurt revenues could reach $1,5 milion in 2017. Show what would happen to the venture's EBOAT if this were to happen E Calculate the EBOAT breakeven point for 2017 in terms of survival revenues for Jen and Larry's Frozen Yogurt Com pary. How many cups of frozen yogurt would have to be sold to reach EBDAT breakeven? F. Show what would happen to the EBOAT breakeven in terms of survival revenues if the cost of producing a cup of yo gurt increased to 5160 but the selling price remained at $300 per cup. How would the EBDAT breakeven change if production costs declined to 5140 per cup when the yogurt selling price remained at $3.00 per cup? G Show what would happen to the EBDAT breakeven point in terms of survival sales if an additional $30.000 was spent on advertising in 2017 while the other fixed costs remained the same, production costs remained at $1.50 per cup and the selling price remained at $300 per cup. H. Now assume that due to competition, Jen and Larry must sell their frozen yogurt for $2.80 per cup in 2017. The cost of producing the yogurt is expected to remain at $150 per cup and cash fixed costs are forecasted to be m 1S180,000 in administrative. $200.000 in marketing, and $15,000 in interest expenses). Depreciation expenses and the tax rate we also expected to remain the same as projected in the initial discussion of Jen and Larry's venture Cale Fate the EBOAT breakuven point in terms of survival breakeven revenues

Answer 1

A. How many cups of frozen yogurt would have to be sold in order for the firm to reach its projected revenues of $1.2 Millions
A. # of cups to breakeven = 1200000/$3 =	400,000.00	Cups
B. Calculate the dolar amount of EBDAT if Jen and Larry's Frozen Yogurt Company achieves the forecasted $1.2 million in sales for 2017. What would EBDAT be as a percent of revenues
EBTDA = Revenues (R) - Variable Costs (VC) – Cash Fixed Costs (CFC)
EBDAT = 1,200,000 - (1.50 x 400,000) - 180,000 - 200,000 - 15,000	$    205,000.00
EBDAT/Sales = $205,000/$1,200,000	17.08%
C. Larry believe that under a worst-case scenario, yogurt revenues would be at the 2016 level of $600,000 even after plans and expenditures were put in place to increase revenues in 2017. What would happen to the venture's EBDAT?
Worst case scenario revenue =	$    600,000.00
# of cups to breakeven = $600,000/$3 =	$    200,000.00
EBTDA = Revenues (R) - Variable Costs (VC) – Cash Fixed Costs (CFC)
EBDAT = 600,000 - (1.50x200,000) - 180,000 - 200,000 - 15,000	(95,000.00)
D. Jen and Larry also believe that, under optimistic conditions, yogurt revenues could reach $1.5 million in 2017.what would happen to the venture's EBDAT if this were to happen
Optimisitic scenario revenue	$ 1,500,000.00
# of cups to breakeven = $1,500,000/$3 =	$    500,000.00
EBTDA = Revenues (R) - Variable Costs (VC) – Cash Fixed Costs (CFC)
EBDAT = 1,500,000 - (1.50x500,000) - 180,000 - 200,000 - 15,000	355,000.00
E.Calculate the EBDAT breakeven point for 2017 in terms of survival revenues for Jen and Lary's Frozen Yogurt Company. How many cups of frozen yogurt would have to be sold to reach EBDAT breakeven?
Variable Cost Revenue Ratio (VCRR) = variable costs (VC)/revenues (R)
VCRR = (1.50 x 400,000)/1,200,000	0.50
Survival Revenues (SR) = [CFC/(1 – VCRR)]
CFC = 180,000 + 200,000  + 15,000 /(1 - .50)	$    790,000.00
# of cups to breakeven $790,000/$3	263,333.33	Cups
F. Show what would happen to the EBDAT breakeven in terms of survival revenues if the cost of producing a cup of yo- gurt increased to $1.60 but the selling price remained at $3.00 per cup. How would the EBDAT breakeven change if
Production cost	$1.60
VCRR = (1.60 x 400,000)/1,200,000	0.53
Survival Revenues (SR) = [CFC/(1 – VCRR)]
CFC = 180,000 + 200,000  + 15,000 /(1 - .53)	$    846,428.57
# of cups to breakeven $846,428.57/$3	282,142.86	Cups
Production cost	$1.40
VCRR = (1.40 x 400,000)/1,200,000	0.47
Survival Revenues (SR) = [CFC/(1 – VCRR)]
CFC = 180,000 + 200,000  + 15,000 /(1 - .47)	$    740,625.00
# of cups to breakeven = $740,625/$3	246,875.00	Cups
G. Show what would happen to the EBDAT breakeven point in terms of survival sales if an additional $30,000 was spent on advertising in 2017 while the other fixed costs remained the same, production costs remained at $1.50 per cup. production costs declined to $1.40 per cup when the yogurt selling price remained at $3.00 per cup?
VCRR= (1.50 x 400,000)/1,200,000 =	0.50
Survival Revenues (SR) = [CFC/(1 – VCRR)]
CFC = 180,000 + 230,000  + 15,000 /(1 - .50)	$    850,000.00
# of cups to breakeven $850,000/$3	283,333.33	Cups
H. Now assume that, due to competition, Jen and Larry must sell their frazen yogurt for $2.80 per cup in 2017 The cost of producing the yogurt is expected to remain at $1.50 per cup and cash fixed costs are forecasted to be $395,000 ($180,000 in administrative, $200,000 in marketing, and $15,000 in interest expenses Depreciation expenses and the tax rate are also expected to remain the same as projected in the initial discussion of Jen and Larry's venture.
# of cups to breakeven = $1,200,000/ $2.80 =	428571.43	Cups
VCRR= (1.50 x 428,571)/1,200,000 =	0.54
Survival Revenues (SR) = [CFC/(1 – VCRR)]
CFC = 180,000 + 200,000  + 15,000 /(1 - .54)	$    850,769.23
# of cups to breakeven $850,769.23/$3	303,846.15	Cups