Use excel to make the calculations (show formulas used in excel) and be sure to identify your answer, including units. FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2 incremental cost. The company plans to sell the products to retailers for $7. What is the break-even point for each location? At what volume is the point of indifference? At what forecasted volumes should FloorsRUs select Huntsville as their new manufacturing location and what volumes should the company select Hays and why?

Use excel to make the calculations (show formulas used in excel) and be sure to identify your answer, including units. FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2 incremental cost. The company plans to sell the products to retailers for $7. What is the break-even point for each location? At what volume is the point of indifference? At what forecasted volumes should FloorsRUs select Huntsville as their new manufacturing location and what volumes should the company select Hays and why?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2 incremental cost. The company plans to sell the products to retailers for $7. At what volume is the point of indifference? At what forecasted volumes should FloorsRUs select Huntsville as their new manufacturing location and what volumes should the company select Hays and why?
A firm that plans to expand its product line must decide whether to build a small or a large facilityto produce the new products. If it builds a small facility and demand is low, the net present valueafter deducting for building costs will be $400,000. If demand is high, the firm can either maintainthe small facility or expand it. Expansion would have a net present value of $450,000, and maintaining the small facility would have a net present value of $50,000.If a large facility is built and demand is high, the estimated net present value is $800,000. If demandturns out to be low, the net present value will be – $10,000.The probability that demand will be high is estimated to be .60, and the probability of low demandis estimated to be .40.a. Analyze using a tree diagram.
A firm that plans to expand its product line must decide whether to build a small or a large facilityto produce the new products. If it builds a small facility and demand is low, the net present valueafter deducting for building costs will be $400,000. If demand is high, the firm can either maintainthe small facility or expand it. Expansion would have a net present value of $450,000, and maintaining the small facility would have a net present value of $50,000.If a large facility is built and demand is high, the estimated net present value is $800,000. If demandturns out to be low, the net present value will be – $10,000.The probability that demand will be high is estimated to be .60, and the probability of low demandis estimated to be .40. 1- Compute the EVPI 2- Determine the range over which each alternative would be best in terms of the value of P ( low demand )
We need to find better places to sell our product. I have three ideas we could pursue, but each one requires a six month commitment. We also have our$1,200budget constraint, which must cover any required location permits. Review the location choices to your right. Remember the cost for any permits will be deducted from the$1,200marketing budget. Great ideas Ariel, but I'm not sure which one would be best. What do you think, ? Silas Lee Which question would you like to ask before making your decision?City Center Park Cost: \$600 for a six-month permit Considerations - Downtown city center park within walking distance of many large corporate office buildings. - This is a very popular park. When the weather is good many business people tend to congregate and eat lunch here. - Several other food trucks do frequent this area.Which community events this past summer generated the most sales? Any ideas why? How would you and Ariel describe the demographics of our past customers?
How to put this on a graph y-axis: Total cost/revenue in dollars x-axis: Quantity of units sold per month The total fixed cost line is a horizontal line at $9,200. The total variable cost line is upward sloping, starting at the origin and with a slope of $0.70 per unit
ABC company wants to open one, two, or three shops. The average Profit varies with the demand in three categories low, medium and high. Determine which one is better using Maximax, Maximin, Laplace, Minimax regret. Demand Number of Shops 1 2 3 Low 150 175 200 Medium 100 200 200 High 0 170 400 I don't want the solution with excel
A logistics provider plans to have a new warehouse built to handle increasing demands for its services. Although the company is unsure of how much demand there will be, it must decide now on the size (large or small) of the warehouse. Preliminary estimates are that if a small warehouse is built and demand is low, the monthly income will be $700,000. If demand is high, it will have to either expand the facility or lease additional space. Leasing will result in a monthly income of $100,000 while expanding will result in a monthly income of $500,000. If a large warehouse is built and demand is low, monthly income will only be $40,000, while if demand is high, monthly income will be $2 million.a. Construct a tree diagram for this decision.b. Using your tree diagram, identify the choice that would be made using each of the four approaches for decision making under uncertainty
A company has the following alternatives for investment. Using the incremental B/C method, determine which alternative should be selected. Assumei = 10%. А В C Cost new $20,000 $24,000 $16,000 Annual O&M Cost $1,000/yr $800/yr $2,200/yr Annual income $5,600/yr $5,700/yr $5,400/yr Estimated life (yr) 7 9. Note: Incremental B/C method should be used in the solution. Solutions by using other methods will not be graded.
Oscar's Bowling, Ic., wants to break into the Phoenix metropolitan market with one of its super-sized 200 lane, 24-hour bowling alleys. It, however, only has enough capital to build one facility. Oscar wants it to be centered by population, as determined by the center of gravity method. The following information is given: City Population x coordinate y coordinate Tempe 285,000 Scottsdale 350,000 10 Chandler 725,000 5 Mesa 300.000 10 1 Glendale 345,000 1 10 a. Where should Oscar build? Oscar should build at an x coordinate of and a y coordinate of . (Enter your responses rounded to one decimal place.)
Method of Least Squares, Goodness of Fit Deepa Dalal opened a free-standing radiology clinic. She had anticipated that the costs for the radiological tests would be primarily fixed, but she found that costs increased with the number of tests performed. Costs for this service over the past nine months are as follows: Month Radiology Tests Total Cost January 2,800 $133,500 February 2,600 135,060 March 3,100 175,000 April 3,500 170,600 May 3,400 176,900 June 3,700 186,600 July 3,840 174,450 August 4,100 195,510 September 3,450 185,300 Required: 1. Compute the cost formula for radiology services using the method of least squares. If required, round your answers to two decimal places. Y = + X 2. Using the formula computed in Requirement 1, what is the predicted cost of radiology services for October for 3,500 appointments? (Round the answer to the nearest dollar.)
An entrepreneurial resident of the Oklahoma City metropolitan area is interested in securing a new franchise for Mad Over Donuts. Ideally this franchise would be centrally located so delivery could be economically handled and all citizens could enjoy fresh, delicious donuts delivered to the doorstep. The main cities and anticipated demand (in thousands per day) are shown in Table 2. What is the appropriate (non-linear) objective function for this scenario (hint: distances are euclidean)? Zoey’s Catnip Toys faces the following relationship between price (p) and demand (v): v = 2000 − 200p. The fixed cost is $500 and variable cost is $1. Write an expression for the total profit. What price should Zoey charge to maximize profit in question b.?
complete the following table to determine what are the total costs to account for if a company's beginning inventory had $231,432 in materials, $186,450 in conversion costs, and added direct material costs ($4,231,392), direct labor ($2,313,392), and manufacturing overhead ($1,156,696)? PLEASE NOTE: All dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). If no dollar amount is needed for that space, please enter "$0" with no quotation marks. Material Costs Conversion Costs Total Costs Beginning work in process 4 Added: Direct materials Direct labor Manufacturing overhead Total Costs