what do you need from me?

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 one.

OPERATIONAL DATA Grooming: The Groomer can groom 5 dogs a day, 5 days a week Each grooming takes 1.5 labor hours Day Care: The Day Care can house 10 large dogs and 12 small dogs daily. Day Care is offered 6 days a week Boarding: There are 12 kennels (single dog only). Boarding (kennel services) is offered every day Facilities: The Grooming facility is 200 square feet The Boarding facility is 2,500 square feet The Day Care facility is 1,500 square feet General: Loan for start-up costs - monthly payment of $420; in effect immediately; limited cash and loan funding - used angel investors Modest monthly draw of $600 a month for first year; should be divided evenly amoung the services (grooming, day care, boarding) SALARY & HIRING DATA Groomer (Allison) - $12.00 an hour, 40 hours a week Day Care Attendant (Beverly) - $9.00 per hour, based on need Receptionist (Cathie) - $8.50 per hour, 30 hours a week Kennel Attendant (Ben) - $11.50 per hour, based on need OTHER COST DATA Grooming: Dog Grooming Arm - $300 . Grooming Table - $900 Grooming Tub - $2,800 Clippers - $136.99; can be used for 100 grooms Shampoo - $103.96 per 5-gallon pail; can be used for 100 grooms Salon Tuff Capri Mobile Carry Cart - $90 Scissors (7 inch straight) - $194.99; used for 200 grooms Scissors (ear and nose) - $7.49; used for 200 grooms Day Care: Fencing for Day Care area - $1,249 Fencing Installation - $1,000 Toys - $3.29 per 6 pack; one toy will last for two dogs in day care per day Rubberized Flooring for Day Care - $3,800 Boarding: 12 Kennels; Depreciation is $80 per month General: Food & Water bowls - $3.59 per unit Day Care - two bowls last for every 75 dogs that attend daycare Boarding - two bowls last for every 100 dogs boarded; two bowls per kennel Grooming - each bowl lasts for 20 grooms and you need 4 bowls at all times Towels - $34.99 per 12 pack Day Care - 12 towels for every 25 dogs Boarding - 12 towels for every 40 dogs Grooming - 2 towels for every groom per day Heating System - $10,000; Depreciation is $83 per month; Allocate based on square footage Rent - $650 per month; Allocate based on square footage Utilities / Insurance - $600 per month; Allocate based on square footage Cage Bank - $2,200 per set of 5 Dryer - $1,250 Cleaning Products Odoban - $14.55 per gallon; Each area wil dilute 1 oz to 1 gallon of water; Allocate based on square footage Simple Green - $15.66 per gallon; Each area will dilute 1 oz to 1 gallon of water; Allocate based on square footage

AutoSave OH ACC 200 Final Project Wo File Home Insert Page Layout Formulas Data Review View Search Help Calibri General Xcut La Copy Paste Format Painte 110 UAA EE 2 Wrap Test BVA- === E Merge & Center Font $ % 90 Conditional Formatas Formatting Table Clipboard Alignment Number 010 c D G . AB 1 2 HOME 3 Ruff Ruff's Grooming Company MILESTONE 2 - Contribution Margin per Unit & Contribution Marein Ratio 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 to completed in Milestone 1 4 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 28 29 31 32 34 35 36 27 38 39 40 41 42 43 44 45 45 SCENARIO (choose one from each category: Dog Day Care 1. With pricing at $18 per dog per day. You can expect to have 22 dolay 2. With pricing at $20 per dog per day. You can exit to have 15 dogs per day 3. With pricing at $25 per dos per day you can expect aveces 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 ber day, you can expect have 7 does per day Basic Groom 1. With pricing at $25 per dog per day, you can expect to have dogs per day 2 with pricing at $30 er dog per day, you can expect to have per day 3. With pricing at $35 per dog per day, you can have aldosters DAY CARE BOARDING GROOMING $ $ Sles Price per Unit Variable cost per Unit Contribution Margin $ Contr instructions instructions Milestone Company Profile Cost Classification Variable Fred Type here to search ACC 202 Final Project Wor AutoSave OH Data Review View Formulas Home Help O Search Fue Insert Page Layout General LLA 2 x can Calib 10 LLO Copy AA EE A 29 Wrap Text Merge & Center Paste Bu $ % 8-98 Conditional Format as Formatting Table Format Painter Clipboard Font Alignment Number F40 G H 1 $ AB C D E 9 Fill in the blanks to get the per unit cost and fixed cost of each Service 10 11 Based on 5 rooms per day 12 GROOMING 14 1 Item Variable costs Item 16 Shampoo $ 104 Groomer 17 Clipper(s) 137 Rent 18 Bowls 0.22 Loan 19 Towels 5.83 Utilities and Insurance 20 Scissors 101 Depreciation on eatine system 21 cleaning Products Odoban 22 Cleaning Products Simple Green 28 Draw 25 Total Variable Costs 9.92 Total Fixed costs 26 Fixed Costs 2.000.00 30.95 20.00 28.57 395 2.08 2.36 200.00 2,367.91 28 29 21 32 34 35 36 37 38 39 41 42 Based on 22 dogs per day for six days a weekAssume 25 operating days for kenneland 22 went our work days for Kennel attendant DAY CARE Item Variable Costs tem Fixed Costs Day care attendant $ 2 88 Rent S 232.14 Toys 027 Loan 150.00 Bowls 0.10 Utilities and Insurance 21420 Towels 1.40 Depreciation on being 29 64 Cleaning Products Odoban 15.59 Cleaning Product Simple Greer 16.76 Otaw 200.00 Total Variable costs S 4.65 To Fixed Co $ 858.44 44 47 40 5 0 51 52 53 54 Based on 12 dogs per day. Assume 22 eight-hour work days for Mennell attendant BOARDING Item Variable costs Hem Kernel attendant $ 52 Dennels Bowls 0.86 Rent Towels 0.87 Loon and insurance Depreciate heating system cleaning Products Odoban cleaning Products Simple Green Drow Total Variable costs 2.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 56 58 39 s 61 Instructions Intructions Milestone 1 Company Profile Cost Classdication Variable Fixed Type here to search O 2 W AutoSave OH ACC 200 Final Project Wo File Home Insert Page Layout Formulas Data Review View Search Help Calibri General Xcut La Copy Paste Format Painte 110 UAA EE 2 Wrap Test BVA- === E Merge & Center Font $ % 90 Conditional Formatas Formatting Table Clipboard Alignment Number 010 c D G . AB 1 2 HOME 3 Ruff Ruff's Grooming Company MILESTONE 2 - Contribution Margin per Unit & Contribution Marein Ratio 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 to completed in Milestone 1 4 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 28 29 31 32 34 35 36 27 38 39 40 41 42 43 44 45 45 SCENARIO (choose one from each category: Dog Day Care 1. With pricing at $18 per dog per day. You can expect to have 22 dolay 2. With pricing at $20 per dog per day. You can exit to have 15 dogs per day 3. With pricing at $25 per dos per day you can expect aveces 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 ber day, you can expect have 7 does per day Basic Groom 1. With pricing at $25 per dog per day, you can expect to have dogs per day 2 with pricing at $30 er dog per day, you can expect to have per day 3. With pricing at $35 per dog per day, you can have aldosters DAY CARE BOARDING GROOMING $ $ Sles Price per Unit Variable cost per Unit Contribution Margin $ Contr instructions instructions Milestone Company Profile Cost Classification Variable Fred Type here to search ACC 202 Final Project Wor AutoSave OH Data Review View Formulas Home Help O Search Fue Insert Page Layout General LLA 2 x can Calib 10 LLO Copy AA EE A 29 Wrap Text Merge & Center Paste Bu $ % 8-98 Conditional Format as Formatting Table Format Painter Clipboard Font Alignment Number F40 G H 1 $ AB C D E 9 Fill in the blanks to get the per unit cost and fixed cost of each Service 10 11 Based on 5 rooms per day 12 GROOMING 14 1 Item Variable costs Item 16 Shampoo $ 104 Groomer 17 Clipper(s) 137 Rent 18 Bowls 0.22 Loan 19 Towels 5.83 Utilities and Insurance 20 Scissors 101 Depreciation on eatine system 21 cleaning Products Odoban 22 Cleaning Products Simple Green 28 Draw 25 Total Variable Costs 9.92 Total Fixed costs 26 Fixed Costs 2.000.00 30.95 20.00 28.57 395 2.08 2.36 200.00 2,367.91 28 29 21 32 34 35 36 37 38 39 41 42 Based on 22 dogs per day for six days a weekAssume 25 operating days for kenneland 22 went our work days for Kennel attendant DAY CARE Item Variable Costs tem Fixed Costs Day care attendant $ 2 88 Rent S 232.14 Toys 027 Loan 150.00 Bowls 0.10 Utilities and Insurance 21420 Towels 1.40 Depreciation on being 29 64 Cleaning Products Odoban 15.59 Cleaning Product Simple Greer 16.76 Otaw 200.00 Total Variable costs S 4.65 To Fixed Co $ 858.44 44 47 40 5 0 51 52 53 54 Based on 12 dogs per day. Assume 22 eight-hour work days for Mennell attendant BOARDING Item Variable costs Hem Kernel attendant $ 52 Dennels Bowls 0.86 Rent Towels 0.87 Loon and insurance Depreciate heating system cleaning Products Odoban cleaning Products Simple Green Drow Total Variable costs 2.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 56 58 39 s 61 Instructions Intructions Milestone 1 Company Profile Cost Classdication Variable Fixed Type here to search O 2 W