The Ace Manufacturing Company has orders for three similar products.ProductMinAs.t.BC12Machine3Three machines are available for the manufacturing operations. All three machines can produce all the products at the sameproduction rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products varydepending on the machine used. Machine capacities for the next week and the unit costs are shown below.AALBBIcCProduct423Orders(units)Machine 1 CapacityProduct A OrdersMachine 2 CapacityProduct B OrdersMachine 3 CapacityProduct C Orders1,800X20 for all i, j.7001,100Capacity(units)1,400(a) Develop the linear programming formulation of this problem. (Let x₁ be the number of units of product A produced byXA1machine 1, x,, be the number of units of product i produced by machine j, etc.)1,5001,0001Machine$1.00 $1.30 $1.102$1.20 $1.40 $1.00$0.90 $1.20 $1.203(b) Solve the transportation model for the minimum cost production schedule for the products and machines.Show the production schedule.(XA1 XA2 XA3 XB1' XB2' XB3 XC1 XC2¹ XC3) =Determine the cost (in dollars) of the production schedule.Total = $

Answered: Image /qna-images/answer/cb7b7692-346c-4360-86de-b0b8e4164ee2.jpg

Answered: Develop the linear programming…

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

Halmar the Great has boasted to his hordes of followers that many a notorious villain has fallen to his awesome sword: His total of 500 victims consists of evil sorcerers, trolls, and orcs. These he has slain with a total of 600 mighty thrusts of his sword; evil sorcerers and trolls each requiring two thrusts (to the chest) and orcs each requiring one thrust (to the neck). When asked about the number of trolls he has slain, he replies, "I, the mighty Halmar, despise trolls four times as much as I despise evil sorcerers. Accordingly, four times as many trolls as evil sorcerers have fallen to my sword!" How many of each type of villain has he slain? sorcererstrollsorcs
Find the dual of the problem. Please use excel to solve the problem. Thank you!
Write a program that asks the user for an angle, entered in degrees. The program should then display the sine, cosine, and tangent of the angle. (Use the sin, cos, and tan library functions to determine these values.) You must convert the angle into radians (angle * 3.14/180)
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.
Machine A costs Rs 45,000 and its operating costs are estimated to be Rs 1,000 for the first year increasing by Rs 10,000 per year in the second and subsequent years.Machine B costs Rs 50,000 and operating costs are Rs 2,000 for the first year, increasing by Rs 4,000 in the second and subsequent years.If at present we have a machine of type A, should we replace it with B? if so when?Assume that both machines have no resale value and their future costs are not discounted.
There are 2657 professors in a college out of which one ofthem has to be selected for promotion through a game.Everyone will sit in a circle with numbered chairs. Each ofthem will evict the professor to his left, starting from the firstchair, and this cycle will go on until one last professor is left.Now you are one of the professors, which chair would youpick to ensure you get promoted?
A mixture of pellets is to be made containing x regular pellets, y large pellets and z extra large pellets. Cost, weight and volume data for each type of pellet are shown in the table. Is it possible to make mixture of 55 pellets at a cost of $0.85 if the mixture is to have 120 weight units and 130 volume units? If so, how many each type of pellet should be in the mixture? Pellet Type 5. Number of Cost per Pellet in Cents Weight Units per Pellet Volume Pellets Units per Pellet Regular Large Extra large 2 1 4 y 1 4 3
FIND THE OPTIMUM SOLUTION TO X= Y= MAX Z=
A group of k students arrive at a restaurant. They sit down around circular tables, leaving no table empty. Then each table orders one of r possible appetizers to share. What is the number of ways this can happen? Two seating arrangements are considered the same if each person has the same left neighbor in both of them. Consider different cases for number of tables.
A manufacturing cell makes three models of a product – AKC1011, BC0001, and AC0102. The daily demand for the three products are as follows: 200 of AKC1011, 500 BC0001, and 300 of AC0102. Develop a balanced mixed-model sequence that should be repeated throughout the day in order to meet demand.
A company produces motor cycle seats. The company has two production lines. The production rate for line one is 50 seats per hour and for line two it is 60 seats per hour. The company has entered into a contract to supply1200 seats daily to another company. Currently, the normal operation period for each line is 8 hours. The production manager 4 | P a g eof the company is trying to determine the best daily operation hours for the two lines. He sets the priorities to achieve his goals as given below:- P1: produce and deliver 1200 seats daily- P2: limit the daily overtime operation hours of line one to 3 hours- P3: Limit the daily overtime operation hours of line two to 4 hours Formulate the problem as a GP model and then solve it by using graphical method
Each column must have at least one value in some row to enable Pivot Tables to work properly. True False

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

Develop the linear programming formulation of this problem. (Let XA1 be the number of units of product A produced by machine 1, x,, be the number of units of product / produced by machine j, etc.)