Explain spreadsheet model computing profit

Assignment Help Game Theory
Reference no: EM132864916

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.

a. Develop a what-if spreadsheet model computing profit for this product in the base-case, worst-case, and best-case scenarios. Please give me the steps in excel for how to input the data into the what-if simulation

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.

c. What is your recommendation regarding whether to launch the product?

Reference no: EM132864916

Questions Cloud

Describe the role of information technology in globalization : Describe the role of information technology in globalization Define the digital divide and explain Nielsen's three stages of the digital divide.
Management of madeira computing : a. Develop a what-if spreadsheet model computing profit for this product in the base-case, worst-case, and best-case scenarios.
Find what is the additional year-three cash flow : Find What is the additional Year-3 cash flow (i.e, the after-tax salvage and the return of working capital - also called terminal value)?
What journal entry does Algae Inc make to record collection : On January 31, 2021, Finley Co. pays all principal and interest owed to Algae Inc. What journal entry does Algae Inc. make to record the collection
Explain spreadsheet model computing profit : The management of Madeira Computing is considering the introduction of a wearable electronic device with the functionality of a laptop computer and phone.
Compare the monthly payments and the total interest : Amortize this mortgage over 25 years, and negotiate the rate down to 7.1%, compare the monthly payments and the total interest with each interest rate.
Existing business rather than start new business : Why would you choose to purchase an existing business rather than start a new business?
Responsibility of board directors and committee : A. Discuss the responsibility of Board directors and committee on corporate governance in Volkswagen company. (CLO1)
What will be the amount of quarterly payment : What will be the amount of your quarterly payment in that scenario? You would like a 17-year amortization period and plan on making quarterly payments.

Reviews

Write a Review

Game Theory Questions & Answers

  What is corporate social responsibility

What is corporate social responsibility? What are some arguments in favor of corporate social responsibility?

  Probability of no off-the-job accidents

What is the probability of no off-the-job accidents during a one-year period (to 4 decimals)?

  Does the game have another nash equilibrium

Exercise shows that an extensive-form perfect equilibrium is not necessarily a strategic-form perfect equilibrium.- Does the game have another Nash equilibrium? Does it have another subgame perfect equilibrium?

  House assignment with identical preferences

Find all the assignments in the core of the n-player game in which every player ranks the houses in the same way.

  Poisson distribution and probability

There is 0.02% probability that a credit card holder of a company reports the loss or theft of the credit card each month. The company has 15,000 credit cards in Memphis. Use the Poisson distribution to answer the following questions.

  What is the appropriate definition of a nash equilibrium

What is the appropriate definition of a Nash equilibrium for this location game? Find the Nash equilibrium locations of the two drinking establishments.

  Level of competitive intensity in an industry

According to Porter, what determines the level of competitive intensity in an industry?

  Perform a swot analysis on the airline industry

Global events have resulted in the airline industry experiencing significant challenges. Perform a SWOT analysis on the airline industry as a whole.

  Find the unique nash equilibrium in the given game

Find the unique Nash equilibrium in the following game (Prisoner's Dilemma). Find two pure-strategy Nash equilibrium in the following game (Battle of Sexes).

  What is the answer to the chiefs question

In equilibrium, what is the total number of fish caught? - What is the answer to the chief's question? What is the efficient number of fishers at each reef?

  A fight with imperfect information about strengths

A fight with imperfect information about strengths:-  Formulate this situation as a Bayesian game and find its Nash equilibria if α ½.

  Value of the sample proportion for health care

What is the value of the sample proportion p who so they are satisfied with the total cost they pay for their health care? Explain in words what the population parameter p is in this setting.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd