{"id":415,"date":"2018-04-17T21:25:13","date_gmt":"2018-04-17T21:25:13","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/?post_type=chapter&#038;p=415"},"modified":"2024-04-29T16:54:50","modified_gmt":"2024-04-29T16:54:50","slug":"target-profit-analysis","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/chapter\/target-profit-analysis\/","title":{"raw":"Target Profit Analysis","rendered":"Target Profit Analysis"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Define target profit analysis and use it to make sales volume calculations<\/li>\r\n<\/ul>\r\n<\/div>\r\nMinnesota Kayak has a few investors who are interested in getting a return on their investment. \u00a0They have talked with your supervisor, and between them all, would like to get $30,000 a month in profit to divide between them. You have been tasked with figuring out how many kayaks need to be sold in order to get the investors their return!\r\n\r\nTarget profit analysis helps us to know how much in dollar sales a company will need to reach a certain profit point. This is one of the key uses of the CVP analysis. Once the basic data is calculated, it can offer a great deal of insight and help in planning.\r\n\r\nMinnesota Kayak Company needs to sell 28 kayaks in our example to break even. The equation method or the formula method can be used with the same result. Remember the formula method is simply a shortened version of the equation method, so both ways should come to the same conclusion.\r\n\r\nWith the previous information you can then figure out, the dollar sales needed to break even:\r\n\r\n[latex]28\\text{ kayaks}\\times\\$500\\text{ per kayak}=\\$14,000\\text{ in sales}[\/latex]\r\n\r\nWhat if they now want to show a $30,000 a month profit?\r\n\r\nSo with that information we now have the following:\r\n<div>\r\n<table style=\"height: 60px;\">\r\n<tbody>\r\n<tr style=\"height: 15px;\">\r\n<td style=\"height: 15px;\">Price per kayak<\/td>\r\n<td style=\"height: 15px;\">$500<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px;\">\r\n<td style=\"height: 15px;\">variable costs per kayak<\/td>\r\n<td style=\"height: 15px;\">$225<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px;\">\r\n<td style=\"height: 15px;\">Contribution margin per kayak<\/td>\r\n<td style=\"height: 15px;\">$275<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px;\">\r\n<td style=\"height: 15px;\">Fixed costs\/month<\/td>\r\n<td style=\"height: 15px;\">$7,700<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\nWith this information, how many kayaks do we need to sell to show a $30,000 profit at the end of the month? It is the same exact formula we used to calculate the break-even point! Remember, we put -0- for the profit in when we were looking to break-even. We simply replace the -0- with $30,000 and now we can calculate how many kayaks we need to sell to meet our profit goal. Pretty neat huh?\r\n\r\nUsing the equation method:\r\n\r\n[latex]\\begin{array}{rcl}\\text{Profit}&amp;=&amp;\\text{Unit CM}\\times\\text{Q}-\\text{Fixed Expense}\\\\\\$30,000&amp;=&amp;\\$275\\times\\text{Q}-\\$7,700\\\\\\$30,000+\\$7,700&amp;=&amp;\\$275\\times\\text{Q}\\\\\\dfrac{\\$37,700}{275}&amp;=&amp;\\text{Q}\\end{array}[\/latex]\r\n\r\nSo we now need to sell 138 kayaks to profit $30,000! How much in sales do we need?\r\n\r\n138 \u00d7 $500 each= $69,000 in sales.\r\n\r\n<em>Note:<\/em> Whenever you are doing break-even or target profit analysis, you should round units up. If you used your calculator to divide $37,700 by 275, you would have gotten 137.090909. Why did we round up to 138 kayaks? Well, you can't sell only 0.09 of a kayak, so you will either sell 137 or 138. If you round down to 137 units and then plug it into the formula to calculate profit, then your profit only ends up being $29,975 - just short of our $30,000 target profit we stated. So we have to round up to 138 kayaks to meet our target profit (and in this case, slightly exceed, as selling 138 kayaks leads to a profit of $30,250).\r\n\r\nHow would we get there using the formula method?\r\n\r\n[latex]\\text{Unit Sales to attain the target profit}=\\dfrac{\\text{Target Profit}+\\text{Fixed expenses}}{\\text{Unit CM}}[\/latex]\r\n\r\nSo in our kayak case\r\n\r\n[latex]\\begin{array}{rcl}\\text{Unit sales needed}&amp;=&amp;\\dfrac{\\$30,000+\\$7,700}{\\$275}\\\\&amp;=&amp;\\dfrac{\\$37,700}{\\$275}\\end{array}[\/latex]\r\n\r\nSo again, we need 138 kayaks sold to make a $30,000 profit!\r\n\r\n138 kayaks \u00d7 $500 selling price per kayak = $69,000 in sales.\r\n\r\nWe can now plug in any amount of desired profit and calculate how many units we need to sell! This is amazing information for business owners and managers to have available. But see the importance of good numbers for your fixed and variable costs? Keep in mind how much a small difference in costs can affect our profit!\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Questions<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/419bb279-a9a6-4ccc-9793-7d123d165f86\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Define target profit analysis and use it to make sales volume calculations<\/li>\n<\/ul>\n<\/div>\n<p>Minnesota Kayak has a few investors who are interested in getting a return on their investment. \u00a0They have talked with your supervisor, and between them all, would like to get $30,000 a month in profit to divide between them. You have been tasked with figuring out how many kayaks need to be sold in order to get the investors their return!<\/p>\n<p>Target profit analysis helps us to know how much in dollar sales a company will need to reach a certain profit point. This is one of the key uses of the CVP analysis. Once the basic data is calculated, it can offer a great deal of insight and help in planning.<\/p>\n<p>Minnesota Kayak Company needs to sell 28 kayaks in our example to break even. The equation method or the formula method can be used with the same result. Remember the formula method is simply a shortened version of the equation method, so both ways should come to the same conclusion.<\/p>\n<p>With the previous information you can then figure out, the dollar sales needed to break even:<\/p>\n<p>[latex]28\\text{ kayaks}\\times\\$500\\text{ per kayak}=\\$14,000\\text{ in sales}[\/latex]<\/p>\n<p>What if they now want to show a $30,000 a month profit?<\/p>\n<p>So with that information we now have the following:<\/p>\n<div>\n<table style=\"height: 60px;\">\n<tbody>\n<tr style=\"height: 15px;\">\n<td style=\"height: 15px;\">Price per kayak<\/td>\n<td style=\"height: 15px;\">$500<\/td>\n<\/tr>\n<tr style=\"height: 15px;\">\n<td style=\"height: 15px;\">variable costs per kayak<\/td>\n<td style=\"height: 15px;\">$225<\/td>\n<\/tr>\n<tr style=\"height: 15px;\">\n<td style=\"height: 15px;\">Contribution margin per kayak<\/td>\n<td style=\"height: 15px;\">$275<\/td>\n<\/tr>\n<tr style=\"height: 15px;\">\n<td style=\"height: 15px;\">Fixed costs\/month<\/td>\n<td style=\"height: 15px;\">$7,700<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>With this information, how many kayaks do we need to sell to show a $30,000 profit at the end of the month? It is the same exact formula we used to calculate the break-even point! Remember, we put -0- for the profit in when we were looking to break-even. We simply replace the -0- with $30,000 and now we can calculate how many kayaks we need to sell to meet our profit goal. Pretty neat huh?<\/p>\n<p>Using the equation method:<\/p>\n<p>[latex]\\begin{array}{rcl}\\text{Profit}&=&\\text{Unit CM}\\times\\text{Q}-\\text{Fixed Expense}\\\\\\$30,000&=&\\$275\\times\\text{Q}-\\$7,700\\\\\\$30,000+\\$7,700&=&\\$275\\times\\text{Q}\\\\\\dfrac{\\$37,700}{275}&=&\\text{Q}\\end{array}[\/latex]<\/p>\n<p>So we now need to sell 138 kayaks to profit $30,000! How much in sales do we need?<\/p>\n<p>138 \u00d7 $500 each= $69,000 in sales.<\/p>\n<p><em>Note:<\/em> Whenever you are doing break-even or target profit analysis, you should round units up. If you used your calculator to divide $37,700 by 275, you would have gotten 137.090909. Why did we round up to 138 kayaks? Well, you can&#8217;t sell only 0.09 of a kayak, so you will either sell 137 or 138. If you round down to 137 units and then plug it into the formula to calculate profit, then your profit only ends up being $29,975 &#8211; just short of our $30,000 target profit we stated. So we have to round up to 138 kayaks to meet our target profit (and in this case, slightly exceed, as selling 138 kayaks leads to a profit of $30,250).<\/p>\n<p>How would we get there using the formula method?<\/p>\n<p>[latex]\\text{Unit Sales to attain the target profit}=\\dfrac{\\text{Target Profit}+\\text{Fixed expenses}}{\\text{Unit CM}}[\/latex]<\/p>\n<p>So in our kayak case<\/p>\n<p>[latex]\\begin{array}{rcl}\\text{Unit sales needed}&=&\\dfrac{\\$30,000+\\$7,700}{\\$275}\\\\&=&\\dfrac{\\$37,700}{\\$275}\\end{array}[\/latex]<\/p>\n<p>So again, we need 138 kayaks sold to make a $30,000 profit!<\/p>\n<p>138 kayaks \u00d7 $500 selling price per kayak = $69,000 in sales.<\/p>\n<p>We can now plug in any amount of desired profit and calculate how many units we need to sell! This is amazing information for business owners and managers to have available. But see the importance of good numbers for your fixed and variable costs? Keep in mind how much a small difference in costs can affect our profit!<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Questions<\/h3>\n<p>\t<iframe id=\"assessment_practice_419bb279-a9a6-4ccc-9793-7d123d165f86\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/419bb279-a9a6-4ccc-9793-7d123d165f86?iframe_resize_id=assessment_practice_id_419bb279-a9a6-4ccc-9793-7d123d165f86\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-415\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Target Profit Analysis. <strong>Authored by<\/strong>: Freedom Learning Group. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":62559,"menu_order":16,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Target Profit Analysis\",\"author\":\"Freedom Learning Group\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"804bd01d-fd31-4314-8765-6285348d6423, 3f9d0aed-ba7d-4128-937e-1671adaff44e","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-415","chapter","type-chapter","status-publish","hentry"],"part":107,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/pressbooks\/v2\/chapters\/415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/wp\/v2\/users\/62559"}],"version-history":[{"count":13,"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/pressbooks\/v2\/chapters\/415\/revisions"}],"predecessor-version":[{"id":4094,"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/pressbooks\/v2\/chapters\/415\/revisions\/4094"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/pressbooks\/v2\/parts\/107"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/pressbooks\/v2\/chapters\/415\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/wp\/v2\/media?parent=415"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/pressbooks\/v2\/chapter-type?post=415"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/wp\/v2\/contributor?post=415"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-accountingformanagers\/wp-json\/wp\/v2\/license?post=415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}