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.
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
Prepare an accurate contribution margin income statement based on breakeven using correct Excel formulas.
Perform a cost volume profit analysis for all scenarios using correct Excel formulas. There are five scenarios. Include the following details in your response:
Calculate the effects on costs and sales volume for each scenario.
Prepare an accurate contribution margin income statement for each scenario.
Calculate the after-tax effect of each proposed scenario.
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:
Calculate the after-tax effect on sales for each scenario.
Prepare a contribution margin income statement for each scenario.
Evaluate a special-order option using correct Excel formulas. Include the following details in your response:
Calculate accurately the after-tax profitability of the special order.
Prepare an accurate contribution margin income statement for the company if the special order is accepted.
High-Level Takeaway Document
Create a one-page high-level takeaway document for the stakeholders that is easy to follow.
