ACC 5301 VII
7 months ago
60
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.
- i need good work..
- If 2 workers take 200 days to make a bridge how many days does it take 15 workers to make...
- i ned in 3 hours, 350 words
- Calculations Shown
- final exam
- discussion responses
- SEC 310 Week 2 Individual Assignment Loss Prevention and Risk Management
- SCI 220 Nutrition and Health
- HISTORY OF TELEPHONE INVENTION
- tech 3 paper