5-1 ACC311

Competency

In this project, you will demonstrate your mastery of the following competency:

• Analyze cost data to inform business operations and strategic decisions
• Communicate cost data and analysis information to internal stakeholders

Overview

Cost accounting is focused on assisting the organization in making better operational decisions. One important decision revolves around exploring options to allow the organization to achieve desired sales and profit levels. In this project, you will take the role of a cost accountant assisting a client with evaluation options to achieve a target profit. You will also help the client with various strategies to achieve that target profit, as well as help the client determine whether or not to accept a special order.

Directions

Your completed project will consist of the following three deliverables:

Project One Workbook

Complete the Project One Workbook Template found in the What to Submit section. It includes all calculations to be completed for the proposed scenarios for the client, which can be found in Project One Case Study linked in the Supporting Materials section. The template will aid you in preparing the financial report for the stakeholders represented in the case study.

Stakeholder Presentation Template and SPEAKER NOTES

Once you have completed all necessary research for the client, you will need to prepare a presentation for the stakeholders represented in the case study using the Project One Presentation Template found in the What to Submit section. Review the Speaker Notes for each slide, they contain guiding information on what should be included on each slide. It will need to be organized and formatted based on the needs of the stakeholders. This should be a polished presentation with all key information including basic visualizations. PLEASE include speaker

High-Level Takeaway Document

Prepare a one-page document that is a high-level overview of the presentation geared towards the stakeholders. This is common practice to have a document for stakeholders to review once a presentation is complete. It will allow them to reference key points and critical information from the presentation to make their decision.

Specifically, you must address the following rubric criteria:

Project One Workbook

1. Prepare an accurate contribution margin income statement based on breakeven using correct Excel formulas.
2. Perform a cost volume profit analysis for all scenarios using correct Excel formulas. There are five scenarios. Include the following details in your response:
3. Calculate the effects on costs and sales volume for each scenario.
4. Prepare an accurate contribution margin income statement for each scenario.
5. Calculate the after-tax effect of each proposed scenario.
6. Determine the effect of the price increase based on the market for all scenarios using correct Excel formulas. Include the following details in your response:
7. Calculate the after-tax effect on sales for each scenario.
8. Prepare a contribution margin income statement for each scenario.
9. Evaluate a special-order option using correct Excel formulas. Include the following details in your response:
10. Calculate accurately the after-tax profitability of the special order.
11. Prepare an accurate contribution margin income statement for the company if the special order is accepted.

Stakeholder Presentation

1. Explain the key points to communicate to the stakeholders. Include the following details in your response:
2. Summarize the companys request.
3. Explain the benefits and advantages to the company for each scenario.
4. Explain the disadvantages to the company for each scenario.
5. Present the best possible recommendation(s) for the company moving forward based on cost data analysis. Include the following details in your response:
6. Determine which scenario is the best for Lorenzo’s company.
7. Determine if Lorenzo should accept the special order.
8. Provide your rationale.
9. Explain the potential impact of decisions on business and workforce relationships. Include the following details in your response:
10. Explain the potential effects of going from a salary to commission-based salesforce.
11. Explain the potential effects of downgrading the quality of supplies for customers orders in the short and long term.
12. Explain how a potential price increase might affect customers short and long term.
13. Utilize effective basic visualizations that support your rationale.
14. Create a simple, neat, and clearly articulated presentation with narration for the needs of the stakeholders.

High-Level Takeaway Document

1. Create a one-page high-level takeaway document for the stakeholders that is easy to follow.

If you need writing support, access the Academic Support module of your course.

What to Submit

To complete this project, you must submit the following:

Project One Workbook Template

Submit the with all tabs completed.

Project One Presentation Template and SPEAKER NOTES

Submit the with all the required headings. Sources should be cited according to APA style.

High-Level Takeaway Document

Submit your high-level takeaway document for the client as a 1-page Microsoft Word document with double spacing, 12-point Times New Roman font, and one-inch margins. Sources should be cited according to APA style.