Set up the objective function and enumerate all the constraints, Define the decision variables of the IP Programming problem 5. A semiconductor corporation produces a particular solid-state module that it supplies to fourdifferent television manufacturers. The module can be produced at each of the corporation's threeplants, although the costs vary because pf differing production efficiencies at the plants.Specifically, it costs 110 pesos to produce a module at Plant A, 95 pesos to produce a module atPlant B, and 103 pesos to produce a module at Plant C. Monthly production capacities of the plantsare 7500, 10000 and 8100 modules, respectively. Sales forecasts project monthly demand at 4200,8300, 6300 and 2700 for television manufacturers I, II, III and IV, respectively. If the cost (inpesos) for shipping a module from a plant to a manufacturer is as shown in the table below,determine the production level in each plant that will meet all needs at minimum total cost.Manufacturer IManufacturer IIManufacturer IIIManufacturer IVPlant A11139.19Plant B12161014Plant C14131215

After adding the information given in the question description, the table will be as follows. Total…

Answered: Set up the objective function and…

Set up the objective function and enumerate all the constraints, Define the decision variables of the IP Programming problem

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

Bugs Bunny and Daffy Duck are contestants on a game show called Split or Steal. On the show, Bugs and Daffy have to pick one of two cards and decide to split the prize money of $100,000 or steal it from the other contestant. The decisions are made simultaneously so neither player knows what the other will do. The table below represents the result of the contestants’ choices. See attached What should a rational player do in this game? Is this a zero-sum game?
The DellaVecchia Garden Center purchases and sells Christmas trees during the holiday season. It purchases the trees for $10 each and sells them for $20 each. Any trees not sold by Christmas day are sold for $2 each to a company that makes wood chips. The garden center estimates that four levels of demand are possible: 100, 200, 500, and 1,000 trees.a. Compute the payoffs for purchasing 100, 200, 500, or1,000 trees for each of the four levels of demand.b. Construct a payoff table, indicating the events and alternative courses of action.c. Construct a decision tree.d. Construct an opportunity loss table. Use the Optimistic (maximax) to choose the best choice.e.Use the Pessimistic (maximin) to choose the best choice.f.Use the Criterion of realism (Hurwicz) to choose the best choice. α = 0.6g.Use the Equally likely (Laplace) to choose the best choice.h.Use the Minimax regret to choose the best choice.i.Use the expected monetary value to make a choice. ( Probability for the four level…
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.
Typed plzzz And Asap Thanks
PROBLEM 7 Eyewitness News is shown on channel 5 Monday through Friday evenings from 5:00 P.M. to 6:00 P.M. During the hour-long broadcast, 18 minutes are allocated to commercials. The remaining 42 minutes of airtime are allocated to single or multiple time segments for local news and features, national news, sports, and weather. The station has learned through several viewer surveys that viewers do not consistently watch the entire news program; they focus on some segments more closely than others. For example, they tend to pay more attention to the local weather than the national news (because they know they will watch the network news following the local broadcast). As such, the advertising revenues generated for commercials shown during the different broadcast segments are $850 per minute for local news and feature segments, $600 per minute for national news, $750 per minute for sports, and $1,000 per minute for the weather. The production cost for local news is…
A chef must decide how many chocolate lava cakes to prepare for the upcoming Mother's Day Dinner special. The chef can either prepare 50, 100, or 150 lava cakes. Assume that demand for the lava cakes can be 50, 100, or 150. Each dish costs $5 to make and is priced at for $7 on the menu. Unsold cakes are donated to a nearby charity center. Assume that there is no opportunity cost for lost sales. Which alternative should be chosen based on the maximax criterion?
How would you write the optimal solution for these?
A decision maker is faced with a choice between two projects, both of which have start-up costs in the first year of $150m and project closing costs of $20m in year 5. Project A is expected to generate net returns of $10m, $20m, $50m and $200m from year 2 to year 5 respectively. Project B is expected to generate net returns of $100m, $80m, $50m, and $20m for year 2 to year 5 respectively. a) Show whether these projects are viable at discount rates of 1% and 10%. b) Show which project is preferred at 1% and which at 10%. c) Offer an intuitive explanation for your preferences at different interest rates d) If these are public sector projects, state two other considerations that could affect the choice of the project.
Variable Cells Model Variable Constraints E S D Constraint Number 1 E 2 3 S D S D Name Economy Models Standard Models Deluxe Models Name Total Profit: $ Fan Motors Cooling Coils Manufacturing Time Optimal Solution Constraints Fan motors Cooling coils Final Value 80.000 120.000 0.000 Final Value 200.000 320.000 2080.000 a. Identify the range of optimality for each objective function coefficient. If there is no lower or upper limit, then enter the text "NA" as your answer. If required, round your answers to one decimal place. Objective Coefficient Range Variable lower limit upper limit E Reduced Cost 0.000 0.000 -24.000 Manufacturing time. AUTO Shadow Price 31.000 32.000 0.000 Right-Hand-Side-Range lower limit upper limit Objective Coefficient 63.000 95.000 135.000 b. Suppose the profit for the economy model is increased by $6 per unit, the profit for the standard model is decreased by $2 per unit, and the profit for the deluxe model is increased by $4 per unit. What will the new optimal…