Question

can you please help me figure out the break even analysis? (last photo

fx =ROUND(420*(2500/4200),2) Total Variable Costs 2$ 4.65 Total Fixed Costs 2$ 858.44 Based on 12 dogs per day. Assume 22 eight-hour work days for kennel attendant. BOARDING Item Variable Costs Item Fixed Costs Kennel attendant 2$ 5.62 Depreciation on kennels 2$ 80.00 Bowls 0.86 Rent 386.90 Towels 0.87 Loan 250.00 Utilities and Insurance 357.14 Depreciation on heating system Cleaning Products: Odoban Cleaning Products: Simple Green 49.40 25.98 29.55 Draw 200.00 Total Variable Costs 7.35 Total Fixed Costs 2$ 1,378.97 Cost Classification Variable Fixed Instructions Milesto Instructions Instructions- Milestone 1 Company Profile Type here to search

)

Answer 1

B Day care Boarding $ 25.00 | $ $858.00 $1,379.00 $2,368.00 $ 20.35 $ Grooming 25.00 $ 2 Sales Price 25.00 3 Fixed Price 4 Contribution Margin 17.64 $ 15.03 5 Breakeven Units (Round up) 158 43 79 $417.00 $ 583.00 $1,000.00 7 Targeted Profit 8 Breakeven Units (Round up) 225 63 112 $ 667.00 $ 909.00 $1,500.00 10 Targeted Profit 11 Breakeven Units (Round up) 258 75 130 12

B D Day care Boarding Grooming 25 2 Sales Price 25 25 3 Fixed Price 2368 858 1379 4 Contribution Margin 17.64 20.35 15.03 |=ROUNDUP(C3/C4,0) |=ROUNDUP(D3/D4,0) 5 Breakeven Units (Round up) |=ROUNDUP(B3/B4,0) 7 Targeted Profit 417 583 1000 |=ROUNDUP((B3+B7)/B4,0) |=ROUNDUP((C3+C7)/C4,0) Breakeven Units (Round up) =ROUNDUP((D3+D7)/D4,0) 10 Targeted Profit 11 Breakeven Units (Round up) 667 909 1500 |=ROUNDUP((B3+B10)/B4,0) =ROUNDUP((C3+C10)/C4,0) =ROUNDUP((D3+D10)/D4,0) 12

With the data given in the last image, the solution is provided above. In case of clarification, please do comment. The excel formula is also imaged for your reference.