File Home Insert Page Layout Formulas Data Review View Help Search X IG Paste Calibri 10 General - ' ' A- Wrap Text Merge a Center BIU $ - %) Clipboard Font Alignment Number AutoSave CH 19 X 4 AB 4 D MILESTONE 2 - Contribution Margin per Unit & Contribution Margin Ratio 5 6 7 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 9 10 11 12 13 14 15 16 17 18 19 20 21 22 25 24 25 26 28 SCENARIO (choose one from each cotegory: Dog Day Care 1. With pricing at $18 per dog per day, you can expect to have 22 dos 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 er day, you can expect to have 12 dogs per day 2. With pricing at $28 per do pet day, you can expect to have 10 dogs per day 3. With pricing at $30 per dor per day, you can expect to have 7 dos 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 590 per dos per day, you can expect to have 4 dogs per day 3. With pricing at 535 per dog per day, you can expect to have 3 dogs per day DAY CARE HOARDING GROOMING 5 Sales Price per Unit Costication Contribution Margin Analysis BE Type here to search O du 12 13 15 Fibe Home Insert Page Layout Formulas Data Review View Help Search Calibri General - 10 - AN Wiap Text 11.0.A-Merge Center Pante BTU- $ - % - Conditional Formatting Font Alignment Number Clipboard AutoSave 9 19 X 4 AB R 9 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 10 11 12 13 14 16 17 18 19 20 21 22 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 dos per day, you can expect to have 15 dos per day 3. With pricing at $25 per dag 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 528 per dos per day, you can expect to have 10 dogs per day 3. With pricing at 550 per dog per day, you can expect to have 7 dogs per day Bask Groom 1. With pricing at $25 per dog per day, you can expect to have dogs per day 2. With pricing at 530 per dag per day. You can expect to have 4 dos per day. 3. With pricing at $35 per des per day, you can expect to have 3 dogs per day 24 25 126 DAY CARE BOARDING GROOMING 28 29 Sales Price per unit Variable Cost per Unit Contribution Martin 31 Cost Classic Contribution Margin Analysis Type here to search RU GU E CE 16 GB YA 3 7 G w E R ACC 2012 Final Project Workbook - Excel Home sert Page Layout Formulas Data Hewww View Search X Cat 30 - AA EE Wip Tot Geen Pante BLUE OASE Merge Cert. $ - % Con FontaCel Forming at Styles Opboard Font IN Auto B 2- + SM INSTRUCTIONS FORESTONE Week 10 IMPORTANT NOTE: Make sure to letely new heric for Milestone 2 11 16 Use the data from this Milestone in working on your new Milestone/Work? 15 20 ITEMS TO COMPLETE FOR THIS MILESTONE (Green Taba): GENERAL Os Minyonya CONTRIBUTON MARGIN ANALYSIS 26 Select a price for carbon 27 Determine the charach 21 Calculate the continuare in your need the forth 19 RRIAREN ANALYS One and content for the Pied to Camera 13 The told O 1 1 3 1 2 3 5 9 6 7 Rab C W R Y ACC 202 Final File Home Insert Page Layout Formulas Data Review View X Help Calibri li Paste 10 AA 25 Wrap Text A. Merge & Center - General BIU. $9 Clipboard Font 5 Alignment AutoSave NL OH B2 S24 f A B D 15 17 18 ITEMS TO COMPLETE FOR THIS MILESTONE (Green Tabs): 20 GENERAL 22 Use data from Milestone 1 in your analysis 24 CONTRIBUTION MARGIN ANALYSIS 26 Select a price for each service (grooming day care, boarding! 27 Determine the variable cost from the Variable_Fixed tab for each service 28 Calculate the contribution margin for each service based on your sales price and the variable cost for that servie 29 30 BREAK-EVEN ANALYSIS 32 Determine the fixed cost from the variable Fixed tab for each service 33 Fixed & Variable cost designation is provided 34 Calculate the break-even units (round up) for each service 35 Calculate the break-even units (round up) for suggested target profit levels for each service 36 37 38 39 40 41 42 Instructions Milestone ? Coloribun Mann Type here to search File Home Insert Page Layout Formulas Data Review View Help Search X IG Paste Calibri 10 General - ' ' A- Wrap Text Merge a Center BIU $ - %) Clipboard Font Alignment Number AutoSave CH 19 X 4 AB 4 D MILESTONE 2 - Contribution Margin per Unit & Contribution Margin Ratio 5 6 7 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 9 10 11 12 13 14 15 16 17 18 19 20 21 22 25 24 25 26 28 SCENARIO (choose one from each cotegory: Dog Day Care 1. With pricing at $18 per dog per day, you can expect to have 22 dos 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 er day, you can expect to have 12 dogs per day 2. With pricing at $28 per do pet day, you can expect to have 10 dogs per day 3. With pricing at $30 per dor per day, you can expect to have 7 dos 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 590 per dos per day, you can expect to have 4 dogs per day 3. With pricing at 535 per dog per day, you can expect to have 3 dogs per day DAY CARE HOARDING GROOMING 5 Sales Price per Unit Costication Contribution Margin Analysis BE Type here to search O du 12 13 15 Fibe Home Insert Page Layout Formulas Data Review View Help Search Calibri General - 10 - AN Wiap Text 11.0.A-Merge Center Pante BTU- $ - % - Conditional Formatting Font Alignment Number Clipboard AutoSave 9 19 X 4 AB R 9 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 10 11 12 13 14 16 17 18 19 20 21 22 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 dos per day, you can expect to have 15 dos per day 3. With pricing at $25 per dag 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 528 per dos per day, you can expect to have 10 dogs per day 3. With pricing at 550 per dog per day, you can expect to have 7 dogs per day Bask Groom 1. With pricing at $25 per dog per day, you can expect to have dogs per day 2. With pricing at 530 per dag per day. You can expect to have 4 dos per day. 3. With pricing at $35 per des per day, you can expect to have 3 dogs per day 24 25 126 DAY CARE BOARDING GROOMING 28 29 Sales Price per unit Variable Cost per Unit Contribution Martin 31 Cost Classic Contribution Margin Analysis Type here to search RU GU E CE 16 GB YA 3 7 G w E R ACC 2012 Final Project Workbook - Excel Home sert Page Layout Formulas Data Hewww View Search X Cat 30 - AA EE Wip Tot Geen Pante BLUE OASE Merge Cert. $ - % Con FontaCel Forming at Styles Opboard Font IN Auto B 2- + SM INSTRUCTIONS FORESTONE Week 10 IMPORTANT NOTE: Make sure to letely new heric for Milestone 2 11 16 Use the data from this Milestone in working on your new Milestone/Work? 15 20 ITEMS TO COMPLETE FOR THIS MILESTONE (Green Taba): GENERAL Os Minyonya CONTRIBUTON MARGIN ANALYSIS 26 Select a price for carbon 27 Determine the charach 21 Calculate the continuare in your need the forth 19 RRIAREN ANALYS One and content for the Pied to Camera 13 The told O 1 1 3 1 2 3 5 9 6 7 Rab C W R Y ACC 202 Final File Home Insert Page Layout Formulas Data Review View X Help Calibri li Paste 10 AA 25 Wrap Text A. Merge & Center - General BIU. $9 Clipboard Font 5 Alignment AutoSave NL OH B2 S24 f A B D 15 17 18 ITEMS TO COMPLETE FOR THIS MILESTONE (Green Tabs): 20 GENERAL 22 Use data from Milestone 1 in your analysis 24 CONTRIBUTION MARGIN ANALYSIS 26 Select a price for each service (grooming day care, boarding! 27 Determine the variable cost from the Variable_Fixed tab for each service 28 Calculate the contribution margin for each service based on your sales price and the variable cost for that servie 29 30 BREAK-EVEN ANALYSIS 32 Determine the fixed cost from the variable Fixed tab for each service 33 Fixed & Variable cost designation is provided 34 Calculate the break-even units (round up) for each service 35 Calculate the break-even units (round up) for suggested target profit levels for each service 36 37 38 39 40 41 42 Instructions Milestone ? Coloribun Mann Type here to search
