A newly formed firm must decide on a plant location. There are two alternatives under consideration: locate near the major raw materials or locate near the major customers. Locating near the raw materials will result in lower fixed and variable costs compared to locating near the market, but the owners believe there would be a loss in sales volume because customers tend to favor local suppliers, Revenue per unit will be $184 in either case. Annual fixed costs (3 millions) Variable cost per unit Expected annual demand (units) S 1.1 10,100 Kansas City F 1.0 $ 10,700 49 Cuck here for the Excel Data Eile Using the above information, determine which location would produce the greater profit.

A newly formed firm must decide on a plant location. There are two alternatives under consideration: locate near the major raw materials or locate near the major customers. Locating near the raw materials will result in lower fixed and variable costs compared to locating near the market, but the owners believe there would be a loss in sales volume because customers tend to favor local suppliers, Revenue per unit will be $184 in either case. Annual fixed costs (3 millions) Variable cost per unit Expected annual demand (units) S 1.1 10,100 Kansas City F 1.0 $ 10,700 49 Cuck here for the Excel Data Eile Using the above information, determine which location would produce the greater profit.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A newly formed firm must decide on a plant location. There are 2 alternatives under consideration: locate near the major raw materials of locate near the the major customers. Locating near the raw materials will result in lower fixed costs and variable costs than locating near the market, but the owners believe ther would be a loss in sales volume because customers tend to favor local suppliers. Revenue per unit will be $185 in either case. Using the following information, determine which location would produce greater profit.. Annual Fixed costs Omaha $1.2 million, Kansas City $1.4 million Variable cost per unit Omaha $26, Kansas City $47 Expected annual demand Omaha 8000 units, Kansas City 12000 units.
A newly formed firm must decide on a plant location. There are two alternatives under consideration: locate near the major raw materials or locate near the major customers. Locating near theraw materials will result in lower fixed and variable costs than locating near the market, but theowners believe there would be a loss in sales volume because customers tend to favor local suppliers. Revenue per unit will be $185 in either case. Using the following information, determinewhich location would produce the greater profit.Omaha Kansas CityAnnual fixed costs ($ millions) $1.2 $1.4Variable cost per unit $36 $47Expected annual demand (units) 8,000 12,000
Peter Billington Stereo, Inc., supplies car radios to auto manufacturers a nd is going to open a new plant. The company is undecided between Detroit and Dallas as the site. The fixed costs in Dallas are lower due to cheaper land costs, but the variable costs in Dallas are higher because shipping distances would increase. Given the following costs: a) Perform an analysis of the volume over which each location is preferable.b) How does your answer change if Dallas's fixed costs increase by 10%?
Problem 8-1 A newly formed firm must decide on a plant location. There are two alternatives under consideration: locate near the major raw materials or locate near the major customers. Locating near the raw materials will result in lower fixed and variable costs than locating near the market, but the owners believe there would be a loss in sales volume because customers tend to favor local suppliers. Revenue per unit will be $181 in either case. Omaha Kansas City Annual fixed costs ($ millions) $ 1.0 $ 1.1 Variable cost per unit $ 32 $ 47 Expected annual demand (units) 9,225 10,775 Using the above information, determine which location would produce the greater profit. (Omit the "$" sign in your response.) (Click to select) Kansas City Omaha would produce the greater gross profit of $ .
Peter Billington Stereo, Inc., supplies car radios to auto manufacturers and is going to open a new plant. The com-pany is undecided between Detroit and Dallas as the site. The COST DALLAS DETROITFixed costs $600,000 $800,000Variable costs $28/radio $22/radioa) Perform an analysis of the volume over which each location ispreferable.b) How does your answer change if Dallas’s fixed costs increaseby 10%?
1. A newly formed firm must decide on a plant location. There are two under consideration: locate near the major raw materials or locate near the major customers. Locating near the raw materials will result in lower fixed and variable costs compared to locating near the market, but the owners believe there would be a loss in sales volume because customers tend to favor local suppliers. Revenue per unit will be $170 in either case. Using the following information, determine which location would produce the greater profit. Omaha Kansas City Annual fixed costs ($ millions) $ 0.9 $1.0 Variable Cost Per Unit $ 20 $ 35 Expected annual demand (units) 9,400 10,000 Using the above information, determine which location would produce the greater profit. ________would produce the greater gross profit of _____________
Select two organizations, one in services and one in manufacturing. What are the key factors that each organization would consider in locating a new facility? What data would you want to collect before evaluating the location options, and how would you collect the data? Explain.
Dobb's Ltd Wants to choose the best location for its new aluminum plant. The manager ofproductions and operations has three possible locations to choose from. His assistantrecommends that he use break-even analysis location technique to help determine whichlocation is best based on costs. Assuming: Total fixed cost = 80,000 Price per unit= 20 AVC (Average variable cost) = 40 Break-even point= Total fixed cost / (AVC-Price per unit) Break-even point = 80,000/ (40-20) Break-even point = 4,000 1) Demonstrate to the OM manager using graph how to go about choosing the best location using thenumerical example designed above.
A manager must decide between two location alternatives, Boston and Chicago. Boston would have annual fixed costs of $70000, transportation costs of $60 per unit, and labor and material costs of $200 per unit. Chicago would have annual fixed costs of $90000, transportation costs of $40 per unit, and labor and material costs of $170 per unit. Revenue will be $300 per unit. 1. Which alternative would yeild the higher profit for an annual demand of 3000 units? 2. Would the two locations yeild the same profit at a certain volume? If so, at what volume would that be?
The fixed and variable costs for four potential plant sites for Brent Snyder's Ski Supplies are shown here: a) Graph the total-cost lines for the four potential sites.b) Over what range of annual volume is each location the preferable one (that with lowest expected cost)?c) If expected volume of the ski equipment is 5,000 units, which location would you recommend?
A manufacturing company is considering two alternative locations for a new facility. The fixed and variable costs for the two locations are found in the table below. For which volume of business would the two locations be equally attractive (Hint: the crossover point)? Please show your work. New Jersey Delaware Variable Costs ($ per unit) _____ (Please pick a number from 11-20 and fill in the blank above. Use the number for your calculation.) _____ (Please pick a number from 21-30 and fill in the blank above. Use the number for your calculation.) Fixed Costs $___________ (Please pick a number from 1,000,000-1,200,000 and fill in the blank above. Use the number for your calculation.) $___________ (Please pick a number from 800,000-1,000,000 and fill in the blank above. Use the number for your calculation.)
ABC Ltd. Wants to choose the best location for its new aluminum plant. The manager ofproductions and operations has three possible locations to choose from. His assistantrecommends that he use break-even analysis location technique to help determine whichlocation is best based on costs. Assuming: Total fixed cost = 80,000 Price per unit= 20 AVC (Average variable cost) = 40 Break-even point= Total fixed cost / (AVC-Price per unit) Break-even point = 80,000/ (40-20) Break-even point = 4,000 1) Demonstrate to the OM manager how to go about choosing the best location using thenumerical example designed above.