Formulate linear programming model

Assignment Help Operation Management

Reference no: EM131367087

Michael has decided to invest $40,000 in three types of funds. Fund A has projected an annual return of 8 percent, Fund B has projected an annual return of 10 percent, and Fund C has projected an annual return of 9 percent. He has decided to invest no more than 30 percent of the total amount in Fund B and no more than 40 percent of the total amount in Fund C. (PLEASE SHOW ALL THE WORK IN AN EXCEL SHEET INCLUDING THE CONSTRAINTS)

(A) Formulate a linear programming model that can be used to determine the amount of investments Michael should allocate to each type of fund to maximize the total annual return.

(B) How much should be allocated to each type of fund? What is the total annual return? Provide solver screenshot.

Reference no: EM131367087

Questions Cloud

What is the average time customer waits for service : Marty’s Barber Shop has one barber. Customers arrive at the rate of 2.2 customers per hour, and haircuts are given at the average rate of 5 per hour. Use the Poisson arrivals and exponential service times model to answer the following questions: What..

Qualitative and quantitative-cause-effect : Qualitative, Quantitative (Cause-Effect): You are the Chief Operating Officer of a hospital. The Human Resources Director reports to you. Two of your valued Directors have a random drug screening for controlled substances with a group of hospital coh..

Compare classroom instruction and e-learning : Compare and contrast classroom instruction and e-learning. How do you think Alibaba might react to Amazon's attempt to extend their value chain into logistics? Discuss the relationship among quality, value and satisfaction and their roles for develop..

Formulate linear programming model : Michael has decided to invest $40,000 in three types of funds. Fund A has projected an annual return of 8 percent, Fund B has projected an annual return of 10 percent, and Fund C has projected an annual return of 9 percent. Formulate a linear program..

Why is the randomized clinical trial research : Research Methods: Why is the randomized clinical trial (RCT) research considered the “gold standard” in clinical epidemiology research? What is an IRB and why is it requirement when performing research with human beings?

Decision making-clinical epidemiology research : Decision Making: Clinical epidemiology research should be based on empirical evident. Define empirical evidence and what it means in decision making in both private and public health decision making in regard to interventions, i.e., the implementatio..

Used to ensure work inputs is feedforward control : The control that is used to ensure work inputs is feedforward control and the control that is used to monitor work outputs is feedback control. In my organization, we work in specialized departments. Each department has their own set of goals to reac..

Difference between feasible solution of the optimal solution : A product has an annual sales volume of 100,000 units and an average inventory investment of $50,000. Calculate the inventory turnover. What has been the impact of horizontal, vertical, and virttual integration on health care organizations? What adva..

User Account

All Pages