ExerciseA business student has $2,500 available from a summer job and has identifiedthree potential stocks in which to invest. The cost per share and expectedreturn over the next two years are given in the table below.a. Identify the decision variables, the objective, and the constraints in simpleverbal statements.b. Develop a linear optimization model to determine the optimal investmentstrategy.Solve this LP problem using Excel Solver and state your recommendation.C.StockPrice/ShareReturn/ShareA$12$8B$15$7C$30$11

Amount available for investment = $2500 ABCPrice/share$12$15$30Return/share$8$7$11

Answered: A business student has $2,500 available…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Formulate a chase sales and operations plan for a company with the following predicted demand:                                                                                                                                                                                                                                                                                                                                                                                             Month 1 2 3 4 5 6 Total Demand 55,200 49,600 12,800 24,800 50,400 25,600 218,400 The beginning workforce is 160 employees. The monthly output per employee is 400 units. The cost to hire and lay off a worker are $2,500 and $3,500, respectively. The cost to carry an item in inventory for one month is estimated at $14, and the stockout cost is $25 per unit. Show the production schedule, the inventory levels, and the changes in the workforce…
An investor has a certain amount of money available to invest now. Three alternative investments are available. The estimated profits, in Kwacha, of each investment under each economic condition are indicated in the following payoff table: Event Investment selection A B C Economy declines 500 -2000 -7000 No charge 1000 2000 -1000 Economy Expand 2000 5000 20,000 Based on his own past experience, the investor assigns the following probabilities to each economic condition: P (Economy declines) = 0.30      P (No Change) = 0.50    P (Economy expands) = 0.20 i. Compute the coefficient of variation for each investment. ii. Compute the return-to-risk ratio (RTRR) for each investment. iii. Based on (i) and (ii), what investment would you choose? Why?
Hudson Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: Demand Staffing Options High Medium Low Own staff 600 550 350 Outside vendor 900 650 450 Combination 700 600 400 a. If the demand probabilities are 0.4, 0.25, and 0.35, which decision alternative will minimize the expected cost of the data processing operation? Own Staff What is the expected annual cost associated with that recommendation? If required, round your answer to the nearest thousand of dollars. Expected annual cost = $  ___________
Mr. Smith is a rentier, he lives on renting apartments. However, these days he has to sell one of his apartments to get a big money. He hesitates which of three apartments of his to sell. Help Mr. Smith to make the right decision if you know the following: The present prices per m2 in the three locations equal: A) 4000, B) 5000, C) 6000 goldies, respectively. However, the long-run prices of those real estates are: A) 5000, B) 6000, and C) 7000 goldies, whereas the respective standard deviations are A) 400, B) 500, and C) 250 goldies.
The distribution of daily demand for rental trucks at a vehicle rental company is shown in the following table: Relative Frequency Demand 0.07 0 0.14 1 0.15 2 0.14 3 0.12 4 0.08 5 0.3 6 Trucks are rented by the day only and the company makes $14 per rented truck per day. The rental company keeps four trucks at this location. Assuming that the stocking decision is optimal, what is the implied range of excess cost per truck per day? a. 0 and 186 b. 8.58064 and 14 c. 14 and 24.8889 d. 6 and 8.58064 e. 34.2759 and 79.3333
The following payoff table shows profit for a decision analysis problem with two decision alternatives and three states of nature. Decision Alternative d₁ d₂ = EV(d₁) EV(d₂) The optimal decision is ? States of Nature $1 $2 230 80 $3 80 5 Suppose that the decision maker obtained the probabilities P(S₁) = 0.65, P(S₂) = 0.15, and P(S3) = 0.20. Use the expected value approach to determine the optimal decision. 80 55
A 36,000 square foot office building in Emeryville, California that was 88% leased had a 2023 annual net operating income estimated to be $1,880,000 with gross leases for all its tenants and a three level subterranean parking garage with 180 parking spaces. The 2024 NOI could be increased by all the following, EXCEPT: Increasing the operating expenses by adding additional maintenance staff Increasing the parking income by charging tenants for their employee parking Increasing the occupancy rate of the building by signing leases with new tenants Increasing the rental rates in new leases that are signed for the building
The following is a breakdown of supplying and installing a piece of equipment to a project owner, atthe time of contract: EGPCost of equipment 250,000Manpower (installation) 50,000Overhead and profits 70,000i – Calculate the price of supplying and installing the equipmentii – If the supply and installing of the equipment was delayed by the project owner, calculate theescalated price of works based on the FIDIC Red Book 1990 formula given:Updated cost of equipment 270,000 EGPBase price index of manpower 123.2Updated price index of manpower 144.9
Place-Plus, a real estate development firm, is considering several alternative development projects. These include building and leasing an office park, purchasing a parcel of land, and building an office building to rent, buying and leasing a warehouse, building a strip mall, and building and selling condominiums. The financial success of these projects depends on interest rate movement in the next 5 years. The various development projects and their 5-year financial return (in €1,000,000s) given that interest rates will decline, remain stable, or increase, are shown in the following image of the payoff table: a) Place-Plus is dissatisfied with the economist’s estimate of the probabilities of future interest rate movement, so it is considering having a financial consulting firm provide a report on future interest rates. The consulting firm can cite a track record which shows that 80% of the time when interest rates declined, it had predicted they would, whereas 10% of the time when…
A chef must decide how many chocolate lava cakes to prepare for the upcoming Mother's Day Dinner special. The chef can either prepare 50, 100, or 150 lava cakes. Assume that demand for the lava cakes can be 50, 100, or 150. Each dish costs $5 to make and is priced at for $7 on the menu. Unsold cakes are donated to a nearby charity center. Assume that there is no opportunity cost for lost sales. Which alternative should be chosen based on the maximax criterion?
The director of career advising at Grand Valley Commu-nity College wants to use decision analysis to provide in-formation to help students decide which two-year degree program they should pursue. The director has set up the following payoff table for six of the most popular and suc-cessful degree programs at GVCC that shows the estimated five-year gross income ($) from each degree for four futureeconomic conditions:Determine the best degree program in terms of projectedincome, using the following decision criteria:a. Maximaxb. Maximinc. Equal likelihoodd. Hurwicz ( .25) Economic ConditionsDegree Program Recession Average Good RobustGraphic Design 115,000 155,000 190,000 220,000Nursing 140,000 175,000 210,000 225,000Real Estate 95,000 135,000 230,000 350,000Medical Technology 120,000 180,000 210,000 270,000Culinary Technology 85,000 125,000 180,000 290,000Computer InformationTechnology 125,000 160,000 200,000 260,000
Donald Harris received a windfall and needs to invest it for tax reasons. He went to his brother-in-law, Joe Harris, who is a financial advisor. Joe prepared a matrix that illustrated the possible returns on investment for different investment strategies under different economic conditions. That matrix is given below. Given these values, what type of investment strategy would be selected by the Maximincriterion? Future Air Traffic Strategies Major Downturn Downturn Upturn Major Upturn Contrarian 20% 10% 5% -15% Risk Averse 2% 4% 7% 10% Growth -10% -8% 13% 20% Aggressive -25% -20% 11% 35% Group of answer choices

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

A business student has $2,500 available from a summer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next two years are given in the table below. Identify the decision variables the obiective and the constraints in simple