Linear programming company-1 A company produces 3 products. Each unit of product 1, 2, and 3 generate a profit ofGHC10,GHC12, and GHC12 respectively.Each product has to go through a manufacturing, assembly, and testing phase. The company'sresources are such that only 20 hours of manufacturing, 20 hours of assembly, and 20 hours oftesting are available. Each unit of product 1 has to spend 1 hour in manufacturing, 2 hours inassembly, and 2 hours in testing. Each unit of product 2 has to spend 2 hours in manufacturing,1 hour in assembly, and 2 hours in testing. Each unit of product 3 has to spend 2 hours inmanufa cturing, 2 hours in assembly, and 1 hour in testing. Company ABC wants to know howmany units of each product it should produce, in order to maximize its profit.a) Formulate a linear programming model for this problem.The model was solved using solver and part of the results is provided in the table below.Use it to answer the questions that follow.Variable CellsRedu Objectiv Allowabl AllowablFinalсеeeeValuCoefficiDecreasCellNameeCostentIncreasee$B$10X1 =41064$B$2.6666611X2 =41266674%3D$B$2.6666612X3 =41266674%3DConstraintsShadConstrai Allowabl AllowablFinalownteeValuR.H.DecreasCellNameePriceSideIncreasee$F$Manufacturin6.66666g Usage$F$ AssemblyUsage$F$ Testing203.6206667106.666666.201.6206667106.66666Usageb) Determine the the optimal solution to the problem.7201.620666710c) Which resource constraint(s) are binding? Give a reason.d) If the company could increase manufacturing hours by 10 hours per week or increasethe assembly hours by 10 per week, which should it choose?Advise the MD, providing detailed explanation using your answer.

Given data: Solved LPP and Solver table is presented . To find: b) Optimal solution c) Resource…

Answered: A company produces 3 products. Each…

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

d) A company can produce three products A, B and C. the products yield a contribution of Kshs.8, 5 and 10 respectively. The products use a machine which has 400 hours capacity. Each unit of the product uses 2, 3 and 1 hour respectively of the machines capacity. There are only 150 units available in the period of a special component which is used singly in product A and C. Only 200kgs of a special alloy is available in the period. The usage of special alloy is 2kgs per unit and 4kgs per unit respectively. There is an agreement with a trade association to produce no more than 50 units of product B in the period. Advise the company on the production plan that will maximize contribution.
Casting molds are produced by MYMOLD company. Each order has unique specifications, depending on customer needs. MYMOLD has received an order of two molds from a customer. The agreed selling price of the molds is 5000TL per mold. According to the agreement, for a defective mold the customer will pay 1000TL instead of the standard price. The customer will not buy any more than two molds and there is a 2000 TL fine for not meeting the demand with two non-defective molds. The excess molds can be salvaged for 500 TL per piece. The cost of production per mold is 2000TL and the probability of producing a non-defective mold is 0.8. Assume that MYMOLD decided to produce two molds, and the first production has been succesfull (a non-defective mold is produced). What is the expected profit given the result of the first production?
Elsa Corporation, a company that manufactures and markets low-end table computers, asked ourfriend Ms. Market Researcher to create the demand curve for its SD 721 model. She conductedsome market research and gave Elsa the demand curve as well as some additional information:350,000 units of SD 721 will sell at a price of $250.(1) What is the point price elasticity if 500,000 units will sell at a price of $200? (2) What is the point price elasticity if 125,000 units will sell at a price of $305?
Atlanta Manufacturing Company produces products W, X, Y, and Z through a joint process. The joint costs amount to $250,000. Product Units Produced Sales Value at Split-Off Additional Costs of Processing Sales Value After Processing W 750 $10,000 $2,500 $15,000 X 1,500 $30,000 $3,000 $35,000 Y 1,000 $20,000 $4,000 $25,000 Z 1,500 $40,000 $6,000 $45,000 If W is processed further, profits of W will: 1) Increase by $2,500 2) Increase by $12,500 3) Decrease by $23,000 4) Increase by $5,000
30) XYZ Company The XYZ Company uses 175 handles per day. The company operates 300 days per year. It costs $2.00 to carry one handle in inventory for one year. When handle inventory is low, an order is sent to the fabrication department to manufacture more handles. Fabrication can produce handles at a rate of 1500 per day and send the handles over to assembly while production is in progress. The setup for each production run costs $500. Assume the XYZ company orders 9,000 handles at a time (not necessarily the economic order quantity). The order receipt period = _____ days. Group of answer choices a) 6.0 b) 5.8 c) 30.0 d) 51.4 e) 50.0
You are asked to help your boss deciding who is considering whether to make or buy a part fora top most demanding product of the company.Your company can make the component for $40 per unit or buy it for $50 per unit from vendor.If the Company decides to make the component, it will require 4 hours of machine time tomake each part. The company has 2,000 hours of machine time available per month. Shouldthe company make or buy the component? How many max parts company can make?________________________________________________________________
How does the y relate to the x axis
Non-inventory goods were purchased and delivered on June 15, 2010. Several security interests exist in these goods. Which of the following security interests has priority over the others? Group of answer choices purchase money security interest perfected June 24, 2010 Security interest perfected June 20, 2010 Security interest attached June 15, 2010 Security interest in future goods attached on June 10, 2010
need a excel formula
Using the 1st law of Thermodynamics solve the following problem and the format of the answer is as follow a.) given:b) required:c solution : The 2M Company supplies 50 kilograms of chicken to ABEst Restaurant, which is contained in a box at 6°C, and is to be frozen at-18°C. The container box is 1.5 kg and the specific heat of the box material is 1.4 kJ/kg-°C. The freezing temperature of chicken is -2.8 °C. Determine the amount of heat that needs to be removed
Buy 99 is a wholesales company selling stationery. The company starts its order processing when it receives an order from the customer. After the company accepts the order, the clerk will check the order against the inventory; if the inventory has sufficient stock, the clerk will reserve the stock and charge the customer credit card for the order. If the inventory has insufficient stock, the clerk will notify the customer and ends the process. If the clerk charges the credit card successfully, the clerk will register the payment. At the same time, the clerk will also generate a pick-and-pack slip, followed by updating the inventory. After completing the registration of payment and the updating of inventory, the clerk will notify the customer. If the clerk did not charge the credit card successfully, the clerk will cancel the reservation of the stock and then notify the customer about the failure of the payment. Draw an Activity Diagram to document the above system.
2.28 A foundry produces castings to order. An order for 20 special castings has been re- ceived. Since the casting process is highly variable, not all castings produced are good. The cost of producing each casting is $550; the additional cost of finishing a good casting is $125. If a casting is not good, it is recycled at a value of $75; excess good castings are not finished but are recycled at a value of $75. The customer has agreed to accept 15, 16, 17, 18, 19, or 20 castings at a price of $1250 each. If fewer than 15 good castings are produced, none will be purchased by the customer. Prob- ability distributions for the number of good castings produced in a batch of varying sizes are given below. How many castings should be scheduled in order to maximize expected profit? #Good Castings 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 79 2 PRODUCT, PROCESS, AND SCHEDULE DESIGN Number of Castings Scheduled 15 16 17 0.05 0.00 0.00 0.00 0.00 0.00 0.05 0.05 0.00…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS