Question

In: Finance

1. Alicia is the owner-operator of Cool Beans, a local coffee shop. For the past year,...

1. Alicia is the owner-operator of Cool Beans, a local coffee shop. For the past year, Cool Beans sold 215,000 drinks at an average price of $2.95 per serving. Her average variable cost per serving was $1.15. Currently, she has been using local TV and newspapers to generate interest and awareness at a cost of $171,000 per year. She recently contacted Brushfire Social Media and they estimated they could reach the same number of people in her community with a social media budget at half the cost, though it would require an additional one-time investment of $14,000 in their website and social platforms. As an additional option, Brushfire suggested a separate promotional campaign that would offer a $1 discount to any person who likes their social media page. Brushfire estimates that Cool Beans would sell an additional 5,900 cups with this discount and this new campaign would cost $2,500.

1. What is the Marketing ROI for the Brushfire website and social media plan compared to their current approach? ___ %

2. SleepItOff Properties is a West Coast company that owns and operates several hotel chains. Here is their partially completed income statement for the most recent fiscal year. Matt Tress, a summer intern for the finance team was asked to calculate some basic performance metrics as part of his training. He also was told that the company had $15 million in cash and $206 million of other assets. For Year Ending Dec 31, 2013 $Mill Total Revenue $88 Cost of Revenue $31 Gross Profit ? General, Selling and Admin $20 Depreciation $10 Operating Income or Loss ? Interest Expense $15 Pre-Tax Income ? Income Taxes ? Net Income ? If SleepItOff's Tax Rate is 30%

2. What is SleepItOff's Net Income?

Solutions

Expert Solution

1. Computation of Cool-bean Marketing Return on Investment:

Particulars Current Approach Brushfire website and social media plan
Sales of drinks (Cups) 215000 215000
Sale of additonal cups due to promotional campaign 0 5900
A Expected sale of drinks 215000 220900
B Selling price per cup 2.95 2.95
C Total sales value = A X B 634250 651655
D Less: Variable Cost per cup:
        Existing variable Cost per cup 247250 247250
        Promotional campaign 0 2500
E Contribution = C-D 387000 401905
F Less: Fixed Cost
For Current approach- TV and news paper 171000 -
For Brushfire social media- (50% of Current cost) - 85500
For one time website and social platforms - 14000
G Profit = E-F 216000 302405
Marketing ROI = Profit/Total Investment *100 51.64 86.59

Note: Total investment = Total variable cost + Total fixed cost

2. Calculation of Sleepit Off properties Net income:

Particulars

Amount in $ in Million

Revenues

88.00

Less: Cost of Revenue

31.00

Gross Profit

57.00

Less: General and Administraive Expenses

20.00

Less: Depreciation

10.00

EBIT or Operating profit

27.00

Less: Interest expenses

15.00

EBT or Pre Tax income

12.00

Less: Tax expenses 30%

3.60

Net Income

8.40

Related Solutions

Alicia is the owner-operator of Cool Beans, a local coffee shop. For the past year, Cool...
Alicia is the owner-operator of Cool Beans, a local coffee shop. For the past year, Cool Beans sold 280,000 drinks at an average price of $2.92 per serving. Her average variable cost per serving was $1.40. Currently, she has been using local TV and newspapers to generate interest and awareness at a cost of $144,000 per year. She recently contacted Brushfire Social Media and they estimated they could reach the same number of people in her community with a social...
Question 1 The coffee shop A coffee shop knows from past records that its weekly takings...
Question 1 The coffee shop A coffee shop knows from past records that its weekly takings (sales) are normally distributed with a mean of $10,500 and a standard deviation of $478. Answer the following questions: Find the probability that in a given week the coffee shop would have takings of more than $10,700 Find the probability that in a given week the takings are between $9,800 and $11,000. Calculate the inter-quartile range of weekly takings. What are the maximum weekly...
Question 1 The coffee shop A coffee shop knows from past records that its weekly takings...
Question 1 The coffee shop A coffee shop knows from past records that its weekly takings (sales) are normally distributed with a mean of $10,500 and a standard deviation of $478. Answer the following questions: a. Find the probability that in a given week the coffee shop would have takings of more than $10,700 b. Find the probability that in a given week the takings are between $9,800 and $11,000. c. Calculate the inter-quartile range of weekly takings. d. What...
Preparing adjusting entries (annual)—depreciation LO4 Mean Beans, a local coffee shop, has the following assets on...
Preparing adjusting entries (annual)—depreciation LO4 Mean Beans, a local coffee shop, has the following assets on January 1, 2017. Mean Beans prepares annual financial statements and has a December 31, 2017 year-end. On January 1, 2017, purchase equipment costing $15,000 with an estimated life of five years. Mean Beans will scrap the equipment after five years for $0. On July 1, 2017, purchase furniture (tables and chairs) costing $12,000 with an estimated life of ten years. Mean Beans estimates that...
A local bookstore is considering adding a coffee shop to their store. Building the coffee shop...
A local bookstore is considering adding a coffee shop to their store. Building the coffee shop will cost $235,956.00 today. The bookstore is going to try this project for five years. The bookstore wants a 12.00% return on their investment. What yearly cash flow must this project generate to “break-even”? Answer format: Currency: Round to: 2 decimal places.
Cool Beans is a locally owned coffeeshop that competes with two large coffee chains, PlanetEuro and...
Cool Beans is a locally owned coffeeshop that competes with two large coffee chains, PlanetEuro and Frothies. Alicia, the owner, is considering two different marketing promotions and thinks that CLV analysis will help her decide the best course of action. An average specialty coffee drink sells for $4.20 and has a margin of 76%. One promotion is providing loyalty cards to her regular customers that would give them one free specialty coffee drink after 10 regular purchases. Alicia estimates that...
b) Is it advisable for a coffee shop owner to increase the price of his coffee...
b) Is it advisable for a coffee shop owner to increase the price of his coffee if demand for coffee is price inelastic? Explain briefly using a diagram that demonstrates the impact on the firm’s Total Revenue. c) Nicolas says that if income elasticity of demand for sugar is -0.7, sugar is an inferior good. Steve disagrees and claims that it is a necessity. Define income elasticity of demand and explain who is right and who is wrong with their...
a coffee shop buys beans 3.2$ per bag, and it sells it for 5.25 $. this...
a coffee shop buys beans 3.2$ per bag, and it sells it for 5.25 $. this coffee shop sales are 21 bag per week. its annual inventory holding cost rate is 25% and it costs this coffee shop 20$ to place an order with the bean supplier. if the bean supplier offers a 7% discount on orders of 400 bags or more and 10% discount for 900 bags or more. A) What is the optimal order quantity for the coffee...
In a sample of 28 cups of coffee at the local coffee shop, the temperatures were...
In a sample of 28 cups of coffee at the local coffee shop, the temperatures were normally distributed with a mean of 182.5 degrees with a sample standard deviation of 14.1 degrees. What would be the 95% confidence interval for the temperature of your cup of coffee?
The owner of a specialty coffee shop wants to study coffee purchasing habits of customers at...
The owner of a specialty coffee shop wants to study coffee purchasing habits of customers at her shop. She selects a random sample of 60 customers during a certain week. Data are available in the worksheet labeled “Problem 2” in the spreadsheet. 1. Construct a 90% confidence interval on the proportion of customers who say they “definitely will” recommend the specialty coffee shop to family and friends. Problem 2 Data Set Note: Y is an indicator variable, i.e., if Y=1,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT