The management of Madeira Computing is considering the introduction of a wearable electronic device with the functionality of a laptop computer and phone. The fixed cost to launch this 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 for the product is expected to range from 0 to approximately 20,000 units, with 4,000 units the most likely. Required:

a. Develop a what-if spreadsheet model computing profit for this product in the base case, worst-case, and best-case scenarios.

b. Model the variable cost as a uniform random variable with a minimum of $160 and a maximum of $240. Model product demand as 1,000 times the value of a gamma random variable with an alpha parameter of 3 and a beta parameter of 2. Construct a simulation model to estimate the average profit and the probability that the project will result in a loss.

in 2001, dell computer became the world’s largest personal computer vendor, continuing to

gain market share and post profits in an industry struggling with slumping sales and billions of

dollars in losses. dell sells 90% of its pcs directly to the final customer, largely bypassing the

reseller channel that accounts for most of the world’s pc sales. this direct customer relationship

is the key to dell’s business model, and provides distinct advantages over the indirect sales

model. dell’s direct relationship with the customer allows it to tailor its offerings to customer

needs, offer add-on products and services, and use the internet to offer a variety of customer

services. in addition, dell’s pcs are built to customers’ specifications upon receipt of an order,

giving dell additional advantages over indirect pc vendors who must try to forecast demand and

ship products based on those forecasts. dell’s direct sales and build-to-order model has achieved

superior performance in the pc industry in terms of inventory turnover, reduced overhead, cash

conversion, and return on investment (kraemer, et al., 2000).

explanation:

almost done 23 out of 25

answerpounds of plastic to purchase 200+60-20=(240);