do not need to solve thr problem, jsit crrate the linear program. Question 1You have $1000 to invest. At the beginning of each year, you can invest your availablemoney in three different plans, Plan 1, Plan 2 and Plan 3 (available money is money notblocked in a plan).Money put in Plan 1 is blocked for one year. After one year, you total interestrate is 5% (if you invested $100, you will have $105 after one year).• Money put in Plan 2 is blocked for two years. After two years, you total interestrate is 12% (if you invested $100, you will have $112 after two years).• Money put in Plan 3 is blocked for three years. After three years, you total interestrate is 19%.The planning horizon is 7 years. You want to maximize the available money at theend of the 7th year (again, available money means not blocked in a plan).Write a linear program solving the problem. Clearly define your variables, and add ashort explanation of each constraint.

Given, Investment = $1000 Invest made in three different plans such as, Plan 1 total interest earned…

Answered: do not need to solve thr problem, jsit…

Business

Operations Management

do not need to solve thr problem, jsit crrate the linear program.

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

Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standard mixes they can produce. • The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of peanuts.• The standard mix takes 0.7 of a pound of raisins and 0.6 of a pound of peanuts.The shop has 100 pounds of raisins and 70 pounds of peanuts. The profit on the deluxe mix is $1.80 and the standard mix profit is $1.60. The owner wants no more than 110 bags of each type prepared. Do not forget the non-negativity constraint and remember that you cannot sell partial bags (whole numbers only). Use Excel Solver Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it.
Question Primer Inc. offers plumbing and air conditioning services to customers in Kumasi, Ghana. The company’s product strategy is to solve the customer’s problem irrespective of what it takes, at the time the customer needs it solved. The company provides same day service for customers, and theaim is to make the customer happy before leaving.The services of the company are available 24 hours a day, 7 days a week for customers. There is no extra charge for requests made on holidays, odd hours of the day, or in festive seasons. The company aims to be available at the call of customers without charging a pesewa extra, even at times when rival firms won’t get out of bed. The company fixes the price of the service before it begins, and customers can be assured of no extra charges. Irrespective of the customer’s location in the city, Primer Inc. does not charge additional fees for transportation. For all services, the company provides a one year guarantee on all parts and labour used,…
Question 1: The Best Person for the Job After 25 years, Kevin is finally ready to retire and take it easy. Kevin teaches accounting and general business courses at Youngstown Community College. Kevin over the years has taught hundreds of accounting students and helped them obtain internships and find employment in the community. Kevin’s golfing buddy sometimes jokes that every bookkeeper in town has been through Kevin’s accounting classes. Besides, the regular accounting classes and internships, Youngstown maintains an accounting lab where students can get tutoring help if needed. The current lab tutor is David, who was hired two years ago when Dianne retired after nearly 10 years as the accounting tutor. David is a former student of Kevin and holds an associate’s degree from Youngstown and a bachelor’s from State. The lab job is part-time, which works out perfectly for David, leaving him plenty of time to pursue his MBA in accounting at State. David wants to teach accounting at…
Question: You want to buy electric energy. You can buy from company A, B, C, or D, but you must choose only one. You obtain past data on these four suppliers, and you then determine that the prices for some of them have been quite volatile, influenced by the state of the economy (recession, stagnation, and inflation). You assess this data given in the table in the picture attached. a) Assuming that you simply want to minimize your average costs over the long run, determine the expected costs for all energy suppliers. Select the supplier based on minimum expected cost. b) Assuming that you cannot afford any surprises and therefore want to minimize his uncertainty, determine the standard deviation for each supplier. Select the supplier based on minimum variance (same as minimum standard deviation).
Question 1: Should the marketing budget be maintained or increased during a recession or economic downturn? During a recession, the immediate desire of many companies is often to simply cut costs. The marketing department can be selected for this cut and in some cases is the first area cut. One could argue that the marketing spend is the one spend or investment in a company which should be maintained or even increased during a recession or economic downturn. Take a position: Marketing spend should be maintained or increased during a recession or economic downturn versus Marketing spend should be cut along with all the other spending in the organisation.
question 7 You manage an ice cream factory that makes two flavors: Creamy Vanilla and Continental Mocha. Into each quart of Creamy Vanilla go 2 eggs and 3 cups of cream. Into each quart of Continental Mocha go 1 egg and 3 cups of cream. You have in stock 450 eggs and 750 cups of cream. You make a profit of $3 on each quart of Creamy Vanilla and $2 on each quart of Continental Mocha. How many quarts of each flavor should you make to earn the largest profit? HINT [See Example 2.] (If an answer does not exist, enter DNE.) Creamy Vanilla quartsContinental Mocha quarts
Question 1 You may produce seven products by consuming three materials. The unit sales price and material consumption of each product are listed in Table 1. For each day, the supply of these three materials are limited. The supply limits are listed in Table 2. For each day, you need to determine the production quantity for each product. Product Price Material 1 Material 2 Material 3 1 100 0 3 10 2 120 5 10 10 3 135 5 3 9 4 90 4 6 3 5 125 8 2 8 6 110 5 2 10 7 105 3 2 7 Table 1: Product information for Problem 1 Material Supply limit 1 100 2 150 3 200 Table 2: Material information for Problem 1 Formulate a linear integer program that generates a feasible production plan to maximize the total profit (which is also the total revenue, as there is no cost in this problem). Then write a computer program…
Question13: Which of the following best describes dispute resolution through an arbitrator? A) A process where a neutral third party facilitates communication between disputing parties to help them reach a mutually acceptable solution. B) A process where a judge hears arguments from both sides and makes a legally binding decision. C) A process where a party decides the outcome of the dispute without the involvement of any third party. D) A process where an arbitrator makes a legally binding decision after hearing evidence from both sides.
QUESTION 2 Samy Company manufactures two types of tables, model K and J. The production of a model K table requires a capital expenditure of RM 6 and 2 hours of labor. The production of a model J table requires a capital of RM 4 and 5 hours of labor. The company has RM 240 capital and 100 hours of labor available for the production of the two models of tables per week. A model K table contributes a profit of RM 30 while model J contributes RM 40. a. Formulate the problem using linear programming model. b. How many of each type of table should the firm produce to maximize the profit? c. What is the maximum profit?
Question 5 The following game is played by 2 players Adam Jack Left Middle Right Up 1,2 3,5 2,1 Middle 0,4 2,1 3,0 Down -1,1 4,3 0,2 Solve the equilibrium for this game.
Question 1: According to the Columbia Accident Investigation Board, the root cause of the Columbia disaster was directly tied to Management’s unwillingness to adequately address the tradeoffs between the program’s conflicting goals of: Group of answer choices A) Cost, schedule, and safety B) Schedule, morale, and risk C) Safety, customer satisfaction, and schedule D) Cost, risk, and test flights
Question 3 A research collaboration can be enhanced by: Limiting the communication between researchers and industry partners. Avoiding the issue of which journal to target since research team members might disagree. Discussing intellectual property issues while the collaboration is forming. Waiting to discuss authorship issues until after data collection. Question 4 In any collaboration, data ownership is typically determined by: The research team with access to the best lawyers. The individual who does the most work on the project. The type and source of funds used to support the project. The relevant department chairs.