Part 2 - Break-even and What-if Analysis DATA SECTION (ONE FOR EACH SCENARIO, SIX SCENARIOS) Make...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 2 - Break-even and What-if Analysis DATA SECTION (ONE FOR EACH SCENARIO, SIX SCENARIOS) Make data labels common for all data, looking somewhat as follows: SCENARIO #1 Selling price per unit Variable cost per unit-- manufacturing --S&A Total fixed cost -- manufacturing --S&A Sales volume in units Tax rate Copy the numbers in Scenariol to each of the other 5 scenarios. TABLE SECTION SCENARIO #2 $32.00 15.00 6.00 $24,000 21,000 6,000 40% Prepare a contribution margin format income statement for each scenario making cell references to its own column. SCENARIO #1 $ . Sales Revenue (Less) Variable Costs: ( ) manufacturing S&A Contribution margin (Less) Fixed Costs: manufacturing () C G A ( 24,000) S&A ( 21,000) Income Before Tax $ Less Income Tax Income After Tax $ SCENARIO #2 ANALYSIS SECTION Scenario #2: A proposed new machine will reduce variable product cost to $13, increase fixed product cost to $30,000, and keep S&A costs the same. What will be the profit? Hint: If your formulas are correct, then all you need is to change the Data section of Scenario 2. Use Goal Seek function (search help on goal seek and read the instructions) to find the following: Scenario #3: Break even sales volume in units and dollars with the old machine as in Scenario #1. Hint: The "goal" is zero net income. You can achieve the goal by changing the Sales volume. Scenario #4: Sales volume in units and dollars needed for a Net Income After Tax of $10,000, all else as in #1. Part 2 - Break-even and What-if Analysis DATA SECTION (ONE FOR EACH SCENARIO, SIX SCENARIOS) Make data labels common for all data, looking somewhat as follows: SCENARIO #1 Selling price per unit Variable cost per unit-- manufacturing --S&A Total fixed cost -- manufacturing --S&A Sales volume in units Tax rate Copy the numbers in Scenariol to each of the other 5 scenarios. TABLE SECTION SCENARIO #2 $32.00 15.00 6.00 $24,000 21,000 6,000 40% Prepare a contribution margin format income statement for each scenario making cell references to its own column. SCENARIO #1 $ . Sales Revenue (Less) Variable Costs: ( ) manufacturing S&A Contribution margin (Less) Fixed Costs: manufacturing () C G A ( 24,000) S&A ( 21,000) Income Before Tax $ Less Income Tax Income After Tax $ SCENARIO #2 ANALYSIS SECTION Scenario #2: A proposed new machine will reduce variable product cost to $13, increase fixed product cost to $30,000, and keep S&A costs the same. What will be the profit? Hint: If your formulas are correct, then all you need is to change the Data section of Scenario 2. Use Goal Seek function (search help on goal seek and read the instructions) to find the following: Scenario #3: Break even sales volume in units and dollars with the old machine as in Scenario #1. Hint: The "goal" is zero net income. You can achieve the goal by changing the Sales volume. Scenario #4: Sales volume in units and dollars needed for a Net Income After Tax of $10,000, all else as in #1.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Model Degrees of Freedom (labeled A) (0.5 point) 1 2 3 4 5 Sum of Square Error (labeled B) (0.5 point) 55.88 494.74 950.15 89314.02 92569.10 Mean Square Model (labeled C) (0.5 point) 325.51 406.89...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
An alternating current i= 414 Sin (2 x 50 x t) A is passed through a series circuit of a resistance of 1002 and an inductance of 0.31831 H. find the expression for the instantaneous values of voltage...
-
Given an array, Arr[] of integer numbers have size N. The task is to find out single or consecutive numbers from Arr[] with 0 sum. When found, print "1" otherwise "0". Example-1: Input: 4 (6,-2,3,-1)...
-
The following are the numbers of employees absent from two government agencies on 25 days: 24 and 29, 32 and 45, 36 and 36, 33 and 39, 41 and 48, 45 and 36, 33 and 41, 38 and 39, 46 and 40, 32 and...
-
Listed below are consecutive first-digits drawn in the California Daily 4 lottery. Test for randomness of even and odd integers. Does the lottery appear to be working as it should? Use a 0.05...
-
What is a covenant? Provide a theoretical example of the usefulness of covenants.
-
Since LSUS corporation is producing at full capacity, Amanda has decided to have Han examine the feasibility of a new manufacturing plant. This expansion would represent a major capital outlay for...
-
rectangle has width x+1, length x+1 and diagonal 6. Solve for x and check for extraneous roots.
-
a. Consider the following FI balance sheet (in millions): Assets Liabilities Liquid assets $20 Deposits $1,800 Loans 2,550 Property 330 Interbank borrowings Equity ? 150 Questions a. If stable core...
-
After the 2008 recession, debates about the problems of capitalism came to many forums. This is one at the 2012 Davos World Economic Forum. Optional PBS Video: CHASING THE DREAM: Rev. Barber on...
-
Discuss the statement made in the Parents Involved case, by Chief Justice Roberts when he declared " the way to stop", and how this seemingly simple observation continues to be unfulfilled in 2023....
-
Ludo, Amlie and Noah are three chef friends who operate a home cooking business together in the form of a SENC. The partnership contract contains a clause which excludes Noah from sharing debts. The...
-
Sandhill Corporation began the month of May with $68000 of obligations and $197000 of economic resources. Stockholders' equity increased by $26000 during May because the company paid $120000 of...
-
2. The diagram below shows a fenced area. The enclosure has a rectangular portion connected to a semi-circular portion as shown. The cost to build and install the fence is $26/ft for the curved...
-
Krombach Auto Corporation, a German manufacturer of cars, investigates their steering wheel attachment process. A steering wheel needs some "Spiel", a small range where moving the steering wheel does...
-
Classify each of the following as direct costs or indirect costs of operating the Pediatrics ward for children at the Cleveland Clinic: a. Wi-Fi covering the entire hospital campus b. Net cost of...
-
The chapter says that a measurement system can affect a business in several ways. As an example, consider a worldwide company with headquarters in New York City and divisions in many different...
-
Under the No Child Left Behind Act, passed in 2001, every public elementary school that receives some federal funding is required to give its students certain tests of reading and math every year....
-
Consider a college transcript as the output of a measurement system. A. Identify the: a. Object being measured b. Attribute of the object being measured c. Rules for measurement d. Standard-setters...
Study smarter with the SolutionInn App