Requirement 1
Units
Sales
Variable Costs
Fixed Costs
Net Income
Price
X$
X$
Requirement 2
Contribution Margin per Unit in Dollars = Selling Price – Variable Costs
Selling Price
Variable Costs
Contribution Margin Ratio = Contribution Margin/Selling Price
Contribution Margin
Selling Price
Requirement 3
Break-Even Point = Fixed Costs / Contribution Margin
Fixed Costs
Contribution Margin
Break-Even Point in Units X Selling Price per Unit = Break-Even Point Sales
Break-Even Point in Units
Selling Price per Unit
Requirement 4A
Margin of Safety in Units = Current Unit Sales – Break-Even Point in Unit Sales
Current Unit Sales
Break-Even Point in Sales
Requirement 4B
Margin of Safety in Dollars = Current Sales in Dollars – Break-Even Point Sales in Dollars
Current Sales in Dollars
Break-Even Point in Dollars
Requirement 4C
Margin of Safety as a Percentage = Margin of Sales in Units / Current Unit Sales
Margin of Safety in Units
Current Unit Sales
Requirement 5
Degree of Operating Leverage = Contribution Margin / Operating Income
Contribution Margin
Operating Income
Requirement 6
Units
Sales
Variable Costs
Fixed Costs
Net Income
Operating Leverage
Prior Income
Increase
Total
$ Per Unit
X$
X$
Times % Increase
$
$
$
From Part 1
Prior Income X XX% Above
Requirement 7
Targeted Income = (Fixed Costs + Target Income) / Contribution Margin
Fixed Costs + Target Income
Fixed Costs
Target Income
Total
Proof
Divided by Contribution Margin
$
$
$
$
# of Units Above X $ Per Unit
Revenue
XX,XXX X $XX.XX
Variable Costs
XX,XXX X $X.XX
Contribution Margin
Fixed Costs
Net Income
Requirement 8
Sales Mix
Current
Expected Sales Units
Revenue = Sales X Price
Variable Costs X Units
Contribution Margin
Fixed Costs
Operating Income
Specialty
X
$
$
$
$
X
$
$
$
$
Prior Net Income From Requirement 1
Additional Operating Income
Decision With Explanation
(Operating Income Above Less Prior Income)
Totals
$
$
$
$
Contribution Margin per Unit
Contribution Margin Ratio
Break-Even Point in Units (Rounded)
Break-Even Point in Sales (Rounded)
Margin of Safety in Units
es in Dollars
Margin of Safety in Dollars
Margin of Safety Percentage
Operating Leverage
Totals
$
$
$
$
Increase would be XX%
# of Units (Rounded)
X
$
$
$
$
$
Total
$
$
$
$
$
$
$
Requirement 1
Hampshire Company
Variable Costing Income Statement
Units
Sales
Variable Cost of Goods Sold:
Beginning Inventory
Direct Materials
Direct Labor
Manufacturing Overhead
Total Variable Costs
$
X$
$
$
$
$
$
$
X $
X $
X $
Cost of Good Available for Sale
Deduct Ending Inventory
Variable Costs of Goods Sold
Variable Selling Costs
Contribution Margin
Fixed Costs:
Fixed Manufacturing Costs
Fixed Administrative Costs
Operating Income
$
$
X$
X $
$
$
$
$
$
$
$
Requirement 2
Hampshire Company
Absorption Costing Income Statement
Units
Sales
Variable Cost of Goods Sold:
Beginning Inventory
Direct Materials
Direct Labor
Manufacturing Overhead
Total Variable Costs
Allocated Fixed Manufacturing Costs
Cost of Good Available for Sale
Deduct Ending Inventory
Costs of Goods Sold
Gross Margin
Fixed Costs:
Variable Selling Costs
$
X$
X $
X $
X $
X $
X$
$
$
$
$
$
$
$
$
$
$
$
X $
$
Fixed Administrative Costs
Operating Income
$
$
Requirement 1
Price Variances:
(Actual Price – Standard Price) X Actual Quantity
Actual
Standard
Actual Quantity Variance Favorable or Unfavorable
X$
Cloth
$
$
Handle Assembly
$
$
X$
Labor Price Variance $
$
X$
Requirement 2
Efficiency Variances:
(Actual Quantity of Input Used – Standard Quantity of Input Allowed for Actual Output) X Budgeted Price of Input
Actual
Cloth
(1.5 Yards per Unit)
Handle Assembly
(1 per Unit)
Labor
(.20 per Unit)
X
Standard
X$
Standard Price
Variance Favorable or Unfavorable
$
X
X$
$
X
X$
$
or Unfavorable
ted Price of Input
or Unfavorable
Cost Information From Instructions
Stick
Units Sold
Selling Price
Direct Material Cost Per Unit
Direct Labor Cost Per Hour
Variable MO
Variable Selling Costs
Labor Hours Per Unit
Sales Orders
Purchase Orders
Production Runs
Material Moves
Machine Setups
Machine Hours
Inspections
Shipments
Collapsible
60,000
$12.50
$3.00
$7.50
$0.40
$1.10
0.2
120
50
45
86
130
525
200
60
Activity Information from Instructions
Activity
Order Processing
Purchasing
Material Handing
Machine Setup
Production
Assembly
Inspecting
Shipping
Activity Cost
$35,000
$36,000
$28,000
$14,000
$99,000
$80,000
$11,000
$7,500
3,000
$14.00
$3.10
$8.00
$0.40
$1.10
0.2
1
3
6
10
6
32
10
3
Activity Cost Driver
Number of Sales Orders
Number of Purchase Orders
Material Moves
Machine Setups
Production Runs
Machine Hours
Number of Inspections
Number of Shipments
Requirement 1
Activity
Order Processing
Purchasing
Material Handing
Machine Setup
Production
Assembly
Inspecting
Shipping
Total Costs
$
$
$
$
$
$
$
$
Quantity of Cost Allocation
Base
X
X
X
X
X
X
X
X
Requirement 2
Traditional Costing
Stick Umbrella
Revenues
Direct Materials
Direct Labor
$
$
$
Collapsible Umbrella
$
$
$
Variable Overhead
Variable Selling Costs
Allocated Fixed Overhead
Total Costs
Operating Income
Operating Income %
Per Unit Operating Income
$
$
$
$
$
$
$
$
$
$
%
$
%
$
Requirement 3
Activity-Based Costing
Stick Umbrella
Revenues
Direct Materials
Direct Labor
Variable Overhead
Variable Selling Costs
Order Processing Costs
Purchasing Costs
Material Handing Costs
Machine Setup Costs
Production Costs
Assembly Costs
Inspecting Costs
Shipping Costs
Total Costs
Operating Income
Operating Income %
Per Unit Operating Income
Requirement 4
Costs per Unit
Traditional
ABC
Difference
Requirement 5
Collapsible Umbrella
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
%
$
%
$
Stick Umbrella
$
$
$
Collapsible Umbrella
$
$
$
Overhead Allocation
Rate
$
$
$
$
$
$
$
$
Total
$
$
$
$
$
$
$
$
Total
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
ACC 550 Milestone Three Guidelines and Rubric
Overview: The final project for this course is the creation of a quantitative analysis that includes an Excel spreadsheet accompanied by a memo to management.
Accountants provide management with the logistics of the business that are crucial for daily operations and a company’s overall success. In any business, it is of
the utmost importance to be aware of all finances and internal processes. Cost accountants focus solely on the internal processes of a business and are tasked
with eliminating any unnecessary costs in order to maximize profits.
For the final project, you have been tasked with conducting a quantitative analysis that looks into the internal processes of a company. Based on your analysis,
you will formulate recommendations to management that aim to improve internal processes and increase profits for the company.
Prompt: For this milestone, submit a draft of the alternative costing method section of the final project (Section IV), including all of critical elements listed below.
Refer to the Hampshire Company Case Study document, as this provides details on how to complete this milestone. All calculations for your quantitative analysis
should be completed in the Hampshire Company Spreadsheet. You will provide a rough draft of your qualitative analysis in a Word document.
Specifically, the following critical elements must be addressed:
IV. Alternative Costing Method
There are various costing methods available for companies to implement. As a company grows, it may become beneficial to consider an alternate costing
method.
A. Identify an alternative costing method that could benefit this company, and describe the main characteristics of that method.
B. What should a company look for when trying to determine whether they should adopt such a system?
C. Should the company adopt this alternative costing method? Defend your response.
If you would like a refresher course on using various features of Excel, sign in to Atomic Learning and type “Excel” in the search box. This will provide you with
options to select the specific level of training that you need (intro, intermediate, or advanced) and the specific version of Excel that you have (e.g., 2011 or 2013).
The trainings are broken down into small, meaningful chunks. Therefore, you should be able to find specific topics at each level that will meet your needs.
Rubric
Guidelines for Submission: The written portion of this submission must be a two- to three-page Word document with 12-point Times New Roman font, double
spacing, and one-inch margins. Sources should be cited according to APA style. Use the Hampshire Company Spreadsheet to submit your calculations as an Excel file.
Critical Elements
Alternative Costing
Method: Main
Characteristics
Proficient (100%)
Identifies alternative costing systems and
describes the main characteristics of each
Alternative Costing
Method: Adopt
Determines what the company should look
for when deciding to adopt an alternative
costing system and supports response with
examples
Determines whether the company should
adopt the alternative costing method and
defends response
Submission has no major errors related to
citations, grammar, spelling, syntax, or
organization
Alternative Costing
Method: Method
Articulation of
Response
Needs Improvement (75%)
Identifies alternative costing systems but
does not describe the main characteristics of
each, or identification or description contain
inaccuracies
Determines what the company should look
for when deciding to adopt an alternative
costing system but does not support
response with examples
Determines whether the company should
adopt the alternative costing method but
does not defend response
Submission has major errors related to
citations, grammar, spelling, syntax, or
organization that negatively impact
readability and articulation of main ideas
Not Evident (0%)
Does not identify alternative costing systems
Value
30
Does not determine what the company
should look for when deciding to adopt an
alternative costing system
30
Does not determine whether the company
should adopt the alternative costing method
30
Submission has critical errors related to
citations, grammar, spelling, syntax, or
organization that prevent understanding of
ideas
Earned Total
10
100%
ACC 550 Final Project Guidelines and Rubric
Overview
The final project for this course is the creation of a quantitative analysis that includes an Excel spreadsheet, accompanied by a memo to management.
Accountants provide management with the logistics of the business that are crucial for daily operations and a company’s overall success. In any business, it is of
the utmost importance to be aware of all finances and internal processes. Cost accountants focus solely on the internal processes of a business and are tasked
with eliminating any unnecessary costs in order to maximize profits.
In this assessment, you have been tasked with conducting a quantitative analysis that looks into the internal processes of a company. Based on your analysis, you
will formulate recommendations to management that aim to improve internal processes and increase profits for the company.
The project is divided into three milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final
submissions. These milestones will be submitted in Modules Three, Five, and Seven. Your final submission will occur in Module Nine.
In this assignment, you will demonstrate your mastery of the following course outcomes:
ACC-550-01: Apply cost-volume-profit (CVP) analysis based on cost classification for planning and control of internal accounting processes within an
organization
ACC-550-02: Assess cost and revenue allocation methods for providing relevant information to decision makers
ACC-550-03: Select the optimal inventory management method for meeting the needs of an organization
ACC-550-04: Evaluate cost accounting performance and planning tools for their impact on business operations
Prompt
Conduct a quantitative analysis of a company’s internal processes using the Hampshire Company Case Study document. Your analysis will consist of completing
the Hampshire Company Spreadsheet and will be accompanied by a memo to management.
Specifically, the following critical elements must be addressed:
I.
Cost-Volume-Profit Analysis
Cost-volume-profit (CVP) analysis is a useful tool for informing short-term economic planning within an organization. In this section, a CVP analysis
will be conducted and used to inform business decisions and recommendations.
A. Perform a CVP analysis based on cost classifications.
B. Explain how a CVP analysis can assist management with short-term economic planning. Support your response with examples from your
CVP analysis.
C. Accurately compute the break-even quantity and break-even revenue.
D. Determine whether the company is breaking even. What are the CVP analysis implications on planning?
II.
Inventory Management
Inventory management serves to minimize the cost to maintain inventory and maximize returns. In this section, the company’s financial data will be
reviewed in order to determine the optimal inventory management system.
A. Determine an optimal cost allocation method based on the relevant costs.
B. Describe how this method should be used by decision makers to fulfill their responsibilities. Support your response with examples.
C. What are the pros and cons of implementing the just-in-time (JIT) inventory system? Do the pros outweigh the cons for this company?
D. Explain how the just-in-time (JIT) inventory system can benefit this organization. Defend your response.
E. Identify the inventory management method you recommend, and explain why this method will benefit the company.
III.
Benchmarking
In this section, benchmarking will be reviewed. Benchmarking can be implemented in various ways depending on a company’s circumstances. Your
company has decided to implement benchmarking and would like you to research and recommend the most effective approach.
A. What is the advantage to benchmarking in terms of improving companies’ performance? Support your response.
B. Identify possible approaches to benchmarking. Describe each.
C. Which benchmarking method should management adopt and why?
IV.
Alternative Costing Method
There are various costing methods available for companies to implement. As a company grows, it may become beneficial to consider an alternate
costing method.
A. Identify an alternative costing method that could benefit this company, and describe the main characteristics of that method.
B. What should a company look for when trying to determine whether they should adopt such a system?
C. Should the company adopt this alternative costing method? Defend your response.
V.
Memo to Management
Your memo to management should serve as a summary of your quantitative analysis, reviewing the key points and recommendations that you feel
management should be aware of.
A. Describe the overall findings of your analysis, including key elements that management should be aware of.
B. Make a recommendation to management based on your cost accounting analysis that will enhance business planning.
C. Recommend a performance tool to management based on your cost accounting analysis that will improve business operations.
You may use the following resources to help you prepare your memo to management: Purdue OWL: Memos contains information related to formatting a memo,
and Purdue OWL: Sample Memo presents a sample of a memo that you can use as a guide when you format the memo for the final project.
If you would like a refresher course on using various features of Excel, sign in to Atomic Learning and type “Excel” in the search box. This will provide you with
options to select the specific level of training that you need (intro, intermediate, or advanced) and the specific version of Excel that you have (e.g., 2011 or 2013).
The trainings are broken down into small, meaningful chunks. Therefore, you should be able to find specific topics at each level that will meet your needs.
Milestones
Milestone One: Draft of Cost-Volume-Profit Analysis
In Module Three, you will submit a draft of the cost-volume-profit analysis (Section I of the final project), including all critical elements as listed above. Refer to
the Hampshire Company Case Study document, as this will provide you with details on how to complete this milestone. All calculations for your quantitative
analysis should be completed in the Hampshire Company Spreadsheet. You will provide a rough draft of your one- to two-page qualitative analysis in a Word
document. The Word document must be in APA format. Once you have completed your analysis, submit your Word and Excel documents. This milestone will be
graded with the Milestone One Rubric.
Milestone Two: Draft of Inventory Management and Benchmarking
In Module Five, you will submit a draft of the inventory management and benchmarking sections of the final project (Sections II and III, respectively), including all
critical elements as listed above. Refer to the Hampshire Company Case Study document, as this will provide you with details on how to complete this milestone.
All calculations for your quantitative analysis should be completed in the Hampshire Company Spreadsheet. You will provide a rough draft of your three- to fourpage qualitative analysis in a Word document. The Word document must be in APA format. Once you have completed your analysis, submit your Word and Excel
documents. This milestone will be graded with the Milestone Two Rubric.
Milestone Three: Draft of Alternative Costing Method
In Module Seven, you will submit a draft of the alternative costing method section of the final project (Section IV), including all critical elements as listed above.
Refer to the Hampshire Company Case Study document, as this will provide you with details on how to complete this milestone. All calculations for your
quantitative analysis should be completed in the Hampshire Company Spreadsheet. You will provide a rough draft of your two- to three-page qualitative analysis
in a Word document. The Word document must be in APA format. Once you have completed your analysis, submit your Word and Excel documents. This
milestone will be graded with the Milestone Three Rubric.
Final Project Submission: Quantitative Analysis and Memo to Management
In Module Nine, you will submit your quantitative analysis and memo to management. It should be a complete, polished artifact containing all of the critical
elements of the final product. It should reflect the incorporation of feedback gained throughout the course. This submission will be graded using the Final
Project Rubric.
Deliverables
Milestone
One
Two
Three
Deliverable
Draft of Cost-Volume-Profit Analysis
Draft of Inventory Management and
Benchmarking
Draft of Alternative Costing Method
Final Project Submission: Quantitative
Analysis and Memo to Management
Module Due
Three
Five
Grading
Graded separately; Milestone One Rubric
Graded separately; Milestone Two Rubric
Seven
Nine
Graded separately; Milestone Three Rubric
Graded separately; Final Project Rubric
Final Project Rubric
Guidelines for Submission: The financial portions of your quantitative analysis should be submitted using the Hampshire Company Spreadsheet. The written
portions of your qualitative analysis should be submitted as a six- to nine-page Microsoft Word document. Your memo to management should be submitted as a
two- to three-page Microsoft Word document. Both Word documents should use double spacing, one-inch margins, and 12-point Times New Roman font.
Sources should be cited according to APA style.
Critical Elements
Cost-Volume-Profit
Analysis: Analysis
Cost-Volume-Profit
Analysis: Economic
Planning
Cost-Volume-Profit
Analysis: Break-Even
Exemplary
Proficient
Performs a cost-volume-profit
analysis based on cost
classifications (100%)
Meets “Proficient” criteria and
Explains how a CVP analysis can
demonstrates a nuanced
assist management with shortunderstanding of the relationship term economic planning and
between CVP and short-term
supports response with examples
planning (100%)
(90%)
Accurately computes the breakeven quantity and break-even
revenue (100%)
Needs Improvement
Performs a cost-volume-profit
analysis, but it is not based on
cost classifications (70%)
Explains how a CVP analysis can
assist management with shortterm economic planning but does
not support response with
examples, or explanation is
cursory or inaccurate (70%)
Computes the break-even
quantity and break-even revenue,
but there are issues with
accuracy (70%)
Not Evident
Does not perform a cost-volumeprofit analysis (0%)
Value
5.4
Does not explain how a CVP
analysis can assist management
with short-term economic
planning (0%)
5.4
Does not compute the breakeven quantity and break-even
revenue (0%)
5.4
Cost-Volume-Profit
Analysis: Implications
Meets “Proficient” criteria and
Determines whether the
uses industry-specific language to company is breaking even and
establish expertise (100%)
identifies cost-volume-profit
analysis implications for planning
(90%)
Inventory Management: Meets “Proficient” criteria and
Relevant Costs
demonstrates a nuanced
understanding of the relationship
between optimal cost allocation
and relevant costs (100%)
Inventory Management: Meets “Proficient” criteria, and
Method
description is exceptionally clear
and contextualized (100%)
Determines an optimal cost
allocation method based on the
relevant costs (90%)
Recommends how the method
should be used by decision
makers to fulfill their
responsibilities and supports
response with examples (90%)
Determines whether the
company is breaking even but
does not identify cost-volumeprofit analysis implications on
planning, or determination or
identification contain issues with
accuracy (70%)
Determines an optimal cost
allocation method, but
determination is not based on
the relevant costs (70%)
Recommends how the method
should be used by decision
makers to fulfill their
responsibilities but does not
support response with examples
(70%)
Inventory Management: Meets “Proficient” criteria, and
Identifies the pros and cons of
Identifies the pros and cons of
Pros and Cons
description is well supported with implementing JIT and describes
implementing JIT but does not
examples (100%)
whether the pros outweigh the
describe whether the pros
cons for this company (90%)
outweigh the cons for this
company (70%)
Inventory Management: Meets “Proficient” criteria, and
Explains how the JIT inventory
Explains how the JIT inventory
Inventory System
explanation is exceptionally clear system can benefit the
system can benefit the
and contextualized (100%)
organization and defends
organization but does not defend
response (90%)
response (70%)
Inventory Management: Meets “Proficient” criteria and
Identifies the inventory
Identifies the inventory
Inventory
uses specific examples to support management method
management method
description (100%)
recommended and explains why recommended but does not
this method will benefit the
explain why this method will
company (90%)
benefit the company (70%)
Benchmarking:
Meets “Proficient” criteria, and
Identifies an advantage of
Identifies an advantage of
Advantage
support includes specific
benchmarking and supports
benchmarking but does not
examples (100%)
response (90%)
support response (70%)
Benchmarking:
Meets “Proficient” criteria and
Identifies different approaches to Identifies different approaches to
Approaches
shows a keen insight into the
benchmarking and describes each benchmarking but does not
variety of benchmarking
(90%)
describe each (70%)
approaches (100%)
Does not determine whether the
company is breaking even (0%)
5.4
Does not determine an optimal
cost allocation method (0%)
5.4
Does not recommend how the
method should be used by
decision makers (0%)
5.4
Does not identify the pros and
cons of implementing JIT (0%)
5.4
Does not explain how the JIT
inventory system can benefit the
organization (0%)
5.4
Does not identify the inventory
management method that is
recommended (0%)
5.4
Does not identify an advantage of
benchmarking (0%)
5.4
Does not identify different
approaches to benchmarking
(0%)
5.4
Benchmarking:
Benchmarking Method
Meets “Proficient” criteria, and
determination is well supported
and plausible (100%)
Alternative Costing
Method: Main
Characteristics
Meets “Proficient” criteria and
displays a keen insight into the
variety of alternative costing
systems (100%)
Alternative Costing
Method: Adopt
Meets “Proficient” criteria and
demonstrates a nuanced
understanding of the relationship
of the needs of a company and an
alternative costing system (100%)
Meets “Proficient” criteria, and
determination is well supported
and plausible (100%)
Alternative Costing
Method: Method
Memo to Management:
Findings
Meets “Proficient” criteria, and
description is exceptionally clear
and contextualized (100%)
Memo to Management:
Business Planning
Meets “Proficient” criteria, and
recommendation is well
supported and plausible (100%)
Memo to Management:
Business Operations
Meets “Proficient” criteria, and
recommendation uses industryspecific language to establish
expertise (100%)
Articulation of Response Submission is free of errors
related to citations, grammar,
spelling, syntax, and organization
and is presented in a professional
and easy to read format (100%)
Determines which benchmarking
method management should
adopt and justifies response
(90%)
Identifies alternative costing
systems and describes the main
characteristics of each (90%)
Determines what the company
should look for when deciding to
adopt an alternative costing
system and supports response
with examples (90%)
Determines whether the
company should adopt the
alternative costing method and
defends response (90%)
Describes the overall findings of
analysis and identifies key
elements that management
should be aware of (90%)
Makes recommendation to
enhance business planning based
on cost accounting analysis (90%)
Recommends a performance tool
to improve business operations
based on cost accounting analysis
(90%)
Submission has no major errors
related to citations, grammar,
spelling, syntax, or organization
(90%)
Determines which benchmarking
method management should
adopt but does not justify
response (70%)
Identifies alternative costing
systems but does not describe
the main characteristics of each,
or identification or description
contain inaccuracies (70%)
Determines what the company
should look for when deciding to
adopt an alternative costing
system but does not support
response with examples (70%)
Determines whether the
company should adopt the
alternative costing method but
does not defend response (70%)
Describes the overall findings of
analysis but does not identify key
elements that management
should be aware of (70%)
Makes recommendation to
enhance business planning, but
recommendation is not based on
cost accounting analysis (70%)
Recommends a performance tool
to improve business operations,
but recommendation is not based
on cost accounting analysis (70%)
Submission has major errors
related to citations, grammar,
spelling, syntax, or organization
that negatively impact readability
and articulation of main ideas
(70%)
Does not determine which
benchmarking method
management should adopt (0%)
5.4
Does not identify alternative
costing systems (0%)
5.4
Does not determine what the
company should look for when
deciding to adopt an alternative
costing system (0%)
5.4
Does not determine whether the
company should adopt the
alternative costing method (0%)
5.4
Does not describe the overall
findings of analysis (0%)
5.4
Does not make recommendation
to enhance planning (0%)
5.4
Does not recommend a
performance tool to improve
business operations (0%)
5.4
Submission has critical errors
related to citations, grammar,
spelling, syntax, or organization
that prevent understanding of
ideas (0%)
2.8
Earned Total 100%
Purchase answer to see full
attachment