Executive Solution Overview
– ## UnitVII_Final_Project_Template.docx – ## ManagementApplicationsofAccountingACC5301UnitVIIAssignment.docx – ## UnitIIIStudyGuide.pdf – UnitVStudyGuide.pdf – UnitVIIStudyGuide.pdf – UnitVIISpreadsheetTemplate.xlsx **## UnitVII_Final_Project_Template.docx** 1 5 **Title of the Paper Goes Here…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
– ## UnitVII_Final_Project_Template.docx
– ## ManagementApplicationsofAccountingACC5301UnitVIIAssignment.docx
– ## UnitIIIStudyGuide.pdf
– UnitVStudyGuide.pdf
– UnitVIIStudyGuide.pdf
– UnitVIISpreadsheetTemplate.xlsx
**## UnitVII_Final_Project_Template.docx**
1
5
**Title of the Paper Goes Here**
Student Name
Institution
ACC 5301 Management Applications of Accounting
Instructor
Date
**Abstract**
_The abstract_ is an overview of the paper, written after completion. Other researchers use the abstract to determine if your work will be useful to them. The abstract should include the background, hypothesis or research question, methodology for data collection and analysis, the findings of your research, and conclusions. It should be between 100–150 words. This is done when the paper is complete.
**Title of Paper**
Remember this part of the paper is double spaced in APA format.
The
_Introduction_ should lead readers into the topic and its importance. Introductions typically include the overall topic of the paper, the specific focus of the paper within the larger topic, the main points in the paper, the kind of paper (study, argument, critique, discussion), and the purpose.
_Writing tip:_ The length of the introduction should be in proportion to the length of the paper. Also ask yourself, “With my purpose and my audience, how do I engage my readers best?” In the introduction, you set the tone of the piece, establish your voice, and demonstrate your writing style; be authentic to your purpose and your audience.
**Part 1 Contribution Margin/Breakeven**
Embed your spreadsheet for this section here and discuss the results.
**Part 2 Full and Variable Costing**
Embed your spreadsheet for this section here and discuss the results.
**Part 3 Special Order**
Embed your spreadsheet for this section here and discuss the results.
**Part 4 Internal Rate of Return**
Embed your spreadsheet for this section here and discuss the results.
**Part 5 Cash Budget**
Embed your spreadsheet for this section here and discuss the results.
**Part 6 Material and Labor Variance**
Embed your spreadsheet for this section here and discuss the results.
**Conclusions and Recommendations**
_The conclusion_ section
should summarize for the readers the topics of importance that led to your final conclusions/analysis regarding this case. Include some specific areas of focus from your analysis to reinforce your conclusion.
**References**
Include complete references in proper APA format for all of the citations
_listed_ in your paper. Be sure to use the library for the required number of sources. Additional sources can be used but should be scholarly. Present your references in alphabetical order.
**## ManagementApplicationsofAccountingACC5301UnitVIIAssignment.docx**
2
Management Applications of Accounting ACC 5301 Unit VII Assignment
**Cookie Business Final Project**
This final project measures your mastery of ULOs 2.2, 2.3, 2.4, 2.6, 2.7, 3.7, 3.8, and 6.2.
Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to evaluate the financial information for the company. You will be creating a series of reports and analyzing the results using the templates provided to guide you through the project. In this final project, you will do the following:
1. Apply accounting concepts and standards to the creation of accounting information and reports.
2. Analyze accounting information used to make strategic business decisions.
3. Apply ethical behavior to accounting-related situations.
4. Make business decisions based on analyzing accounting data.
5.
**Length:** Using the
Unit VII Final Project Template, prepare an eight-to-twelve-page written report (including spreadsheets).
**References:** At least three peer-reviewed sources are required, any additional resources used are required to be scholarly/academic in nature. APA Style is required for citations and references.
**Details:** First, start the paper with an abstract and introduction section, per the assignment template provided.
**Part 1:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (CM Breakeven tab):
· Calculate the contribution margin (CM) for each of the three products sold at the cookie business.
· Calculate the weighted average CM.
· Calculate the breakeven point.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, and such.
**Part 2:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Full Variable tab), complete the calculations listed below.
· Calculate the value of ending inventory under full or absorption costing.
· Calculate the value of ending inventory under variable costing.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results, and comment on which method you think is more helpful to managers and why.
**Part 3:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Special Order tab), calculate the net increase or decrease in profit if they take the special order.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results and comment on if you think the cookie business should take on this special order of cookies for a wedding. Business has been slow the last few months, and the offer is less than the usual selling price for the cookies.
As part of your discussion, include both quantitative (based on the numbers) and qualitative (not based on numbers) factors that would go into the decision to take on the special order, including pricing decisions.
**Part 4:** Based on the data presented in the
Unit VII Spreadsheet Template in Excel (IRR tab), calculate the internal rate of return (IRR) for the new equipment purchase.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Note: the PV Annuity table is provided for you. Discuss if you think the cookie business should accept or reject the purchase of the new equipment and why.
Additional information has come to your attention regarding the equipment purchase. One of the partner's brothers owns the company that sells the equipment and insists the equipment is needed. Discuss any ethical concerns you see with this type of transaction.
**Part 5:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Cash Budget tab), calculate the cash receipts for the first quarter of this year.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.
**Part 6:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Variances tab), complete the following calculations.
· Calculate the material variances.
· Calculate the labor variances.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss your observations about the variances and ways to plan to improve any of the variances.
End this paper with the key observations and present any future recommendations.
**Submission**: Save the submission as a Word document and upload the document to Blackboard.
**Grading:** The assignment will be reviewed in alignment with the grading rubric criteria. The assignment is worth 20% of your course grade.
**## UnitIIIStudyGuide.pdf**
ACC 5301, Management Applications of Accounting 1
Course Learning Outcomes for Unit III
Upon completion of this unit, students should be able to:
2. Apply accounting concepts to the creation of accounting information and reports.
2.2 Prepare cost-volume-profit analysis reports.
3. Analyze accounting information used to make strategic business decisions.
3.7 Compare and contrast full (absorption) and variable costing.
Required Unit Resources
Chapter 4: Cost-Volume-Profit Analysis, pp. 4-1 – 4-27
Chapter 5: Variable Costing, pp. 5-1 – 5-13
Unit Lesson
Introduction
Welcome to Unit III. In this unit, we will be looking at cost-volume-profit analysis and how this is related to
several key management tasks; planning, controlling, and decision-making. In this unit, we will also look at
how the costs we have identified (variable and fixed) are reported under both full (absorption) and variable
costing and how inventory levels effect net income under both of these methods.
Cost Identification
Variable costs and fixed costs: We are going to start off with a short review of variable and fixed costs and
how these costs change in total and per unit. Remember, fixed costs remain the same in total regardless of
the level of production while the per unit cost decreases as more units are produced because those fixed cost
are spread over more items.
Variable costs, remember, will increase or decrease in total with the level of production while the per-unit cost
remains the same. This is because the more units that are produced, the more it will cost the company in total
for those units, but each unit still costs the same amount regardless of how many are produced.
UNIT III STUDY GUIDE
Cost-Volume-Profit and
Variable Costing
ACC 5301, Management Applications of Accounting 2
UNIT x STUDY GUIDE
Title
Mixed costs: We are going to add to our previous cost
discussion the idea of mixed costs. These costs, as
the name implies, have an element of both fixed and
variable costs. As you can see from the chart, there is
a fixed cost of $200 per week, but the more units
produced above a certain level would allow the
employee to receive additional pay for those
additional units (variable costs). For example, let's say
you receive a base salary of $200 per week for up to
10 units produced, and in addition to that base salary,
you receive an additional amount if you produce more
than the 10 items. In this example, if you produce 20
items, you still receive your $200 (fixed amount) plus
an additional $200 (variable amount) for a total of
$400 that week. As you can see, the more you
produce, the more money you will make. Regardless
of the number of items you produce each week, you
will still receive the $200 base pay per week.
Why is it important to know the classification for the various costs within a company? It is important so that
managers can properly estimate the costs and perform a cost-volume-profit analysis. Keep in mind, most
managers within the company only have control over their own department or unit. Therefore, costs involved
in the negotiation of the rent contract for the factory would not be within the authority of the factory floor
supervisor. The factory floor supervisor would, however, have control over the effectiveness of his or her
workers and the efficient use of materials needed to make products within his or her department.
Cost-Volume-Profit Analysis
A cost-volume-profit analysis is an evaluation method that looks at the relationship between the level of
activity within the organization, the costs within the organization, and the profit of the organization (Jiambalvo,
2020). The basic equation to determine profit is:
Sales – Costs=Profit
Taking this equation one step further when dealing with cost-volume-profit analysis is:
(Selling price per unit * number of units sold) – (Variable costs per unit * number of units sold) – Total fixed
= Profit
ACC 5301, Management Applications of Accounting 3
UNIT x STUDY GUIDE
Title
As you can see by expanding our basic equation, we now take into account the number of units sold and
break down our costs by variable and fixed costs. This leads us to a couple of important calculations related
to cost-volume-profit analysis, break-even point, and
contribution margin.
Break-even point: One important use of a cost-volume-
profit analysis is to determine the break-even point.
This allows managers to calculate out how many
products or dollars they need to sell so they do not
make money, but they do not lose money. In other
words, this helps guide production for the company. If
the company sells above the break-even point (where
costs and revenue meet), it will make a profit, but if it
sells below the break-even point, then the company
will incur a loss. The chart to the side shows the
relationship between fixed and variable costs as well
as sales revenue. As you can see, the break-even
point is where sales and costs intersect on the chart.
Contribution margin: Another important calculation in this unit is the contribution margin. This calculation
shows how much of a "contribution" a product is making per unit to income based on variable costs only. This
means that fixed costs are not calculated into the equation. The calculation is:
Selling price per unit – Variable cost per unit = Contribution margin
For example, if a product sells for $100 but costs $60 to make, the contribution margin in $40 per unit. Keep
in mind, this calculation does not include fixed costs (like rent, CEO's salary, etc.). The contribution margin
does give the managers a basic idea if they are selling the product for more than the cost to make it.
Remember, a company may make more than one product or provide more than one service, so this technique
can be used for each product or service to make sure each one is profitable.
By using the cost-volume-profit techniques, a manager can determine how many products to make in order to
break even (no profit or no loss) and determine if the product or products the company sells are selling above
the cost to make the product, the contribution margin. By using just these two techniques, managers can plan
how many products to make, control the cost to make those products, and make decisions that will allow the
company to be profitable.
Full (Absorption) and Variable Cost Reporting
Looking at our other topic for this unit, full (absorption) and variable cost reporting, we are going to compare
and contrast these two reporting methods. Let's first look at the format of the two reports as pictured below
(Jiambalvo, 2020):
ACC 5301, Management Applications of Accounting 4
UNIT x STUDY GUIDE
Title
Both reports show sales, costs and net income. The difference between the two reports is how the
variable and fixed costs are displayed on the reports. On full or absorption costing, fixed and variable costs
are not broken down; the costs are all included in total regardless of their status as fixed or variable costs.
Keep in mind, this is the only reporting method that is acceptable for GAAP (Generally Accepted
Accounting Principles) for external reporting. This means that if the company needed to prepare a statement
for a governmental or regulatory agency or even a bank to get a loan, it would need to report using
absorption costing.
However, as a manger, full (absorption) costing does not break down the costs into fixed and variable costs.
In other words, as we noted previously, a manager has more control over variable costs, and full costing does
not show the breakdown of costs that would enable a manager to better plan and control costs. Looking at
variable costing, you can see that, while the information is the same, there is a clear breakdown of the
variable and fixed costs. Managers can now look to see how they can better control costs within their
responsibilities. For example, we noted that the factory supervisor typically does not have control over fixed
costs such as rent. By using the variable costing statement, the factory supervisor can clearly see which costs
he or she can control (variable costs) and find ways to minimize these costs.
Effects of Production on Cost Reporting
In our example above, we assumed that all 4,000 units produced were sold. This is why net income for both
full (absorption) and variable costing showed the same amount. Now, let's take a look at what happens when
inventory increases or decreases under variable costing. In this first example, only 3,800 units were sold, so
that left 200 units in inventory unsold. The chart below shows the effect on net income when not all of the
units produced are sold. As you can see, the net income under variable costing is less than the net income
under full (absorption) costing.
ACC 5301, Management Applications of Accounting 5
UNIT x STUDY GUIDE
Title
In our final example below, when the company sells more than it produces, in this case 4,200 units, net
income for variable costing is higher than the net income for full (absorption costing). This means that the
company is selling units that were left in inventory from a prior month.
Conclusion
In this unit, we have discussed cost-volume-profit techniques that are useful to managers for planning
production and sales, controlling costs, and making decisions. The two main techniques we have looked at
are calculating break-even and contribution margin. These calculations provide managers the tools they need
to not only look at how many items they should be producing but also what it is costing them to produce
those products.
This unit also looked at the two different costing reports; full (absorption) and variable costing. As we
discussed, these two methods have advantages and disadvantages. For example, while variable costing
makes it clearer to see the breakdown between variable and fixed costs, variable costing can also be used to
manipulate income based on changes in inventory levels.
ACC 5301, Management Applications of Accounting 6
UNIT x STUDY GUIDE
Title
Reference
Jiambalvo, J. (2020). Managerial accounting (7th ed.). Wiley.
https://bookshelf.vitalsource.com/#/books/9781119577706
Suggested Unit Resources
View the following video by accessing the Unit III Additional Unit Resources folder in the unit.
The video Whole Foods: Cost-Volume-Profit Analysis will demonstrate how cost-volume-profit analysis
techniques can be used at Whole Foods.
You can access a transcript for this video by hovering over the PDF button at the bottom of the video and
then clicking on the word “Transcript.” Alternatively, you can click on the “cc” button at the bottom of the video
to turn on closed captions.
Learning Activities (Nongraded)
Nongraded Learning Activities are provided to aid students in their course of study. You do not have to submit
them. If you have questions, contact your instructor for further guidance and information.
After watching the video Whole Foods: Cost-Volume-Profit Analysis in the Suggested Unit Resources, you
may want to answer the three questions in the Unit III Questions resource . Note that the "View the Video" link
referenced in each question is the same Whole Foods: Cost-Volume-Profit Analysis video linked above.
**UnitVStudyGuide.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitvstudyguide-pdf-10458203)
**UnitVIIStudyGuide.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitviistudyguide-pdf-10458199)
**UnitVIISpreadsheetTemplate.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitviispreadsheettemplate-xlsx-10458195)
**UnitVIISpreadsheetTemplate.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitviispreadsheettemplate-xlsx-10458195)
**## UnitVII_Final_Project_Template.docx**
1
5
**Title of the Paper Goes Here**
Student Name
Institution
ACC 5301 Management Applications of Accounting
Instructor
Date
**Abstract**
_The abstract_ is an overview of the paper, written after completion. Other researchers use the abstract to determine if your work will be useful to them. The abstract should include the background, hypothesis or research question, methodology for data collection and analysis, the findings of your research, and conclusions. It should be between 100–150 words. This is done when the paper is complete.
**Title of Paper**
Remember this part of the paper is double spaced in APA format.
The
_Introduction_ should lead readers into the topic and its importance. Introductions typically include the overall topic of the paper, the specific focus of the paper within the larger topic, the main points in the paper, the kind of paper (study, argument, critique, discussion), and the purpose.
_Writing tip:_ The length of the introduction should be in proportion to the length of the paper. Also ask yourself, “With my purpose and my audience, how do I engage my readers best?” In the introduction, you set the tone of the piece, establish your voice, and demonstrate your writing style; be authentic to your purpose and your audience.
**Part 1 Contribution Margin/Breakeven**
Embed your spreadsheet for this section here and discuss the results.
**Part 2 Full and Variable Costing**
Embed your spreadsheet for this section here and discuss the results.
**Part 3 Special Order**
Embed your spreadsheet for this section here and discuss the results.
**Part 4 Internal Rate of Return**
Embed your spreadsheet for this section here and discuss the results.
**Part 5 Cash Budget**
Embed your spreadsheet for this section here and discuss the results.
**Part 6 Material and Labor Variance**
Embed your spreadsheet for this section here and discuss the results.
**Conclusions and Recommendations**
_The conclusion_ section
should summarize for the readers the topics of importance that led to your final conclusions/analysis regarding this case. Include some specific areas of focus from your analysis to reinforce your conclusion.
**References**
Include complete references in proper APA format for all of the citations
_listed_ in your paper. Be sure to use the library for the required number of sources. Additional sources can be used but should be scholarly. Present your references in alphabetical order.
**## ManagementApplicationsofAccountingACC5301UnitVIIAssignment.docx**
2
Management Applications of Accounting ACC 5301 Unit VII Assignment
**Cookie Business Final Project**
This final project measures your mastery of ULOs 2.2, 2.3, 2.4, 2.6, 2.7, 3.7, 3.8, and 6.2.
Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to evaluate the financial information for the company. You will be creating a series of reports and analyzing the results using the templates provided to guide you through the project. In this final project, you will do the following:
1. Apply accounting concepts and standards to the creation of accounting information and reports.
2. Analyze accounting information used to make strategic business decisions.
3. Apply ethical behavior to accounting-related situations.
4. Make business decisions based on analyzing accounting data.
5.
**Length:** Using the
Unit VII Final Project Template, prepare an eight-to-twelve-page written report (including spreadsheets).
**References:** At least three peer-reviewed sources are required, any additional resources used are required to be scholarly/academic in nature. APA Style is required for citations and references.
**Details:** First, start the paper with an abstract and introduction section, per the assignment template provided.
**Part 1:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (CM Breakeven tab):
· Calculate the contribution margin (CM) for each of the three products sold at the cookie business.
· Calculate the weighted average CM.
· Calculate the breakeven point.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, and such.
**Part 2:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Full Variable tab), complete the calculations listed below.
· Calculate the value of ending inventory under full or absorption costing.
· Calculate the value of ending inventory under variable costing.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results, and comment on which method you think is more helpful to managers and why.
**Part 3:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Special Order tab), calculate the net increase or decrease in profit if they take the special order.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results and comment on if you think the cookie business should take on this special order of cookies for a wedding. Business has been slow the last few months, and the offer is less than the usual selling price for the cookies.
As part of your discussion, include both quantitative (based on the numbers) and qualitative (not based on numbers) factors that would go into the decision to take on the special order, including pricing decisions.
**Part 4:** Based on the data presented in the
Unit VII Spreadsheet Template in Excel (IRR tab), calculate the internal rate of return (IRR) for the new equipment purchase.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Note: the PV Annuity table is provided for you. Discuss if you think the cookie business should accept or reject the purchase of the new equipment and why.
Additional information has come to your attention regarding the equipment purchase. One of the partner's brothers owns the company that sells the equipment and insists the equipment is needed. Discuss any ethical concerns you see with this type of transaction.
**Part 5:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Cash Budget tab), calculate the cash receipts for the first quarter of this year.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.
**Part 6:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Variances tab), complete the following calculations.
· Calculate the material variances.
· Calculate the labor variances.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss your observations about the variances and ways to plan to improve any of the variances.
End this paper with the key observations and present any future recommendations.
**Submission**: Save the submission as a Word document and upload the document to Blackboard.
**Grading:** The assignment will be reviewed in alignment with the grading rubric criteria. The assignment is worth 20% of your course grade.
**## UnitIIIStudyGuide.pdf**
ACC 5301, Management Applications of Accounting 1
Course Learning Outcomes for Unit III
Upon completion of this unit, students should be able to:
2. Apply accounting concepts to the creation of accounting information and reports.
2.2 Prepare cost-volume-profit analysis reports.
3. Analyze accounting information used to make strategic business decisions.
3.7 Compare and contrast full (absorption) and variable costing.
Required Unit Resources
Chapter 4: Cost-Volume-Profit Analysis, pp. 4-1 – 4-27
Chapter 5: Variable Costing, pp. 5-1 – 5-13
Unit Lesson
Introduction
Welcome to Unit III. In this unit, we will be looking at cost-volume-profit analysis and how this is related to
several key management tasks; planning, controlling, and decision-making. In this unit, we will also look at
how the costs we have identified (variable and fixed) are reported under both full (absorption) and variable
costing and how inventory levels effect net income under both of these methods.
Cost Identification
Variable costs and fixed costs: We are going to start off with a short review of variable and fixed costs and
how these costs change in total and per unit. Remember, fixed costs remain the same in total regardless of
the level of production while the per unit cost decreases as more units are produced because those fixed cost
are spread over more items.
Variable costs, remember, will increase or decrease in total with the level of production while the per-unit cost
remains the same. This is because the more units that are produced, the more it will cost the company in total
for those units, but each unit still costs the same amount regardless of how many are produced.
UNIT III STUDY GUIDE
Cost-Volume-Profit and
Variable Costing
ACC 5301, Management Applications of Accounting 2
UNIT x STUDY GUIDE
Title
Mixed costs: We are going to add to our previous cost
discussion the idea of mixed costs. These costs, as
the name implies, have an element of both fixed and
variable costs. As you can see from the chart, there is
a fixed cost of $200 per week, but the more units
produced above a certain level would allow the
employee to receive additional pay for those
additional units (variable costs). For example, let's say
you receive a base salary of $200 per week for up to
10 units produced, and in addition to that base salary,
you receive an additional amount if you produce more
than the 10 items. In this example, if you produce 20
items, you still receive your $200 (fixed amount) plus
an additional $200 (variable amount) for a total of
$400 that week. As you can see, the more you
produce, the more money you will make. Regardless
of the number of items you produce each week, you
will still receive the $200 base pay per week.
Why is it important to know the classification for the various costs within a company? It is important so that
managers can properly estimate the costs and perform a cost-volume-profit analysis. Keep in mind, most
managers within the company only have control over their own department or unit. Therefore, costs involved
in the negotiation of the rent contract for the factory would not be within the authority of the factory floor
supervisor. The factory floor supervisor would, however, have control over the effectiveness of his or her
workers and the efficient use of materials needed to make products within his or her department.
Cost-Volume-Profit Analysis
A cost-volume-profit analysis is an evaluation method that looks at the relationship between the level of
activity within the organization, the costs within the organization, and the profit of the organization (Jiambalvo,
2020). The basic equation to determine profit is:
Sales – Costs=Profit
Taking this equation one step further when dealing with cost-volume-profit analysis is:
(Selling price per unit * number of units sold) – (Variable costs per unit * number of units sold) – Total fixed
= Profit
ACC 5301, Management Applications of Accounting 3
UNIT x STUDY GUIDE
Title
As you can see by expanding our basic equation, we now take into account the number of units sold and
break down our costs by variable and fixed costs. This leads us to a couple of important calculations related
to cost-volume-profit analysis, break-even point, and
contribution margin.
Break-even point: One important use of a cost-volume-
profit analysis is to determine the break-even point.
This allows managers to calculate out how many
products or dollars they need to sell so they do not
make money, but they do not lose money. In other
words, this helps guide production for the company. If
the company sells above the break-even point (where
costs and revenue meet), it will make a profit, but if it
sells below the break-even point, then the company
will incur a loss. The chart to the side shows the
relationship between fixed and variable costs as well
as sales revenue. As you can see, the break-even
point is where sales and costs intersect on the chart.
Contribution margin: Another important calculation in this unit is the contribution margin. This calculation
shows how much of a "contribution" a product is making per unit to income based on variable costs only. This
means that fixed costs are not calculated into the equation. The calculation is:
Selling price per unit – Variable cost per unit = Contribution margin
For example, if a product sells for $100 but costs $60 to make, the contribution margin in $40 per unit. Keep
in mind, this calculation does not include fixed costs (like rent, CEO's salary, etc.). The contribution margin
does give the managers a basic idea if they are selling the product for more than the cost to make it.
Remember, a company may make more than one product or provide more than one service, so this technique
can be used for each product or service to make sure each one is profitable.
By using the cost-volume-profit techniques, a manager can determine how many products to make in order to
break even (no profit or no loss) and determine if the product or products the company sells are selling above
the cost to make the product, the contribution margin. By using just these two techniques, managers can plan
how many products to make, control the cost to make those products, and make decisions that will allow the
company to be profitable.
Full (Absorption) and Variable Cost Reporting
Looking at our other topic for this unit, full (absorption) and variable cost reporting, we are going to compare
and contrast these two reporting methods. Let's first look at the format of the two reports as pictured below
(Jiambalvo, 2020):
ACC 5301, Management Applications of Accounting 4
UNIT x STUDY GUIDE
Title
Both reports show sales, costs and net income. The difference between the two reports is how the
variable and fixed costs are displayed on the reports. On full or absorption costing, fixed and variable costs
are not broken down; the costs are all included in total regardless of their status as fixed or variable costs.
Keep in mind, this is the only reporting method that is acceptable for GAAP (Generally Accepted
Accounting Principles) for external reporting. This means that if the company needed to prepare a statement
for a governmental or regulatory agency or even a bank to get a loan, it would need to report using
absorption costing.
However, as a manger, full (absorption) costing does not break down the costs into fixed and variable costs.
In other words, as we noted previously, a manager has more control over variable costs, and full costing does
not show the breakdown of costs that would enable a manager to better plan and control costs. Looking at
variable costing, you can see that, while the information is the same, there is a clear breakdown of the
variable and fixed costs. Managers can now look to see how they can better control costs within their
responsibilities. For example, we noted that the factory supervisor typically does not have control over fixed
costs such as rent. By using the variable costing statement, the factory supervisor can clearly see which costs
he or she can control (variable costs) and find ways to minimize these costs.
Effects of Production on Cost Reporting
In our example above, we assumed that all 4,000 units produced were sold. This is why net income for both
full (absorption) and variable costing showed the same amount. Now, let's take a look at what happens when
inventory increases or decreases under variable costing. In this first example, only 3,800 units were sold, so
that left 200 units in inventory unsold. The chart below shows the effect on net income when not all of the
units produced are sold. As you can see, the net income under variable costing is less than the net income
under full (absorption) costing.
ACC 5301, Management Applications of Accounting 5
UNIT x STUDY GUIDE
Title
In our final example below, when the company sells more than it produces, in this case 4,200 units, net
income for variable costing is higher than the net income for full (absorption costing). This means that the
company is selling units that were left in inventory from a prior month.
Conclusion
In this unit, we have discussed cost-volume-profit techniques that are useful to managers for planning
production and sales, controlling costs, and making decisions. The two main techniques we have looked at
are calculating break-even and contribution margin. These calculations provide managers the tools they need
to not only look at how many items they should be producing but also what it is costing them to produce
those products.
This unit also looked at the two different costing reports; full (absorption) and variable costing. As we
discussed, these two methods have advantages and disadvantages. For example, while variable costing
makes it clearer to see the breakdown between variable and fixed costs, variable costing can also be used to
manipulate income based on changes in inventory levels.
ACC 5301, Management Applications of Accounting 6
UNIT x STUDY GUIDE
Title
Reference
Jiambalvo, J. (2020). Managerial accounting (7th ed.). Wiley.
https://bookshelf.vitalsource.com/#/books/9781119577706
Suggested Unit Resources
View the following video by accessing the Unit III Additional Unit Resources folder in the unit.
The video Whole Foods: Cost-Volume-Profit Analysis will demonstrate how cost-volume-profit analysis
techniques can be used at Whole Foods.
You can access a transcript for this video by hovering over the PDF button at the bottom of the video and
then clicking on the word “Transcript.” Alternatively, you can click on the “cc” button at the bottom of the video
to turn on closed captions.
Learning Activities (Nongraded)
Nongraded Learning Activities are provided to aid students in their course of study. You do not have to submit
them. If you have questions, contact your instructor for further guidance and information.
After watching the video Whole Foods: Cost-Volume-Profit Analysis in the Suggested Unit Resources, you
may want to answer the three questions in the Unit III Questions resource . Note that the "View the Video" link
referenced in each question is the same Whole Foods: Cost-Volume-Profit Analysis video linked above.
**UnitVStudyGuide.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitvstudyguide-pdf-10458203)
**UnitVIIStudyGuide.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitviistudyguide-pdf-10458199)
**UnitVIISpreadsheetTemplate.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitviispreadsheettemplate-xlsx-10458195)
**## UnitVII_Final_Project_Template.docx**
1
5
**Title of the Paper Goes Here**
Student Name
Institution
ACC 5301 Management Applications of Accounting
Instructor
Date
**Abstract**
_The abstract_ is an overview of the paper, written after completion. Other researchers use the abstract to determine if your work will be useful to them. The abstract should include the background, hypothesis or research question, methodology for data collection and analysis, the findings of your research, and conclusions. It should be between 100–150 words. This is done when the paper is complete.
**Title of Paper**
Remember this part of the paper is double spaced in APA format.
The
_Introduction_ should lead readers into the topic and its importance. Introductions typically include the overall topic of the paper, the specific focus of the paper within the larger topic, the main points in the paper, the kind of paper (study, argument, critique, discussion), and the purpose.
_Writing tip:_ The length of the introduction should be in proportion to the length of the paper. Also ask yourself, “With my purpose and my audience, how do I engage my readers best?” In the introduction, you set the tone of the piece, establish your voice, and demonstrate your writing style; be authentic to your purpose and your audience.
**Part 1 Contribution Margin/Breakeven**
Embed your spreadsheet for this section here and discuss the results.
**Part 2 Full and Variable Costing**
Embed your spreadsheet for this section here and discuss the results.
**Part 3 Special Order**
Embed your spreadsheet for this section here and discuss the results.
**Part 4 Internal Rate of Return**
Embed your spreadsheet for this section here and discuss the results.
**Part 5 Cash Budget**
Embed your spreadsheet for this section here and discuss the results.
**Part 6 Material and Labor Variance**
Embed your spreadsheet for this section here and discuss the results.
**Conclusions and Recommendations**
_The conclusion_ section
should summarize for the readers the topics of importance that led to your final conclusions/analysis regarding this case. Include some specific areas of focus from your analysis to reinforce your conclusion.
**References**
Include complete references in proper APA format for all of the citations
_listed_ in your paper. Be sure to use the library for the required number of sources. Additional sources can be used but should be scholarly. Present your references in alphabetical order.
**## ManagementApplicationsofAccountingACC5301UnitVIIAssignment.docx**
2
Management Applications of Accounting ACC 5301 Unit VII Assignment
**Cookie Business Final Project**
This final project measures your mastery of ULOs 2.2, 2.3, 2.4, 2.6, 2.7, 3.7, 3.8, and 6.2.
Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to evaluate the financial information for the company. You will be creating a series of reports and analyzing the results using the templates provided to guide you through the project. In this final project, you will do the following:
1. Apply accounting concepts and standards to the creation of accounting information and reports.
2. Analyze accounting information used to make strategic business decisions.
3. Apply ethical behavior to accounting-related situations.
4. Make business decisions based on analyzing accounting data.
5.
**Length:** Using the
Unit VII Final Project Template, prepare an eight-to-twelve-page written report (including spreadsheets).
**References:** At least three peer-reviewed sources are required, any additional resources used are required to be scholarly/academic in nature. APA Style is required for citations and references.
**Details:** First, start the paper with an abstract and introduction section, per the assignment template provided.
**Part 1:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (CM Breakeven tab):
· Calculate the contribution margin (CM) for each of the three products sold at the cookie business.
· Calculate the weighted average CM.
· Calculate the breakeven point.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, and such.
**Part 2:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Full Variable tab), complete the calculations listed below.
· Calculate the value of ending inventory under full or absorption costing.
· Calculate the value of ending inventory under variable costing.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results, and comment on which method you think is more helpful to managers and why.
**Part 3:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Special Order tab), calculate the net increase or decrease in profit if they take the special order.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss the results and comment on if you think the cookie business should take on this special order of cookies for a wedding. Business has been slow the last few months, and the offer is less than the usual selling price for the cookies.
As part of your discussion, include both quantitative (based on the numbers) and qualitative (not based on numbers) factors that would go into the decision to take on the special order, including pricing decisions.
**Part 4:** Based on the data presented in the
Unit VII Spreadsheet Template in Excel (IRR tab), calculate the internal rate of return (IRR) for the new equipment purchase.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Note: the PV Annuity table is provided for you. Discuss if you think the cookie business should accept or reject the purchase of the new equipment and why.
Additional information has come to your attention regarding the equipment purchase. One of the partner's brothers owns the company that sells the equipment and insists the equipment is needed. Discuss any ethical concerns you see with this type of transaction.
**Part 5:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Cash Budget tab), calculate the cash receipts for the first quarter of this year.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.
**Part 6:** Based on the data presented in the Unit VII Spreadsheet Template in Excel (Variances tab), complete the following calculations.
· Calculate the material variances.
· Calculate the labor variances.
Complete your calculations by filling in the highlighted cells; embed a copy of the completed spreadsheet into this report. Discuss your observations about the variances and ways to plan to improve any of the variances.
End this paper with the key observations and present any future recommendations.
**Submission**: Save the submission as a Word document and upload the document to Blackboard.
**Grading:** The assignment will be reviewed in alignment with the grading rubric criteria. The assignment is worth 20% of your course grade.
**## UnitIIIStudyGuide.pdf**
ACC 5301, Management Applications of Accounting 1
Course Learning Outcomes for Unit III
Upon completion of this unit, students should be able to:
2. Apply accounting concepts to the creation of accounting information and reports.
2.2 Prepare cost-volume-profit analysis reports.
3. Analyze accounting information used to make strategic business decisions.
3.7 Compare and contrast full (absorption) and variable costing.
Required Unit Resources
Chapter 4: Cost-Volume-Profit Analysis, pp. 4-1 – 4-27
Chapter 5: Variable Costing, pp. 5-1 – 5-13
Unit Lesson
Introduction
Welcome to Unit III. In this unit, we will be looking at cost-volume-profit analysis and how this is related to
several key management tasks; planning, controlling, and decision-making. In this unit, we will also look at
how the costs we have identified (variable and fixed) are reported under both full (absorption) and variable
costing and how inventory levels effect net income under both of these methods.
Cost Identification
Variable costs and fixed costs: We are going to start off with a short review of variable and fixed costs and
how these costs change in total and per unit. Remember, fixed costs remain the same in total regardless of
the level of production while the per unit cost decreases as more units are produced because those fixed cost
are spread over more items.
Variable costs, remember, will increase or decrease in total with the level of production while the per-unit cost
remains the same. This is because the more units that are produced, the more it will cost the company in total
for those units, but each unit still costs the same amount regardless of how many are produced.
UNIT III STUDY GUIDE
Cost-Volume-Profit and
Variable Costing
ACC 5301, Management Applications of Accounting 2
UNIT x STUDY GUIDE
Title
Mixed costs: We are going to add to our previous cost
discussion the idea of mixed costs. These costs, as
the name implies, have an element of both fixed and
variable costs. As you can see from the chart, there is
a fixed cost of $200 per week, but the more units
produced above a certain level would allow the
employee to receive additional pay for those
additional units (variable costs). For example, let's say
you receive a base salary of $200 per week for up to
10 units produced, and in addition to that base salary,
you receive an additional amount if you produce more
than the 10 items. In this example, if you produce 20
items, you still receive your $200 (fixed amount) plus
an additional $200 (variable amount) for a total of
$400 that week. As you can see, the more you
produce, the more money you will make. Regardless
of the number of items you produce each week, you
will still receive the $200 base pay per week.
Why is it important to know the classification for the various costs within a company? It is important so that
managers can properly estimate the costs and perform a cost-volume-profit analysis. Keep in mind, most
managers within the company only have control over their own department or unit. Therefore, costs involved
in the negotiation of the rent contract for the factory would not be within the authority of the factory floor
supervisor. The factory floor supervisor would, however, have control over the effectiveness of his or her
workers and the efficient use of materials needed to make products within his or her department.
Cost-Volume-Profit Analysis
A cost-volume-profit analysis is an evaluation method that looks at the relationship between the level of
activity within the organization, the costs within the organization, and the profit of the organization (Jiambalvo,
2020). The basic equation to determine profit is:
Sales – Costs=Profit
Taking this equation one step further when dealing with cost-volume-profit analysis is:
(Selling price per unit * number of units sold) – (Variable costs per unit * number of units sold) – Total fixed
= Profit
ACC 5301, Management Applications of Accounting 3
UNIT x STUDY GUIDE
Title
As you can see by expanding our basic equation, we now take into account the number of units sold and
break down our costs by variable and fixed costs. This leads us to a couple of important calculations related
to cost-volume-profit analysis, break-even point, and
contribution margin.
Break-even point: One important use of a cost-volume-
profit analysis is to determine the break-even point.
This allows managers to calculate out how many
products or dollars they need to sell so they do not
make money, but they do not lose money. In other
words, this helps guide production for the company. If
the company sells above the break-even point (where
costs and revenue meet), it will make a profit, but if it
sells below the break-even point, then the company
will incur a loss. The chart to the side shows the
relationship between fixed and variable costs as well
as sales revenue. As you can see, the break-even
point is where sales and costs intersect on the chart.
Contribution margin: Another important calculation in this unit is the contribution margin. This calculation
shows how much of a "contribution" a product is making per unit to income based on variable costs only. This
means that fixed costs are not calculated into the equation. The calculation is:
Selling price per unit – Variable cost per unit = Contribution margin
For example, if a product sells for $100 but costs $60 to make, the contribution margin in $40 per unit. Keep
in mind, this calculation does not include fixed costs (like rent, CEO's salary, etc.). The contribution margin
does give the managers a basic idea if they are selling the product for more than the cost to make it.
Remember, a company may make more than one product or provide more than one service, so this technique
can be used for each product or service to make sure each one is profitable.
By using the cost-volume-profit techniques, a manager can determine how many products to make in order to
break even (no profit or no loss) and determine if the product or products the company sells are selling above
the cost to make the product, the contribution margin. By using just these two techniques, managers can plan
how many products to make, control the cost to make those products, and make decisions that will allow the
company to be profitable.
Full (Absorption) and Variable Cost Reporting
Looking at our other topic for this unit, full (absorption) and variable cost reporting, we are going to compare
and contrast these two reporting methods. Let's first look at the format of the two reports as pictured below
(Jiambalvo, 2020):
ACC 5301, Management Applications of Accounting 4
UNIT x STUDY GUIDE
Title
Both reports show sales, costs and net income. The difference between the two reports is how the
variable and fixed costs are displayed on the reports. On full or absorption costing, fixed and variable costs
are not broken down; the costs are all included in total regardless of their status as fixed or variable costs.
Keep in mind, this is the only reporting method that is acceptable for GAAP (Generally Accepted
Accounting Principles) for external reporting. This means that if the company needed to prepare a statement
for a governmental or regulatory agency or even a bank to get a loan, it would need to report using
absorption costing.
However, as a manger, full (absorption) costing does not break down the costs into fixed and variable costs.
In other words, as we noted previously, a manager has more control over variable costs, and full costing does
not show the breakdown of costs that would enable a manager to better plan and control costs. Looking at
variable costing, you can see that, while the information is the same, there is a clear breakdown of the
variable and fixed costs. Managers can now look to see how they can better control costs within their
responsibilities. For example, we noted that the factory supervisor typically does not have control over fixed
costs such as rent. By using the variable costing statement, the factory supervisor can clearly see which costs
he or she can control (variable costs) and find ways to minimize these costs.
Effects of Production on Cost Reporting
In our example above, we assumed that all 4,000 units produced were sold. This is why net income for both
full (absorption) and variable costing showed the same amount. Now, let's take a look at what happens when
inventory increases or decreases under variable costing. In this first example, only 3,800 units were sold, so
that left 200 units in inventory unsold. The chart below shows the effect on net income when not all of the
units produced are sold. As you can see, the net income under variable costing is less than the net income
under full (absorption) costing.
ACC 5301, Management Applications of Accounting 5
UNIT x STUDY GUIDE
Title
In our final example below, when the company sells more than it produces, in this case 4,200 units, net
income for variable costing is higher than the net income for full (absorption costing). This means that the
company is selling units that were left in inventory from a prior month.
Conclusion
In this unit, we have discussed cost-volume-profit techniques that are useful to managers for planning
production and sales, controlling costs, and making decisions. The two main techniques we have looked at
are calculating break-even and contribution margin. These calculations provide managers the tools they need
to not only look at how many items they should be producing but also what it is costing them to produce
those products.
This unit also looked at the two different costing reports; full (absorption) and variable costing. As we
discussed, these two methods have advantages and disadvantages. For example, while variable costing
makes it clearer to see the breakdown between variable and fixed costs, variable costing can also be used to
manipulate income based on changes in inventory levels.
ACC 5301, Management Applications of Accounting 6
UNIT x STUDY GUIDE
Title
Reference
Jiambalvo, J. (2020). Managerial accounting (7th ed.). Wiley.
https://bookshelf.vitalsource.com/#/books/9781119577706
Suggested Unit Resources
View the following video by accessing the Unit III Additional Unit Resources folder in the unit.
The video Whole Foods: Cost-Volume-Profit Analysis will demonstrate how cost-volume-profit analysis
techniques can be used at Whole Foods.
You can access a transcript for this video by hovering over the PDF button at the bottom of the video and
then clicking on the word “Transcript.” Alternatively, you can click on the “cc” button at the bottom of the video
to turn on closed captions.
Learning Activities (Nongraded)
Nongraded Learning Activities are provided to aid students in their course of study. You do not have to submit
them. If you have questions, contact your instructor for further guidance and information.
After watching the video Whole Foods: Cost-Volume-Profit Analysis in the Suggested Unit Resources, you
may want to answer the three questions in the Unit III Questions resource . Note that the "View the Video" link
referenced in each question is the same Whole Foods: Cost-Volume-Profit Analysis video linked above.
**UnitVStudyGuide.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitvstudyguide-pdf-10458203)
**UnitVIIStudyGuide.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitviistudyguide-pdf-10458199)
**UnitVIISpreadsheetTemplate.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/unitviispreadsheettemplate-xlsx-10458195)
– 1
– 2
– 3
– 4
– 5
– 6