Compute profit for the base-case-worst case and best-case

Assignment Help Operation Management

Reference no: EM131192670

The management of Madeira Manufacturing Company is considering the introduction of a wearable electronic device with the functionality of a laptop computer and phone. The fixed cost to launch the new product is $300,000. The variable cost for the product is expected to be between $160 and $240, with a most likely value of $200 per unit. The product will sell for $300 per unit. Demand estimates for the product vary widely, ranging from 0 to 20,000 units, with an average of 4000 units.

a. Compute profit for the base-case, worst case, and best-case scenarios

b. Assume the variable cost is a uniform random variable between $16 and $24 and the product demand is an exponential random variable with a mean of 4000 units. Construct a simulation model to estimate the mean profit and the probability that the project will result in a loss.

(I'm having trouble with entering information into excel)

Reference no: EM131192670

Questions Cloud

Challenges in long-term care : Challenges in Long-Term Care Your instructor will assign you a research article relating to the current challenges in the long-term care continuum and their impact on the current long-term care industry. Read the assigned research paper and research ..

How much should be ordered in each replenishment lot : Demand for the deskpro PC at Best Buy is D=1000 units/mo. Ordering cost=$4000/order, each PC costs $500 and holding costs are 20% of the cost/unit/yr. How much should be ordered in each replenishment lot (EOQ)? What is the # of orders/yr.? What is th..

Set of coherent actions for implementation of the strategy : Nvidia went from an IPO in 1999 to being named “company of the year” by Forbes magazine in 2007. Forbes noted Nvidia had gross margins of 46 percent in 2006 and its stock price rose even faster than Apple over this period. In 2013, the firm, cloud co..

Compute profit for the base-case-worst case and best-case : The management of Madeira Manufacturing Company is considering the introduction of a wearable electronic device with the functionality of a laptop computer and phone. The fixed cost to launch the new product is $300,000. Compute profit for the base-c..

Increase capacity by adding new machine : Fabricators, Inc. wants to increase capacity by adding a new machine. The fixed costs for machine A are $90,000, and its variable cost is $15 per unit. The revenue is $21 per unit. The break-even point for machine A is a. $90,000 dollars b. 90,000 un..

Gibson valves produces cast bronze valves on assembly line : Gibson Valves produces cast bronze valves on an assembly line, currently producing 1600 valves per shift. If the production is increased to 2000 valves per shift, labor productivity will increase by a. 10% b.20% c.25% d. 40% e.50%

Basic break-even analysis typically assumes : Basic break-even analysis typically assumes that a. revenues increase in direct proportion to the volume of production, while costs increase at a decreasing rate as production volume increases b.

Alternative locations for new plant for building embossed : The owner of a millwork shop is considering three alternative locations for a new plant for building embossed-and-clad steel exterior doors for residences. Fixed and variable costs follow. Since the plant ships nationwide, revenue is assumed the same..

User Account

All Pages