Q.A portfolio manager is trying to balance investments between bonds, stocks and cash. The return on bonds is 9 percent, 12 percent on stocks, and 3 percent on cash. The total portfolio is $1 billion, and he or she must keep 10 percent in cash in accordance with company policy. The fund's prospectus promises that stocks cannot exceed 75 percent of the portfolio. Solve this investment decision as a linear programming problem. Download the Answer Report 9% 12% 3% Balance Totoal profit r S C Total Port $1billion Cash accord cant exceed Contraints 10% 75% of port 9% O x1 x2 12% B 3% LHS . . RHS 1,000,000,000 10% 75%
Q: Briefly discuss , What are the key considerations when designing a facility layout for lean…
A: Facility layout refers to the arrangement of different components, such as workstations, equipment,…
Q: can you discuss the operations performance in an organisation? in 800 words.
A: Operations performance is a critical aspect of organizational success, encompassing the efficiency…
Q: Creating a map of the project with and without its architecture may facilitate comprehension. What…
A: Creating a map of a project, along with its architecture, can greatly enhance understanding and…
Q: Questions #1, #2, and #3 are about the following situation. You have been given the information in…
A: MRP stands for Material Requirements Planning. It is a computer-based inventory management system…
Q: Using a level production plan and the data below, calculate total ending inventory and total…
A: Level production planning is a strategy used by companies to maintain a consistent level of…
Q: Find the Initial Basic feasible solution (Total Cost) by using Vogel's Approximation method.…
A: The Vogel's Approximation Method (VAM), also known as the Vogel's Approximation Technique (VAT), is…
Q: Which consideration is most important before making the change to batch processing? Justify your…
A: One of the most important considerations (before making the change to batch processing) would be the…
Q: Software project management errors caused Denver International Airport's faulty luggage system. Can…
A: The Denver International Airport (DIA) faced significant issues with its luggage handling system…
Q: What are the 4vs of Sainsbury and Sainsbury local
A: Sainsbury's and Sainsbury Local, they both are one of the most famous supermarket chains in the UK.…
Q: Shoney Video Concepts produces a line of video streaming servers that are linked to computers for…
A: Manufacturing cost is = $170 per serverInventory storage cost is = $5 per monthestimated to cost an…
Q: skills levels of operators and requested service levels as factors impacting warehouse operations…
A: Skilled operators play a vital role in maintaining efficient and effective warehouse operations.…
Q: The management of two different sized sachets of maize meal—5 kg and 3 kg—is entrusted to you. The…
A: Best value for money refers to getting the most benefit or quality for the price paid by the…
Q: What would the advantages of an enterprise data model be for Mercy? Is it more important than ever…
A: An enterprise data model would keep the data assets in a structured framework. It could also…
Q: Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the…
A: Material Requirement Planning is a systematic approach that is used by businesses for determining…
Q: Edwards Manufacturing Company purchases two component parts from three different suppliers. The…
A: For obtaining a computer solution, we formulate the problem in Excel as shown below:
Q: Do you understand how dynamic programming is used?
A: The following is the basic conceptual understanding of dynamic programming:Dynamic programming is a…
Q: of the following are strongly associated with "cross docking"? sportation facilities at ports…
A: Cross-docking is not directly compatible with the other options:(1) Port transportation facilities:…
Q: What is manufacturing like at JYSK?
A: JYSK is a Danish retail chain specializing in household goods and furniture.
Q: Choose the term that best fits the situation being described. What types of power do effective…
A: Power is the ability of an individual to influence or control the behavior, actions, and decisions…
Q: Determine the minimum number of workers needed, and a schedule for the following staffing…
A: We formulate the linear programming problem in Excel as shown below:As the above table shows, x1,…
Q: Peter is considering operating a local business in the textile, clothing and footwear sector. Peter…
A: FabricWear is a sustainable textile, apparel, and footwear firm with big plans for the future.…
Q: 4. Vince Parker's computer training school, in Alabang, stocks workbooks with the following…
A: Annual Demand = D = 17500 unitsOrdering Cost = S = $30 per orderHolding Cost = H = $6 per unit per…
Q: What is the Labor productivity ratio of this manufacturing process?
A: Total output produced= 132Total labor hours= 360 hrsDefected units = 52Sales price of defective…
Q: Genjeteye, Inc. makes aircraft engines. The mean time to failure has been found to be 100,000 hours…
A: Failure rate refers to the frequency or likelihood of failure of a system, product, process, or…
Q: Discuss the Resource Planning for Information System, consisting of the following categories: a.…
A: Resource planning for an information system involves various components and strategies to…
Q: Do you understand how dynamic programming is used?
A: The following is the basic conceptual understanding of dynamic programming:By segmenting more…
Q: Roger Ginde is developing a program in supply chain management certification for managers. Ginde has…
A: The process of project development helps in generating as well as the implementation of ideas for…
Q: 1. Explore the mess by answering the following questions: (a) What do we know? (b) What can we…
A: (a) What do we know ? We know that desalinating seawater in the Persian Gulf using…
Q: A machine cycle, also known as a process loop, comprises four components. Which aspects of machine…
A: A machine cycle, or process loop, is a basic notion in computer architecture that describes the…
Q: Brentford Square Community Shopping Centre Project (Part A): A marketing strategy for a small…
A: 1) Larger shopping centers are more handy and suitable for the customers than community shopping…
Q: The decision under different risk approaches such Risk seeking approach/ Risk neutral approach/ Risk…
A: Risk in decision-making is the uncertainty or variability of results linked to various options or…
Q: In this assignment, you will examine the important role of a specific type of group — a social…
A: Title: The Vital Role of Social Justice Organizations in Promoting Equality and Human RightsTo…
Q: Building a map of the project both with and without the core structure may help with comprehension.…
A: Building a map of a project, including both the core structure and alternative scenarios, can…
Q: 7. Suppose you're a perfume retailer who sells 1000 bottles of perfume every week. Your vendor takes…
A: The reorder point is a concept used in inventory management to determine when to reorder a…
Q: Carefully analyse the figure below and answer the question that will follow: Scope definition…
A: The numerous actions and components that contribute to the forward and reverse flow of commodities…
Q: Walking the Walk: Putting Social Responsibility into Action at the White Dog CaféLinks to an…
A: As per our guidelines, we are supposed to answer only three subparts if multiple subparts are asked.
Q: A highway contractor needs to locate a single supply point to provide road building materials to…
A: The Center of Gravity Method is a location analysis technique used to determine the ideal…
Q: A construction manager needs to lay plumbing pipe in a real estate development project. What network…
A: In the context of laying plumbing pipe in a real estate development project, the most suitable…
Q: A furniture company manufactures desks and chairs. Each desk uses four units of woods and each chair…
A: Linear programming is a mathematical optimization technique used to find the best solution for a…
Q: What are the different online platforms that Scotiabank offers explain in detail. what is itrade…
A: Scotiabank, one of Canada's largest banks, offers several online platforms to cater to different…
Q: The activities described by the following table are given for the J.C. Howard Corporation in Kansas:…
A: Based on the activity durations and predecessor relationships given, we prepare a project network…
Q: Develop Electric Vehicles (EVs) and Infrastructure 5 porter's analysis
A: Porter's Five Forces analysis is a framework used to analyze the competitive environment of an…
Q: 3. The goal of inventory management is to have the right ______, in the right _______, at the right…
A: The product, place, and time are the correct option because the product considers the right…
Q: 32. With the held of examples, explain in detail the functioning of the Job Characteristics Model.…
A: The Job Characteristics Model (JCM) is a framework developed by Richard Hackman and Greg Oldham in…
Q: What is a paradigm of a system? What variables should be included in baseline models
A: A paradigm of a system refers to a fundamental model/framework, and within this, the structure and…
Q: new york government has decided to develop four desalination plants to combat the negative effects…
A: An assignment problem is a mathematical optimization problem that involves finding the optimal…
Q: How does a software engineer determine an accurate cost estimate for a project?
A: One of the important responsibilities of a software engineer is to prepare an accurate cost estimate…
Q: Do you believe that an agile or waterfall strategy would be more beneficial for a project that has…
A: When considering the choice between an agile or waterfall strategy for a project with…
Q: The weekly demand amount for a product is 2200 pieces and 12% of the incoming products are…
A: EOQ stands for Economic Order Quantity. It is a formula used in inventory management to determine…
Q: SMARTPAK (Smart Backpack): Product Description: The SMARTPAK is a technologically advanced and…
A: A product description is a written statement or explanation that provides detailed information about…
Kk. 240.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 8 images
- The IRR is the discount rate r that makes a project have an NPV of 0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where guess" is your best guess for the IRR. It is best to try a range of guesses (say, 90% to 100%). Find the IRR of the project described in Problem 34. 34. Consider a project with the following cash flows: year 1, 400; year 2, 200; year 3, 600; year 4, 900; year 5, 1000; year 6, 250; year 7, 230. Assume a discount rate of 15% per year. a. Find the projects NPV if cash flows occur at the ends of the respective years. b. Find the projects NPV if cash flows occur at the beginnings of the respective years. c. Find the projects NPV if cash flows occur at the middles of the respective years.You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
- A common decision is whether a company should buy equipment and produce a product in house or outsource production to another company. If sales volume is high enough, then by producing in house, the savings on unit costs will cover the fixed cost of the equipment. Suppose a company must make such a decision for a four-year time horizon, given the following data. Use simulation to estimate the probability that producing in house is better than outsourcing. If the company outsources production, it will have to purchase the product from the manufacturer for 25 per unit. This unit cost will remain constant for the next four years. The company will sell the product for 42 per unit. This price will remain constant for the next four years. If the company produces the product in house, it must buy a 500,000 machine that is depreciated on a straight-line basis over four years, and its cost of production will be 9 per unit. This unit cost will remain constant for the next four years. The demand in year 1 has a worst case of 10,000 units, a most likely case of 14,000 units, and a best case of 16,000 units. The average annual growth in demand for years 2-4 has a worst case of 7%, a most likely case of 15%, and a best case of 20%. Whatever this annual growth is, it will be the same in each of the years. The tax rate is 35%. Cash flows are discounted at 8% per year.In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?If the number of competitors in Example 11.1 doubles, how does the optimal bid change?
- Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.A European put option allows an investor to sell a share of stock at the exercise price on the exercise data. For example, if the exercise price is 48, and the stock price is 45 on the exercise date, the investor can sell the stock for 48 and then immediately buy it back (that is, cover his position) for 45, making 3 profit. But if the stock price on the exercise date is greater than the exercise price, the option is worthless at that date. So for a put, the investor is hoping that the price of the stock decreases. Using the same parameters as in Example 11.7, find a fair price for a European put option. (Note: As discussed in the text, an actual put option is usually for 100 shares.)Suppose you are borrowing 25,000 and making monthly payments with 1% interest. Show that the monthly payments should equal 556.11. The key relationships are that for any month t (Ending month t balance) = (Ending month t 1 balance) ((Monthly payment) (Month t interest)) (Month t interest) = (Beginning month t balance) (Monthly interest rate) Of course, the ending month 60 balance must equal 0.
- Suppose you begin year 1 with 5000. At the beginning of each year, you put half of your money under a mattress and invest the other half in Whitewater stock. During each year, there is a 40% chance that the Whitewater stock will double, and there is a 60% chance that you will lose half of your investment. To illustrate, if the stock doubles during the first year, you will have 3750 under the mattress and 3750 invested in Whitewater during year 2. You want to estimate your annual return over a 30-year period. If you end with F dollars, your annual return is (F/5000)1/30 1. For example, if you end with 100,000, your annual return is 201/30 1 = 0.105, or 10.5%. Run 1000 replications of an appropriate simulation. Based on the results, you can be 95% certain that your annual return will be between which two values?If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?