INSTRUCTIONS: Select a price from the scenarios below and compute the contribution for each service based on your selected price. Variable cost per unit comes from your Variable_Fixed tab completed in Milestone 1. SCENARIO (choose one from each category): Dog Day Care 1. With pricing at $18 per dog per day, you can expect to have 22 dogs per day. 2. With pricing at $20 per dog per day, you can expect to have 15 dogs per day. 3. With pricing at $25 per dog per day, you can expect to have 10 dogs per day. Overnight Boarding 1. With pricing at $25 per dog per day, you can expect to have 12 dogs per day. 2. With pricing at $28 per dog per day, you can expect to have 10 dogs per day. 3. With pricing at $30 per dog per day, you can expect to have 7 dogs per day. Basic Groom 1. With pricing at $25 per dog per day, you can expect to have 5 dogs per day. 2. With pricing at $30 per dog per day, you can expect to have 4 dogs per day. 3. With pricing at $35 per dog per day, you can expect to have 3 dogs per day. BOARDING GROOMING DAY CARE $ $ Sales Price per Unit Variable Cost per Unit Contribution Margin $ $ S Based on 5 grooms per day GROOMING Item Item Fixed Costs S S Shampoo Clipper(s) Bowls Towels Scissors Variable Costs 1.04 1.37 0.72 5.83 1.01 Groomer Rent Loan Utilities and Insurance Depreciation on heating system Cleaning Products: Odoban Cleaning Products: Simple Green Draw Total Fixed Costs 2,080.00 30.95 20.00 28.57 3.95 2.08 2.36 200.00 2,367.91 Total Variable Costs 9.97 $ Based on 22 dogs per day for six days a week. Assume 25 operating days for ken 122 eight-hour work days for kennel attendant. DAY CARE Item Variable Costs Item Fixed Costs Day care attendant S 2.88 Rent 232.14 Toys 0.27 Loan 150.00 Bowls 0.10 Utilities and Insurance 214.29 Towels 1.40 Depreciation on heating system 29.64 Cleaning Products: Odoban 15.59 Cleaning Products: Simple Green 16.78 Draw 200.00 Total Variable Costs S 4.65 Total Fixed Costs $ 858.44 Item S Based on 12 dogs per day. Assume 22 eight-hour work days for kennel attendant BOARDING Item Variable Costs Kennel attendant S 5.62 Depreciation on kennels Bowls 0.86 Rent Towels 0.87 Loan Utilities and Insurance Depreciation on heating system Cleaning Products: Odoban Cleaning Products Simple Green Draw Total Variable Costs $ 7:35 Total Fixed Costs Fixed Costs 80.00 386.90 250.00 357.14 49.40 25.98 29.55 200.00 1.378.97 $