Risk risktarget function to find the probability

Assignment Help Accounting Basics
Reference no: EM131106701

In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined.

a. For each of these, use @RISK's RISKTARGET function to find the probability that Miller's profit is positive. Do you believe these results should have any bearing on Miller's choice of bid?

b. Use @RISK's RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?

Example 11.1

The Miller Construction Company must decide whether to make a bid on a construction project. Miller believes it will cost the company $10,000 to complete the project (if it wins the contract), and it will cost $350 to prepare a bid. However, there is uncertainty about each of these. Upon further reflection, Miller assesses that the cost to complete the project has a triangular distribution with minimum, most likely, and maximum values $9000, $10,000, and $15,000. Similarly, Miller assesses that the cost to prepare a bid has a triangular distribution with parameters $300, $350, and $500. (Note the skewness in these distributions. Miller recognizes that cost overruns are much more likely than cost underruns.) Four potential competitors are going to bid against Miller. The lowest bid wins the contract, and the winner is then given the winning bid amount to complete the project. Based on past history, Miller believes that each potential competitor will bid, independently of the others, with probability 0.5. Miller also believes that each competitor's bid will be a multiple of its (Miller's) most likely cost to complete the project, where this multiple has a triangular distribution with minimum, most likely, and maximum values 0.9, 1.3, and 1.8, respectively. If Miller decides to prepare a bid, its bid amount will be a multiple of $500 in the range $10,500 to $15,000. The company wants to use simulation to determine which strategy to use to maximize its expected profit.

Objective To simulate the profit to Miller from any particular bid, and to see which bid amount is best.

Reference no: EM131106701

Questions Cloud

Differences between these two methods of dynamic programming : Discuss other differences between these two methods of dynamic programming.
Define distributions window to check that the distributions : Referring to Example 11.1, if the average bid for each competitor stays the same, but their bids exhibit less variability, does Miller's optimal bid increase or decrease?
Define communication and communication problems : How do Wiener and de Rosney define communication and communication problems
What price does the monopolist charge in each market : What price does the monopolist charge in each market? How much profit does the firm make? In equilibrium, what is the monopolist's elasticity of demand in each of the two markets?
Risk risktarget function to find the probability : a. For each of these, use @RISK's RISKTARGET function to find the probability that Miller's profit is positive. Do you believe these results should have any bearing on Miller's choice of bid?
What is the cost per share of treasury stock : For a recent 2-year period, the balance sheet of Franklin Company showed the following stockholders' equity data at December 31 in millions.
Simulate the profit to miller from any particular bid : The Miller Construction Company must decide whether to make a bid on a construction project. Miller believes it will cost the company $10,000 to complete the project (if it wins the contract), and it will cost $350 to prepare a bid.
Indicate the addressing mode : 1)Assume 64 different op codes and 19-bit instruction word in a computer system. Two bits in the instruction are reserved to indicate the addressing mode.
Examine critical thinking inquiring and communication skills : In this discussion forum, you will examine your critical thinking, inquiring, and communication skills as they relate to the subject of physical education

Reviews

Write a Review

Accounting Basics Questions & Answers

  How are general long-term liabilities distinguished from

how are general long-term liabilities distinguished from other long-term liabilities for the government? how does

  Define probability distribution

What's a probability distribution? What's it used for and why do we care? Does a probability distribution guarantee a particular value will occur under a set of circumstances?

  Partnership paid office expenses

Kaylyn is a 40% partner in the KKM Partnership. During the current year, KKM reported gross receipts of $160,000 and a charitable contribution of $10,000. The partnership paid office expenses of $100,000. In addition, KKM distributed $10,000 each ..

  What is a committed fund balance in a governmental funds

What is a committed fund balance in a governmental funds balance sheet? How does it differ from a restricted fund balance?

  Basics of percentage-of-completion method

Indiana Co. began a construction project in 2006 that will provide it $150 million when it is completed in 2008. During 2006, Indiana incurred $36 million of costs and estimates an additional $84 million of costs to complete the project. Using the..

  Determine a business related example of a potentially

find a business related example of a potentially unethical accounting situation on the internet. summarize the

  Investing on project if funds are available

If fund were available, would you invest in one, both or neither project? Why?

  Find the mean for the given sample data unless indicated

find the mean for the given sample data. unless indicated otherwise round your answer to one more decimal place than is

  Cyber queen services manager must decide whether to hire a

cyber queen services manager must decide whether to hire a new employee or to outsource some of the web design work to

  Record the conversions using the book value method

On January 1, 2014, Gottlieb Corporation issued $4,000,000 of 10-year, 8% convertible debentures at 102. Interest is to be paid semiannually on June 30 and December 31. Each $1,000 debenture can be converted into eight shares of Gottlieb Corporati..

  Incremental analysis of jefferson plaza hotel

The Jefferson Plaza Hotel is a deluxe four star establishment. Late on Friday, it had 10 of its 200 rooms available when the desk clerk received a call from the Riley Hotel.

  In order to fund her retirement michele requires a

in order to fund her retirement michele requires a portfolio with an expected return of 0.11 per year over the next 30

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