E4 Location Breakeven Analysis (also known as cost-volume analysis) is a technique used to make an economic comparison of location alternatives. The fixed and variable costs of three potential locations are listed below: LOCATION FIXDED COST PER ANNUM VARIABLE COST PER UNIT A 40 000 80 B 70 000 65 C 120 000 3 The expected selling price of the product is R 150.00. The company wishes to find the most economical location for an expected volume of 2500 units per year. Plot the costs for each location, with costs on the vertical axis and annual volume on the horizontal axis and identify the location that has the lowest total cost for the expected production volume.

E4 Location Breakeven Analysis (also known as cost-volume analysis) is a technique used to make an economic comparison of location alternatives. The fixed and variable costs of three potential locations are listed below: LOCATION FIXDED COST PER ANNUM VARIABLE COST PER UNIT A 40 000 80 B 70 000 65 C 120 000 3 The expected selling price of the product is R 150.00. The company wishes to find the most economical location for an expected volume of 2500 units per year. Plot the costs for each location, with costs on the vertical axis and annual volume on the horizontal axis and identify the location that has the lowest total cost for the expected production volume.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter15: Decision Analysis

Section: Chapter Questions

Problem 5P: Hudson Corporation is considering three options for managing its data warehouse: continuing with its...

See similar textbooks

Similar questions

Problem 4 (Target Costing, Strategy) Benchmark Industries manufactures large workbenches for industrial use. Wally Garcia, the vice president for marketing at Benchmark, has concluded from his market analysis that sales are dwindling for Benchmark's standard table because of aggressive pricing by competitors. Benchmark's table sells for P875 whereas the competition's comparable table is selling in the P80Q range. Garcia has determined that dropping price to P800 is necessary to regain the firm's annual market share of 10,000 tables. Cost data based on sales of 10,000 tables are: Budgeted Amount 400,000 sq. ft. 85,000 hrs. 30,000 hrs 320,000 hrs. Actual Amount Actual Cost 425,000 sq. ft. 100,000 hrs. 30,000 hrs. 320,000 hrs. Direct materials P2,700,000 1,000,000 300,000 4,000,000 Direct labor Machine setups Mechanical assembly
A company would like to determine various costs and points to aid them in deciding whether to expand or not. If you are given the following information, compute the required amounts and / or figures.Selling price / unit = P100 Variable cost / unit = P70Annual fixed cost = P500,000 Compute 5. Sales in units to earn a profit of 10% of sales.
An automated turning machine is the current constraint at Jordison Corporation. Three products use this constrained resource. Data concerning those products appear below: Selling price per unit Variable cost per unit Minutes on the constraint Multiple Choice O Rank the products in order of their current profitability from most profitable to least profitable. In other words, rank the products in the order in which they should be emphasized. (Round your intermediate calculations to 2 decimal places.) O JQ, RQ, LN RQ, LN, JQ RQ, JQ, LN LN $160.46 $ 106.40 3.40 LN, JQ, RQ JQ $ 346.18 $ 281.70 5.20 RQ $ 409.29 $ 311.25 8.60
Marigold Corp. is using the target cost approach on a new product. Information gathered so far is as follows: Expected annual sales Desired profit per unit Target cost What is the unit selling price? O $0.30 O $0.64 O $0.62 O $0.32 500000 units $0.32 $150000
A business encountered the following problem while choosing between alternative locations X and Y. The total fixed costs of X and Y places are 100,000 TL and 200,000 TL, respectively. The unit variable costs are 5 and 7 TL for X and Y location, respectively. The selling price at X site is 10 TL. What should be the selling price of the product in place Y if it is desired that the transition to profitability is in question at the same production amount in both places?
Each of the question below is to be treated independently. Basic CVP Analysis – Using Goal Seek Determine the breakeven point for the Drill/Driver product line. Pittsburgh Tools is considering modifications to the 18v Light production line. Analysis suggests that the modifications could result in $0.65 per unit variable cost reduction and $1,300 per quarter fixed cost increase. Assuming these changes have no impact on volume, determine the price that would be necessary to achieve $0 product line margin? Multiproduct CVP Analysis – Using Solver Assuming the current sales mix reaches the targeted sales mix, determine the breakeven point in sales revenue necessary for the division to achieve $0 divisional operating income (breakeven). Assume the current sales mix reaches the targeted sales mix, determine the sales revenue necessary for the division to achieve $100,000 divisional operating income. See the Excel instructions on the next page Making Copies of a Worksheet Tab Your…
Hudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing, or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? What is the expected annual cost associated with that recommendation? Construct a risk profile for the optimal decision in part (a). What is the probability of the cost exceeding $700,000?
The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: ProcurementCost ($) Probability LaborCost ($) Probability TransportationCost ($) Probability 10 0.2 18 0.25 2 0.74 12 0.35 20 0.35 5 0.26 13 0.45 22 0.1 25 0.3 Compute profit per unit for the base-case, worst-case, and best-case scenarios.Profit per unit for the base-case: $ fill in the blank 1Profit per unit for the worst-case: $ fill in the blank 2Profit per unit for the best-case: $ fill in the blank 3 Construct a simulation model to estimate the mean profit per unit. If required, round your answer to the nearest cent.Mean profit per unit = $ fill in the blank 4 Why is the simulation approach to risk analysis preferable to generating a variety of…
Problem 4 (Target Costing, Strategy) Benchmark Industries manufactures large workbenches for industrial use. Wally Garcia, the vice president for marketing at Benchmark, has concluded from his market analysis that sales are dwindling for Benchmark's standard table because of aggressive pricing by competitors. Benchmark's table sells for P875 whereas the competition's comparable table is selling in the P800 range. Garcia has determined that dropping price to P800 is necessary to regain the firm's annual market share of 10,000 tables. Cost data based on sales of 10,000 tables are: Budgeted Amount 400,000 sq. ft. 85,000 hrs. 30,000 hrs 320,000 hrs. Actual Amount Actual Cost 425,000 sq. ft. 100,000 hrs. 30,000 hrs. 320,000 hrs. Direct materials P2,700,000 1,000,000 300,000 4,000,000 Direct labor Machine setups Mechanical assembly
The Shine Company, which manufactures projection equipment, is ready to introduce a new line of portable projectors. The following data are available for a proposed model: Variable manufacturing costs Applied fixed manufacturing overhead Variable selling and administrative costs Applied fixed selling and administrative costs What price will the company charge if the firm uses cost-plus pricing based on total variable cost and a markup percentage of 235%? Multiple Choice $1,565.25. $1,700.25. $1,835.25. $2,060.25. None of these answer choices is correct. $ 440 220 175 190
APPLY THE CONCEPTS: Margin of Safety Margin of safety can allow you to see how much padding there is for your company between profit and loss. If this number is great, it may indicate that your company is performing very well. If this number is small, it may be worth looking into possible remediation. Consider the following pricing and cost information: Price and Cost Information Amount Selling Price per Unit $450 Variable Cost per Unit $400 Total Fixed Cost $70,000 For the upcoming period, the company projects that it will sell 2,000 units. Considering that the company has a unit break-even point of 1,400 units, what is the margin of safety in terms of both units and sales revenue? Round your answers to two decimal places, if necessary. Margin of Safety in Units Margin of Safety in Sales Revenue = $
Problem Solving.Determine for what is asked. Show your solution legibly. Improper solution will not be credited. Consider the following cost and pricing data of ABC Corp. on its Product X:Price: P120.00.per unitProfit Contribution: P90.00 Proposed additional Cost: P3 per unit (for quality improvement)Current Profits: P2.4 millionSales: 100,000 units. A. Assuming that average variable costs are constant at all output levels, find ABC Corp.’s total cost function before the proposed change.B. Calculate the total cost function if the quality improvement is implemented.C. Calculate ABC Corp.’s break-even output before and after the change, assuming it cannot increase its price.D. Calculate the increase in sales that would be necessary with the quality improvement to increase profits to P2.7 million