Can you please solve the linear function with clear steps. it is better to be graphically instead of using excel Question 20:Janet Lopez is establishing an investment portfolio that will include stock and bond funds. She has OR720,000 toinvest, and she does not want the portfolio to include more than 65% stocks. The average annual return for the stockfund she plans to invest in is 18%, whereas the average annual return for the bond fund is 6%. She further estimatesthat the most she could lose in the next year in the stock fund is 22%, whereas the most she could lose in the bondfund is 5%. To reduce her risk, she wants to limit her potential maximum losses to OR100,000.

First let us define the variables x1 as the stocks and x2 as bonds. Now since the objective is to…

Answered: Can you please solve the linear…

Business

Operations Management

Can you please solve the linear function with clear steps. it is better to be graphically instead of using excel

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 #4 - Jerry Smith is thinking about opening a bicycle shop in his hometown. Jerry loves to take his own bike on 50-mile trips with his friends, but he believes that any small business should be started only if there is a good chance of making a profit. Jerry can open a small shop, a large shop, or no shop at all. The profits will depend on the size of the shop and whether the market is favorable or unfavorable for his products. Because there will be a 5-year lease on the building that Jerry is thinking about using, he wants to make sure that he makes the correct decision. Jerry is also thinking about hiring his old marketing professor to conduct a marketing research study. If the study is conducted, the study could be favorable (i.e., predicting a favorable market) or unfavorable (i.e., predicting an unfavorable market). Develop a decision tree for Jerry.
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 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 1The Rotary Club is holding a pizza sale to finance outreach projects. The Club made an agreement to purchase pizza from Pizza Hut at a 30% discount which the Rotary Club can then resell for a profit. It is expected that of the 500 families in the community, at most 70% will buy pizza. Based on a survey of their personal preferences, the students believe that they should orderno more than 120 cheese pizzas, no more than 150 pepperoni pizzas, and no more than 100 vegetarian pizzas. They also want to make sure that at least 20% of the total pizzas are cheese and at least 50% of the pizzas are pepperoni. The standard price (before discount) for the cheese, pepperoni and vegetarian is $12, $15 and $14, respectively. The Rotary Club makes a profit of 10%, 15% and 20%, respectively, for each cheese, pepperoni, and vegetarian pizza they resell. a) Formulate a linear programming model that would determine the optimal solution. An explanation for the derivation of EACH equation should…
Question 1 A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutes for cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution.b. Graph the feasible region.c. Determine the coordinates of each extreme point.
Question 1 A A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutesfor cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution b. Graph the feasible region. c. Determine the coordinates of each extreme point. d. What is the optimal solution. e. Solve in excel.
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 5 AIT computer department purchases a new computer every two years with preferences for three models; T1, T2 and T3. If the present model is T1, the next computer may be T2 with probability 0.2 or T3 with probability 0.15. If the present model is T2, the probabilities of switching to T1 and T3 are 0.6 and 0.25 respectively. And if present model is T3 then, the probabilities of switching to T1 and T2 are 0.5 and 0.1 respectively. Represent the situation as a Markov chain.
Question 3: A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Use Excel Solver to solve the problem (provide exact values for all variables and the optimal objective function).
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…
QUESTION THREEGiven the LP below:a) Solve the problem using big M-methodMinimize Z = 3X1 +4X2s.t 4X1 + X2 ≥ 30−X1 − 4X2 ≤ −184X1 + 3X2 ≥ 28X1, X2, ≥ 0
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?