Molly\'s Cupcakes management is trying to decide whether to stay in business. They are currently losing money. They want to know how close they are to making a profit. They are also considering a couple of alternatives in their quest for profitability Molly\'s provided the following information from the most recent monthly financials: Revenue Expense Profit (loss) 3,1002 $34,000 37,100 When talking to Molly\'s management, you first asked two questions to help you understand the data provided: (1) What costs are included in expenses? (2) How do these costs behave? Management responded with the following information Costs have been matched to revenue to determine what costs should appear as expenses. The costs of goods remaining in inventory are not included in expenses There are no fixed manufacturing costs. Cost of sales is 40% of revenue $8,500 of the selling and administrative expenses are variable Costs and selling prices are expected to remain stable for at least the next two years . . · Required (use excel spreadsheet): 1. Show that you understand Molly\'s cost structure by showing its income statement in contribution margin format. Note: In this problem we don\'t know the number of cupcakes (units) sold, so we cannot compute per unit numbers for sales price, variable cost per unit, and contribution margin per unit. You should instead compute the variable expense (cost) ratios and the contribution margin ratio to help you in your analysis 2. Management wants to know how close they are to making a profit. Compute the break-even point and margin of safety. What is the increase in revenue required for Molly\'s to break-even? Does this increase seem achievable in the short-term? Explain Management\'s goal is to make a pre-tax profit (NOI) of $4,000 each month. Compute the increase in sales dollars that would be re quired to hit this target? Does this increase seem achievable in the short term? Explain 3. Management is considering two alternatives to increase profitability. The first alternative is to invest in monthly advertising. This ad vertising will cost $1,000 and is expected to increase sales volume by 20%. Prepare a new contribution format income statement for this alternative. What is the impact on profit of this alternative? Compute the BEP and margin of safety percentage with this alter native 4. The second alternative management is considering is cost cutting. Management believes it can cut fixed cost by $1,500. It has also learned through trade association meetings that similar stores have selling and administrative expenses of 10% of revenue (bench- marking). Prepare a new contribution format income statement for this alternative. What is the impact on profit of this alternative? Compute the BEP and margin of safety percentage with this alternative 5.
Solution 1:
Sales = $34,000
Total Expense = $37,100
Cost of Sales (Variable) = 40% of Revenue = 40% of $34,000 = $13,600
Selling and adminstrative expense = $37,100 - $13,600 = $23,500
Variable Selling and administrative expense = $8,500
Fixed Selling and administrative expense = $23,500 - $8,500 = $15,000
Contribution margin ratio = Contribution / Sales *100 = $11,900/$34,000*100 = 35%
Variable expenses ration = Variable cost / Sales *100 = $22,100 / $34,000*100 = 65%
Solution 2:
Break even point = Fixed cost / contributon margin ratio = $15,000/35% = $42,857.14
Margin of safety = Current level sale - break even point = $34,000 - $42,857.14 = -$8,857.14
Current sale = $34,000
Required increase in sale for breakeven = $42857.14 - $34,000 = $8,857.14
If company will make efforts and do some expenditure on advertisement etc then this increase seems acheivable in short term.
Solution 3:
Target Profit = $4,000
Target contribution = $4,000 + $15,000 = $19,000
Target Sales = Target contributon / Contribution margin = $19,000/35% = $54,285.71
Required increase in sales = $54,285.71 - $34,000 = $20,285.71
Required increase in sales is 60% of current level sales which is a high percentage that seems non achievable in short term.
Solution 4:
Impact on profit from this alternative = Revised Profit - Existing profit = -$1,720 - (-$3,100) = $1,380
Hence profit will be increased by $1,380 by this alternative.
Revised break even point = $16,000 / 35% = $45,714.28
Margin of Safety = $40,800 - $45714.28 = -$4,914.28
Margin of safety percentage = -$4914.28 / $40,800 *100 = 12.04%
| Income Statement - Molly\'s Cupcakes |
| Particulars | Amount |
| Sales | $34,000.00 |
| Variable Cost: | |
| Cost of Sales | $13,600.00 |
| Variable Selling and Administrative expense | $8,500.00 |
| |
| Contribution | $11,900.00 |
| |
| Fixed Selling and Administrative expense | $15,000.00 |
| |
| Profit (Loss) | -$3,100.00 |
Homework Sourse
