Problem 1: Three products can be manufactured on any of four machines. The unit production costs (in $) are summarized below. MACHINE PRODUCT 1 2 3 4 1 4 4 5 7 2 6 7 5 6 3 12 10 8 11 The time (in hours) required to produce a unit of each product on each of the machines is given below. MACHINE PRODUCT 1 2 3 4 1 0.3 0.25 0.2 0.2 2 0.2 0.3 0.2 0.25 3 0.8 0.6 0.6 0.5 3000, 6000, and 4000 units of the products are required, and that the available machine hours are 1500, 1200, 1500, and 2000 on machines 1-4, respectively. Given the above problem, answer the following questions: 1. Give the complete LP formulation without using the index and summation notations 2. Give the complete LP formulation using the index and summation notation. 3. Solve the problem using EXCEL SOLVER and tabulate the sensitivity analysis report. 4. Obtain the dual problem. 5. Solve the dual problem using EXCEL SOLVER. 6. Draw the problem as a network model. 7. Obtain the matrix form of the formulated problem.

Problem 1: Three products can be manufactured on any of four machines. The unit production costs (in $) are summarized below. MACHINE PRODUCT 1 2 3 4 1 4 4 5 7 2 6 7 5 6 3 12 10 8 11 The time (in hours) required to produce a unit of each product on each of the machines is given below. MACHINE PRODUCT 1 2 3 4 1 0.3 0.25 0.2 0.2 2 0.2 0.3 0.2 0.25 3 0.8 0.6 0.6 0.5 3000, 6000, and 4000 units of the products are required, and that the available machine hours are 1500, 1200, 1500, and 2000 on machines 1-4, respectively. Given the above problem, answer the following questions: 1. Give the complete LP formulation without using the index and summation notations 2. Give the complete LP formulation using the index and summation notation. 3. Solve the problem using EXCEL SOLVER and tabulate the sensitivity analysis report. 4. Obtain the dual problem. 5. Solve the dual problem using EXCEL SOLVER. 6. Draw the problem as a network model. 7. Obtain the matrix form of the formulated 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

00:53:53 C k TB Problem Qu. 5-114 (Algo) Mccabe Corporation uses the weighted-average... for September. Mccabe Corporation uses the weighted-average method in its process costing. The following data pertain to its Assembly Department Mc Graw Hill control Work in process, September 1 Units started into production during September Units completed during September and transferred to the next department Work in process, September 30 Equivalent units of production Q A 2 Required: the weighted-average method. Compute the equivalent units of production for both materials and conversion costs for the Assembly Department for September using Z option W S # 3 X F3 Materials E H command D $ 4 DOD DOO F4 Conversion R C do 5 % F U * 8 N DII F8 Units 800 8,200 7,300 1,700 ( 9 F9 K M 0 Materials 55% F10 Percent Complete 75% L H P F11 > Help command Conversion 10% 25% + 11 Save & Exit 2 F12 option 2 Sub dele
Qty Standard Labor Hour Raw Material В Standard Labor 2 Hours Raw Material INDEPENDENT DEMAND Period 1 2 3 4 5 6 Total Product A 1,000 1,000 1,000 1,000 1,000 1,000 6,000 Product B 500 500 ,500 500 16. Products A and B are produced on two different dedicated production lines. If both lines work on the same shift schedule, the ratio of workers on line A to workers on line B is A. 2:1 В. 2:3 С. 2:5 D. 4:1
Hii solve only final answers fast no need long explanation
Operation 1 Work Center A 2B 3 4 C D SE 5 Hourly Unit 70 80 100 50 60 60 Output Rate Product X is manufactured by starting with raw material and then processing it sequentially through 5 operations using work centers A to E resepectively (see diagram). The hourly rates for each machine are given in the table. What is the maximum output per hour for product X?
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?