1 | Break Even Point = Total Fixed Costs / Contribution Per Unit | ||
Particulars | Option A | Option B | |
Fixed Costs | $1,450,000 | $4,700,000 | |
Contribution per Unit | $15 | $40 | |
BEP (Volume) | 96,667 | 117,500 | |
2 | How many shipments would have to be made under Option A to produce operating Income of $43,000 for an annual Period? | ||
Particulars | Option A | ||
Target Operating income | $43,000 | ||
Fixed Costs | $1,450,000 | ||
Total Amount to be recovered | $1,493,000 | ||
Contribution per Unit | $15 | ||
No. Of Shipments to be made ($1,493,000/$15) |
99,533 | ||
3 | How many shipments would have to be made under Option A to produce operating equal to 11% of Sales revenue ? | ||
Let the Number of Shipments be a | |||
Sales revenue = $100 X a | |||
Operating Income = $100a X 11% = $11a | |||
Operating income = Contribution - Fixed Costs | |||
$11a = $15a - $1,450,000 | |||
$1,450,000 = $4a | |||
a = $1,450,000 / $4 | |||
a = 362,500 | |||
The total shipments to be made = 362,500 | |||
4. | How many shipments would have to be made under Option B to produce net Income of $213,000 per year, given a corporate tax rate of 25% | ||
Particulars | Option B | ||
Target net income | $213,000 | ||
Tax @25% ($213,000*25/75) | $71,000 | ||
Target income before tax | $284,000 | ||
Fixed Costs | $4,700,000 | ||
Total Amount to be recovered | $4,984,000 | ||
Contribution per Unit | $40 | ||
No. of Shipments to be made ($4,984,000/$40) |
124,600 |
5 | Assume that for the coming year total fixed costs are expected to decrease by 8% for each of the two options. | ||
What is the new break even point for each options | |||
Particulars | Option A | Option B | |
Fixed Costs | 1450000 | 4700000 | |
Future Fixed Costs | 1334000 | 4324000 | |
Contribution per Unit | 15 | 40 | |
BEP (Volume) | 88933 | 108100 | |
Analysis | |||
Particulars | Option A | Option B | |
BEP (Volume) - Current year | 96667 | 117500 | |
BEP (Volume) - Future years | 88933 | 108100 | |
Change in Break Even | 7734 | 9400 | |
Decrease in Fixed Cost | 8% | 8% | |
For 1% decrease in fixed costs, the break even point (volume) changes by 967 shipments(7734/8) in case of Option A and 1175 shipments(9400/8) in case of option B |
6 | Assume an average income tax rate is 35%. Wha volume (Shipments) would be needed to generate net income of 8% of revenue for each option? | |||
Let the number of shipments be a for option A and b for Option b | ||||
Particulars | Option A | Option B | ||
Number of shipments | a | b | ||
Sales Revenue | $100a | $100b | ||
Net Income 8% | $8a | $8b | ||
Income before tax | $8a X 100 / 65 | $8b X 100 / 65 | ||
Contribution | $15a | $40b | ||
Total Fixed Costs | 1450000 | 4700000 | ||
Option A | ||||
Operating income = Contribution - Fixed Costs | ||||
$8a X 100/65 = $15a - $1,450,000 | ||||
$800a = 65 ($15a - $1,450,000) | ||||
$800a = $975a - $94,250,000 | ||||
$175a = $94,250,000 | ||||
a= $94,250,000 / $175 | ||||
a = 538,571 | ||||
No.of shipments for Option A = 538,571 | ||||
Option B | ||||
Operating income = Contribution - Fixed Costs | ||||
$8b X 100/65 = $40b - $4,700,000 | ||||
$800b = 65 ($40b - $4,700,000) | ||||
$800b = $2600b - $305,500,000 | ||||
$1800b = $305,500,000 | ||||
b= $305,500,000 / $1800 | ||||
b = 169,722
|
Case: Cost Structures for Global Shippers Inc. Management from Global Shippers Inc, an international shipping business,...
Case: Cost Structures for Global Shippers Inc. Management from Global Shippers Inc, an international shipping business, is in the process of assessing the choice between two different cost structures for the business. Option A has relatively higher variable costs per unit shipped but lower annual fixed costs, while Option B has the opposite—relatively lower variable costs in its cost structure but higher fixed costs. Assume that delivery selling prices per unit are constant. The table below contains critical information in...
Case: Cost Structures for Global Shippers Inc. Management from Global Shippers Inc, an international shipping business, is in the process of assessing the choice between two different cost structures for the business. Option A has relatively higher variable costs per unit shipped but lower annual fixed costs, while Option B has the opposite relatively lower variable costs in its cost structure but higher fixed costs. Assume that delivery selling prices per unit are constant. The table below contains critical information...
Management from Global Shippers Inc, an international shipping business, is in the process of assessing the choice between two different cost structures for the business. Option A has relatively higher variable costs per unit shipped but lower annual fixed costs, while Option B has the opposite—relatively lower variable costs in its cost structure but higher fixed costs. Assume that delivery selling prices per unit are constant. The table below contains critical information in making the decision: Cost InformationOption AOption BDelivery price...
et can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Case: Cost Structures for Global Shippers Inc. Management from Global Shippers Inc, an interational shipping business, is in the process of assessing the choice between two different cost structures for the business. Option A has relatively higher variable costs per unit shipped but lower annual fixed costs, while Option B has the opposite relatively lower variable costs in its cost structure but...
In order to complete your case analysis successfully, you must identify the role you are playing, assess user needs analyze user needs or issues (qualitatively and quantitatively), and provide a recommendation and conclusion. An average grade will result from answering all questions with basic coverage and accuracy, showing all your work. Additional points come from including greater detail, astute, informed commentary where appropriate and connections to readings and other content. Case: Cost Structures for Global Shippers Inc. Management from Global...
In three units of study, there will be application-focused cases due at the beginning of the class that will be provided by the instructor. These cases will be complex in nature and will require the application of course concepts to real-word business situations. Each case will have an associated rubric to highlight expectations. All submissions must be of professional quality and done in Microsoft Word, Microsoft Excel, or submitted as a PDF. Objectives • To apply cost-volume profit analysis to...
Instructions and Submission Galaxy Incorporated • Due no later than the start of class in Unit 5 or as directed by your professor • Worth 5% of final grade Late Submission Policy • This assignment is subject to the Late Submission penalty policy, namely 5% per day for three days. • This page will close and will not allow further submissions after this Late Submission period has expired. • In the event of an emergency preventing you from submitting within...
d e Average race will result from an u ns with and how your work Actions controin astute informed commentary where appropriate and connections to read and other content Case Cost Structures for Global Shippers Inc. Ma r t from Shippers in an email usness is in the process of the two differenc Option Alas relatively higher warble costs per unit ed but lower an d we Opon has the r ivewer but h e dico. Assume that everywing prices...
Problem 4-31 Changes in Cost Structure; Break-Even Analysis; Indifference (L04, LOS, LO6] Patterson Products Inc. is considering an upgrade to its manufacturing equipment. The two upgrade options under consideration are shown below. Direct material cost per unit Direct labour cost per unit Variable overhead per unit Fixed manufacturing costs Option 1 61.2 48 13.2 $ 2,070,000 Option 2 $ 40.8 $ 41 $ 33.8 $ 4,008,000 The selling price of the company's product is $204 per unit with variable selling...
Problem 2: Changing Cost Structures Karen Hefner, a florist, operates retail stores in several shopping malls. The average selling price of an arrangement is $70 and the average cost of each 15 50. She also pays a manager $8 000 per month. A new mall is opening where Karen wants to locate a store but the location manager is not sure about the rent method to accept. The mall operator offers the following three options for its retail store rentals:...