A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free. Formulate the LP model for this problem. Create the spreadsheet model and use Solver to solve the problem.
Q: 2. Suppose demand for a power steering gear assembly is given by Week 1 2 3 4 6. 7 8. 9 10 Demand |…
A: Given: Week 1 2 3 4 5 6 7 8 9 10 Demand 45 65 35 40 0 0 33 0 32 25 Projected on…
Q: A production assembly line of 7 seven activities designed to produce 120 units per hour and you have…
A: A line balancing is a process which helps to allot the right activities to the right workstation…
Q: Evaluation Service process Consumer participant Consumer-provider interface Consumer Consumer…
A: The diagram shown in the question is the process of service management. Service management processes…
Q: MZ Entertainment has been using this equation, which was developed by regressing inventories on…
A: In order to find the next year inventory forecast, we are required to calculate the next year sales,…
Q: What are the advantages and disadvantages of using a manual guest check system to control revenue…
A: A control system is a system that controls the output to produce the desired response.A control…
Q: (ou are working in a small, student-run company that sends out merchandise with university pranding…
A:
Q: Given the following cost information, solve for the optimal transportation cost: Use MODI Method…
A: solution using VAM
Q: Complete the production cost report for the month of November
A: Cost Report is the report managed and used by organization to identify production quantity and cost…
Q: A company has 3 factories manufacturing the same product and 5 sale agencies in different parts of…
A:
Q: Operations Management How is Total Productive Maintenance different from Preventive Maintenance and…
A: lean management is described as the technique through which an organization emphasizes the process…
Q: Define horizontal integration and provide a successful or unsuccessful example. Provide a real-world…
A: Horizontal integration is undoubtedly defined as the process of combining two companies at the same…
Q: State in which decision environment is linear programming most suited
A: To be determined: State in which decision environment is linear programming most suited . Linear…
Q: FRITO-LAY'S QUALITY-CONTROLLED POTATO CHIPS Frito-Lay, the multi-billion-dollar snack food giant,…
A: Quality control often called QC can be stated as the course of action or course of actions intended…
Q: Under what conditions could it make sense to combine private and public warehouses in a logistical…
A: Companies stored inventory of resources or commodities in warehouses to ensure that enough inventory…
Q: a) Use integer linear programming to solve the capital rationing problem with the project listed…
A:
Q: Briefly discuss how the forecast methods be applied in operations.
A: Production is the process of estimating the future demand based on previous or historic data and…
Q: consider the following reliability analysis for the variable customer difference. What could you…
A: Consistency over the course of time (test-retest unwavering quality), between things (interior…
Q: Q1: determine the optimum assignment ant total cost from the following profits table
A:
Q: 3 A product is produced at three plants and shipped to three warehouses (the transportation costs…
A: given,
Q: FRITO-LAY'S QUALITY-CONTROLLED POTATO CHIPS Frito-Lay, the multi-billion-dollar snack food giant,…
A: Given data: Sample 1: 1.98 2.11 2.15 2.06 Sample 2: 1.99 2 2.08 1.99 Sample 3: 2.2 2.1 2.2…
Q: How is the increase in transportation costs likely to affect global supply chain networks and their…
A: A supply chain network covers the movement of material/information that affects the supply chain.…
Q: Carefully examine the following ASSIGNMENT problem. Which of the following constraints is not true?…
A: In assignment problem we assign one job to machine to get all the job done with a minimum cost…
Q: List and describe the information systems serving each of the major functional areas of a business.
A: Business is full of risk and uncertainty. To move to growth every business need to deal with…
Q: Carrying cost per unit per month $2 Assume that the initial inventory has no holding cost in the…
A:
Q: What is project risk management and how does it work?
A: Project management is the management in which special and different skills, processes, and knowledge…
Q: Imagine you are a wholesaler for dairy products such asmilk and cheese, which are produced by a…
A: Retailers are those who sell products to the customers and in small quantities as well and they sell…
Q: Raytheon Co. has $4139 (million) worth of inventory and their COGS are $16,860 (milion), Their…
A:
Q: Suppose we are deciding which projects to implement in the upcoming year. Let's represent each…
A: First Project = P1 Second Project = P2 Third Project = P3 The requirement is that to complete…
Q: Calculate the breakeven point for each product? Calculate contribution ratio for each product 3.…
A: In this question, for each product line, we have sales data, fixed costs data and variable costs…
Q: State the advantage and disadvantage of varying the workforce in accordance to the predicted changes…
A: In order to maximise your company's capacity to fulfil customer demand efficiently, demand planning…
Q: What would the forumals that are in cells B20:L20 be?
A: The question is to obtain the number of teachers needed to be hired to teach subjects Science, Math,…
Q: Determine the best assignment of jobs to. What is the resulting total production of the assignment?
A: Assignment problems solve the problem of assigning different jobs to different and best resources.…
Q: Effective capacity is: Multiple Choice a. also called theoretical capacity. b. base capacity plus…
A: Overall throughput, or quantity of the product a facility can keep, deliver, store, as well as…
Q: corporate governance functions
A: The system of directing and supervising the structuring and functioning of the company by the…
Q: Microeconomics Please use excel for this problem A company is trying to determine how to allocate…
A: Given data is Budget = $145000 Limit for purchasing newspaper ads = 30 Limit for purchasing…
Q: a) What are the critical activities?
A: The expected activity time is the time taken by the particular activity to complete the project…
Q: Given the following transportation matrix where the numbers in the cells represent cost of…
A: Find the Given details below: Given details: From/To 3 4 5 6 Dummy Supply 1 40 35 M M 0 100…
Q: You've been promoted to the position of Manager at the Ibis Hotel in Kuala Lumpur, which is a great…
A: The Kano Model is a technique for analysis and measuring consumer needs. It's a method of…
Q: 2017 2019 2018 89 59 24 Summer 56 78 Fall Winter Spring 88 52 71 48 82 69 79 Using the table above…
A: Given Data-
Q: Automobile repair costs continue to rise with the average cost now at $500 per repair. Assume that…
A: Mean (μ) = $500 Standard deviation (σ) = $88
Q: Just three months ago, a major oil distributor faces a cyber-security threat that halted their…
A: A decreasing natural supply is a long-term problem for oil and gas corporations. Political attitudes…
Q: Question 37 How much slack is there in task A? Your Answer: Your Answer Question 38 If the crash…
A: Slack is the available time in a activity for delaying the project without affecting the total…
Q: Explain the current trends governing site selection?
A: Logistics has practiced a tremendous modification from a virtuously functional function that stated…
Q: 1. Give TWO (2) examples of a disrupt EC impact.
A: EC definition:- Enterprise Cloud is an integrated suite of advanced applications, databases, and…
Q: What is a service quality and the various consequences of poor quality that impacts an organisation.
A: When it comes to quality , it's all about keeping an eye on everything that needs to be done to get…
Q: Explain why and how a firm measures process capacity
A: Process capacity is the output generated by a machine/worker under expected working conditions and…
Q: so, what's the most advatagous district?
A: The question is the most advantageous assignment for the broker. This means which broker should…
Q: Why do organizations need to tailor project management concepts, such as those found in the PMBOK®…
A: PMBOK stands for project management body of knowledge and is a entire collection of processes. good…
Q: The term facework (giving or saving face) is used to describe the verbal and nonverbal strategies…
A: Kindly find the solutions to both the questions in the following steps.
Q: Discuss the relationship between Materials Requirements Planning (MRP) and distribution requirements…
A: 1. MRP (Material Requirement Planning): MRP is a term that refers to the process of planning…
Use excel for this problem
A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return.
Bond |
Annual Return |
Maturity |
Risk |
Tax Free |
A |
9.5% |
Long |
High |
Yes |
B |
8.0% |
Short |
Low |
Yes |
C |
9.0% |
Long |
Low |
No |
D |
9.0% |
Long |
High |
Yes |
E |
9.0% |
Short |
High |
No |
The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free.
- Formulate the LP model for this problem.
- Create the spreadsheet model and use Solver to solve the problem.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
- 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?Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).
- 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?The eTech Company is a fairly recent entry in the electronic device area. The company competes with Apple. Samsung, and other well-known companies in the manufacturing and sales of personal handheld devices. Although eTech recognizes that it is a niche player and will likely remain so in the foreseeable future, it is trying to increase its current small market share in this huge competitive market. Jim Simons, VP of Production, and Catherine Dolans, VP of Marketing, have been discussing the possible addition of a new product to the companys current (rather limited) product line. The tentative name for this new product is ePlayerX. Jim and Catherine agree that the ePlayerX, which will feature a sleeker design and more memory, is necessary to compete successfully with the big boys, but they are also worried that the ePlayerX could cannibalize sales of their existing productsand that it could even detract from their bottom line. They must eventually decide how much to spend to develop and manufacture the ePlayerX and how aggressively to market it. Depending on these decisions, they must forecast demand for the ePlayerX, as well as sales for their existing products. They also realize that Apple. Samsung, and the other big players are not standing still. These competitors could introduce their own new products, which could have very negative effects on demand for the ePlayerX. The expected timeline for the ePlayerX is that development will take no more than a year to complete and that the product will be introduced in the market a year from now. Jim and Catherine are aware that there are lots of decisions to make and lots of uncertainties involved, but they need to start somewhere. To this end. Jim and Catherine have decided to base their decisions on a planning horizon of four years, including the development year. They realize that the personal handheld device market is very fluid, with updates to existing products occurring almost continuously. However, they believe they can include such considerations into their cost, revenue, and demand estimates, and that a four-year planning horizon makes sense. In addition, they have identified the following problem parameters. (In this first pass, all distinctions are binary: low-end or high-end, small-effect or large-effect, and so on.) In the absence of cannibalization, the sales of existing eTech products are expected to produce year I net revenues of 10 million, and the forecast of the annual increase in net revenues is 2%. The ePIayerX will be developed as either a low-end or a high-end product, with corresponding fixed development costs (1.5 million or 2.5 million), variable manufacturing costs ( 100 or 200). and selling prices (150 or 300). The fixed development cost is incurred now, at the beginning of year I, and the variable cost and selling price are assumed to remain constant throughout the planning horizon. The new product will be marketed either mildly aggressively or very aggressively, with corresponding costs. The costs of a mildly aggressive marketing campaign are 1.5 million in year 1 and 0.5 million annually in years 2 to 4. For a very aggressive campaign, these costs increase to 3.5 million and 1.5 million, respectively. (These marketing costs are not part of the variable cost mentioned in the previous bullet; they are separate.) Depending on whether the ePlayerX is a low-end or high-end produce the level of the ePlayerXs cannibalization rate of existing eTech products will be either low (10%) or high (20%). Each cannibalization rate affects only sales of existing products in years 2 to 4, not year I sales. For example, if the cannibalization rate is 10%, then sales of existing products in each of years 2 to 4 will be 10% below their projected values without cannibalization. A base case forecast of demand for the ePlayerX is that in its first year on the market, year 2, demand will be for 100,000 units, and then demand will increase by 5% annually in years 3 and 4. This base forecast is based on a low-end version of the ePlayerX and mildly aggressive marketing. It will be adjusted for a high-end will product, aggressive marketing, and competitor behavior. The adjustments with no competing product appear in Table 2.3. The adjustments with a competing product appear in Table 2.4. Each adjustment is to demand for the ePlayerX in each of years 2 to 4. For example, if the adjustment is 10%, then demand in each of years 2 to 4 will be 10% lower than it would have been in the base case. Demand and units sold are the samethat is, eTech will produce exactly what its customers demand so that no inventory or backorders will occur. Table 2.3 Demand Adjustments When No Competing Product Is Introduced Table 2.4 Demand Adjustments When a Competing Product Is Introduced Because Jim and Catherine are approaching the day when they will be sharing their plans with other company executives, they have asked you to prepare an Excel spreadsheet model that will answer the many what-if questions they expect to be asked. Specifically, they have asked you to do the following: You should enter all of the given data in an inputs section with clear labeling and appropriate number formatting. If you believe that any explanations are required, you can enter them in text boxes or cell comments. In this section and in the rest of the model, all monetary values (other than the variable cost and the selling price) should be expressed in millions of dollars, and all demands for the ePlayerX should be expressed in thousands of units. You should have a scenario section that contains a 0/1 variable for each of the binary options discussed here. For example, one of these should be 0 if the low-end product is chosen and it should be 1 if the high-end product is chosen. You should have a parameters section that contains the values of the various parameters listed in the case, depending on the values of the 0/1 variables in the previous bullet For example, the fixed development cost will be 1.5 million or 2.5 million depending on whether the 0/1 variable in the previous bullet is 0 or 1, and this can be calculated with a simple IF formula. You can decide how to implement the IF logic for the various parameters. You should have a cash flows section that calculates the annual cash flows for the four-year period. These cash flows include the net revenues from existing products, the marketing costs for ePlayerX, and the net revenues for sales of ePlayerX (To calculate these latter values, it will help to have a row for annual units sold of ePlayerX.) The cash flows should also include depreciation on the fixed development cost, calculated on a straight-line four-year basis (that is. 25% of the cost in each of the four years). Then, these annual revenues/costs should be summed for each year to get net cash flow before taxes, taxes should be calculated using a 32% tax rate, and taxes should be subtracted and depreciation should be added back in to get net cash flows after taxes. (The point is that depreciation is first subtracted, because it is not taxed, but then it is added back in after taxes have been calculated.) You should calculate the company's NPV for the four-year horizon using a discount rate of 10%. You can assume that the fixed development cost is incurred now. so that it is not discounted, and that all other costs and revenues are incurred at the ends of the respective years. You should accompany all of this with a line chart with three series: annual net revenues from existing products; annual marketing costs for ePlayerX; and annual net revenues from sales of ePlayerX. Once all of this is completed. Jim and Catherine will have a powerful tool for presentation purposes. By adjusting the 0/1 scenario variables, their audience will be able to see immediately, both numerically and graphically, the financial consequences of various scenarios.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.)