1. Factory PQR produces two products, product X and product Y. The Factory employs five workers: three machinists and two assemblers; and that each of them works only 40 hours a week. Product X and/or Y can be produced by these workers subject to the following constraints: • Product X requires three hours of machining and one hour of assembly per unit; Product Y requires two hours of machining and two hours of assembly per unit. If you can realize $10 profit per unit of product X and $14 profit per unit of product Y, state the problem in a formal Linear Programming equations ! 2. Perform iterations of the Simplex method to find the production level of product X and product Y in Question No. 1! 3. Write down your conclusion that you get from Question No. 2 ! 4. Formulate the dual of the LP equations that you have from No. 1 ! 5. Solve the Dual LP problem with Excel Solver ! 6. Explain the connection between the solution in Primal problem (from No.2) and the solution in Dual problem (from No. 5) !

1. Factory PQR produces two products, product X and product Y. The Factory employs five workers: three machinists and two assemblers; and that each of them works only 40 hours a week. Product X and/or Y can be produced by these workers subject to the following constraints: • Product X requires three hours of machining and one hour of assembly per unit; Product Y requires two hours of machining and two hours of assembly per unit. If you can realize $10 profit per unit of product X and $14 profit per unit of product Y, state the problem in a formal Linear Programming equations ! 2. Perform iterations of the Simplex method to find the production level of product X and product Y in Question No. 1! 3. Write down your conclusion that you get from Question No. 2 ! 4. Formulate the dual of the LP equations that you have from No. 1 ! 5. Solve the Dual LP problem with Excel Solver ! 6. Explain the connection between the solution in Primal problem (from No.2) and the solution in Dual problem (from No. 5) !

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

This process is used in business or manufacturing to predict their future requirements Select one: a. Plant Layout b. Capacity Study c. Forecast d. Scheduling
Identify the features that Business Intelligence incorporates which are found in the list below. a. TPS, OAS and KWS b. DSS, EIS and ESS c. TPS, MIS and KWS d. OAS, KWS and EIS
Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α = 0.5) and 3-year moving average to forecast it. a. Please fill the blanks above and write your processes below. b. What are the mean absolute deviations (MADs) of the two methods? Whichmethod will you choose based on the results? *Please solve for a-b and type or write all your work/steps and answers on paper* NO EXCEL, thank you
So what is npm, exactly? Describe it quickly using your own words.
What are Booth's algorithm's objectives?
I could use a hand with this
You are asked to perform a study about the effect of the weather on software developer’s productivity (if any). The study is for a company called MySoftware which gave you access to all data you need to perform the study. They aim at relocating if they find an effect of the weather on their engineers. 1. Use the “Goal-Question-Metric” (GQM) approach to set up the study. derive a minimum of one objective, the associated question, and suitable metrics. The metrics and questions showed be mapped to each other. That is, after each question, state the metric(s) that you suggest to answer the question DB RESPONSE: When you reply to other peers’ posts, comment on whether their metrics are measurable, hard or easy to measure, or costly. Your discussion does not have to be "perfect", but it must be yours. Please check the Discussion Board grading rubric.
If we have selected a problem and it is climate change which is affecting our environment and we are thinking about a product which is (Water conservation technologies such as drought-resistant crops and greywater systems address the problem of water scarcity, which is an issue that is being exacerbated by climate change) Now we need to answer the following questions on our product shown in the image.
give details calculation
snip
What relationship between x and y is suggested by the scattergram? OA a quadratic relationship with downward concavity OB. a linear relationship with positive slope OC. a linear relationship with negative slope D. a quadratic relationship with upward concavity
Dave F letcher, the general manager of NorthCarolina Engineering Corporation (NCEC), thinks that his firm'sengineering services contracted to highway construction firms aredirectly rela ted to the volume of highway construction businesscontracted with companies in his geographic area. He wondersif thjs is really so, and if it is, can this information help him planhjs operations better by forecasting the quantity of his engineeringservices required by construction firms in each quarter of theyear? The following table presents the sales of his services andtotal amounts of contracts for hjghway construction over the pasteight quarters:…