Question 5A company produces two types of transformer. If X, is the number of type-A transformers andX2 is the number of type-B transformers made by the company where each transformer of type-A makes €14 profit and each type-B makes €17 profit.Not completeMarked out of1.00The table below represents the final solution of the simplex method with the basis removed.P Flag questionHow many type-B transformers need to be produced to maximise profit.X1X2S2S31-1/41?11-3/51811/2-2/5323/213.2924Answer:Check

Given that: Profit = 924 x1(Type A) = 32 x2(Type B) = ?

A company produces two types of transformer. If X1 is the number of type-A transformers and X2 is the number of type-B transformers made by the company where each transformer of type- A makes €14 profit and each type-B makes €17 profit. The table below represents the final solution of the simplex method with the basis removed. How many type-B transformers need to be produced to maximise profit. X1 X2 S2 S3 1 -1/4 1 ? 1 1 -3/5 18 1 1/2 -2/5 32 3/2 13.2 924

A company produces two types of transformer. If X1 is the number of type-A transformers and X2 is the number of type-B transformers made by the company where each transformer of type- A makes €14 profit and each type-B makes €17 profit. The table below represents the final solution of the simplex method with the basis removed. How many type-B transformers need to be produced to maximise profit. X1 X2 S2 S3 1 -1/4 1 ? 1 1 -3/5 18 1 1/2 -2/5 32 3/2 13.2 924

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 4An investor is to purchase one of three types of real estate, as illustrated in Figure below. Theinvestor must decide among an apartment building, an office building, and a warehouse. Thefuture states of nature that will determine how much profit the investor will make are goodeconomic conditions and poor economic conditions. The profits that will result from eachdecision in the event of each state of nature are shown in Table below: a) Find the optimal act using Maxi-Max criteriab) Find the optimal act using Mini-Max criteria c) Find the optimal act using Maxi-Min criteria d) Find the optimal act using Min-Max regret table
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 #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 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 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 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 3a) Explain the risk management procedure. Set out the risks associated with attendingthe annual Engineering Institute of Zambia symposium in Livingstone. Draw a riskregister (log) and populate it with at least four perceived risks. Analyse these risksand rank them.b) You are planning the manufacture of modification to an existing product. Youranalysis has come up with the following information. What contingency reservewould you use? Project data Costcontingency There is a 30 percent probability of a delay in thereceipt of parts, with a cost to the project ofZMW90,000. There is a 20 percent probability that the parts willcost ZMW 100,000 less than expected. There is a 25 percent probability that two parts willnot fit together when installed, costing an extraZMW30,500. There is a 30 percent probability that themanufacture may be simpler than expected, savingZMW20,500. There is a 5 percent probability of a design defect,causing ZMW 50,000 of…
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 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 1 (b) A company is considering to invest in eight projects. The estimated cost of each project, the perceived priority points, the estimated number of new jobs each project would create are provided in the Table 1. Table 1 Project Cost ($) Priority Points New Jobs X1 X2 X3 X4 X5 X6 X7 X8 5000 4500 600 2000 6000 800 3200 2500 3176 2774 3513 2928 4607 862 3829 2708 5 1 2 1 3 1 7 2 1. Formulate objective function for this 0-1 integer model to maximise the total number of perceived priority points. Considering the above problem write down mathematical equations for each of following conditions/constraints. 2. A budget of $21000 is available for the projects. 3. The company wishes to fund at most three of the projects. 4. The company wants to create at least 8 new jobs from these projects.…
Question 1 (b) A company is considering to invest in eight projects. The estimated cost of each project, the perceived priority points, the estimated number of new jobs each project would create are provided in the Table 1. Table 1 Project Cost ($) Priority Points New Jobs X1 X2 X3 X4 X5 X6 X7 X8 5000 4500 600 2000 6000 800 3200 2500 3176 2774 3513 2928 4607 862 3829 2708 5 1 2 1 3 1 7 2 4. The company wants to create at least 8 new jobs from these projects. 5. Only one of the two projects, i.e., X3 and X5 should be funded at this time but not both. 6. The company believes that if it decides to invest in project X7 then it should also invest in project X8, and vice versa. [DO NOT SOLVE THE ABOVE MODEL YOU DEVELOPED IN QUESTION 1 (b).…
QUESTION 3 J A decision tree has action a1 with outcomes s1, s2 and s3 with payoffs K8000, K10000 and -K1000 Decision a2 with outcomes s1, s2 and s3 with payoffs K3000, K6000 and -K2000 Decision a3 with outcomes s1, s2 and s3 with outcomes K10 000, -K900 and K50 Required: Find the actions that would be prescribed by the Maximax, and Maximin criterion. Explain why the action prescribed by the Maximin criterion here is potentially unreasonable from a practical viewpoint