Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

ACC/561: Accounting Wk 5 – Cost-Volume-Profit Analysis [due Tue] Assignment Content Purpose of Assignment The Case Study focuses on CVP (Cost-Volume-Profit), break-even, and margin of safety...

1 answer below »

ACC/561: Accounting

Wk 5 – Cost-Volume-Profit Analysis [due Tue]

Assignment Content

Purpose of Assignment

The Case Study focuses on CVP (Cost-Volume-Profit), break-even, and margin of safety analyses which allows students to experience working through a business scenario and applying these tools in managerial decision making.

Resources

o Cost-Volume-Profit Analysis Grading Guide

o Generally Accepted Accounting Principles (GAAP), U.S. Securities and Exchange Commission (SEC)

o Tutorial help on Excel and Word functions can be found on the Microsoft Office website. There are also additional tutorials via the web offering support for Office products.

Scenario:Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $24,000 in fixed costs to the $270,000 in fixed costs currently spent. In addition, Mary is proposing a 5% price decrease ($40 to $38) will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $24 per pair of shoes. Management is impressed with Mary's ideas but concerned about the effects these changes will have on the break-even point and the margin of safety.

Assignment Steps

Completethe following:

o Compute the current break-even point in units, and compare it to the break-even point in units if Mary's ideas are used.

o Compute the margin of safety ratio for current operations and after Mary's changes are introduced (Round to nearest full percent).

o Prepare a CVP (Cost-Volume-Profit) income statement for current operations and after Mary's changes are introduced.

Preparea maximum 700-word informal memo to management addressing Mary's suggested changes.

o Explain whether Mary's changes should be adopted. Why or why not? Analyze the above information (three bullet points above) and use this information to support your suggestion.

Showyour work in Microsoft Word or Excel.

Completecalculations/computations using Microsoft Word or Excel.

Submit your assignment.

Individual Assignment: Cost-Volume-Profit Analysis

Purpose of Assignment

The Case Study focuses on CVP (Cost-Volume-Profit), Break-Even, and margin of safety analyses which allows students to experience working through a business scenario and applying these tools in managerial decision making.

Resources Required

Generally Accepted Accounting Principles (GAAP)

U.S. Securities and Exchange Commission (SEC)

Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web offering support for Office products.

Grading Guide

Content

Met

Partially Met

Not Met

Comments:

Computed the current break-even point in units, and compared it to the break-even point in units if Mary’s ideas were used.

Computed the margin of safety ratio for current operations and after Mary’s changes were introduced (rounded to nearest full percent).

Prepared a CVP (Cost-Volume-Profit) income statement for current operations and after Mary’s changes were introduced.

Explained whether Mary’s changes should be adopted. Why or why not? Analyzed the information (first three rows above) and used the information to support student’s suggestion.

Showed work in Microsoft® Word or

Excel®. Completed calculations/computations

using Microsoft® Word or Excel®.

The informal memo is a maximum 700 words in length.

Total Available

Total Earned

100

#/100

Writing Guidelines

Met

Partially Met

Not Met

Comments:

The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements.

Intellectual property is recognized with in-text citations and a reference page.

Paragraph and sentence transitions are present, logical, and maintain the flow throughout the paper.

Sentences are complete, clear, and concise.

Rules of grammar and usage are followed including spelling and punctuation.

Total Available

Total Earned

30

#/30

Assignment Total

#

130

#/130

Additional comments:

Answered Same Day Oct 03, 2021

Solution

Anamika answered on Oct 05 2021
163 Votes
1. CALCULATION OF BREAKEVEN POINT IN UNITS.
BEP (IN UNITS)         =     FIXED COST/CONTRIBUTION
CONTRIBUTION         =     SALE PRICE – VARIABLE COST
Cu
ent operation
Fixed cost         -    $270,000
Sales price per unit     -     $40
Sales Volume         –     20,000 units
Variable cost per unit     -     $24
Contribution         =     $40 - $24         =     $16/unit
BEP (in units)        =     270,000/16         =     16,875 units
If Mary’s change is adopted:
Fixed cost         -    $294,000
Sales price per unit     -     $38
Sales Volume         –     24,000 units
Variable cost per unit     -     $24
Contribution        =    $38 - $24         =    $14/unit
BEP (in units)        =    $294,000/14        =    21,000 units
2. MARIGIN OF SAFETY RATIO
MARGIN OF SAFETY        =        ACTUAL SALES – BREAKEVEN POINT
MARGIN OF SAFETY RATIO    =        MARGIN OF SAFETY/ACTUAL SALES
Cu
ent Operation
Actual Sales (in units)        =    20,000 units
Sales at BEP (in units)    =    16,875 units
Margin of Safety        =    20,000 – 16,875    =    3,125 units
Ratio                =    3,125/20,000        =    15.6%
Proposed Option
Actual Sales (in units)        =    24,000 units
Sales at BEP (in units)    =    21,000 units
Margin of Safety        =    24,000 – 21,000    =    3,000 units
Ratio                =    3,000/24,000        =    12.5%
3. COST VOLUME PROFIT INCOME STATEMENT
Cu
ent Operation
                        Total ($)            Unit
Revenue (20,000 units)            800,000            40
Variable Expenses                480,000            24
Contribution Margin                320,000            16
Fixed Expenses                270,000            
Net Income                    50,000
Mary’s Proposal
                        Total ($)            Unit
Revenue (24,000 units)            912,000            38
Variable Expenses                576,000            24
Contribution Margin                336,000            14
Fixed Expenses                294,000            
Net Income                    42,000
MEMO
Mary (advertising manager) gave a suggestion regarding installation of a new lighting system that will increase overall profit. We analyzed the proposal given by Mary and we found that although it is profitable but...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here