Halsey Corporation manufactures products that have variable costs of $60 per unit. Its fixed cost amounts...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Halsey Corporation manufactures products that have variable costs of $60 per unit. Its fixed cost amounts to $360,000. It sells the products for $90 each. Conduct a sensitivity analysis on an excel file, on the first sheet manually, (fixed cost and variable cost being on the vertical axis and sales volume being on the horizontal axis) considering: . 4 levels of fixed cost: 300,000-360,000-430,000-500,000. 5 levels of variable cost: 50-55-60-65-70 5 levels of sales volume: 8,000-10,000-12,000-14,000-16,000. ● ● Then conduct the same sensitivity analysis, on the second sheet using what if analysis, (sales volume being on the horizontal axis and variable cost being on the vertical axis) considering: Halsey Corporation manufactures products that have variable costs of $60 per unit. Its fixed cost amounts to $360,000. It sells the products for $90 each. Conduct a sensitivity analysis on an excel file, on the first sheet manually, (fixed cost and variable cost being on the vertical axis and sales volume being on the horizontal axis) considering: . 4 levels of fixed cost: 300,000-360,000-430,000-500,000. 5 levels of variable cost: 50-55-60-65-70 5 levels of sales volume: 8,000-10,000-12,000-14,000-16,000. ● ● Then conduct the same sensitivity analysis, on the second sheet using what if analysis, (sales volume being on the horizontal axis and variable cost being on the vertical axis) considering:
Expert Answer:
Answer rating: 100% (QA)
Manual Sensitivity Analysis 1 Open a new Excel spreadsheet and create a table with the following str... View the full answer
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-1259569197
8th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Olds
Posted Date:
Students also viewed these accounting questions
-
Halsey Corporation manufactures products that have variable costs of $60 per unit. Its fixed cost amounts to $360,000. It sells the products for $90 each. Required Use the per-unit contribution...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
Kemeth Corporation manufactures products that have variable costs of $43 per unit. Its fixed cost amounts to $84,000. It sells the products for $78 each. Required Use the per-unit contribution margin...
-
Name: PN 200 Fundamentals of Nursing II Medication Error Prevention-OTC's Date: Jeff Voss, a 29-year-old graduate student is at the student health center for a physical examination required before...
-
Balance sheet data for the Lawrence Corporation follows. Required Compute the following: a. Working capital b. Current ratio c. Debt to assets ratio d. Debt to equity ratio $ 20,000 140,000 Current...
-
A patient receives a gamma scan/ of his liver. He ingests 3.7 MBq of \({ }^{198} \mathrm{Au}\), which decays with a 2.7 day half-life by emitting a \(1.4 \mathrm{MeV}\) beta particle. Medical tests...
-
One can follow the developments in the chemical industry in trade magazines such as the Chemical \& Engineering News. Answer the following questions after reading the article, "Global Top 50 " for...
-
For 2015, Apple Corporation (a calendar year integrated oil company) had the following transactions: Taxable income $3,600,000 Regular tax depreciation on realty in excess of ADS (placed in service...
-
What is the purpose of the Fed's Discount Window that offers the Discount Rate?
-
John and Nina Hartwick, married 17 years, have a 13-year-old daughter. Eight years ago, they purchased a home on which they owe about $240,000. They also owe $6,000 on a two-year-old automobile. All...
-
In the following system below, show a design on how to reduce this multi-subsystem into a single subsystem. R(s) H G1 G2 G3 C(s) (PO4)
-
Decide whether the given point is a feasible solution for the constraints \[\left\{\begin{array}{l}x \geq 0 \\y \geq 0 \\3 x+2 y \leq 10 \\2 x+4 y \leq 8\end{array}ight.\] a. \((1,3)\) b. \((2,1)\)...
-
Solve the systems in Problems 15-26 by the substitution method. \(\left\{\begin{array}{l}3 t_{1}+5 t_{2}=1,541 \\ t_{2}=2 t_{1}+160\end{array}ight.\)
-
The supply for a certain commodity is linear and determined to be \[p=0.005 n+12\] whereas the demand is linear with \[p=150-0.01 n\] where \(p\) is the price and \(n\) is the number of items. What...
-
An analogy to Zeno's tortoise paradox can be made as follows. A woman standing in a room cannot walk to a wall. To do so, she would first have to go half the distance, then half the remaining...
-
What are the three main topics of calculus?
-
Answer questions 1-3 below and show your work. Introduction Nikita Vasiliev, a 25 year-old application developer, has little knowledge of personal finance. She pays her bills on time, and has save...
-
How has the globalization of firms affected the diversity of their employees? Why has increased diversity put an additional burden on accounting systems?
-
Cobb Company currently produces and sells 9,000 units annually of a product that has a variable cost of $20 per unit and annual fixed costs of $195,000. The company currently earns an $228,000 annual...
-
Spalding Pointers Corporation expects to begin operations on January 1, 2019; it will operate as a specialty sales company that sells laser pointers over the Internet. Spalding expects sales in...
-
Power-To-Spare, Inc. makes a smartphone case that includes a battery that extends the operating life of an iPhone. The manufacturing costs per unit include $15 direct materials, $17 direct labor and...
-
Let \(X_{t}, t \geq 0\), be defined as \[X_{t}=\left\{B_{t} \mid B_{t} \geq 0 ight\}, \quad \forall t>0\] that is, the process has the paths of the Brownian motion conditioned by the current value...
-
Let \(B_{t}\) be a standard Brownian motion started at 0 . Use that for any function \(f\) we have: \[\mathbf{E}\left[f\left(B_{t} ight) ight]=\frac{1}{\sqrt{2 \pi t}} \int_{-\infty}^{\infty} f(x)...
-
If \(X_{t} \sim N(0, t)\), calculate the distribution of \(\left|X_{t} ight|\). Calculate \(\mathbf{E}\left|X_{t} ight|\) and \(V\left(\left|X_{t} ight| ight)\).
Study smarter with the SolutionInn App