milstone one :
INSTRUCTIONS: Determine the per unit cost for each dog. Fill in the blanks to get the per unit cost and fixed cost of each service. Based on 5 grooms per day
GROOMING Item Variable Costs Item Fixed Costs
Shampoo $ 1.04 Groomer $ 2,080.01
Clipper(s) 1.37 Rent 30.95
Bowls 0.72 Loan 20.00
Towels 5.83 Utilities and Insurance 28.57
Scissors 1.01 Depreciation on heating system 3.95 Cleaning Products: Odoban 2.08 Cleaning Products: Simple Green 2.36 Draw 200.00
Total Variable Costs $ 9.97 Total Fixed Costs $ 2,367.92
Based on 22 dogs per day for six days a week. Assume 25 operating days for kennel and 22 eight-hour work days for kennel attendant.
DAY CARE Item Variable Costs Item Fixed Costs
Day care attendant $ 2.88 Rent $ 232.14 Toys 0.27 Loan 150.00 Bowls 0.10 Utilities and Insurance 214.29 Towel 1.40 Depreciation on heating system 29.64 Cleaning Products: Odoban 15.59
Cleaning Products: Simple Green 16.78 Draw 200.00Total Variable Costs $ 4.65 Total Fixed Costs $ 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 $ 5.62 Depreciation on kennels $ 80.00 Bowls 0.86 Rent 386.90
Towels 0.87 Loan 250.00 Utilities and Insurance 357.14 Depreciation on heating system 49.40 Cleaning Products: Odoban 25.98
Cleaning Products: Simple Green 29.55 Draw 200.00 Total Variable Costs$ 7.36 Total Fixed Costs$1,378.99
Select a price from the scenarios below and compute the contribution for each service based on your selected price.INSTRUCTIONS:
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
DAY CARE , BOARDING, GROOMING
Sales Price $ - $ - $ -
Variable Cost per Unit - - -
Contribution Margin$ - $ - $ -
contribution margin = selling price per unit - variable cost per unit
DAY CARE |
BOARDING |
GROOMING |
|
Sales price |
18 |
25 |
25 |
Variable cost per unit |
4.65 |
7.36 |
9.97 |
Contribution margin |
13.35 |
17.64 |
15.03 |
Dear Student,
Kindly take note that the calculation for contribution margin has been provided based on the sales and variable cost per unit details provided by you.
milstone one : INSTRUCTIONS: Determine the per unit cost for each dog. Fill in the blanks...
INSTRUCTIONS: Determine the per unit cost for each dog. Fill in the blanks to get the per unit cost and fixed cost of each service. Based on 5 grooms per day GROOMING Item Variable Costs Item Fixed Costs 1.37 Shampoo Clipper(s) Bowls Towels Scissors ou Groomer Rent Loan Utilities and Insurance Depreciation on heating system Cleaning Products: Odoban Cleaning Products: Simple Green Draw Total Fixed Costs 30.95 20.00 28.57 3.95 2.08 2.36 200.00 2,367.91 Total Variable Costs $ 9.97 $...
Data: MILESTONE 1 - Variable & Fixed Cost Exercise INSTRUCTIONS: Determine the per unit cost for each dog. Fill in the blanks to get the per unit cost and fixed cost of each service. Based on 5 grooms per day GROOMING Variable Costs Fixed Costs Item Item Shampoo 1.04 Groomer 2,080.01 Clipper(s) Bowls 30.95 1.37 Rent 0.72 20.00 Loan Utilities and Insurance Towels 5.83 28.57 1.01 Depreciation on heating system Scissors 3.95 Cleaning Products: Odoban 2.08 Cleaning Products: Simple Green...
I am having trouble figuring this out. How do I break down the calculations? INSTRUCTIONS FOR MILESTONE 2 (Due Week 4) IMPORTANT NOTE: Make sure to completely review the Rubric for Milestone 2 Use the data from this Milestone and begin working on your final presentation due in Milestone 4 (Week 7) ITEMS TO COMPLETE FOR THIS MILESTONE (Green Tabs): GENERAL Use data from Milestone 1 in your analysis CONTRIBUTION MARGIN ANALYSIS Select a price for each service (grooming, day...
help? I am a little lost here. ITEMS TO COMPLETE FOR THIS MILESTONE (Blue Tabs): GENERAL You plan to open a pet services business that will offer dog grooming, day care and boarding COMPANY PROFILE TAB Determine a company name. B crete (e.g. "Inspiring Dog Care"] Pick a location (e.g. "Chicago") Define your company's vision and mission for how your business will add value to the community COST CLASSIFICATION Accurately classify all of your costs [direct material, direct labor, manufacturing...
VARIABLE & FIXED COSTS: Determine your per unit cost per dog for grooming, day care and boarding OPERATIONAL & COST INFORMATION: For simplicity, base all calculations using 30 days in each month 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...
Can I get some help??? Did I complete this problem correctly? GENERAL You plan to open a pet services business that will offer dog grooming. day care and boarding COMPANY PROFILE TAB Determine a company name. Be creative fe.q. "Inspiring Dog Care" Pick a location feq. "Chicago" Define your company's vision and mission for how your business will add value to the community COST CLASSIFICATION Accurately classify all of your costs (direct material, direct labor, manufacturing overhead, period costs) Fixed...
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...
I have to find the fixed costs for GROOMER Also I have to write the answer with the Excel formula E FO Number 5 Formatting Table Styles Clipboard Font Alignment Styles Q12 . в со E F G H I J K L M мора For simplicity, base all calculations using 30 days in each month 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...
Overview: In the first milestone of your final project, you will determine and classify the costs necessary for opening your business. This is a critical step that must be done correctly for you to successfully complete the subsequent milestones and the final submission. Scenario: Prior to Opening, Part I: You plan to open a pet-services business that will offer dog grooming, day care, and boarding. You can be creative in deciding the name of your business (e.g., "Inspiring Dog Care"),...
please help with the income statement - + Fit to page D Page view A Read aloud h Add notes Overview: In the third milestone, you will jump forward in time: Imagine that your business has already opened. Use the updated scenario information to analyze your company's performance. o Post-opening Scenario: Your angel investors are silent in relation to the business; however, they require board meetings for status updates on the company's financial health. Therefore, you need to analyze your...