Question

Paste BIU Merge Lane A Font Cells Styles Editing Number Alignment Clipboard K26 K M N O P Q R AB 3 Jazzy Dreams Dog Care MILE

General Calibri 10 AA E EE BIU HA E Font 29 Wrap Text Merge & Center - 22 O $ % 9 78-29 Conditional Formatas Cell Formatting

I'm stuck....how do I calculate to get the other break-even units

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Day Care Boarding Grooming
Fixed Cost $       858.44 $    1,378.97 $    2,367.91
Target Profit $       417.00 $       583.00 $    1,000.00
Total (a) $    1,275.44 $    1,961.97 $    3,367.91
Contribution Margin (b) $         13.35 $         17.65 $         15.03
Break Even Units (a)/(b)                  96                111                224
Day Care Boarding Grooming
Fixed Cost $       858.44 $    1,378.97 $    2,367.91
Target Profit $       667.00 $       909.00 $    1,500.00
Total $    1,525.44 $    2,287.97 $    3,867.91
Contribution Margin $         13.35 $         17.65 $         15.03
Break Even Units                114                130                257
Add a comment
Know the answer?
Add Answer to:
I'm stuck....how do I calculate to get the other break-even units Paste BIU Merge Lane A...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • ACC 202 Final Project Workbook - Excel - AutoSave Off HO File Home Insert B Draw...

    ACC 202 Final Project Workbook - Excel - AutoSave Off HO File Home Insert B Draw : Page Layout Formulas Data Review View Help Search 0 X Comments 4 Ideas Calibri === - 10 - AA - - A, AutoSum 47 On E Lori Foster LF 0 Share 0 Fill Sort & Find & Clear Filter - Select Editing a Wrap Text Merge & Center - Accounting $ $,% % , a Paste BIU - 4 68 .00 Insert Delete...

  • I am having trouble figuring this out. How do I break down the calculations? INSTRUCTIONS FOR MILESTONE 2 (Due Week 4...

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

  • INSTRUCTIONS:                                        &n

    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.                                      Break-even = Fixed Costs / Contribution Margin                                                                                            DAY CARE                          BOARDING                         GROOMING                                                                                                  Sales Price           $                          -                            $                          -                            $                          -                                                                                                        Fixed Costs         $                          -                            $                          -                            $                          -                                                                                                        Contribution Margin       $                          -                            $                          -                            $                          -                                                                                                        Break-even Units (round up)                                    ...

  • can you please help me figure out the break even analysis? (last photo ) fx =ROUND(420*(2500/4200),2)...

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

  • can you please complete the income statement (last photo) other pages are for refernce. please let...

    can you please complete the income statement (last photo) other pages are for refernce. please let me know what additional information is needed to complete the question TOLED Tuy Demstalled, but first we need to close some apps. Update now A B C D E F G H J K L M N O P Q R S OPERATIONAL & COST INFORMATION: For simplicity, base all calculations using 30 days in each month m OPERATIONAL DATA Grooming: The Groomer can...

  • 6 MILESTONE 2 (Due in Module 4) MILESTONE 3 (Due in Module 5) MILESTONE 1 (Due in Module 2) 7 9 Instructions Milestone 2 10 12 1. Contribution Margin COGM Schedule .5 Name Choose a price range and ca...

    6 MILESTONE 2 (Due in Module 4) MILESTONE 3 (Due in Module 5) MILESTONE 1 (Due in Module 2) 7 9 Instructions Milestone 2 10 12 1. Contribution Margin COGM Schedule .5 Name Choose a price range and calculate Grooming Create a Cost of Goods Manufactured Sched Location Vision Day Care Mission Bcarding 2. 2. 2. Break-Even Analysis Identify the following Create an Income Statement Calculate the break-even units Revenue will be provided end of week 4 Direct Materials Grooming...

  • please help with COS schedule, income statement, and variances. everything is completed and added for reference....

    please help with COS schedule, income statement, and variances. everything is completed and added for reference. please complete the last 3 sections View Help i SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. Reactivate H32 X : B for D A C E F G H I J K L M N O P Q 43 For simplicity, base all calculations using 30 days in each month OPERATIONAL DATA Grooming: The Groomer can groom 5 dogs a...

  • GENERAL Use data from Milestone 1 and Milestone 2 in your analysis Revenue data needed for the Income Statement will be...

    GENERAL Use data from Milestone 1 and Milestone 2 in your analysis Revenue data needed for the Income Statement will be provided COST OF SERVICES PROVIDED SCHEDULE Use the data at the top of the schedule to complete the report INCOME STATEMENT Use the data at the top of the schedule to complete the report Use the data from your Cost of Services Provided Schedule VARIANCES Use the data at the top of the schedule to calculate the following: Variance...

  • Overview: In the third milestone, you will jump forward in time: Imagine that your business has already opened. Use the...

    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. 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 company's performance over the last month using the data provided below. Note: Your instructor will create an announcement sharing the income...

  • please help with the income statement - + Fit to page D Page view A Read...

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

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT