Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. An operations manager must purchase new equipment has developed a table of conditional values for the various alternatives (equipment options) and states of nature (demand market conditions). states of nature (market conditions) Alternatives Good Average Poor X800 $38,000 $21,000 -$18,000 Y900 $33,000 $16,000 -$12,000 Z1000 $29,000 $19,000 $6,000 If the probabilities associated with the states of nature are 0.40 for a good market, 0.40 for an average market, and 0.20 for a poor market, determine: 1. the alternative that provides the greatest expected monetary value (EMV)

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. An operations manager must purchase new equipment has developed a table of conditional values for the various alternatives (equipment options) and states of nature (demand market conditions). states of nature (market conditions) Alternatives Good Average Poor X800 $38,000 $21,000 -$18,000 Y900 $33,000 $16,000 -$12,000 Z1000 $29,000 $19,000 $6,000 If the probabilities associated with the states of nature are 0.40 for a good market, 0.40 for an average market, and 0.20 for a poor market, determine: 1. the alternative that provides the greatest expected monetary value (EMV)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section9.5: Multistage Decision Problems

Problem 17P

See similar textbooks

Similar questions

One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. Your recommendation should identify and explain at least 3 options. These three options must be based only with information present in the excel production plan, sensitivity report and components of LP modeling [decision variables, objective function (prices and variable cost) and resource constraints] The business memo should be 1 to 2 pages. A professionally written proper style and grammar are worth 50% of the grade. Your recommendations on the three options are worth 50%.
AutoTime, a manufacturer of electronic digital timers, has a monthly fixed cost of $50,000 and a production cost of $7 for each timer manufactured. The timers sell for $15 each. (a) What is the cost function C(x)?C(x) = (b) What is the revenue function R(x)?R(x) = (c) What is the profit function P(x)?P(x) = (d) Compute the profit (loss) corresponding to production levels of 3000, 6000, and 11,000 timers, respectively. (Input a negative value to indicate a loss.) 3000 timers $ 6000 timers $ 11,000 timers $
Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round time value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? Monthly Mortgage Payment a. $123,000, 15-year loan at 6.00 percent. b. $165,000, 30-year loan at 7.50 percent. c. $68,000, 20-year loan at 7.50 percent. d-1. Longer mortgage terms mean a monthly payment. d-2. For increase in mortgage rate monthly payment is required.
One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. Your recommendation should identify and explain at least 3 options. These three options must be based only with information present in the excel production plan, sensitivity report and components of LP modeling [decision variables, objective function (prices and variable cost) and resource constraints].
One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. What are three recommendations you have to the VP of operations based on the attached optimal production plan? These three options must be based only on information present in the excel production plan and components of LP modeling [decision variables, objective function (prices and variable cost), and resource constraints].
You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
Financial ratio analysis is conducted by three main groups of analysts: credit analysts, stock analysts, and managers. What is the primary emphasis of each group, and how would that emphasis affect the ratios on which they focus? Why would the inventory turnover ratio be more important for someone analyzing a grocery store chain than an insurance company? Over the past year, M.D. Ryngaert & Co. had an increase in its current ratio and a decline in its total asset’s turnover ratio. However, the company’s sales, cash, and equivalents, DSO, and fixed assets turnover ratio remained constant. What balance sheet accounts must have changed to produce the indicated changes? Profit margins and turnover ratios vary from one industry to another. What differences would you expect to find between the turnover ratios, profit margins, and DuPont equations for a grocery store and a steel company? How does inflation distort ratio analysis comparisons for one company over time (trend analysis) and…
Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory, selling price, and Bill of Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built to maximize revenue. You must make 4 chairs for every table. Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number.) Scenario 1 Large wood per table 3 Small wood per table 2 Large wood per chair 1 Small wood per chair 4 Revenue per table $35 Revenue per chair $29 Large wood inventory 300 Small wood inventory 500
Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand is $50.00. Her best guess is that she can sell 300 cups per week at $0.50 per cup. The variable cost of producing a cup oflemonade is $0.20.a. Given her other assumptions, what level of sales volume will enable Julie to break even?b. Given her other assumptions, discuss how a change in sales volume affects profit.c. Given her other assumptions, discuss how a change in sales volume and variable cost jointly affect profit.d. Use Excel’s Formula Auditing tools to show which cells in your spreadsheet affect profit directly.
Imagine that JRP Computing Bhd. has saturated the large firm market for its products and competitors are undermining its technological advantage. JRP needs to look to new markets for revenue. The CEO has suggested that it starts selling its software down-market to middle-market companies and at the same time the company enters into the consulting and installation side of the business for this target market. Discuss the risks and opportunities of such a strategy.
alternatives big average small large stock $22000 $ 12000 $-2000 average stock $14000 $10000 $6000 small stock $9000 $8000 $4000 the probabilities associated with states of nature are 0.3 for a big demand, 0.5 for an average demand, and 0.2 for a small demand. how do you compute expected monetary value (EMV) and expected value of perfect value (EVPI) ? a) determine the alternative that provides andrew the greatest expected monetary value (EMV). b} compute the expected value of perfect information (EVPI). compute EMV AND EVPI?
Use excel to make the calculations (show formulas used in excel) and be sure to identify your answer, including units. FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2 incremental cost. The company plans to sell the products to retailers for $7. What is the break-even point for each location? At what volume is the point of indifference? At what forecasted volumes should FloorsRUs select Huntsville as their new manufacturing location and what volumes should the company select Hays and why?