Activity 5: Linear Programming – Graphical MethodSolve the following Linear Programming problems using the graphical method. Use thePHPSimplex application software.1. An appliance manufacturer produces two models of televisions: Colored TV and B&WTV. Both models require fabrication and assembly work; each colored TV uses four hoursof fabrication and two hours of assembly; each B&W TV uses two hours of fabrication andtwo hours of assembly. There are 600 hours fabrication available per week and 480 hoursavailable of assembly. Each colored TV contributes P1200 to profit and each B&W TVcontributes P900 to profits. How many-colored TV and B&W TV must the manufacturerproduce in order to maximize the profit?2. An animal food producer mixes two types of animal food: X and Y. Each unit of X costsP100 and contains 40 grams of fat, 20 grams of protein and 1600 calories. Each unit of Ycosts P80 and contains 60 grams of fat, 60 grams of protein and 1200 calories. Supposethe producer wants each unit of the final product to yield at least 360 grams of fat, at least240 grams of protein and at least 9600 calories, how many of each type of grain should theproducer use to minimize his cost?

Note: - Since the exact one wasn’t specified, we will answer the first question here. Kindly submit…

Answered: Activity 5: Linear Programming -…

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

3. Nathasa, the controller of Nath Pizza, is purchasing several new delivery vehicles. Nathasa has numerous work responsibilities, so she has limited time to shop for cars. Because of the time constraints, she cannot make an extensive search for the best alternative, so she looks for cars until she finds a model that is satisfactory. Nathasa is following the ____ model. a.dilemma b.rational c.limited scope d.satisficing e.limited focus
Exercises on Linear Programming: Graphical Method 1. Weenies and Buns is a food processing plant which manufactures hot dogs and hot dog buns. They grind their own flour for the hot dog buns at a maximum rate of 200 pounds per week. Each hot dog bun requires 0.1 pound of flour. They currently have a contract with Pigland, Inc., which specifies that a delivery of 800 pounds of pork product is delivered every Monday. Each hot dog requires pound of pork product. All the other ingredients in the hot dogs and hot dog buns are in plentiful supply. Finally, the labor force at Weenies and Buns consists of 5 employees working full time (40 hours per week each). Each hot dog requires 3 minutes of labor, and each hot dog bun requires 2 minutes of labor. Each hot dog yields a profit of $0.88, and each bun yields a profit of $0.33. Weenies and Buns would Ilike to know how many hot dogs and how many hot dog buns they should produce each week so as to achleve the highest possible profit. (a)…
PROBLEM-2 XYZ Company manufactures a number of products. One important product is Q. which consists of two internally manufactured items Rand S as in the figure below: R (1 Piece) ITEM Q R S Item Q is assembled in an assembly station, A 10; Item R is in work center WC 30, and item S is manufactured in work center WC 70. Operation data for product Q and items R and S are shown in the table: ITEM Q Week Gross Requirements Lot size Lot for lot 50 150 1 40 Q Work Center 2 80 A 10 WC 30 WC 70 3 40 S (3 Pieces) 4 30 Setup time (Hrs) 0 3.0 2.0 5 40 6 30 Runtime per piece Lead Time (weeks) (Hrs) 1.7 1.0 1.0 1 1 1 1 Determine "capacity requirements planning" stated for product Q in the work centers A 10, WC 30, and W 70 for the next weeks on the basis of material requirements planning carried out.
33 White & Becker Tools (W&B) requires 2,000 elec- tric motors next month for its product line of weed trimmers. Each motor is composed of three com- ponents: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of produc- ing them and purchasing them are shown in the following table. COMPONENT Coil Shaft Housing DEPART- MENT PRODUCTION COST PER UNIT Fabrication 0.5 Molding 0.4 Inspection 0.2 $2.60 $1.80 $1.40 The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table: 0.2 0.7 0.3 PURCHASE COST PER UNIT COIL SHAFT HOUSING AVAILABILITY (HR.) (HR.) (HR.) (HR.) $3.12 $2.16 $1.68 0.6 0.3 0.4 3,000 3,000 1,800 In order to determine the number of components that will be produced and the number…
4. The seven-person maintenance function at a hospital performs both preventive and corrective maintenance on hundreds of items each month. All the workers are scheduled for 40 hours per week and there are four weeks in a month. It is the goal of the maintenance department to achieve 90% utilization with a mix of two-thirds preventive maintenance and one-third corrective maintenance. How many hours each monthOre spent performing preventive maintenance if they achieve their 90% utilization and correct/preventive mix targets? 6. Focus ר DELL
The Ace Manufacturing Company has orders for three similar products. Product A Min B C 1 2 Machine 3 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below. A A B B Ic C Product 1 12 3 Orders (units) 1,900 500 1,100 Capacity (units) 1,300 1,600 800 1 Machine 2 3 $1.00 $1.30 $1.10 $1.20 $1.40 $1.00 $0.90 $1.20 $1.20 (a) Develop the linear programming formulation of this problem. (Let XA1 be the number of units of product A produced by machine 1, X;; be the number of units of product i produced by machine j, etc.)
The Ace Manufacturing Company has orders for three similar products. Product Min A s.t. B C 1 2 Machine 3 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below. A A LB B Ic C Product 4 2 3 Orders (units) Machine 1 Capacity Product A Orders Machine 2 Capacity Product B Orders Machine 3 Capacity Product C Orders 1,800 X20 for all i, j. 700 1,100 Capacity (units) 1,400 (a) Develop the linear programming formulation of this problem. (Let x₁ be the number of units of product A produced by XA1 machine 1, x,, be the number of units of product i produced by machine j, etc.) 1,500 1,000 1 Machine $1.00 $1.30 $1.10 2 $1.20 $1.40 $1.00 $0.90 $1.20 $1.20 3 (b) Solve the transportation model for the…
Bill builds benches in a small shop and he plans to operate five 8-hour days perweek. Each bench has two ends and a top. It takes 5 minutes to cut and sand eachend and 2 minutes to make each top. Assembly requires 8 minutes per bench, andpainting requires 5 minutes per bench. Bill has one employee who makes the topsand ends. Bill will do the final assembly and painting. He also plans 1 hour per dayfor setup and teardown for each department.a. How many benches should he plan to build per week?b. How many hours per week are required for each person?c. Suggest ways to increase the number of benches produced per week
Can you help me with these three review questions A sports manufacturer produces skateboards and rollerblades. The same wheels are used for both products. For the next week, the master production schedule for skateboards shows a need for 147 units, while the master production schedule for rollerblades shows a need of 149 pairs. 4 wheels are required to manufacture a skateboard, and 8 wheels are required to manufacture one pair of rollerblades. What are the gross requirements for wheels to meet the requirements on the master production schedules for the next week?
2.2 At Modern Lumber Inc, Moise Ngwenya the producer of apple crates sold to growers, has been able with his current equipment, to produce 240 crates per 100 logs. He currently purchases 100 logs per day, and each log requires 3 labor-hours to process. He believes that he can hire a professional buyer who can buy a better-quality log at the same cost. If this is the case, he can increase production to 260 crates per 100 logs. His labour hours will increase by 8 hours per day. What will be the impact on productivity (measured in crates per labor-hour) if the buyer is hired?
A linear programming computer package is needed. The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown. Constraint Television Radio Online Audience per advertisement 300,000 54,000 120,000 Cost per advertisement $2,000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. (a) If the promotional budget is limited to $20,500, how many commercial messages should be run on each medium to maximize total audience contact? Television Radio Online What is the allocation of the budget among the three media, and what is the…
A linear programming computer package is needed. The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown. Constraint Television Radio Online Audience per advertisement 400,000 72,000 160,000 Cost per advertisement $2,000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. If the promotional budget is limited to $20,500, By how much would audience contact increase if an extra $100 were allocated to the promotional budget? (Round your answer to the nearest whole number.)

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