Question: C. highly fair or extremely low? greater or less? may or may not (Ail answers were generated using 1,000 trials and native Excel functionasity.) The
(Ail answers were generated using 1,000 trials and native Excel functionasity.) The manogement of Maderb Computing is considering the introduction of a wearable electronic device with the functionality of a laptop coenputer and phone: The fixed cost to launch this new product is $300,000. The variable cost for the product is expected to be between $128 and $192, with a most likefy value of $160 per unit. The product wilf sell for $240 per unit. Demand for the product is expected to range from 0 to approximately 20,000 units, with 4,000 units the most whely. (a) Develop a what d spreadtheet model computing profic for this product in the base-case, worst-case. and best-case sctenarios. If your andwer is negative, use minus sinn. (b) Model the variable cost as a uniform randorn variable with a minimum of 5128 and a maxmum of $192. Model the product demand as 1,000 umes the value of a gamm random variable wich an alphs parameter of 3 and a beta parameter of 2 . Construct a smulation model to estimyte the average profir and the probability that the project will result in a loss. Hound your answers to the nearest whole number: Average Profit 1 Frobubity or atoss (c) The averoge prodit is and the probubilicy of a loss is than 20\%. Thus, Madeira Computing wart to Lunch the product if they have low risk tolerance (Wi.answers were pegerated using 1,000 trials and nabie Excel Aonctionaity.) most inely. wirrenhe in a lesk. ArerageProht Nobihaly of a Lab
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
