In: Finance
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?
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 |