The Rio Credit Union has $250,000 available to invest in a 12-month commitment and wants to invest all of it. The money can be placed in Brazilian treasury notes yielding an 8% return or in riskier high-yield bonds at an average rate of return of 9%. Credit union regulations require diversification to the extent that at least 50% of the investment be placed in Treasury notes. It is also decided that no more than 30% of the investment be placed in bonds. The aim of the objective function for Rio Credit Union should be to the objective value. Decision variables: X = $ invested in Treasury notes Y = $ invested in Bonds Objective function (in decimals, eg., .07, NOT 7%): Z=ROI=X+Y Subject to: 1X+1Y 1X+0Y OX+1Y X, Y 20 ▼$250,000 (C₁) ▼$125,000 (C₂) $75,000 (C3) CD Y (in 000) 300- 250- 200- 150- 100- 50- 50 100 C2 150 X (in 000) 200 C1 250 C3 300 Q
Q: In queueing theory, λ represents the mean arrival rate; for example, the number of people arriving…
A: A queueing model is a mathematical framework used to analyze and understand how entities (such as…
Q: Choose two research articles on the ethics of project management and describe their findings.
A: Below are the two research articles on the ethics of project management and their findings:
Q: e continue with the Painting at JWU project moving into Phase 2 by creating the project milestones…
A: Project management is a field of study where specific tools and techniques are used to monitor and…
Q: What average cycle time is required for the assembly line to achieve the production quota in 10…
A: Given: Total units produced = 36+26+34 = 96Total time = 10 hrs
Q: I would like to extract this into the word format for my school. How can I do it? Please help
A: I have converted the images to Excel format which can be just copied and pasted into Word. Part (A):…
Q: The following is a payoff table giving profits for various situations. Alternatives Alternative 1…
A: Here, we could see that there are four alternatives, and each alternative has three states A, B, and…
Q: Name the 3 usual competitive strategies. Provide real life examples of companies using each strategy…
A: Competitive strategies are the techniques and methods utilized by companies to acquire a competitive…
Q: Assuming that the problems identified are the following, what would be your proposed solution to…
A: Service quality and customer satisfaction are critical components of a company's success. Service…
Q: For the sake of argument, let's say you've isolated the source of XYZ's operational problems. 1.…
A: Below is a general framework for identifying and addressing operational challenges:
Q: Using the following table, calculate the slack for Task H
A: In the context of the Critical Path Method (CPM), "slack" refers to the amount of time that an…
Q: Investigate how the production planning of the beer business is carried out, based on the following…
A: Production planning is the process of creating a plan for the efficient use of resources in the…
Q: STAR Co. provides paper to smaller companies whose volumes are not large enough to warran paper…
A: Decision Variables: Suppose-xj= No. of 100 foot wide rolls using cutting pattern j, where…
Q: Case study: Zappos, based in Las Vegas, is an online retailer with the initial goal of trying to be…
A: Zappos is a Las Vegas-based online shoe shop with the primary objective of becoming the greatest…
Q: Maria is working to redesign the performance appraisal system for her organization. She needs a…
A: Here, Maria is redesigning the performance appraisal system, she needs to make such a system that…
Q: For which activities can rework be reduced by using automation? Please choose two activities. a.…
A: To generate goods and services that match customer requirements and organizational goals, operations…
Q: (a) Draw a project network. (Submit a file with a maximum size of 1 MB.) Choose File no fie selected
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: CASE STUDY- Health and Safety Crisis Project Guyana There is a growing challenge in Guyana relative…
A: Below is the project plan of Health and Safety Crisis Project in Guyana:
Q: The boundaries of a process include all but one of the following: Select one: O a. Identification of…
A: A process is a series of interrelated activities that are performed to achieve a specific goal or…
Q: The current compensation output for standard inventory is estimated by using this formula: Y = D /…
A: Given that, Annualized compensation for 2021 was $6, and its output per stake was $411.12
Q: Re-order level (ii) Optimum order quantity and total inventory costs (iii) Maximum stock level
A: NOTE: We are allowed to do the first three sub-parts only. Given: Order cost (S) = K100 Raw…
Q: IT project management is characterized by its use of the tools and technologies that you specify
A: Project management is a process which helps to planning, organizing, budgeting and leading a project…
Q: What do we mean by the term queue discipline? o Queue discipline refers to how people should behave…
A: A queueing model is a mathematical framework used to analyze and understand how entities (such as…
Q: Why would a security manager prefer to hire an outside organisation to undertake research rather…
A: Security operations can be defined as the continuous exercises and cycles that are set up to…
Q: The forecasting sales of Month 1 (F1) was 27, and the actual sale of Month 1 (A1) turned out to be…
A: The forecasting method is the one that helps the organization in determining the value of goods and…
Q: a) Should managers monitor employee e-mail and Internet usage? Answer this question using the…
A: Employee internet usage monitoring alludes to the practice of tracking and recording employees'…
Q: do not need to solve thr problem, jsit crrate the linear program.
A: Given, Investment = $1000 Invest made in three different plans such as, Plan 1 total interest earned…
Q: Problem 11-6 (Static) Avis Company is a car rental company that is located three miles from the Los…
A: Formulae used: According to Little’s Law: Inventory=Through put rate × Flow time
Q: Explore the most critical concerns in risk management. How significant is risk management when…
A: The aim of risk management is to improve the probability of accomplishing business objectives while…
Q: Answer the given question with a proper explanation and step-by-step solution. An E-commerce firm…
A: Given- Weekly demand (d) = 10,000 unitsWeeks in a year = 50 weeksAnnual demand (D) = 10,000×50 =…
Q: Complete the level production plan, using the following information. The only costs you need to…
A: Manufacturing produces items from raw materials and components available to the firm in large or…
Q: Topic: Managment Information system Please read and answer the different parts operational…
A: Below are the answers for the discussion given:
Q: The original z-score formula intended for public manufacturing companies is shown below:…
A: Calculate X1 X1 = Working Capital ÷ Total Asset Working Capital = Current asset - Current Liability…
Q: How should a catastrophic recovery strategy be evaluated?
A: A catastrophic recovery strategy should be evaluated based on its ability to effectively recover…
Q: Provide seven essential competencies for those who want to succeed in the role of IT project…
A: Project managers with expertise in information technology are in high demand because of the…
Q: The Childfair Company has three plants producing child push chairs that are to be shipped to four…
A: A transportation problem would be a linear programming challenge that includes choosing the best…
Q: Using the table below, what is the largest amount of slack that any activity in the project has?
A: A network diagram shows the sequence of the task that is done to complete a project. It usually…
Q: Is the workflow management system targeting a specific area of concern?
A: A workflow management system is a software application that helps businesses automate and manage…
Q: Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a…
A: Given Sensitivity Report-
Q: Explain how the implementation of the new information system can give a competitive advantage in…
A: Competitive advantage refers to the unique advantage that a business or organization has over its…
Q: 2. Solve this model using graphical and simplex method and compare the answers. A transistor radio…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: How much of the variation in cost is explained by production? Multiple Choice O O 97.98% 95.60%…
A: % of variation in cost is not explained by production=(1-R square)×100
Q: You are completing your audit of LTC Ltd, an importer of cell phones from Taiwan. Total sales this…
A: Given that, Population 120 $5,200,000 Sample 30 $2,080,000
Q: Design a Gantt chart using the following data.
A: A Gantt chart is a project management tool used to visualize the start and end dates of tasks in a…
Q: McDermott Company has developed a new industrial component called IC-75. The company is excited…
A: 1. Reference value: Productive hours = 2,160 hours Purchase cost= $1360
Q: INSTRUCTION: FOLLOW THE SITUATION BELOW : - Unemployment is escalating from 24,728 in 2010 to 48,100…
A: Below is the introduction to the business proposal:
Q: Should the public policy exception be expanded to protect applicants from discrimination based on…
A: From operational management perspective, expanding public policy exception to protect applicants…
Q: A group of University students are considering opening a new business in the Tourism sector. The…
A: In the tourism industry, a group of college students is thinking of starting their own enterprise.…
Q: Mr. Mermiad gets paid on commission. He sold a car for $56,000 and gets 8% commission. How much did…
A: Commission is determined by multiply selling with commission. selling price = $56,000 Commission =…
Q: The sale data is shown as follows: Month 1: 1 Month 2: 6 Month 3: 9 Using 3-month Simple Moving…
A: There are numerous techniques available for demand forecasting. Demand forecasting is a universal…
Q: a. In Problem 42, Mega-Mart is considering purchasing a parcel of land adjacent to the current site…
A: Objective Functions and Constraints: Based on the given details, the objective…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
- This problem is based on Motorolas online method for choosing suppliers. Suppose Motorola solicits bids from five suppliers for eight products. The list price for each product and the quantity of each product that Motorola needs to purchase during the next year are listed in the file P06_93.xlsx. Each supplier has submitted the percentage discount it will offer on each product. These percentages are also listed in the file. For example, supplier 1 offers a 7% discount on product 1 and a 30% discount on product 2. The following considerations also apply: There is an administrative cost of 5000 associated with setting up a suppliers account. For example, if Motorola uses three suppliers, it incurs an administrative cost of 15,000. To ensure reliability, no supplier can supply more than 80% of Motorolas demand for any product. A supplier must supply an integer amount of each product it supplies. Develop a linear integer model to help Motorola minimize the sum of its purchase and administrative costs.Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
- The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?