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...
-
1. In your opinion, is there too much money in politics? If there is too much money, why is that a bad thing? Are there any ways to limit the role of money in politics?
-
Rewrite the attribute grammar of Figure 4.14 in the form of an ad hoc tree traversal consisting of mutually recursive subroutines in your favorite programming language. Keep the symbol table in a...
-
You are evaluating a new cookie-baking oven. The Cookie Munster costs \($90,000,\) has a seven-year life, and has an annual Operating Cash Flow (OCF), after tax, of -\($8,000\) per year. If your...
-
Jennifer Ross, an employee of Hampton Company, worked 44 hours during the week of February 9 through 15. Her rate of pay is $ 30 per hour, and she receives time- and- a- half for work in excess of 40...
-
01:27:10 A company uses the perpetual inventory system and the gross method of accounting for sales and had the following sales transactions during June: June 2 Sold merchandise to a customer on...
-
A counter-current gas-absorption column is to be designed to remove CO 2 from an inert gas stream by reaction with an amine solution at 20C. At this temperature, CO 2 reacts with the amine according...
-
Before her last soccer game, Krysta predicted her team would take 18 shots on goal. Her prediction was 12.5% more than the team's actual number of shots. How many shots on goal did the soccer team...
-
Diamond Auto Supply distributes new and used automobile parts to local dealers throughout the Southeast. Diamonds credit terms are n/30. As of the end of business on July 31, the following accounts...
-
Cardinal Company sells carpeting. Over 75% of all carpet sales are on credit. The following procedures are used by Cardinal to process this large number of credit sales and the subsequent...
-
Logan Corporation manufactures two products with the following characteristics. If Logan's machine hours are limited to 2,000 per month, determine which product it should produce. Product 1 Product 2...
-
Blake and Roscoe are college friends planning a skiing trip to Aspen before the New Year. They estimated the following costs for the trip: Requirements 1. Blake suggests that the costs be shared...
-
On March 19, 2003, the SEC filed accounting fraud charges in the Northern District of Alabama against HealthSouth Corporation and its CEO, Richard Scrushy. Scrushy was also charged with knowingly...
-
A Timothy le gustara iniciar su propio negocio. Su esposa esuna madre ama de casa con dos nios pequeos. Cul de lassiguientes sera una desventaja del trabajo por cuenta propia?Falta de s 1 answer
-
Consider the combustion of methanol below. If 64 grams of methanol reacts with 160 grams of oxygen, what is the CHANGE in volume at STP. 2CH3OH(g) + 3O2(g) 2CO2(g) + 4H2O(1) The volume decreases by...
-
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...
-
What weakness is inherent in the accounting rate of return when it is used as an investment criterion?
-
Identify several nonquantitative factors that are apt to play a decisive role in the final selection of projects for capital expenditures.
-
In what way does depreciation affect the analysis of cash flows for a proposed capital expenditure?
Study smarter with the SolutionInn App