The Trim-Look Company makes several lines of skirts, dresses, and sport coats. Recently, a consultant suggested that the company reevaluate its South Islander line and allocate itsresources to products that would maximize contribution to profits and to overhead. Each product requires the same polyester fabric and must pass through the cutting and sewingdepartments. The following data were collected for the study.a. Let X₁ = number of skirts produced,X₂ = number of dresses produced,X3 = number of sport coats produced.ProductSpecify the objective function and constraints for the problem.Objective function: Maximize Z = X₁ + x₂ + x3SkirtDressSport coatProcessing Time (hr)CuttingSewing213325Material (yd)The cutting department has 120 hours of capacity, sewing has 200 hours of capacity, and 120 yards of material are available. Each skirt contributes $9 to profits and overhead;each dress, $21; and each sport coat, $35.15

Linear programming (LP) is a mathematical optimization technique that helps solve problems where an…

Answered: a. Let X₁ = number of skirts produced,…

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

Please show your math! Steel Mills in three cities produce the following amounts of steels: Location Weekly Production (tons) A. Bethlehem 150 B. Birmingham 210 C. Gary 260 Total 620 These Mills supply steel to four cities, where manufacturing plants have the following demand: Location Weekly Demand (tons) 1. Detroit 130 2. St. Louis 70 3. Chicago 180 4. Norfolk 240 Total 620 Shipping Costs per ton of steel are as follows: To (Cost) 3. Chicago Form 1. Detroit 2. St. Louis 4. Norfolk A. Bethlehem $14 $9 $16 $18 B. Birmingham $11 $8 $7 $16 C. Gary $16 $12 $10 $22 a. Write down the function for Total cost in cell B19. b. Find the Minimum cost in cell B19 using Solver in Excel.
The Ace Manufacturing Company has orders for three similar products: Product Order (Units) A 1750 B 500 C 1100 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 as follows: Machine Capacity (Units) 1 1550 2 1450 3 1150 Product Machine A B C 1 $0.80 $1.30 $0.70 2 $1.40 $1.30 $1.50 3 $0.80 $0.80 $1.20 Use the transportation model to develop the minimum cost production schedule for the products and machines. Show the linear programming formulation. If the constant is "1" it must be entered in the box. If your answer is zero enter "0". The linear programming formulation and optimal solution are shown. Let xij = Units of product j on machine i.…
a. What is the orrect graph that shows the feasible region for the problem. b. What are the extreme points of the feasible region? c. What is the correct graph that shows the optimal solution for the problem
Estimate a range for the optimal objective value for the following LPs: *(a) Minimize z = 5x₁ + 2x₂ subject to (b) Maximize z subject to x₁ + 5x₂ + 3x3 X₁ X₂ ≥ 3 2x₁ + 3x₂ = 5 X1, X₂ ≥ 0 x₁ + 2x₂ + x3 = 30 2x₁ - x₂ = 40 X1, X2, X3 ≥ 0
8 Graphically find all optimal solutions to the follow- ing LP: min z = x1 - x2 s.t. X1 + x2 < 6 X1 - x2 2 0 X2 - x, 2 3 X1, X2 2 0
Kindly help
A manufacturing fi rm has discontinued production of a certain unprofi table product line.Considerable excess production capacity was created as a result. Management is consideringdevoting this excess capacity to one or more of three products: X1, X2, and X3.Machine hours required per unit areProductMachine Type X1 X2 X3Milling machine 8 2 3Lathe 4 3 0Grinder 2 0 1The available time in machine hours per week isMachine Hours per WeekMilling machines 800Lathes 480Grinders 320The salespeople estimate they can sell all the units of X1 and X2 that can be made. Butthe sales potential of X3 is 80 units per week maximum.Unit profi ts for the three products areUnit ProfitsX1 $20X2 6X3 8a. Set up the equations that can be solved to maximize the profi t per week.b. Solve these equations using the Excel Solver.c. What is the optimal solution? How many of each product should be made, and whatshould the resultant profi t be?d. What is this situation with respect to the machine groups? Would they…
The manager of Jokitian Iron Works Company received an order to produce anumber of pipes which require the use of material A costing $3 and material Bcosting $8 per unit. For each pipe no more than 12 units of Material A and at least16 units of material B must be used. While each unit of A weighs 4 pounds andeach unit of B weighs 6 pounds, the final product must weigh exactly 120 pounds.a. Present the objective function.b. Present the constraint functions.c. Show and label the graph of the feasible solution.d. How many units of each raw material should be used in order to producethe ordered pipes most economically?e. What is the cost of each pipe?
Using Excel Solve the following LP Maximize $4x + $5y Subject to 2x + 3y ≤ 20 (labor, in hours) 6x + 6y ≤ 36 (materials, in pounds) 4x + 4y ≤ 40 (storage, in square feet) x, y ≥ 0 a) Write the original optimal solution and objective function value. b) What is the optimal solution and objective function value if you acquire 2 additional pounds of material? c) What is the optimal solution and objective function value if you acquire 1.5 additional hours of labor?
b) The figure below presents an unbounded feasible region of a five constrained LP problem. 10- |(0, 6) 6. (1, 4) 4 (3, 2) 2+ (9, 0) 8 10 i. Write down in terms of x and y the inequalities that represent these constraints. ii. If the objective function is Z = 0.12x + 0.15y, determine the optimal solution to this problem (show the movement of the isocost line). ii. Identify the binding and non-binding constraints.
Solve Using Excel solver in Linear Optimization Problems. Must present the excel solver output including (answer report sensitivity report and limits report) 1. A calculator company produces two models of calculators at two different factories. Factory A can produce 130 scientific calculators and 25 graphing calculators per day. Factory B can produce 70 scientific and 90 graphing calculators per day. It cost $1200 per day to operate Factory A and $900 per day to operate Factory B. If the company needs to produce 460 scientific calculators and 340 graphing calculators for a big order, find the minimum cost to produce the order.(please help)
KrazySockzThe KrazySockz Company is known for their colorful yetcomfortable socks. They have forecasted their demand for the nextsix months as follows: Month 1 demand is 30,000, month 2demand is 50,000, month 3 demand is 20,000, month 4 demand is10,000, month 5 demand is 15,000 and month 6 demand is 20,000.At the beginning of month 1 they have 15,000 pairs of socks onhand. KrazySockz currently has 40 production employees. Each productionemployee costs the company the company $4,000 per month ($3,200 salary and $800in other costs) per month. Production employees can work up to 160 hours permonth before they must be paid overtime. Overtime is paid at a rate of $30 per hourand production employees can not work more than 30 hours per month overtime. Ittakes 15 minutes of labor and $0.75 of raw material to produce a pair of socks.KrazySockz can hire or fire employees each month. Hiring a production employeeincurs a cost of $3,500 and firing a production employee costs $4,500. At the end…

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

a. Let X₁ = number of skirts produced, X₂ = number of dresses produced, X3 = number of sport coats produced. Specify the objective function and constraints for the problem. Objective function: Maximize Z = X₁ + x₂ + x3