Solve the following linear programming problem by the graphical method. (Note: You are expected todraw a graph to represent the constraints, clearly label axes, shade the feasible region, showwhere the optimal solution is located, state the values of the variables in the optimal solution, andthe value of the objective function for the optimal solution.) SHOW YOUR WORKMinSubject to:Z= X1+ X22X1 + 3X2< 302X1+ X2≥ 14X1+ 2X2≥ 10X1≥0, X2≥0富

To solve the linear programming problem using the graphical method, we need to follow these steps:1.…

Answered: Solve the following 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

ons Problem 13-15 Algo (Solving Integer Optimization Problems with Excel Solver) The Northside Bank working to develop an efficient work schedule for full-time and part-time tellers. The schedule must provide for efficient operation of the bank, including adequate customer service, employee breaks, and so on. On Fridays, the bank open from 9:00 A.M. to 7:00 P.M. The number of tellers necessary to provide adequate customer service during each hour of operation is summarized here. Time Time 9:00 a.m.-10:00 a.m. 2:00 p.m.-3:00 p.m. 10:00 a.m.-11:00 a.m. 3:00 p.m.-4:00p.m. 11:00 a.m.-Noon 4:00 p.m.-5:00p.m. Noon-1:00 p.m. 5:00 p.m.-6:00 p.m. 1:00 p.m.-2:00 p.m. 6:00 p.m.-7:00p.m. Each full-time employee starts on the hour and works a 4-hour shift, followed by a 1-hour break and then a 3-hour shift. Part-time employees work one 4-hour shift beginning on the hour. Considering salary and fringe benefits, full-time employees cost the bank $15 per hour ($105 a day), and part-time employees cost…
the excel file president’s inn guest database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed- and-breakfast inn during one month. room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. guests staying for seven days or more receive a 10% discount. modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
Simplex Method (Use Two-Phase Method by H. Taha)
Show that, simplex method provides a better solution in each iteration compared to its previous iteration in terms of optimization.
Please formulate the problem as AN OPTIMIZATION MODEL only and I will finish the rest. Health Center is planning to open its facilities 24 hours a day and wants to determine an optimal schedule. for their nurses. A nurse's work schedule is 8 hours in a row and can only start at the beginning of each shift. The personnel requirement for each shift is shown in Table 1. Table 1 – Personnel Requirement
Seneca Hill Winery recently purchased land for the purpose of establishing a new vineyard.Management is considering two varieties of white grapes for the new vineyard: Chardonnayand Riesling. The Chardonnay grapes would be used to produce a dry Chardonnay wine,and the Riesling grapes would be used to produce a semidry Riesling wine. It takes approximatelyfour years from the time of planting before new grapes can be harvested. Thislength of time creates a great deal of uncertainty concerning future demand and makes thedecision about the type of grapes to plant difficult. Three possibilities are being considered:Chardonnay grapes only; Riesling grapes only; and both Chardonnay and Riesling grapes.Seneca management decided that for planning purposes it would be adequate to consideronly two demand possibilities for each type of wine: strong or weak. With two possibilitiesfor each type of wine, it was necessary to assess four probabilities. With the help of someforecasts in industry…
The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month. Room rates include breakfast and are the same for one or two guests; however, any additional guests must pay an extra $20 per person per day for breakfast. Parties staying for seven days or more receive a 10% discount on the room rate as well as any additional breakfast fees. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
(Linear Objective Function and Optimization Application) On a special occasion, renowned electronic giant retailer Best Buy sold a variety of TVs at a discounted prices or on huge sales. Task-1: Write down an appropriate equation for the net profit function, P in order to account for the net profit made by Best Buy after selling: (i) x-number of televisions (TVs) that made $250 profit on the sale of each SONY TVs (ii) y-number of televisions that made $10,500 profit on the sale of each PHILIP TVs respectively, in that event. Task-2: Profit margin, P as discussed in Task-1 was subject to the following constraints applied to the products. a. Maximum cost price was $5000 to manufacture each piece of SONY TVs and $10,000 to manufacture each piece of PHILIP TVs respectively. All TVs were manufactured at a maximum cost of $10 x106 as given in Plot No 1: Plot No. 1: ($5000 x + $ 10000y) ≤ $10 million; Graph the Plot No. 1 up to the scale in a paper. b. 10 and 150 employees worked to…
Ensemble Theatre of Cincinnati D. Lynn Meyers has been Producing Artistic Director of the nationally renowned Ensemble Theatre of Cincinnati (ETC) since 1995. The nonprofit ETC, recently celebrating its 25th anniversary, is dedicated to the production and development of new plays and of works new to the region. Lynn values the opinions of each member of her small staff when hiring. She usually interviews four or five people for a staff position and conducts two interviews. After the preliminary interview determines that an applicant is suitable, she says, “We invite the person back to meet the staff they would have contact with on a daily basis.” She has passed on qualified candidates who did not interact well with their prospective coworkers or who did not convince her that they had a strong desire for the job. Lynn researches job applicants online and on social media sites. “Frankly, if we find unprofessional behavior, we take that into consideration,” she says. “We always check…
An entrepreneur is starting up a new bakery featuring a special pastry from an old family recipe. The basic dough recipe requires 5cups of flour, which is 0.75kg, plus another 0.75kg consisting of all the other ingredients, sugar, butter, milk, yeast, fruits, nuts and spices, to make the dough for 15 medium pastries. She runs some tests to scale up her recipe. In her first test batch she creates dough for 300 pastries, how much flour, in kg, was required?
I want to know the solution to this problem done by excel solver!
Please do not give solution in image formate thanku.

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