Typed answer pleaseSuppose we are deciding which projects to implement in the upcoming year. Let's represent each project usinga binary variable so that whether or not we do project 1 is represented by P1, Project 2 is represented by P2,and so on.The managers decide that to complete Project 2, Project 1 must be finished first but Project 3 CANNOT bedone. Which pair of constraints capture this requirement?O P2 <= P1 and P2 <=P3O P2 <= P1 and P2 >= P3O P2 <= P1 and P2 +P3 <=1O P2 >= P1 and P2 +P3 <=1O P2 = P1 and P2 +P3 <=1

The decision variables given are P1, P2, and P3. If project 1 is selected, then P1 will take the…

Answered: Suppose we are deciding which projects…

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

1) You operate a small wooden toy company making two products: alphabet blocks and wooden trucks. Your profit is $30 per box of blocks and $40 per box of trucks. Producing a box of blocks requires one hour of woodworking and two hours of painting; producing a box of trucks takes three hours of woodworking but only one hour of painting. You employ three wood workers and two painters, each working 40 hours per week. How many boxes of blocks (X1) and trucks (X2) should you make each week to maximize profit? Solve graphically as a linear program.
Hi... I'm having trouble with the following: Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows: In cell A5, enter a formula without using a function that references cell A5 in the Madison Copy the formula from cell A5 to the range A6:A8 without copying the formatting. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison Copy the formula from cell B5 to the range B6:B8 without copying the formatting. Copy the formulas and the formatting from the range B5:B8 to the range C5:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.)
For the remaining questions, consider the following problem description: An oil company is considering exploring new well sites S₁, S2, ..., S10 with respective costs C1, C2, C10. And in particular they want to find the least-cost selection of 5 out of the 10 possible sites. The binary decision variables x₁,x2,..., X10 denote the decision to explore the corresponding site.
2 3 4 Chocolate 5 Nougat 6 Nuts 7 Caramel 8 9 Demand 10 Total to Make Ingredients 11 12 Price/Bar 13 Cost/Bar 14 Gross Profit/Bar 15 16 Gross Profit/Type 17 18 Total Gross Profit 19 20 21 Ingredients 22 Chocolate 23 Nougat 24 Nuts 25 Caramel 26 Milky Way 1 1 0 .1 Candy Bars Snickers 1 1 $0.90 $0.45 $0.45 1 1 Nut Roll 3 Musketeers 1 1 0 0 2,000,000 2,500,000 1,000,000 2,000,000 1,500,000 1,000,000 0 1 1 1 $0.90 $1.05 $0.65 $0.50 $0.25 $0.55 Material Totals Used Available 5,000,000 6,000,000 6,000,000 7,000,000 2,500,000 2,500,000 4,500,000 5,500,000 $900,000 $375,000 $550,000 $2,725,000 1,500,000 1,500,000 $0.90 $0.30 $0.60 $900,000 Cost $0.15 $0.15 $0.20 $0.15
A school is looking to hire teachers and TAs to fill its staffing needs for its summer program at minimum cost. The average monthly salary of a teacher is $2400 and the average monthly salary of a TA is $1100. The program can accommodate up to 45 staff members, needs at least 30 to run properly, and must have teachers (they will NOT employee only TAs...as much as it makes purely economic sense). They must have at least 10 TAs and may have up to 3 TA's for every 2 teachers. How many teachers and TAs the should the program hire to minimize costs. What is the minimum cost?
Forrester and Cohen is a small accounting firm managed by Joseph Cohen since the retirement in December of his partner, Brenda Forrester. Cohen and his 3 CPAs together bill 640 hours per month. When Cohen or another accountant bills more than 160 hours per month, he or she gets an additional "overtime" pay of $62.50 for each of the extra hours. This is above and beyond the $5,000 salary each draws during the month. (Cohen draws the same base pay as his employees.) Cohen strongly discourages any CPA from working (billing) more than 250 hours in any given month. The demand for billable hours for the firm over the next 6 months is estimated below. Month Jan. Feb. Mar Apr. Estimate of Billable Hours 600 490 1,010 1,220 660 570 O May June Cohen has an agreement with Forrester, his former partner, to help out during the busy tax season, up to 250 hours in any given month if needed, for an hourly fee of $120. Cohen will not even consider laying off one of his colleagues in the case of a slow…
SureStep is currently getting 160 regular-time hours from each worker per month. This is actu-ally calculated from 8 hours per day times 20 days per month. For this, they are paid $9.375 per hour(51500y160). Suppose workers can change theircontract so that they only have to work 7.5 hours perday regular-time—everything above this becomesovertime—and their regular-time wage rate increasesto $10 per hour. They will still work 20 days per month. Will this change the optimal no-backloggingsolution?

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