For the next 6 numbers: Refer to the Management Scientist output of amaximization LP problem. The constraints are defined as follows:Constraint 1: advertising budget ()Constraint 2: sales force availability ()Constraint 3: production level (=)Constraint 4: retail stores requirement ()Optimal SolutionObjective Function Value -Variable.ConstraintX1X2X1X2X3X4X3X412Variable12334OBJECTIVE COEFFICIENT RANGES4ConstraintRIGHT HAND SIDE RANGESValueSlack/SurplusLover Limit25.000425.000150.0000.00084.00050.000No Lover LinitNo Lover LinitLover Limit48450.0000.00025.0000.0000.0004950.0001775.000515.0000.000Reduced CostsDual PricesCurrent Value90.00084.00070.00060.000Current Value0.0000.0000.00045.0005000.0001800.000600.000150.0003.0000.00060.000-17.000Upper LimitNo Upper Linit90.00087.000105.000Upper Linit5850.000No Upper Limit603.571200.000 What should be the objective function coefficient of X4 to make its value positive?45105O 195O 115

Answered: For the next 6 numbers: Refer to the…

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

Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements areDay M T W Th F S SuRequirements 6 3 5 3 7 2 3Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have two consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S–Su pair in case of a tie.
Operation research 1: LP model answer all questions below asap
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 Hours required to complete all the oak cabinets 47 40 27 Hours required to complete all the cherry cabinets 64 51 36 Hours available 40 30 35 Cost per hour $34 $41 $52 For example, Cabinetmaker 1 estimates it will take 47 hours to complete all the oak cabinets and 64 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 40 hours available for the final…
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 5 5 6 2 2 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) Part 2 The minimum number of workers is _________workers. (Enter your response as a…
I need help finding the answer for this problem
A small grocery store has two employees, Von and Jack. They are equally productive and hardworking and are both currently earning Php 50 per hour. The owner decides to move his store to a new location nearby where he knows business will be better. He lets his workers know that if they wish to continue at the new location he will be able to raise their wage. He explains that they will continue to have the same He also explains that which worker gets the higher wage will have determined later on the Basis of a coin’s toss. The workers can choose to find similar work elsewhere for their current Php 50 per hour/ they both choose to go with the owner. Is it fair? Why?
Problem 10-07 (Algorithmic) Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its main power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table shows Aggie Power Generation's major residential markets, the annual demand in each market (in megawatts or MWs), and the cost to supply electricity to each market from each power generation plant (prices are in $/MW). Distribution Costs City Los Angeles Tulsa Seattle Demand (MWs) Seattle $356.25 $593.75 $59.38 950.00 Portland $356.25 $593.75 $178.13 831.25 San Francisco $178.13 $475.00 $296.88 2375.00 Boise $356.25 $475.00 $296.88 593.75 Reno $237.50 $475.00 $356.25 950.00 Bozeman $415.63 $415.63 $296.88 593.75 Laramie $356.25 $415.63 $356.25 1187.50 Park City $356.25 $356.25 $475.00 712.50 Flagstaff $178.13 $475.00 $593.75 1187.50 Durango $356.25 $296.88 $593.75 1543.75 If there are no restrictions on the amount of power that…
Problem 8-21 (Algorithmic) Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows: Rental Class Room Super Saver Deluxe Business Type I $30 $35 — Type II $20 $30 $40 Type I rooms do not have wireless Internet access and are not available for the Business rental class. Round Tree's management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 130 rentals in the Super Saver class, 60 rentals in the Deluxe class, and 50 rentals in the Business class. Round Tree has 100 Type I rooms and 120 Type II rooms. Use linear programming to determine how many reservations to accept in each rental class and how the reservations should be…
A renowned chocolatier, Francesco Schroeder, makes three kinds of chocolate confectionery: artisanal truffles, handcrafted chocolate nuggets, and premium gourmet chocolate bars. He uses the highest quality of cacao butter, dairy cream, and honey as the main Ingredients. Francesco makes his chocolates each morning, and they are usually sold out by the early afternoon. For a pound of artisanal truffles, Francesco uses 1 cup of cacao butter, 1 cup of honey, and 1/2 cup of cream. The handcrafted nuggets are milk chocolate and take 1/2 cup of cacao, 2/3 cup of honey, and 2/3 cup of cream for each pound. Each pound of the chocolate bars uses 1 cup of cacao butter, 1/2 cup of honey, and 1/2 cup of cream. One pound of truffles, nuggets, and chocolate bars can be purchased for $35, $25, and $20, respectively. A local store places a daily order of 10 pounds of chocolate nuggets, which means that Francesco needs to make at least 10 pounds of the chocolate nuggets each day. Before sunrise each…
A fruit juice manufacturer has recently begun negotiations with brokers in the areas where it intends to distribute its products. Before finalizing the agreements, however, the manager wants to determine shipping routes and costs. The firm has three plants with the capacities as shown below: Estimate demands in each of the warehouse localities are: PLANT CAPACITY (PIECES PER WEEK) WAREHOUSE 1 2 3 400 800 600 A B C D DEMAND (PIECES PER WEEK) 900 200 400 300 The estimated ship cost per box for the various routes are: ΤΟ FROM A B C D 1 5 7 9 12 2 10 7 2 3 3 8 9 6 4 Row/Column Opportunity Cost Demand Row/Column Cell Total Cost Opportunity Cost Cost of the above Test of unallocated Cells allocation Supply Amount char
Problem 10-07 (Algorithmic) Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its main power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table shows Aggie Power Generation's major residential markets, the annual demand in each market (in megawatts or MWs), and the cost to supply electricity to each market from each power generation plant (prices are in $/MW). City Seattle Portland San Francisco Boise Reno Bozeman Laramie Park City Flagstaff Durango Los Angeles $344.25 $350.25 $181.13 $351.25 $236.50 $403.63 $381.25 $371.25 $187.13 $361.25 Distribution Costs Tulsa $581.75 $587.75 The optimal solution is to produce $478.00 The optimal solution is to produce with the additional constraints is $ $470.00 $474.00 $403.63 $440.63 $371.25 $484.00 $301.88 Seattle $47.38 $172.13 $299.88 $291.88 $355.25 $284.88 $381.25 $490.00 $602.75 $598.75 Demand (MWS) 938.00 825.25 2378.00 588.75 949.00 581.75 1212.50 727.50…
Valencia products makes automobile radar detectors and assembles two models. Laser stop and Speedbuster both models use the same electronic components after reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of Speedbuster models produced. Implement the linear optimization model on a spreadsheet and use. Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints and verify the values of the slack variables . Maximize profit = 123 L + 139 S 19 L + 11 S < 4,000 (availability of component A) 6 L + 9 S < 35000 (availability of component B) L > 0 and S > 0 The optimal solution is to produce how many Laser stop models ? And how many Speedbuster models ? The maximum possible profit is ? Component A is or is not a binding…

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