ACC 203 Final Project Workbook 1. Exce Home Insert Page Layout Formulas Data Review View Help Search 05 Calib 10 ste - AA BIU-E-AA- General 2 Wrap Test Merge & Center - $ - % pboard Condit Formatti Font Alignment toSave Number Oe 50 XB AB 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 foxed cost of each service 1 2 4 Item Based on 5 rooms per day GROOMING Item Shampoo Clippers Bowls Towels Scissors Variable costs 104 1.37 0.72 18 39 20 21 583 101 Groomer Rent Loan Utilities and insurance Depreciation on heating system Cleaning Products Odobon Cleaning Products Simple Green Draw Total Fixed Costs Fixed Costs 2,080.00 30.95 20.00 28.57 395 2.08 2.36 200.00 3,167,91 23 25 26 Total Variable costs 3 9.97 28 Based on 22 dogs per day for six days a week. Assume 25 operating days for kennel and 22 hour work days for entendant DAY CARE Variable Fixed Type here to search o + E 1 12 15 ACC 202 Final Project Workbook-1 Excel Fle Home Insert Page Layout Formulas Data Review View Help Search ca -10 AA = BIU..A General Paste 13 Wrap Merge Center - $. % 941 ins Conditional Formatas Call Formatting Table Style Stiri Font 15 Chipboard Autise Aliment Number 19+ 130 29 31 33 34 Based on 23 does per day for six days a week. Asume 25 operating days for lenne and 2 our work days for sannel attendant DAY CARE Variable costs Ford Costs Dewcate attendant 2.88 Rent 2:32.14 Toys 027 Loan 150.00 Bowls 0.10 Utilities and insurance 21429 Tous 140 Depreciation in system Cleaning Products Odoban 1550 Che Products mole Green 16.78 Drew 20000 Total Variable costs Total Fed Costs 3 8584 36 37 30 41 44 30 Based on perdey Assu2ght our work days forenelatendant DOARDING RE Kennel ten 5. Oreciation Bours Twis 081 valities and runte Dating LO Feed Cats 80.00 SONO 25000 157.14 440 12 H Tybe here to search fi BD 19 YA 2 & 7 2 3 4 5 6 8 W F ACC 202 Final Project Workbook 1 - Excel Home insert Page Layout Formulas Data Review View Help Search Calibri - General BIV- -10 - AA Wrap Text C. A.A. Merge a Center Alignment $ -% - pboard Font Conditional Formats Formatting Tables Styles utolive Number 0 -50 AB 3 4. 5 G 232.14 150.00 214 29 29.64 1559 16.25 200.00 ER 5 1 12 14 5:44 C Day care attendant $ 2.88 Rent Toys 027 Loan Bowls Ulities and Insurance Towels 140 Depreciation on heating system Cleaning Products Odoban Cleaning Products Simple Green Draw Total Variable Costs 4.65 Total Fied Costs Based on 12 dogs per day. Assume 22 eight-hour work days for kennel attendant BOARDING Variable costs Kennel attendant 5.62 Depreciation onnels Bowls 0.86 Rent Towels 0.37 Loan Utilities and insurance Depreciation on heating wstem Cleaning Products Odoban Cleaning Products Simple Green Or Total Variable Couts 5 2.35 Total Fed Costa $ 47 49 50 52 52 sa 54 Fixed costs BODO 3860 25000 357.14 2590 56 200.00 50 s Variable Fixed Type here to search O BE #1 12R 13 15 3 5 6 7 Home ACC 202 Final Project Workbock-1 Excel Insert Page Layout Formulas Data Review View Help Search Calibri 10 Paste BIU A A A. Wiap Text Merge Center - General $ -% - Clipboard AutoSave Condicional Formatting 6 Font -- Alignment OM Number SI 19 AAB 4 MILESTONE 2 - Contribution Margin per Unit & Contribution Margin Ratio 5 6 2 8 10 11 12 1 14 15 16 17 18 19 20 21 22 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 dos per day you can expect to have 22 dopper day 2. With pricing at $20 per dog per day, vou can expect to have 15 cops per day 3. With pricing at $25 per dog per day. You can expect to have 10 des per day Overnight Boarding 1 with pricing at $25 per dos per day, you can expect to have 12 dos per day 2. With pricing at $28 per dog per day. You can expect to have 10 des per day With pricing at $30 per dos per day. You can expect to have cops per day Base Groom 1 with pricing at 525 per dog per day. You can expect to have 5 dos per day 2. With pricing at $30 per dag per day, you can expect to have 4 dos per day 3. With pricing at 535 per dag per day. You can expect to have 3 dors per day 24 25 26 DAY CARE BOARDING 28 Sales Price per Unit GROOMING 5 Contribution Margin Analysis traken Type here to search dh 12 13 16 GB ACC 202 Final Project Workbook-1 - Excel ale Home Insert Page Layout Formulas Data Review View Help Search Calibri General 10 AA BIU AA Wrap Text Metge Center - $ - % Conditi Formatt lipboard Font Alignment 5 Number utoSave 9 X ) AB C 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 8 5 6 SCENARIO (choose one from each category): Dog Day Care 1. With pricing at $18 per dos 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 dag 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 does 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 a dogs per day 3. With pricing at $35 per dog per day, you can expect to have 3 dogs per day 8 8 9 20 21 22 24 25 26 28 DAY CARE BOARDING GROOMING 5 S $ Sales Price per Unit Variable Cost per Unit Contribution Martin 31 32 5 Cost Classification Variable Instruction Milestone 2 Contribution Margin Analysis Type here to search O B File Home Insert Page Layout Formulas Data Review View Help Search Wrap Text General Calibri 10 -AA BIV-1 0- Paste Merge a Center $ -% - Conditional Formatting Clipboard Font Alignment 5 Number AutoSave OF B 2 N21 AB 4 MILESTONE 2 - Break-Even Analysis 6 7 8 9 10 INSTRUCTIONS: Show all steps and calculations to determine the break-even Determine the break even for the target profit levels as outlined in the instructions 11 Breakeven Fixed Costs / Contribution Margin 13 14 35 DAY CARE BOARDING GROOMING 12 Sales Price $ Fixed Costs 19 20 5 Contribution Margit 3 22 fresk-even Units round up) 24 26 27 Target Prot 5 417.00 $ 583.00 1.000.00 be Break-Eren Analysis Type here to search O du E 16 G 2 3 7 ACC 202 Final Project Workbook 1. Excel File Home Insert Page Layout Formulas Data Review View Help O Search Calibri 10 -AN == General Paste Wiap Text Merge Center - $ - % Conditional Forma Formatting Table Styles Clipboard Font Alignment Number AutoSave H- N21 ZA c C Break-even Pied Costs Contribution Margin 12 13 14 15 DAY CARE BOARDING GROOMING Sales Price 5 14 10 Fixed Costs 20 Contribution Margin $ 22 23 24 Break even Units fround up) Ti Profit 5 417.00 58300 1,000.00 26 27 28 29 BO Break-even Units (round up) 32 Target Profit 66700 0900 1.500.00 Sveits round up 35 50 costa Brak wens Analyst Type here to search o 15 16 VA 2 3 4 6 ACC 203 Final Project Workbook 1. Exce Home Insert Page Layout Formulas Data Review View Help Search 05 Calib 10 ste - AA BIU-E-AA- General 2 Wrap Test Merge & Center - $ - % pboard Condit Formatti Font Alignment toSave Number Oe 50 XB AB 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 foxed cost of each service 1 2 4 Item Based on 5 rooms per day GROOMING Item Shampoo Clippers Bowls Towels Scissors Variable costs 104 1.37 0.72 18 39 20 21 583 101 Groomer Rent Loan Utilities and insurance Depreciation on heating system Cleaning Products Odobon Cleaning Products Simple Green Draw Total Fixed Costs Fixed Costs 2,080.00 30.95 20.00 28.57 395 2.08 2.36 200.00 3,167,91 23 25 26 Total Variable costs 3 9.97 28 Based on 22 dogs per day for six days a week. Assume 25 operating days for kennel and 22 hour work days for entendant DAY CARE Variable Fixed Type here to search o + E 1 12 15 ACC 202 Final Project Workbook-1 Excel Fle Home Insert Page Layout Formulas Data Review View Help Search ca -10 AA = BIU..A General Paste 13 Wrap Merge Center - $. % 941 ins Conditional Formatas Call Formatting Table Style Stiri Font 15 Chipboard Autise Aliment Number 19+ 130 29 31 33 34 Based on 23 does per day for six days a week. Asume 25 operating days for lenne and 2 our work days for sannel attendant DAY CARE Variable costs Ford Costs Dewcate attendant 2.88 Rent 2:32.14 Toys 027 Loan 150.00 Bowls 0.10 Utilities and insurance 21429 Tous 140 Depreciation in system Cleaning Products Odoban 1550 Che Products mole Green 16.78 Drew 20000 Total Variable costs Total Fed Costs 3 8584 36 37 30 41 44 30 Based on perdey Assu2ght our work days forenelatendant DOARDING RE Kennel ten 5. Oreciation Bours Twis 081 valities and runte Dating LO Feed Cats 80.00 SONO 25000 157.14 440 12 H Tybe here to search fi BD 19 YA 2 & 7 2 3 4 5 6 8 W F ACC 202 Final Project Workbook 1 - Excel Home insert Page Layout Formulas Data Review View Help Search Calibri - General BIV- -10 - AA Wrap Text C. A.A. Merge a Center Alignment $ -% - pboard Font Conditional Formats Formatting Tables Styles utolive Number 0 -50 AB 3 4. 5 G 232.14 150.00 214 29 29.64 1559 16.25 200.00 ER 5 1 12 14 5:44 C Day care attendant $ 2.88 Rent Toys 027 Loan Bowls Ulities and Insurance Towels 140 Depreciation on heating system Cleaning Products Odoban Cleaning Products Simple Green Draw Total Variable Costs 4.65 Total Fied Costs Based on 12 dogs per day. Assume 22 eight-hour work days for kennel attendant BOARDING Variable costs Kennel attendant 5.62 Depreciation onnels Bowls 0.86 Rent Towels 0.37 Loan Utilities and insurance Depreciation on heating wstem Cleaning Products Odoban Cleaning Products Simple Green Or Total Variable Couts 5 2.35 Total Fed Costa $ 47 49 50 52 52 sa 54 Fixed costs BODO 3860 25000 357.14 2590 56 200.00 50 s Variable Fixed Type here to search O BE #1 12R 13 15 3 5 6 7 Home ACC 202 Final Project Workbock-1 Excel Insert Page Layout Formulas Data Review View Help Search Calibri 10 Paste BIU A A A. Wiap Text Merge Center - General $ -% - Clipboard AutoSave Condicional Formatting 6 Font -- Alignment OM Number SI 19 AAB 4 MILESTONE 2 - Contribution Margin per Unit & Contribution Margin Ratio 5 6 2 8 10 11 12 1 14 15 16 17 18 19 20 21 22 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 dos per day you can expect to have 22 dopper day 2. With pricing at $20 per dog per day, vou can expect to have 15 cops per day 3. With pricing at $25 per dog per day. You can expect to have 10 des per day Overnight Boarding 1 with pricing at $25 per dos per day, you can expect to have 12 dos per day 2. With pricing at $28 per dog per day. You can expect to have 10 des per day With pricing at $30 per dos per day. You can expect to have cops per day Base Groom 1 with pricing at 525 per dog per day. You can expect to have 5 dos per day 2. With pricing at $30 per dag per day, you can expect to have 4 dos per day 3. With pricing at 535 per dag per day. You can expect to have 3 dors per day 24 25 26 DAY CARE BOARDING 28 Sales Price per Unit GROOMING 5 Contribution Margin Analysis traken Type here to search dh 12 13 16 GB ACC 202 Final Project Workbook-1 - Excel ale Home Insert Page Layout Formulas Data Review View Help Search Calibri General 10 AA BIU AA Wrap Text Metge Center - $ - % Conditi Formatt lipboard Font Alignment 5 Number utoSave 9 X ) AB C 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 8 5 6 SCENARIO (choose one from each category): Dog Day Care 1. With pricing at $18 per dos 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 dag 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 does 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 a dogs per day 3. With pricing at $35 per dog per day, you can expect to have 3 dogs per day 8 8 9 20 21 22 24 25 26 28 DAY CARE BOARDING GROOMING 5 S $ Sales Price per Unit Variable Cost per Unit Contribution Martin 31 32 5 Cost Classification Variable Instruction Milestone 2 Contribution Margin Analysis Type here to search O B File Home Insert Page Layout Formulas Data Review View Help Search Wrap Text General Calibri 10 -AA BIV-1 0- Paste Merge a Center $ -% - Conditional Formatting Clipboard Font Alignment 5 Number AutoSave OF B 2 N21 AB 4 MILESTONE 2 - Break-Even Analysis 6 7 8 9 10 INSTRUCTIONS: Show all steps and calculations to determine the break-even Determine the break even for the target profit levels as outlined in the instructions 11 Breakeven Fixed Costs / Contribution Margin 13 14 35 DAY CARE BOARDING GROOMING 12 Sales Price $ Fixed Costs 19 20 5 Contribution Margit 3 22 fresk-even Units round up) 24 26 27 Target Prot 5 417.00 $ 583.00 1.000.00 be Break-Eren Analysis Type here to search O du E 16 G 2 3 7 ACC 202 Final Project Workbook 1. Excel File Home Insert Page Layout Formulas Data Review View Help O Search Calibri 10 -AN == General Paste Wiap Text Merge Center - $ - % Conditional Forma Formatting Table Styles Clipboard Font Alignment Number AutoSave H- N21 ZA c C Break-even Pied Costs Contribution Margin 12 13 14 15 DAY CARE BOARDING GROOMING Sales Price 5 14 10 Fixed Costs 20 Contribution Margin $ 22 23 24 Break even Units fround up) Ti Profit 5 417.00 58300 1,000.00 26 27 28 29 BO Break-even Units (round up) 32 Target Profit 66700 0900 1.500.00 Sveits round up 35 50 costa Brak wens Analyst Type here to search o 15 16 VA 2 3 4 6